Enum ConnectionDataSourceType

ConnectionDataSourceType enumeration

Specifies external database source type

public enum ConnectionDataSourceType

Values

NameValueDescription
ODBCBasedSource1ODBC-based source
DAOBasedSource2DAO-based source
FileBasedDataBaseSource3File based database source
WebQuery4Web query
OLEDBBasedSource5OLE DB-based source
TextBasedSource6Text-based source
ADORecordSet7ADO record set
DSP8DSP
OLEDBDataModel100OLE DB data source created by the Spreadsheet Data Model.
DataFeedDataModel101Data feed data source created by the Spreadsheet Data Model.
WorksheetDataModel102Worksheet data source created by the Spreadsheet Data Model.
Table102Worksheet data source created by the Spreadsheet Data Model.
TextDataModel103Text data source created by the Spreadsheet Data Model.
Unknown255Text data source created by the Spreadsheet Data Model.

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.ExternalConnections;

namespace AsposeCellsExamples
{
    public class ExternalConnectionsClassConnectionDataSourceTypeDemo
    {
        public static void Run()
        {
            // Create a workbook with sample data
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets[0];
            
            // Add sample data to worksheet
            sheet.Cells["A1"].PutValue("Product");
            sheet.Cells["B1"].PutValue("Sales");
            sheet.Cells["A2"].PutValue("Item1");
            sheet.Cells["B2"].PutValue(1000);
            sheet.Cells["A3"].PutValue("Item2");
            sheet.Cells["B3"].PutValue(2000);

            // Create a pivot table using the worksheet data
            var pivotTable = sheet.PivotTables.Add("A1:B3", "D1", "PivotTable1");
            
            // Get the connection and demonstrate ConnectionDataSourceType
            var conn = sheet.PivotTables[0].GetSourceDataConnections()[0];
            Console.WriteLine("Connection Name: " + conn.Name);
            Console.WriteLine("Class Type: " + conn.ClassType);
            Console.WriteLine("Source Type: " + conn.SourceType);
            Console.WriteLine("Command: " + conn.Command);
            
            // Save the workbook
            workbook.Save("ExternalConnectionDemo.xlsx");
        }
    }
}

See Also