PivotTableCollection method. Deletes the specified PivotTable and delete the PivotTable data...Create a workbook from source Excel file Workbookworkbook = new...new Workbook ( "PivotTableExample.xlsx" ); // Access first worksheet...
LoadOptions property. Gets and sets the auto fitter options...Load workbook with the specified options Workbookworkbook = new...new Workbook ( "example.xlsx" , loadOptions ); // Demonstrate...
TextEffectFormat property. The name of the font used in the WordArt...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add a WordArt...
RenderingWatermark property. Gets or sets opacity of the watermark in range 0 1...void Run () { Workbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; worksheet . Cells [...
WorkbookSettings property. Enable macros...worksheet to other worksheet in a workbook. Examples using System ; using...Create a new workbookWorkbook wb = new Workbook (); // Access...
FormatCondition method. Gets the value or expression associated with this format condition...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add sample data...