ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UTF-8 File Opened in Excel from Firefox Browser (https://www.excelbanter.com/excel-programming/443684-utf-8-file-opened-excel-firefox-browser.html)

Greg Lovern

UTF-8 File Opened in Excel from Firefox Browser
 
If I save a UTF-8 file to my local hard drive and open it in Excel,
Excel recognizes it as UTF-8 and displays the correct characters.

But if I browse to that same file in Firefox web browser, and choose
Excel when Firefox prompts me for what application I want to open it
in, Excel does not seem to recognize the file as UTF-8, and it
displays incorrect characters.

Is there anything we can put in those UTF-8 files to get Excel to
recognize them as UTF-8 when opened in Excel
through Firefox?


Thanks,

Greg

Greg Lovern

UTF-8 File Opened in Excel from Firefox Browser
 
Let me rephrase that without Firefox:


If I save a UTF-8 file to my local hard drive and open it in Excel,
Excel recognizes it as UTF-8 and displays the correct characters.


But if I enter a Run command in Windows to run Excel, with a UTF-8
file as a parameter for Excel to open, Excel does not seem to
recognize the file as UTF-8, and it
displays incorrect characters. For example:

excel "C:\My path\my utf-8 file.txt"


If I change the file extension to something random, like this:

excel "C:\My path\my utf-8 file.abc"

Then it does read the correct UTF-8 characters. However, it ignores
and removes the tab delimiters, putting everything in column A.


Any suggestions on how to open a UTF-8 file in Excel by command line
while preserving both the correct UTF-8 characters and the tab
delimiters?


Thanks,

Greg


On Oct 1, 10:59*am, Greg Lovern wrote:
If I save a UTF-8 file to my local hard drive and open it in Excel,
Excel recognizes it as UTF-8 and displays the correct characters.

But if I browse to that same file in Firefox web browser, and choose
Excel when Firefox prompts me for what application I want to open it
in, Excel does not seem to recognize the file as UTF-8, and it
displays incorrect characters.

Is there anything we can put in those UTF-8 files to get Excel to
recognize them as UTF-8 when opened in Excel
through Firefox?

Thanks,

Greg




All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com