Expotring excel to HTML Format ?

exactly !!!!
any ideas????

I would not expect the schema to have anything useful for what you are asking about here.

i get the schema of the table i am reading but it didn't help

using this :

ExcelSchema = ExcelConnection.GetOleDbSchemaTable(

OleDbSchemaGuid.Tables, null);

Either the data includes the data necessary to determine the styles to use or it does not. If it does not then you must get the style data from the spreadsheet somehow.

Thank you alll for your answers but i think i didn't explain what i really need to figure out in a proper way as what i need is to render my excel file on the page not to save the file again..

scenario:
i have an excel file which i read using oledbcommand and an OleDbDataAdapter...now all i need is to make the data in this excel file to be displayed on my page with the same styles as it is on the original excel file...(merged cells,Backcolors,etc..)
i hope i explained it right this time
thank you again
any ideas?????

Please try this links also.

http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html
http://www.codeproject.com/KB/webforms/DAtaGridExportToExcel.aspx
http://weblogs.asp.net/datagridgirl/archive/2003/04/14/5631.aspx
http://aspalliance.com/725_CodeSnip_Export_a_DataGrid_to_a_Formatted_Excel_Spreadsheet
http://dotnetguts.blogspot.com/2006/10/export-datagrid-data-to-excel-aspnet_15.html
http://dotnetguts.blogspot.com/2007/12/export-datagrid-to-excel-in-aspnet.html

Different ways:

Export to Excel, Word with css (Cascading Style Sheets)


Export Data from GridView to Excel, Word, HTML with C#

Export Gridview/Listview to Excel with Color formatting