WPF

Upgrade Guide User Guide Demos Support Forums Download
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class SpreadsheetImportExtension - WPF API Reference | Syncfusion

    Show / Hide Table of Contents

    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.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.Spreadsheet.Converter
    Assembly: Syncfusion.SfSpreadsheet.WPF.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)

    Converts the System.Drawing.Color into corresponding System.Windows.Media.SolidColorBrush.

    Declaration
    public static SolidColorBrush ConvertColorToBrush(this Color excelColor)
    Parameters
    Type Name Description
    System.Drawing.Color excelColor

    An instance of System.Drawing.Color.

    Returns
    Type Description
    System.Windows.Media.SolidColorBrush

    An instance of System.Windows.Media.SolidColorBrush.

    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.

    Back to top Generated by DocFX
    Copyright © 2001 - 2021 Syncfusion Inc. All Rights Reserved