xls to csv format

darma teja

Hi,

I tried to convert my excel file into csv file format.

I wrote code like this:

Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();

Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(@"Tabelle1.xls");

wb.SaveAs(@"\\Desktop\output.csv", Microsoft.Office.Interop.Excel.XlFileFormat.xlCSVWindows);

My problem now is that the output file should be in unicode format.

if i write code like this: It works fine as it is unicode format. But the file is not in csv format.
wb.SaveAs(@"\\Desktop\output.csv", Microsoft.Office.Interop.Excel.XlFileFormat.xlUnicodeText);

Thanks
Darma

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
I think that the unicode text file will be tab delimited so, if you could change the tabs to commas and provided there are no embedded commas in the fields themselves, that should give you want you want.

So, I'd try:

using System.IO;
using System.Text;

// ...

string filePath = @"\\Desktop\output.csv";
wb.SaveAs(filePath, Microsoft.Office.Interop.Excel.XlFileFormat.xlUnicodeText);
string text = File.ReadAllText(filePath, Encoding.Unicode);
text = text.Replace('\t', ',');
File.WriteAllText(filePath, text, Encoding.Unicode);
Vulpes13y ago
I don't think there is another 'simple' solution as the XlFileFormat enumeration just doesn't have a member which does what you want :(

However, if you don't mind installing Excel add-ins, you could try the solution in this link instead:

http://jaimonmathew.wordpress.com/2011/08/23/excel_addin_to_work_with_unicode_csv/
darma teja13y ago
Hi Vulpes,

Thanks for your reply.

I tried like this before. I thought there is some solution with out replacing tabs.

Thanks

Darma