Class ExcelGridModelImportExtensions
Inheritance
Inherited Members
Namespace: Syncfusion.Windows.Controls.Grid.Converter
Assembly: Syncfusion.Spreadsheet.WPF.ClientProfile.dll
Syntax
public static class ExcelGridModelImportExtensions
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(SpreadsheetGridModel, IWorkbook, IWorksheet, IRange, ImportGridCellFromExcelHandler)
Converts the excel range to grid.
Declaration
public static void ConvertExcelRangeToGrid(SpreadsheetGridModel grid, IWorkbook book, IWorksheet sheet, IRange rangeToConvert, ImportGridCellFromExcelHandler importingHandler)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridModel | grid | The grid. |
IWorkbook | book | |
IWorksheet | sheet | The sheet. |
IRange | rangeToConvert | The range to convert. |
ImportGridCellFromExcelHandler | importingHandler | The importing handler. |
ConvertExcelRangeToVirtualGrid(SpreadsheetGridStyleInfo, IWorksheet, IRange, ImportGridCellFromExcelHandler)
Declaration
public static void ConvertExcelRangeToVirtualGrid(SpreadsheetGridStyleInfo cell, IWorksheet sheet, IRange rangeToConvert, ImportGridCellFromExcelHandler importingHandler)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridStyleInfo | cell | |
IWorksheet | sheet | |
IRange | rangeToConvert | |
ImportGridCellFromExcelHandler | importingHandler |
ConvertExcelRangeToVirtualGrid(SpreadsheetGridStyleInfo, IWorksheet, IRange, Boolean, ImportGridCellFromExcelHandler)
Converts the excel range to virtual grid.
Declaration
public static void ConvertExcelRangeToVirtualGrid(SpreadsheetGridStyleInfo cell, IWorksheet sheet, IRange rangeToConvert, bool ImportConditionalFormat, ImportGridCellFromExcelHandler importingHandler)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridStyleInfo | cell | The grid cell. |
IWorksheet | sheet | The sheet. |
IRange | rangeToConvert | The excel cell. |
System.Boolean | ImportConditionalFormat | |
ImportGridCellFromExcelHandler | importingHandler | The importing event handler. |
CopyHyperlinkToCell(IWorkbook, IWorksheet, IRange, GridStyleInfo)
Copies the hyperlink to normal grid.
Declaration
public static void CopyHyperlinkToCell(IWorkbook book, IWorksheet sheet, IRange excelrange, GridStyleInfo cell)
Parameters
Type | Name | Description |
---|---|---|
IWorkbook | book | |
IWorksheet | sheet | |
IRange | excelrange | The excelrange. |
GridStyleInfo | cell | The cell. |
CopyImageToGrid(IWorksheet, SpreadsheetGridModel)
Copies the image from excel worksheet into grid.
Declaration
public static void CopyImageToGrid(IWorksheet sheet, SpreadsheetGridModel grid)
Parameters
Type | Name | Description |
---|---|---|
IWorksheet | sheet | The sheet. |
SpreadsheetGridModel | grid | The grid. |
CopyMergesToGrid(IWorksheet, SpreadsheetGridModel)
Copies merged ranges into grid.
Declaration
public static void CopyMergesToGrid(IWorksheet sheet, SpreadsheetGridModel grid)
Parameters
Type | Name | Description |
---|---|---|
IWorksheet | sheet | Destination worksheet. |
SpreadsheetGridModel | grid | Source grid. |
CopySparkLineToGrid(IWorksheet, SpreadsheetGridModel)
Copies the sparkline groups from excel worksheet into grid.
Declaration
public static void CopySparkLineToGrid(IWorksheet sheet, SpreadsheetGridModel grid)
Parameters
Type | Name | Description |
---|---|---|
IWorksheet | sheet | The sheet. |
SpreadsheetGridModel | grid | The grid. |
ImportFromExcel(SpreadsheetGridModel, IWorkbook, IWorksheet)
Declaration
public static void ImportFromExcel(this SpreadsheetGridModel grid, IWorkbook book, IWorksheet sheet)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridModel | grid | |
IWorkbook | book | |
IWorksheet | sheet |
ImportFromExcel(SpreadsheetGridModel, IWorkbook, IWorksheet, ImportGridCellFromExcelHandler)
Imports single sheets from excel to Grid with importing event handler.
Declaration
public static void ImportFromExcel(this SpreadsheetGridModel grid, IWorkbook book, IWorksheet sheet, ImportGridCellFromExcelHandler importFromExcelHandler)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridModel | grid | The grid. |
IWorkbook | book | |
IWorksheet | sheet | The sheet. |
ImportGridCellFromExcelHandler | importFromExcelHandler |
ImportFromExcel(SpreadsheetGridModel, Stream)
Imports single sheets from excel to Grid.
Declaration
public static void ImportFromExcel(this SpreadsheetGridModel grid, Stream fileStream)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridModel | grid | The Grid. |
System.IO.Stream | fileStream | The File stream. |
ImportFromExcel(SpreadsheetGridModel, Stream, ImportGridCellFromExcelHandler)
Imports single sheets from excel to Grid with importing event handler.
Declaration
public static void ImportFromExcel(this SpreadsheetGridModel grid, Stream fileStream, ImportGridCellFromExcelHandler importFromExcelHandler)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridModel | grid | The Grid. |
System.IO.Stream | fileStream | The File stream. |
ImportGridCellFromExcelHandler | importFromExcelHandler | The importing event handler. |
ImportFromExcel(SpreadsheetGridModel, String)
Imports single sheets from excel to Grid.
Declaration
public static void ImportFromExcel(this SpreadsheetGridModel grid, string FileName)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridModel | grid | The Grid. |
System.String | FileName | Name of the file. |
ImportFromExcel(SpreadsheetGridModel, String, ImportGridCellFromExcelHandler)
Imports single sheets from excel to Grid with importing event handler.
Declaration
public static void ImportFromExcel(this SpreadsheetGridModel grid, string FileName, ImportGridCellFromExcelHandler importFromExcelHandler)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridModel | grid | The Grid. |
System.String | FileName | Name of the file. |
ImportGridCellFromExcelHandler | importFromExcelHandler | The importing event handler. |
ImportFromExcel(IWorkbook)
Imports the entire workbook.
Declaration
public static SpreadsheetGridModel[] ImportFromExcel(IWorkbook book)
Parameters
Type | Name | Description |
---|---|---|
IWorkbook | book | The book. |
Returns
Type | Description |
---|---|
SpreadsheetGridModel[] | Array of GridModels |
ImportFromExcel(IWorkbook, ImportGridCellFromExcelHandler)
Imports the entire workbook.
Declaration
public static SpreadsheetGridModel[] ImportFromExcel(IWorkbook book, ImportGridCellFromExcelHandler importFromExcelHandler)
Parameters
Type | Name | Description |
---|---|---|
IWorkbook | book | The book. |
ImportGridCellFromExcelHandler | importFromExcelHandler | The importing event handler. |
Returns
Type | Description |
---|---|
SpreadsheetGridModel[] | Array of GridModels |
ImportFromExcel(String, Int32[], SpreadsheetGridModel[])
Imports the particular sheets from excel to Grid Model array.
Declaration
public static void ImportFromExcel(string strFileName, int[] arrIndexes, SpreadsheetGridModel[] arrModels)
Parameters
Type | Name | Description |
---|---|---|
System.String | strFileName | Name of the file. |
System.Int32[] | arrIndexes | The array indexes. |
SpreadsheetGridModel[] | arrModels | The array models. |
ImportFromExcel(String, Int32[], SpreadsheetGridModel[], ImportGridCellFromExcelHandler)
Imports the particular sheets from excel to Grid Model array with importing event handler.
Declaration
public static void ImportFromExcel(string strFileName, int[] arrIndexes, SpreadsheetGridModel[] arrModels, ImportGridCellFromExcelHandler importFromExcelHandler)
Parameters
Type | Name | Description |
---|---|---|
System.String | strFileName | Name of the file. |
System.Int32[] | arrIndexes | The array indexes. |
SpreadsheetGridModel[] | arrModels | The array models. |
ImportGridCellFromExcelHandler | importFromExcelHandler | The importing event handler. |
ImportFromExcelToVirtualGrid(SpreadsheetGridModel, IWorkbook, IWorksheet, ImportGridCellFromExcelHandler)
Imports the single sheet from excel to virtual grid.
Declaration
public static void ImportFromExcelToVirtualGrid(this SpreadsheetGridModel grid, IWorkbook book, IWorksheet sheet, ImportGridCellFromExcelHandler importFromExcelHandler)
Parameters
Type | Name | Description |
---|---|---|
SpreadsheetGridModel | grid | The grid. |
IWorkbook | book | |
IWorksheet | sheet | The sheet. |
ImportGridCellFromExcelHandler | importFromExcelHandler | The importing event handler. |
ImportFromExcelToVirtualGrid(IWorkbook, ImportGridCellFromExcelHandler, Int32)
Imports the entire workbook from excel to virtual grid.
Declaration
public static SpreadsheetGridModel[] ImportFromExcelToVirtualGrid(IWorkbook book, ImportGridCellFromExcelHandler importFromExcelHandler, int sheetFamilyId)
Parameters
Type | Name | Description |
---|---|---|
IWorkbook | book | The book. |
ImportGridCellFromExcelHandler | importFromExcelHandler | importing event handler. |
System.Int32 | sheetFamilyId | Sheet family Id of FormulaEngine |
Returns
Type | Description |
---|---|
SpreadsheetGridModel[] | Array of GridModel |
ImportFromExcelToVirtualGrid(IWorkbook, Int32)
Imports the entire workbook from excel to virtual grid.
Declaration
public static SpreadsheetGridModel[] ImportFromExcelToVirtualGrid(IWorkbook book, int sheetFamilyID)
Parameters
Type | Name | Description |
---|---|---|
IWorkbook | book | The book. |
System.Int32 | sheetFamilyID | Sheet family Id of FormulaEngine |
Returns
Type | Description |
---|---|
SpreadsheetGridModel[] | 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 |