Forum Discussion
vishalvd
Aug 23, 2024Copper Contributor
MS Project Export as CSV not generating non english language data
i have been following below link to save MS Project file as CSV
https://support.microsoft.com/en-us/office/export-or-import-data-to-another-file-format-6e6e581f-a580-4f04-aa87-9b6552143d9c#:~:text=Choose%20File%20%3E%20Save%20As.%20Choose%20Browse.%20In,a%20name%20for%20the%20exported%20file.%20Choose%20Save
using Existing Task Export Map to save as CSV
Issue i am facing is after generating CSV, non English data is getting corrupted, showing as "????????" in the CSV
CSV File generated is getting saved as ANSI encoding, there is no way to change it to UTF 8 in Export Wizard
these are all steps can be done Mannully on MS Project
i also have MSPPlugin written in DotNet which does same exact steps programmatically
have used below APIs to perform the same
https://learn.microsoft.com/en-us/office/vba/api/project.application.mapedit
https://learn.microsoft.com/en-us/office/vba/api/project.application.filesaveas
getting same output as shown in screenshot
Note: I have MS Project Standard 2019 installed on windows
No RepliesBe the first to reply