Click or drag to resize
ComHelper Class
Contains methods that can be useful for users which are calling GemBox.Spreadsheet component using COM interop.
Inheritance Hierarchy
SystemObject
  GemBox.SpreadsheetComHelper

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1033
Syntax
public class ComHelper

The ComHelper type exposes the following members.

Constructors
  NameDescription
Public methodComHelper
Initializes a new instance of the ComHelper class.
Top
Methods
  NameDescription
Public methodComSetLicense
Call this method from your application to set GemBox.Spreadsheet serial key.
Public methodGetColumn
Gets the column from a sheet with the specified index.
Public methodGetRow
Gets the row from a sheet with the specified index.
Public methodCode exampleLoad
Loads a spreadsheet from a file with the specified path.
Public methodCode exampleLoadWithOptions
Loads a spreadsheet from a file with the specified path.
Public methodLoadXlsxFromDirectory
Loads all parts of XLSX file as separate files from input directory.
Public methodRemoveColumn
Removes the column with the specified index.
Public methodRemoveRow
Removes the row with the specified index.
Public methodSaveEntireFileToPdf
Saves the entire spreadsheet to PDF file with the specified path.
Public methodCode exampleSaveWithOptions
Saves the spreadsheet to a file with the specified path.
Public methodSaveXlsxToDirectory
Saves all parts of XLSX file as separate files to output directory.
Public methodSetFrozenWorksheetPanes
Sets frozen worksheet panes for freezing rows and columns.
Top
See Also