How to convert an excel file to .csv file?

Question

I'm developping an application for Honeywell Dolphin 6100, a mobile computer with a barcode scanner that uses Windows CE 5.0 like OS.

I want to create a little application responsible of the convertion of an excel file to .csv file.

Is it possible in Win CE ? if so, any help on it ?

thank you in advance !!

Note: I'm using VS2008 and I'm working on Windows 7.

I don't whether it will work on **Mobile platform** or not, But try to rename the file **extension** from `.xls` or `.xlsx` to `.csv` and **save** the file programatically. — Prahalad Gaggar, Apr 03 '13 at 09:57
Have you tried anything so far? Have you done any research on your own? — JDB, Apr 03 '13 at 13:12

score 6 · Answer 1 · answered Apr 03 '13 at 09:36

6

You can do this by using saveas() method in Excel:

wbexceltocsv.SaveAs("c:\Filename.csv", Microsoft.Office.Interop.Excel.XlFileFormat.xlCSV)

Follow link:

http://www.c-sharpcorner.com/UploadFile/yuanwang200409/how-to-convert-xls-file-into-csv-file-in-C-Sharp/

As well this link can be helpful to you:

http://www.codeproject.com/Articles/246772/Convert-xlsx-xls-to-csv

answered Apr 03 '13 at 09:36

Freelancer

9,008
7
42
81

I don't think he can use excel interop with wince – jle Apr 03 '13 at 09:38

score 0 · Answer 2 · answered Apr 03 '13 at 12:44

0

There's no reasonable way to do this on a Windows CE device. Presumably the CSV file is coming from a PC, so you must convert it on the PC (using an interop library or tool) before sending to the device.

answered Apr 03 '13 at 12:44

ctacke

66,480
18
94
155

How to convert an excel file to .csv file?

2 Answers2

Linked