Class SpreadsheetImportExtension
Represents a class which holds the functions for importing the worksheets from excel workbook into SpreadsheetGrid.
Inheritance
System.Object
SpreadsheetImportExtension
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Syncfusion.UI.Xaml.Spreadsheet.Converter
Assembly: Syncfusion.SfSpreadsheet.WPF.dll
Syntax
public static class SpreadsheetImportExtensionRemarks
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)
Converts the System.Drawing.Color into corresponding System.Windows.Media.SolidColorBrush.
Declaration
public static SolidColorBrush ConvertColorToBrush(this Color excelColor)Parameters
| Type | Name | Description |
|---|---|---|
| System.Drawing.Color | excelColor | An instance of System.Drawing.Color. |
Returns
| Type | Description |
|---|---|
| System.Windows.Media.SolidColorBrush | An instance of System.Windows.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.