Class CellsDataTableFactory
Contents
[
Hide
]CellsDataTableFactory class
Utility to build ICellsDataTable from custom objects for user’s convenience.
public class CellsDataTableFactory
Methods
Name | Description |
---|---|
GetInstance(double[]) | |
GetInstance(ICollection) | Creates ICellsDataTable from given collection. |
GetInstance(int[]) | |
GetInstance(object[]) | |
GetInstance(double[], bool) | Creates ICellsDataTable from given sequence of double values. |
GetInstance(double[], string[]) | Creates ICellsDataTable from given sequence of double values. |
GetInstance(int[], bool) | Creates ICellsDataTable from given sequence of int values. |
GetInstance(int[], string[]) | Creates ICellsDataTable from given sequence of int values. |
GetInstance(object[], bool) | Creates ICellsDataTable from given sequence of objects. |
GetInstance(object[], string[]) | Creates ICellsDataTable from given sequence of objects. |
Examples
[C#]
using Aspose.Cells;
using System;
using System.Collections.Generic;
namespace Demos
{
public class CellsDataTableFactoryDemo
{
public static void RunDemo()
{
// Create a new workbook
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
// Add some sample data
List<CustomData> dataList = new List<CustomData>
{
new CustomData { Id = 1, Name = "John Doe", Age = 30 },
new CustomData { Id = 2, Name = "Jane Smith", Age = 25 },
new CustomData { Id = 3, Name = "Sam Brown", Age = 35 }
};
// Get the CellsDataTableFactory instance from the workbook
CellsDataTableFactory factory = workbook.CellsDataTableFactory;
// Create an ICellsDataTable instance from the custom data list
ICellsDataTable dataTable = factory.GetInstance(dataList);
// Import the data table into the worksheet starting at cell A1
sheet.Cells.ImportData(dataTable, 0, 0, new ImportTableOptions());
// Save the workbook
workbook.Save("CellsDataTableFactoryDemo.xlsx");
workbook.Save("CellsDataTableFactoryDemo.pdf");
}
}
// Custom data class
public class CustomData
{
public int Id { get; set; }
public string Name { get; set; }
public int Age { get; set; }
}
}
See Also
- namespace Aspose.Cells
- assembly Aspose.Cells