How to convert .xls file into text file.

[pappu]

Hello friends,

I want to convert .xls file into text file.So can anybody pls
help me out.

Thxxxxxx,
Sachin.

 

[Morten Wennevik]

Hi Sachin,

You can convert excel files to comma separated files in several ways. You
can do it directly from Excel in save as, using the office API (requires
Excel installed)

ThisApplication.ActiveWorkbook.SaveAs("c:\\MyWorkbook.xml",
Excel.XlFileFormat.xlCSVMSDOS, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

Or using an OleDB provider and write your custom method for reading excel
files and outputting as text files.

 

[Laurent Bugnion]

Hi,

Hi Sachin,

You can convert excel files to comma separated files in several ways.
You can do it directly from Excel in save as, using the office API
(requires Excel installed)

ThisApplication.ActiveWorkbook.SaveAs("c:\\MyWorkbook.xml",
Excel.XlFileFormat.xlCSVMSDOS, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing);

We miss the context, but it's always good to mention that Microsoft
explicitly recommends against server-side automation of Office.
http://support.microsoft.com/kb/257757

Or using an OleDB provider and write your custom method for reading
excel files and outputting as text files.

I like that option much better.
http://geekswithblogs.net/lbugnion/archive/2006/08/25/89315.aspx

HTH,
Laurent

 

[Sonya]

To speak from one's own experience there is often no necessity to read
the xls-file. If you only want to get data of one table inside the
xls-file just export it to csv-file.

 

[Laurent Bugnion]

Hi,

To speak from one's own experience there is often no necessity to read
the xls-file. If you only want to get data of one table inside the
xls-file just export it to csv-file.

Isn't it like saying "To speak from experience, one often doesn't need a
car, one can walk". I think it really depends on the situation. I see
one case at least where using an Excel file instead of a CSV file makes
sense: Mobile environments (in my case, Palm PDAs) support editing
native Excel files, but do not support exporting to CSV. In that case,
reading an Excel file from a NET application is needed. Additionally,
Excel can only export one sheet to a CSV file, not all sheets. For
multiple sheets, additional work is needed to merge multiple CSV files
to one before reading them.

Based on my own experience, it's not possible to generalize

Greetings,
Laurent

 

[Mark Rae]

We miss the context, but it's always good to mention that Microsoft
explicitly recommends against server-side automation of Office.
http://support.microsoft.com/kb/257757

That's true, but the OP doesn't specifically mention server-side - he
certainly doesn't mention ASP.NET... WinForms automation is perfectly OK...

I like that option much better.
http://geekswithblogs.net/lbugnion/archive/2006/08/25/89315.aspx

Or even this, if more functionality is required:
http://www.aspose.com/Products/Aspose.Cells/Default.aspx

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Extremely easy to do, read the excel file using OleDB (google the code for
this)
and just export it like csv.

Send me an email if you are too lazy to find the code

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi

Hi Sachin,

You can convert excel files to comma separated files in several ways. You
can do it directly from Excel in save as, using the office API (requires
Excel installed)

I think that this is like shooting a fish with a cannon, using OleDB you can
read the file as a datasource and simply write down a csv file with just a
few lines of codes

 

[Ignacio Machin \( .NET/ C# MVP \)]

hi

what if he neeeds to do this in a service? or do this everyday at midnight?