Convert Excel file to .csv

[jordnlvr]

Anyone have a clue as to how I can convert a .xls file into a .csv file? Using Asp.NET, VS.NET, vb and IIS on Win2k.

 

[Custom24]

Well, presumably the excel file resides on the web server? If it does, and you have the Excel application also installed on the web server, then you can just use the Excel COM object library to do this, from your web app.



Mark

 

[jordnlvr]

That sounds great, but how do I do that?

 

[Custom24]

Well, do you know any Excel VBA? If you don't, then I suggest you use the macro recorder in Excel to record you opening a file and saving it to a certain path as CSV. Then have a look at the code the macro has created.

Once you've done that, you add a reference to the COM Excel object in your .net app, and use its Workbooks collection and Workbook object to manipulate the file in the same way as the macro code does.



Mark