Class GridModelImportExtensions

Inheritance

System.Object

GridModelImportExtensions

Namespace: Syncfusion.Windows.Controls.Grid.Converter

Assembly: Syncfusion.GridConverter.Wpf.dll

Syntax

public static class GridModelImportExtensions : Object

Methods

AppendFormat(IFont, Run)

Declaration

public static Run AppendFormat(IFont charfont, Run run)

Parameters

Type	Name	Description
IFont	charfont
System.Windows.Documents.Run	run

Returns

Type
System.Windows.Documents.Run

ConvertCellValueToParagraph(IRichTextString)

Declaration

public static FlowDocument ConvertCellValueToParagraph(IRichTextString RichText)

Parameters

Type	Name	Description
IRichTextString	RichText

Returns

Type
System.Windows.Documents.FlowDocument

ConvertExcelRangeToGrid(GridModel, IWorksheet, IRange, GridCellImportFromExcelHandler)

Converts the excel range to grid.

Declaration

public static void ConvertExcelRangeToGrid(GridModel grid, IWorksheet sheet, IRange rangeToConvert, GridCellImportFromExcelHandler importingHandler)

Parameters

Type	Name	Description
GridModel	grid	The grid.
IWorksheet	sheet	The sheet.
IRange	rangeToConvert	The range to convert.
GridCellImportFromExcelHandler	importingHandler	The importing handler.

ConvertExcelRangeToVirtualGrid(GridStyleInfo, IWorksheet, IRange, GridCellImportFromExcelHandler)

Declaration

public static void ConvertExcelRangeToVirtualGrid(GridStyleInfo cell, IWorksheet sheet, IRange rangeToConvert, GridCellImportFromExcelHandler importingHandler)

Parameters

Type	Name	Description
GridStyleInfo	cell
IWorksheet	sheet
IRange	rangeToConvert
GridCellImportFromExcelHandler	importingHandler

ConvertExcelRangeToVirtualGrid(GridStyleInfo, IWorksheet, IRange, Boolean, GridCellImportFromExcelHandler)

Converts the excel range to virtual grid.

Declaration

public static void ConvertExcelRangeToVirtualGrid(GridStyleInfo cell, IWorksheet sheet, IRange rangeToConvert, bool ImportConditionalFormat, GridCellImportFromExcelHandler importingHandler)

Parameters

Type	Name	Description
GridStyleInfo	cell	The grid cell.
IWorksheet	sheet	The sheet.
IRange	rangeToConvert	The excel cell.
System.Boolean	ImportConditionalFormat
GridCellImportFromExcelHandler	importingHandler	The importing event handler.

CopyComboBoxToGrid(IWorksheet, GridModel)

Copies the combox from excel worksheet into grid.

Declaration

public static void CopyComboBoxToGrid(IWorksheet sheet, GridModel grid)

Parameters

Type	Name	Description
IWorksheet	sheet	The sheet.
GridModel	grid	The grid.

ImportFromExcel(GridModel, IWorksheet)

Imports single sheets from excel to Grid.

Declaration

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

Parameters

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

ImportFromExcel(GridModel, IWorksheet, GridCellImportFromExcelHandler)

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

Declaration

public static void ImportFromExcel(this GridModel grid, IWorksheet sheet, GridCellImportFromExcelHandler importFromExcelHandler)

Parameters

Type	Name	Description
GridModel	grid	The grid.
IWorksheet	sheet	The sheet.
GridCellImportFromExcelHandler	importFromExcelHandler

ImportFromExcel(GridModel, Stream)

Imports single sheets from excel to Grid.

Declaration

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

Parameters

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

ImportFromExcel(GridModel, Stream, GridCellImportFromExcelHandler)

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

Declaration

public static void ImportFromExcel(this GridModel grid, Stream fileStream, GridCellImportFromExcelHandler importFromExcelHandler)

Parameters

Type	Name	Description
GridModel	grid	The Grid.
System.IO.Stream	fileStream	The File stream.
GridCellImportFromExcelHandler	importFromExcelHandler	The importing event handler.

ImportFromExcel(GridModel, String)

