Enum TableDataSourceType

TableDataSourceType enumeration

Represents the table’s data source type.

public enum TableDataSourceType

Values

NameValueDescription
Worksheet0Excel Worksheet Table
SharePoint1Read-write SharePoint linked List
XML2XML mapper Table
QueryTable3Query Table

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using Aspose.Cells.Tables;
    using System;

    public class TableDataSourceTypeDemo
    {
        public static void TableDataSourceTypeExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();

            // Add a new worksheet to the workbook
            Worksheet worksheet = workbook.Worksheets[0];

            // Add sample data to the worksheet
            worksheet.Cells["A1"].PutValue("ID");
            worksheet.Cells["A2"].PutValue(1);
            worksheet.Cells["A3"].PutValue(2);
            worksheet.Cells["A4"].PutValue(3);

            worksheet.Cells["B1"].PutValue("Name");
            worksheet.Cells["B2"].PutValue("Alice");
            worksheet.Cells["B3"].PutValue("Bob");
            worksheet.Cells["B4"].PutValue("Charlie");

            // Add a ListObject (table) to the worksheet
            int listObjectIndex = worksheet.ListObjects.Add(1, 0, 4, 1, true);
            ListObject listObject = worksheet.ListObjects[listObjectIndex];

            // Set the display name of the table
            listObject.DisplayName = "SampleTable";

            // Set the data source type of the table
            TableDataSourceType dataSourceType = listObject.DataSourceType;

            // Output the data source type
            Console.WriteLine("Data Source Type: " + dataSourceType);

            // Save the workbook
            workbook.Save("TableDataSourceTypeExample.xlsx");
        }
    }
}

See Also