FileConverters vs. FileFormatConverters

[Armando]

I am trying to automate Excel to read an HTML table . I have Office
2007 installed and I am using VS2008 for developing my app in C#

The MSN documentation refers to Application.FileConverters,. However,
the method I have available in the Excel class is called
Application.FileExportConverters.

Anyay, when I call Application.FileExportConverters I get a 0 Count.
So, I cannot choose the HTML converter to do what I intend to do.

Question 1: Are Application.FileConverters and
Application.FileExportConverters. the same thing with a differente
name?

Question 2. Are there any snippets I can use to see exactly how to
import an HTML table in Excel usign .NET?

Questio 3: is there an alternative way (probably using ADO.NET) to
read an HTML table into a dataset?

Thanks

 

[filip]

I am trying to automate Excel to read an HTML table .  I have Office
2007 installed and I am using VS2008 for developing my app in C#

The MSN documentation refers to Application.FileConverters,.  However,
the method I have available in the Excel class is called
Application.FileExportConverters.

Anyay, when I call Application.FileExportConverters I get a 0 Count.
So, I cannot choose the HTML converter to do what I intend to do.

Question 1:  Are Application.FileConverters  and
Application.FileExportConverters.  the same thing with a differente
name?

Question 2. Are there any snippets I can use to see exactly how to
import an HTML table in Excel usign .NET?

Questio 3:  is there an alternative way (probably using ADO.NET) to
read an HTML table into a dataset?

Thanks

Hi Armando,

Best way to deal with Excel in C# is by using 3rd party component. Try
using GemBox.Spreadsheet, a component for exporting Excel. Component
is free for commercial use but with limit of 150 rows.
http://www.gemboxsoftware.com/GBSpreadsheet.htm

Here you can see a list of reason why GemBox.Spreadsheet much better
tool to work with Excel Automation:
http://www.gemboxsoftware.com/Excel-Automation.htm

Filip
GemBox Software - easier and faster way to deal with Excel then Excel
Automation