How to convert Excel(xls) contents into HTML

manish.sharma04 · July 14th, 2006, 12:16 AM

I have generated local report using SQL REPORTING Services and get rendered it as below:
Method Render()
Start
Warning[] warnings;
        string[] streamids;
        string mimeType;
        string encoding;
        string extension;

        byte[] bytes = ReportViewer1.LocalReport.Render("Excel",
                 null, out mimeType, out encoding,
                 out extension,
                 out streamids, out warnings);

End
End Method
Now I have the bytes of Excel file, I want to convert it into HTML response. How can I do this, Pl assist me.

Thanks,
Manish

Aiden Dayrep · July 29th, 2013, 04:42 AM

Hi, you can try this C# Excel component which has a really nice API for converting Excel to a HTML file in C#.
Here is how you can stream your Excel file bytes to a client:

Code:

MemoryStream ms = new MemoryStream(bytes);
ExcelFile.Load(ms, LoadOptions.XlsDefault).Save(this.Response, SaveOptions.HtmlDefault);