convert XLS to CSV with charset convertion

[Alain R.]

Hi,

I have an excel file with charset "windows-1250" and i would like to
convert it to CSV file with charset "UTF-8"

how can i do that ?

thanks a lot,

Al.

[Nicholas Paldino [.NET/C# MVP]]

Alain,

Do you have Excel installed on the machine and are you running this in a
non-ASP.NET application? If so, then I would automate Excel to open up the
file, and then just call the SaveAs method on the workbook, specifying the
CSV file format.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Alain R." <no*****@nospam.comwrote in message
news:e0**************@TK2MSFTNGP06.phx.gbl...

Hi,

I have an excel file with charset "windows-1250" and i would like to
convert it to CSV file with charset "UTF-8"

how can i do that ?

thanks a lot,

Al.

[Alain R.]

Hi,

so yes, excel is installed on the computer and it should run under
C#.net program only.

for now, i did the following thing :
open an OLEDB connection to excel file and line by line save it to
another file format CSV.

and i would like to convert string (line) to UTF-8 before saving it to CSV.

Al.

Nicholas Paldino [.NET/C# MVP] wrote:

Alain,

Do you have Excel installed on the machine and are you running this in a
non-ASP.NET application? If so, then I would automate Excel to open up the
file, and then just call the SaveAs method on the workbook, specifying the
CSV file format.

[Nicholas Paldino [.NET/C# MVP]]

Alain,

That seems pretty roundabout, and too much code that you have to put
together.

Why not just call this?

http://msdn2.microsoft.com/en-us/lib...as(VS.80).aspx

Here is some more information on saving workbooks in Excel:

http://msdn2.microsoft.com/en-us/lib...36(VS.80).aspx

Note that you will want to set the FileFormat parameter to xlCSV. For
more information on file formats, check here:

http://msdn2.microsoft.com/en-us/lib...at(VS.80).aspx
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"Alain R." <no*****@nospam.comwrote in message
news:Of****************@TK2MSFTNGP06.phx.gbl...

Hi,

so yes, excel is installed on the computer and it should run under C#.net
program only.

for now, i did the following thing :
open an OLEDB connection to excel file and line by line save it to another
file format CSV.

and i would like to convert string (line) to UTF-8 before saving it to
CSV.

Al.

Nicholas Paldino [.NET/C# MVP] wrote:

>Alain,

Do you have Excel installed on the machine and are you running this
in a non-ASP.NET application? If so, then I would automate Excel to open
up the file, and then just call the SaveAs method on the workbook,
specifying the CSV file format.