1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

<%@ Page Language="c#" Codebehind="export-data.aspx.cs" AutoEventWireup="false" Inherits="Aspose.Cells.Demos.ExportData"
    MasterPageFile="~/tpl/Demo.Master" Title="Exporting data from excel files - Aspose.Cells Demos" %>

<asp:Content ID="Content" ContentPlaceHolderID="MainContent" runat="server">
    <p class="componentDescriptionTxt">
        <span style="font-size: 10pt; font-family: Arial"></span>
        &nbsp;<p class="componentDescriptionTxt">
            <span style="font-size: 10pt; font-family: Arial"></span>
                <table align="center" border="0" cellpadding="0" cellspacing="0" width="90%">
                    <tr>
                        <td valign="top" width="19">
                            <img alt="" height="41" src="/Common/images/heading_lft.jpg" width="19" /></td>
                        <td class="demos-heading-bg" width="100%">
                            <h2 class="demos-heading-bg">
                                &nbsp;<font face="Arial" size="4">Exporting Data - Aspose.Cells</font></h2>
                        </td>
                        <td valign="top" width="19">
                            <img alt="" height="41" src="/Common/images/heading_rt.jpg" width="19" /></td>
                    </tr>
                </table>
        </p>
    <p class="componentDescriptionTxt">
        <font face="Arial" size="2">This online demo shows how to retrieve data from a worksheet
            and <strong style="font-weight: 400">Export</strong> to fill a DataTable object
            using <a href="http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx">
                Aspose.Cells</a> for .NET </font>
    </p>
    <p class="componentDescriptionTxt">
        <font face="Arial" size="2">The demo gets data from a worksheet of an excel file and
            exports it to fill a DataTable. The example also binds the DataTable object to a
            DataGrid control. This is achieved through a single API of Aspose.Cells. All this
            is done with so much ease and it minimizes your coding lines which may extend while
            performing this operation manually.</font></SPAN></p>
    <p class="componentDescriptionTxt">
        <span style="font-size: 10pt; font-family: Arial"><font face="Arial" size="2"></font>
    	Click <b>Export Data</b> to see how example 
    	exports part of the excel file into a <b>DataTable</b> showing the table in a grid as a result. </span>
    </p>
    <p class="componentDescriptionTxt">
        <span style="font-size: 10pt; font-family: Arial"></span>
    <asp:Button runat="server" ID="Button1" Text="Export Data" /><span style="font-size: 10pt;
            font-family: Arial">
    <br />
        </span>
    <asp:DataGrid ID="DataGrid1" runat="server" CellPadding="4" CellSpacing="0" Width="90%"
        BorderColor="#aaaaaa">
    </asp:DataGrid></p>
</asp:Content>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Aspose.Cells;
using System.IO;

namespace Aspose.Cells.Demos
{
    /// <summary>
    /// Summary description for ExportData.
    /// </summary>
    public class ExportData : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.DataGrid dgExportData;
        protected System.Web.UI.WebControls.Button btnExportData;

        private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here
        }

        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.btnExportData.Click += new System.EventHandler(this.btnExportData_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void btnExportData_Click(object sender, System.EventArgs e)
        {
            //Open template
            string path = MapPath("~");
            path = path.Substring(0, path.LastIndexOf("\\"));
            path += @"\designer\book1.xls";

            //Instantiate a new workbook
            Workbook workbook = new Workbook(path);

            //Get the first worksheet in the workbook
            Worksheet worksheet = workbook.Worksheets[0];

            //Create a datatable
            DataTable dataTable = new DataTable();

            //Export worksheet data to a DataTable object by calling either ExportDataTable or ExportDataTableAsString method of the Cells class		 	
            dataTable = worksheet.Cells.ExportDataTable(0, 0, worksheet.Cells.MaxRow + 1,
                         worksheet.Cells.MaxColumn + 1);

            //Bind the DataGrid with DataTable
            dgExportData.DataSource = dataTable;
            dgExportData.ShowHeader = false;
            dgExportData.DataBind();

        }

    }
}