Cells.ExportDataTableAsString

ExportDataTableAsString(int, int, int, int)

Exports data in the Cells collection to a DataTable object.

public DataTable ExportDataTableAsString(int firstRow, int firstColumn, int totalRows, 
    int totalColumns)
ParameterTypeDescription
firstRowInt32The row number of the first cell to export out.
firstColumnInt32The column number of the first cell to export out.
totalRowsInt32Number of rows to be imported.
totalColumnsInt32Number of columns to be imported.

Return Value

Exported DataTable object.

Remarks

All data in the Cells collection are converted to strings.

Examples

using System;
using System.Data;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class CellsMethodExportDataTableAsStringWithInt32Int32Int32Int32Demo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            
            // Access the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];
            Cells cells = worksheet.Cells;

            // Add sample data to cells
            cells["A1"].PutValue("Column1");
            cells["B1"].PutValue("Column2");
            cells["A2"].PutValue("Value1");
            cells["B2"].PutValue("Value2");

            // Export data to DataTable as strings
            DataTable dataTable = cells.ExportDataTableAsString(0, 0, 2, 2);

            // Display the exported data
            Console.WriteLine("Exported DataTable:");
            foreach (DataColumn column in dataTable.Columns)
            {
                Console.Write(column.ColumnName + "\t");
            }
            Console.WriteLine();
            
            foreach (DataRow row in dataTable.Rows)
            {
                foreach (var item in row.ItemArray)
                {
                    Console.Write(item.ToString() + "\t");
                }
                Console.WriteLine();
            }
        }
    }
}

See Also

ExportDataTableAsString(int, int, int, int, bool)

Exports data in the Cells collection to a DataTable object.

public DataTable ExportDataTableAsString(int firstRow, int firstColumn, int totalRows, 
    int totalColumns, bool exportColumnName)
ParameterTypeDescription
firstRowInt32The row number of the first cell to export out.
firstColumnInt32The column number of the first cell to export out.
totalRowsInt32Number of rows to be imported.
totalColumnsInt32Number of columns to be imported.
exportColumnNameBooleanIndicates whether the data in the first row are exported to the column name of the DataTable.

Return Value

Exported DataTable object.

Remarks

All data in the Cells collection are converted to strings.

Examples

using System;
using System.Data;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class CellsMethodExportDataTableAsStringWithInt32Int32Int32Int32BooleanDemo
    {
        public static void Run()
        {
            // Create a workbook with sample data
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];
            
            // Add sample data to cells
            worksheet.Cells["A1"].PutValue("Name");
            worksheet.Cells["B1"].PutValue("Age");
            worksheet.Cells["A2"].PutValue("John");
            worksheet.Cells["B2"].PutValue(30);
            worksheet.Cells["A3"].PutValue("Alice");
            worksheet.Cells["B3"].PutValue(25);

            // Export data to DataTable
            int maxRow = worksheet.Cells.MaxDataRow + 1;
            int maxCol = worksheet.Cells.MaxDataColumn + 1;
            DataTable dataTable = worksheet.Cells.ExportDataTableAsString(0, 0, maxRow, maxCol, true);

            // Display the exported data
            foreach (DataRow row in dataTable.Rows)
            {
                foreach (DataColumn col in dataTable.Columns)
                {
                    Console.Write(row[col] + "\t");
                }
                Console.WriteLine();
            }
        }
    }
}

See Also