WPF

Code Examples Upgrade Guide User Guide Demos Support Forums Download
  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class GridModelImportExtensions

    Show / Hide Table of Contents

    Class GridModelImportExtensions

    Inheritance
    System.Object
    GridModelImportExtensions
    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.Windows.Controls.Grid.Converter
    Assembly: Syncfusion.GridConverter.Wpf.dll
    Syntax
    public static class GridModelImportExtensions

    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 Description
    System.Windows.Documents.Run

    ConvertCellValueToParagraph(IRichTextString)

    Declaration
    public static FlowDocument ConvertCellValueToParagraph(IRichTextString RichText)
    Parameters
    Type Name Description
    IRichTextString RichText
    Returns
    Type Description
    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 Description
    System.Boolean
    Back to top Generated by DocFX
    Copyright © 2001 - 2023 Syncfusion Inc. All Rights Reserved