Create Excel file from HTML

Question

I know that I can create HTML <table>and save it as an .xls file for reading in Excel, and this works fine and everything, but it gives me only one sheet.

Is there a way to generate HTML so that I can have multiple sheets in a single .xls file? I tried to just generate more than one <table>, but they just end up being added to eachother.

Answer 1

Short answer: No.

. , HTML, Excel. , HTML, , , Excel , . , 5 , HTML excel ( /, ) .

: , ClosedXML FileHelpers, xlsx.

Answer 2

, , , . http://www.c-sharpcorner.com/UploadFile/kaushikborah28/79Nick08302007171404PM/79Nick.aspx Worksheets

http://msdn.microsoft.com/en-us/library/Aa155477%28office.10%29.aspx

3 XML Reference/Excel Workbook...

Answer 3

You can use open-source ClosedXML , wrap it around OpenXML to conveniently generate xlsx files, i.e. Excel 2007 format Excel files.