Click here to Skip to main content
15,885,366 members
Articles / Productivity Apps and Services / Microsoft Office

Export DataSet to Multiple Excel Sheets

Rate me:
Please Sign up or sign in to vote.
4.80/5 (42 votes)
12 Dec 2008CPOL 273.8K   8.1K   94  
Exporting multiple tables in a DataSet to multiple sheets in an Excel file
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Button ID="btn" Text="EmptyTable" runat="server" />
        
         <asp:Button ID="Button1" Text="Table With Data" runat="server" />
    </div>
    </form>
</body>
</html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer Oliver Wyman Groups
United States United States
Education: Masters in Applied mathematics

Certification:
MCP in Asp.net
MCP in SQL Server 2008 Implementation.

Working Experience In .Net since 2005

Comments and Discussions