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.WPF.dll

Syntax

public static class SpreadsheetImportExtension : Object

Remarks

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.