Export Html Tables to Multiple Excel Sheet using C#

Question

How to export multiple tables to multiple excel sheet using c#? Below code is working but only for 1 html table.

    Response.ContentType = "application/x-msexcel";
    Response.AddHeader("Content-Disposition", "attachment; filename=ExcelFile.xls");
    Response.ContentEncoding = Encoding.UTF8;
    StringWriter tw = new StringWriter();
    HtmlTextWriter hw = new HtmlTextWriter(tw);
    tbl.RenderControl(hw);
    Response.Write(tw.ToString());
    Response.End();

Below are tables in *.aspx page. And i want to both tables in one excel with multiple sheet.

for Example : Table 1 is in worksheet 1 table 2 is in worksheet 2

  <table id="tbl" border="1" runat="server" >
                <tr>
                    <td>Product</td>
                    <td>Price</td>
                    <td>Available</td>
                    <td>Count</td>
                </tr>
                <tr>
                    <td>Bred</td>
                    <td>1
                    </td>
                    <td>2
                    </td>
                    <td>3
                    </td>
                </tr>
                <tr>
                    <td>Butter</td>
                    <td>4
                    </td>
                    <td>5
                    </td>
                    <td>6
                    </td>
                </tr>
            </table>

     <table id="tbl2" border="1" runat="server" >
                <tr>
                    <td>KD</td>
                    <td>Dabhi</td>
                    <td>Qnil</td>
                    <td>Dabhi</td>
                </tr>
                <tr>
                    <td>Bred</td>
                    <td>1
                    </td>
                    <td>2
                    </td>
                    <td>3
                    </td>
                </tr>
                <tr>
                    <td>Butter</td>
                    <td>4
                    </td>
                    <td>5
                    </td>
                    <td>6
                    </td>
                </tr>
            </table>


     <asp:Button runat="server" ID="ExportToExcelButton" OnClick="ExportToExcelButton_Click"
        Text="Export To Excel" />

ramiramilu · Accepted Answer · 2015-04-20 11:41:26Z

2

In the example you mentioned, you are NOT creating an Excel (or Excel WorkSheets), instead you are trying to open HTML content in Excel format. That is the reason, even if you have TWO Tables, they will show up in single sheet.

Use Microsoft's OpenXml SDK, through which you can create any number of Sheets and inject data into sheets. Even OpenXml SDK got some minor issues when it comes to Date Type (especially while reading data from Excel sheets). In such a case you can go to any third party Excel automation providers like SpreadSheetGear.

answered Apr 20, 2015 at 11:41

ramiramilu

17.2k6 gold badges51 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

KD. Over a year ago

Thanks, There is no any other way to solve ? either using C# or other language ?

ramiramilu Over a year ago

Using C#, you can use OpenXml SDK. There is one other way to solve without using OpenXml (or third party tools), that is by constructing you own XML and sending it in response (codeproject.com/Articles/532589/…). I dont think this is a generic approach, so I wouldn't suggest it.

Community · Accepted Answer · 2017-05-23 11:50:47Z

0

Working solution for GridViews is here:

http://www.aspsnippets.com/Articles/Exporting-Multiple-GridViews-To-Excel-SpreadSheet-in-ASP.Net.aspx

You may want to look also here for some advise:

Add table to second sheet of Excel using C#

You may want to use EPPLUS library (free) instead of interop because it has a lot of functionality:

http://epplus.codeplex.com/

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Apr 20, 2015 at 11:44

demonplus

5,83912 gold badges56 silver badges73 bronze badges

4 Comments

KD. Over a year ago

Thanks for your revert. But, I am looking for with HTML Tables not grid-views. :) I really appreciated your efforts here.

demonplus Over a year ago

No problem, then using some library like EPPLUS may be a solution for you instead of Interop, it will have more flexibility.

KD. Over a year ago

I have no idea about EPPLUS, Is it possible to convert HTML tables to excel using this library? If yes, How?

demonplus Over a year ago

I added the link to it to my post

Collectives™ on Stack Overflow

Export Html Tables to Multiple Excel Sheet using C#

2 Answers 2

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related