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.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Syncfusion.Windows.Forms.Spreadsheet.Converter

Assembly: Syncfusion.Spreadsheet.Windows.dll

Syntax

public static class SpreadsheetImportExtension

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)

Declaration

public static SolidBrush ConvertColorToBrush(this Color excelColor)

Parameters

Type	Name	Description
System.Drawing.Color	excelColor

Returns

Type
System.Drawing.SolidBrush

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.