export-excel encoding codepage

[evanefsvals]

Hi Team,

Is there a way for export-excel to use specific encoding instead of first export to csv and then to xlsx?
I need to use Windows-1252 encoding for export.

Thanks

[dfinke]

Please say a bit more of what you are trying to do. I have never worked with that sort of encoding.

[evanefsvals]

Hello Doug,

Sorry for the late reply.
Here is an example of the error message I am getting.

Is that related to encoding or with something else?
The source of that text is from a Dutch server.

Kind regards,
Evan

[scriptingstudio]

"smb acl marketing en communicatie mr".length
36

Simple test. Try to rename any sheet in Excel to "smb acl marketing en communicatie mr" (or any other text). You'll get the result from your screenshot, "smb acl marketing en communicat".

"smb acl marketing en communicat".length
31

This says that a sheet name has a length limitation. This is the reason of the issue.

[evanefsvals]

Thanks. Is there a way to suppress the warning?

[scriptingstudio]

Thanks. Is there a way to suppress the warning?

parameter -WarningAction SilentlyContinue or -WarningAction Ignore
Or global setting $WarningPreference = 'SilentlyContinue'