Is there a way in MS Graph API to set the region format when converting Excel to PDF to use the correct digit grouping and decimal characters? (for example, "1 234,5" - french format).
I'm using the API /v1.0/drives/{driveId}/items/{itemId}/content?format=pdf
The /settings/regionalAndLanguageSettings API is not an option because it is a server-to-server integration using Client Id/Client Secret authentication.
And formatting cells as numeric "# ##0.0" doesn't work because PDF comes with "1,123.4" (US format)
Is there a way in MS Graph API to set the region format when converting Excel to PDF to use the correct digit grouping and decimal characters? (for example, "1 234,5" - french format).
I'm using the API /v1.0/drives/{driveId}/items/{itemId}/content?format=pdf
The /settings/regionalAndLanguageSettings API is not an option because it is a server-to-server integration using Client Id/Client Secret authentication.
And formatting cells as numeric "# ##0.0" doesn't work because PDF comes with "1,123.4" (US format)
Share Improve this question edited 1 min ago President James K. Polk 42k29 gold badges109 silver badges145 bronze badges asked Apr 1 at 17:49 Carlos SilvaCarlos Silva 11 Answer
Reset to default 0At the moment, the Microsoft Graph API does not provide a direct way to set the region format for converting Excel to PDF. You would have to make the changes on the file directly using Excel under File > Options>Advanced. Once updated, upload the modified file and then use the Graph API to convert to PDF. **
Link to Documentation- Convert to other formats - Microsoft Graph v1.0 | Microsoft Learn**