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(); }