Class SpreadsheetImportExtension
Represents a class which holds the functions for importing the worksheets from excel workbook into SpreadsheetGrid.
Inheritance
System.Object
SpreadsheetImportExtension
Namespace: Syncfusion.UI.Xaml.Spreadsheet.Converter
Assembly: Syncfusion.SfSpreadsheet.UWP.dll
Syntax
public static class SpreadsheetImportExtension : ObjectRemarks
This class imports the formulas,charts, sparklines, images, merge cells, named ranges, border, background colors, etc., from the worksheet using XlsIO into SpreadsheetGrid.
Methods
ConvertColorToBrush(Color)
Declaration
public static SolidColorBrush ConvertColorToBrush(this Color excelColor)Parameters
| Type | Name | Description |
|---|---|---|
| Windows.UI.Color | excelColor |
Returns
| Type |
|---|
| Windows.UI.Xaml.Media.SolidColorBrush |
ImportWorksheetToGrid(SpreadsheetGrid, IWorksheet)
Imports single sheets from excel worbook to SpreadsheetGrid.
Declaration
public static void ImportWorksheetToGrid(this SpreadsheetGrid grid, IWorksheet sheet)Parameters
| Type | Name | Description |
|---|---|---|
| SpreadsheetGrid | grid | An instance of SpreadsheetGrid. |
| IWorksheet | sheet | An instance of IWorksheet. |
Remarks
Sets the grid lines and headers visibility, importing of rows/columns, merges, images, textboxes and charts in the workbook.