dfinke/ImportExcel

export-excel encoding codepage

Closed this issue · 6 comments

evanefsvals commented

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 commented

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

evanefsvals commented

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 commented 
"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.

  • 👍2
evanefsvals commented

Thanks. Is there a way to suppress the warning?

scriptingstudio commented

Thanks. Is there a way to suppress the warning?

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

  • 👍2
stale commented

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.