JsonSaveOptions property. Indicates whether exporting empty cells as null...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Fill data with...
LabelActiveXControl property. Gets and set the descriptive text that appears on a control...void Run () { Workbookworkbook = new Workbook (); Worksheet...Worksheet sheet = workbook . Worksheets [ 0 ]; // Add Label ActiveX Control...
ListBoxActiveXControl property. Gets and sets the value of the control...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add a ListBox...
PowerQueryFormulaFunction property. Gets and sets the definition of function...static void Run () { // Load a workbook that contains existing Power...Query formulas Workbookworkbook = new Workbook ( "example.xlsx"...
Protection method. Gets the hash of current password...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Set protection...
RevisionCellMove property. Represents the type of revision...new workbook and get the first worksheet Workbookworkbook = new...new Workbook (); Worksheet worksheet = workbook . Worksheets...
DbfSaveOptions constructor. The options of saving .dbf file...Create a new workbook with sample data Workbookworkbook = new Workbook...(); Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add...