Imports single sheets from excel to Grid.

Declaration

public static void ImportFromExcel(this GridModel grid, string FileName)

Parameters

Type	Name	Description
GridModel	grid	The Grid.
System.String	FileName	Name of the file.

ImportFromExcel(GridModel, String, GridCellImportFromExcelHandler)

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

Declaration

public static void ImportFromExcel(this GridModel grid, string FileName, GridCellImportFromExcelHandler importFromExcelHandler)

Parameters

Type	Name	Description
GridModel	grid	The Grid.
System.String	FileName	Name of the file.
GridCellImportFromExcelHandler	importFromExcelHandler	The importing event handler.

ImportFromExcel(IWorkbook)

Imports the entire workbook.

Declaration

public static GridModel[] ImportFromExcel(IWorkbook book)

Parameters

Type	Name	Description
IWorkbook	book	The book.

Returns

Type	Description
GridModel[]	Array of GridModels

ImportFromExcel(IWorkbook, GridCellImportFromExcelHandler)

Imports the entire workbook.

Declaration

public static GridModel[] ImportFromExcel(IWorkbook book, GridCellImportFromExcelHandler importFromExcelHandler)

Parameters

Type	Name	Description
IWorkbook	book	The book.
GridCellImportFromExcelHandler	importFromExcelHandler	The importing event handler.

Returns

Type	Description
GridModel[]	Array of GridModels

ImportFromExcel(String, Int32[], GridModel[])

Imports the particular sheets from excel to Grid Model array.

Declaration

public static void ImportFromExcel(string strFileName, int[] arrIndexes, GridModel[] arrModels)

Parameters

Type	Name	Description
System.String	strFileName	Name of the file.
System.Int32[]	arrIndexes	The array indexes.
GridModel[]	arrModels	The array models.

ImportFromExcel(String, Int32[], GridModel[], GridCellImportFromExcelHandler)

Imports the particular sheets from excel to Grid Model array with importing event handler.

Declaration

public static void ImportFromExcel(string strFileName, int[] arrIndexes, GridModel[] arrModels, GridCellImportFromExcelHandler importFromExcelHandler)

Parameters

Type	Name	Description
System.String	strFileName	Name of the file.
System.Int32[]	arrIndexes	The array indexes.
GridModel[]	arrModels	The array models.
GridCellImportFromExcelHandler	importFromExcelHandler	The importing event handler.

ImportFromExcelToVirtualGrid(GridModel, IWorkbook, IWorksheet, GridCellImportFromExcelHandler)

Imports the single sheet from excel to virtual grid.

Declaration

public static void ImportFromExcelToVirtualGrid(this GridModel grid, IWorkbook book, IWorksheet sheet, GridCellImportFromExcelHandler importFromExcelHandler)

Parameters

Type	Name	Description
GridModel	grid	The grid.
IWorkbook	book
IWorksheet	sheet	The sheet.
GridCellImportFromExcelHandler	importFromExcelHandler	The importing event handler.

ImportFromExcelToVirtualGrid(IWorkbook)

Imports the entire workbook from excel to virtual grid.

Declaration

public static GridModel[] ImportFromExcelToVirtualGrid(IWorkbook book)

Parameters

Type	Name	Description
IWorkbook	book	The book.

Returns

Type	Description
GridModel[]	Array of GridModel

ImportFromExcelToVirtualGrid(IWorkbook, GridCellImportFromExcelHandler)

Imports the entire workbook from excel to virtual grid.

Declaration

public static GridModel[] ImportFromExcelToVirtualGrid(IWorkbook book, GridCellImportFromExcelHandler importFromExcelHandler)

Parameters

Type	Name	Description
IWorkbook	book	The book.
GridCellImportFromExcelHandler	importFromExcelHandler	importing event handler.

Returns

Type	Description
GridModel[]	Array of GridModel

IsFormatSame(IFont, IFont)

Declaration

public static bool IsFormatSame(IFont char1, IFont char2)

Parameters

Type	Name	Description
IFont	char1
IFont	char2

Returns

Type
System.Boolean