WorksheetExtensions.Import(Worksheet, Object, Int32, Int32, DataSourceImportOptions) Method
Imports data from a data source.
You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Docs.v24.2.dll
NuGet Package: DevExpress.Document.Processor
#Declaration
public static void Import(
this Worksheet sheet,
object dataSource,
int firstRowIndex,
int firstColumnIndex,
DataSourceImportOptions options
)
#Parameters
Name | Type | Description |
---|---|---|
sheet | Worksheet | A Worksheet that is the worksheet to which the data is imported. |
data |
Object | An object that is the data source for import. |
first |
Int32 | An integer that is the row index of the start cell in which the imported data will be inserted. |
first |
Int32 | An integer that is the column index of the start cell in which the imported data will be inserted. |
options | Data |
A Data |
#Remarks
You can specify object properties to import, as illustrated in the following code snippet..
#Example
List<TestObject> list = new List<TestObject>();
list.Add(new TestObject(1, "1", true));
list.Add(new TestObject(2, "2", false));
worksheet.Import(list, 0, 0, new DataSourceImportOptions() { PropertyNames = new string[] { "BoolValue", "IntValue" } });
class TestObject
{
public TestObject(int intValue, string value, bool boolValue)
{
this.intValue = intValue;
this.Value = value;
this.BoolValue = boolValue;
}
public int intValue;
private int privateValue { get { return 123; } }
public int IntValue { get { return intValue + privateValue - 123; } }
public string Value { get; set; }
public bool BoolValue { get; set; }
public int this[int index] { get { return index; } }
}