Expotring excel to HTML Format ?

Question

Hii
i have a problem displaying an excel file with the same format as it is on microsoft excel..(Merged Cells,Backcolors,etc...)
First i read the file and return the results on a data table...but it doesn't hold the same format as it is on excel is there a way to display it in HTML format without using the excel library as it will be on a website so the user doesn't have to have an installed version of microsoft office????
any help would be great
Thankssssssssss

Morcos Adel · Answer

exactly !!!! any ideas????

Sam Hobbs · Answer

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

Morcos Adel · Answer

i get the schema of the table i am reading but it didn't help using this : ExcelSchema = ExcelConnection.GetOleDbSchemaTable( OleDbSchemaGuid .Tables, null );

Sam Hobbs · Answer

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.

Morcos Adel · Answer

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?????

Sam Hobbs · Answer

Microsoft provides a program for viewing Excel files for free. It is not capable of making any changes to the file and it is not a complete copy of Office; it is just a viewer for just Excel files.

Muralidharan Deenathayalan · Answer

Ok Suthish.

Suthish Nair · Answer

Murali, post links from our community only. If no links available share external ones.

Muralidharan Deenathayalan · Answer

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

Suthish Nair · Answer

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

Expotring excel to HTML Format ?

Answers (10)