PivotField property. Represents the function used to summarize this PivotTable data field...Create a workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; Cells cells = worksheet...
PivotTable property. Indicates whether to show grand totals for columns of this pivot table...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet sheet = workbook . Worksheets [ 0 ]; // Add sample data...
ReplaceOptions property. Indicates whether to match entire cells contents...Create a workbook with sample data Workbookworkbook = new Workbook...(); Worksheet worksheet = workbook . Worksheets [ 0 ]; // Set...
Worksheet property. Gets all ListObjects in this worksheet...Create a new workbookWorkbookworkbook = new Workbook (); // Access...worksheet Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add...
TickLabels property. Gets and sets the direction of text...Create a workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add sample data...
TickLabels property. Gets and sets the display number format of tick labels...Create a new workbookWorkbookworkbook = new Workbook (); // Access...worksheet Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add...
Sparkline property. Gets the column index of the sparkline...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet sheet = workbook . Worksheets [ 0 ]; // Add sample data...
Series property. True if the series has a shadow...void Run () { Workbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add sample data...
ExternalConnectionCollection property. Gets the ExternalConnection element at the specified index...Create a new workbookWorkbookworkbook = new Workbook (); try {...ExternalConnectionCo connections = workbook . DataConnections ; // Check...
ThreadedCommentAuthorCollection property. Gets the person who create threaded comments...void Run () { Workbookworkbook = new Workbook (); ThreadedCommentAutho...ThreadedCommentAutho authors = workbook . Worksheets . ThreadedCommentAutho...