Class ExcelImportExtension

Done the operation of importing of excel sheet into grid.

Inheritance

System.Object

ExcelImportExtension

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.CellGrid.Converter

Assembly: Syncfusion.SfCellGrid.WPF.dll

Syntax

public static class ExcelImportExtension

Methods

ImportExcelRangeToGrid(SfCellGrid, IWorksheet, IRange, ExcelImportingOptions)

Actual operation of importing excel cellvalues and styles are importing done here

Declaration

public static void ImportExcelRangeToGrid(SfCellGrid grid, IWorksheet sheet, IRange rangeToConvert, ExcelImportingOptions importoptions)

Parameters

Type	Name	Description
SfCellGrid	grid	importing to grid
IWorksheet	sheet	importing sheet
IRange	rangeToConvert	source cell range
ExcelImportingOptions	importoptions	Excel importing options

ImportFromExcel(SfCellGrid, IWorksheet)

Imports single sheets from excel to Grid.

Declaration

public static void ImportFromExcel(this SfCellGrid grid, IWorksheet sheet)

Parameters

Type	Name	Description
SfCellGrid	grid	The grid.
IWorksheet	sheet	The Sheet.

ImportFromExcel(SfCellGrid, IWorksheet, ExcelImportingOptions)

Imports single sheets from excel to Grid with importing event handler.

Declaration

public static void ImportFromExcel(this SfCellGrid grid, IWorksheet sheet, ExcelImportingOptions importingoptions)

Parameters

Type	Name	Description
SfCellGrid	grid	The grid.
IWorksheet	sheet	The sheet.
ExcelImportingOptions	importingoptions	Excel importing options.

ImportFromExcel(SfCellGrid, Stream)

Imports single sheet from excel to Grid.

Declaration

public static void ImportFromExcel(this SfCellGrid grid, Stream fileStream)

Parameters

Type	Name	Description
SfCellGrid	grid	The Grid.
System.IO.Stream	fileStream	The File stream.

ImportFromExcel(SfCellGrid, Stream, ExcelImportingOptions)

Imports single sheets from excel to Grid with excel importing options

Declaration

public static void ImportFromExcel(this SfCellGrid grid, Stream fileStream, ExcelImportingOptions importingoptions)

Parameters

Type	Name	Description
SfCellGrid	grid	The Grid.
System.IO.Stream	fileStream	The File stream.
ExcelImportingOptions	importingoptions	excelimportingoptions.

ImportFromExcel(SfCellGrid, String)

Imports single sheets from excel to Grid.

Declaration

public static void ImportFromExcel(this SfCellGrid grid, string file)

Parameters

Type	Name	Description
SfCellGrid	grid	The Grid.
System.String	file	File to import.

ImportFromExcel(SfCellGrid, String, ExcelImportingOptions)

Imports single sheets from excel to Grid with excel importing options.

Declaration

public static void ImportFromExcel(this SfCellGrid grid, string file, ExcelImportingOptions importingoptions)

Parameters

Type	Name	Description
SfCellGrid	grid	The Grid.
System.String	file	File to import
ExcelImportingOptions	importingoptions	Excel importing options.