public static void GetExcelTableAsPocoList([Excel(
Path = "TestSheet.xlsx",
WorksheetName = "Sheet1",
TableName = "sampletable",
UserId = "%UserId%",
Identity = TokenIdentityMode.UserFromId)] PartsTableRow table)
{
//Note that each POCO object represents one row, and the values correspond to
//the column titles that match the POCO's property names.
}
public static void AppendRowToExcelTableWithSinglePoco([Excel(
Path = "TestSheet.xlsx",
WorksheetName = "Sheet1",
TableName = "Parts",
UserId = "%UserId%",
Identity = TokenIdentityMode.UserFromId)] out PartsTableRow output)
{
output = new PartsTableRow
{
Part = "samplepartname",
Id = 42,
Price = 3.75,
};
}
public static void UpdateEntireExcelTableWithPocos(
[Excel(
Path = "TestSheet.xlsx",
WorksheetName = "Sheet1",
TableName = "Parts",
UserId = "%UserId%",
UpdateType = "Update",
Identity = TokenIdentityMode.UserFromId)] out PartsTableRow[] output)
{
output = new PartsTableRow[2];
output[0] = (new PartsTableRow
{
Part = "part1",
Id = 35,
Price = 0.75
});
output[1] = (new PartsTableRow
{
Part = "part2",
Id = 73,
Price = 42.37,
});
}
