Aspose.Cells.GridWeb.Examples.CSharp.Worksheets.ExportDataTable.btnExportDataTable_Click C# (CSharp) Method

        protected void btnExportDataTable_Click(object sender, EventArgs e)
        {
            // ExStart:ExportDataTable
            // Creating a new DataTable object
            DataTable dataTable = new DataTable();

            // Adding specific columns to the DataTable object
            dataTable.Columns.Add("Name", System.Type.GetType("System.String"));
            dataTable.Columns.Add("Gender", System.Type.GetType("System.String"));
            dataTable.Columns.Add("Age", System.Type.GetType("System.Int32"));
            dataTable.Columns.Add("Class", System.Type.GetType("System.String"));

            // Accessing the reference of the worksheet that is currently active
            GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

            // Getting the total number of rows and columns inside the worksheet
            int totalColumns = sheet.Cells.MaxColumn + 1;
            int totalRows = sheet.Cells.MaxRow + 1;

            // Exporting the data of the active worksheet to a specific DataTable object
            dataTable = sheet.Cells.Export(0, 0, totalRows, totalColumns, true, true);
            
            // Display exported data table in GridView
            GridView1.DataSource = dataTable;
            GridView1.DataBind();
            // ExEnd:ExportDataTable

            // ExStart:ExportNewDataTable
            // Accessing the reference of the worksheet that is currently active
            GridWorksheet sheet1 = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

            // Getting the total number of rows and columns inside the worksheet
            int totalColumns1 = sheet.Cells.MaxColumn + 1;
            int totalRows1 = sheet.Cells.MaxRow + 1;

            // Exporting the data of the active worksheet to a new DataTable object
            DataTable dt = sheet.Cells.Export(0, 0, totalRows1, totalColumns1, true, true);
            
            // Display exported data table in GridView
            GridView2.DataSource = dataTable;
            GridView2.DataBind();
            // ExEnd:ExportNewDataTable

            trResult.Visible = true;

        }
    }