public static object GetData()
{
Workbook wb = new Workbook();
wb.LoadDocument("Employees.xlsx");
RangeDataSourceOptions options = new RangeDataSourceOptions();
options.UseFirstRowAsHeader = true;
options.CellValueConverter = new XPictureProvider(wb.Worksheets[0]);
return(wb.Worksheets[0].Tables[0].GetDataSource(options));
}
void spreadsheet_DocumentLoaded(object sender, EventArgs e)
{
#region #BindGridToSpreadsheetTable
IWorkbook workbook = spreadsheet.Document;
Worksheet worksheet = workbook.Worksheets[0];
// Access the table on the worksheet.
Table expensesTable = worksheet.Tables[0];
// Specify the data source settings.
RangeDataSourceOptions options = new RangeDataSourceOptions();
options.PreserveFormulas = true;
options.SkipHiddenRows = true;
// Bind the grid control to the table data.
grid.ItemsSource = expensesTable.DataRange.GetDataSource(options);
#endregion #BindGridToSpreadsheetTable
}
private void UseTableAsDataSource()
{
#region #TableAsDataSource
RangeDataSourceOptions options = new RangeDataSourceOptions();
Worksheet sheet = spreadsheetControl1.ActiveWorksheet;
Table sheetDataTable = sheet.Tables[0];
if (sheetDataTable.ShowHeaders)
{
options.UseFirstRowAsHeader = true;
}
else
{
options.UseFirstRowAsHeader = false;
}
options.EditingOptions = DataSourceEditingOptions.ReadOnly;
options.SkipHiddenColumns = false;
rangeDS = sheetDataTable.GetDataSource(options);
sheet.DataBindings.Error += DataBindings_Error;
#endregion #TableAsDataSource
BindControlsToDataSource();
}
private void UseRangeAsDataSource()
{
#region #RangeAsDataSource
RangeDataSourceOptions options = new RangeDataSourceOptions();
Worksheet sheet = spreadsheetControl1.ActiveWorksheet;
CellRange dataRange = sheet.Selection;
if (dataRange.Equals(sheet.Tables[0].Range))
{
options.UseFirstRowAsHeader = true;
}
else
{
options.UseFirstRowAsHeader = false;
options.DataSourceColumnTypeDetector = new MyColumnDetector();
}
options.SkipHiddenColumns = true;
rangeDS = dataRange.GetDataSource(options);
sheet.DataBindings.Error += DataBindings_Error;
#endregion #RangeAsDataSource
BindControlsToDataSource();
}
