Worksheet method. Filters the range...new workbook and get the first worksheet Workbookworkbook = new...new Workbook (); Worksheet worksheet = workbook . Worksheets...
Represents the style of the table....TableStyle ; Example const { Workbook , BackgroundType , Color ...AsposeCells ; var workbook = new Workbook (); var firstColumnStyle...
WorkbookDesigner method. Processes the smart markers and populates the data source values...Create a new workbookWorkbook wb = new Workbook (); // Access...( "&=$Value" ); // Create workbook designer WorkbookDesigner...
Chart method. Change chart type with a preset template...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add sample data...
Chart property. Returns all drawing shapes in this chart...Create a new workbookWorkbookworkbook = new Workbook (); // Access...worksheet Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add...
DataLabels property. Indicates whether to show cell range as the data labels...// Create workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Set sample data...
ChartDataTable property. True if the text in the object changes font size when the object size changes. The default value is True...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add sample data...
PivotDateTimeRangeGroupSettings property. Gets the start date time of the group...Create a new workbookWorkbookworkbook = new Workbook (); Worksheet...Worksheet worksheet = workbook . Worksheets [ 0 ]; // Add sample data...
Aspose.Cells.Pivot.PivotFieldGroupType enum. Represents the group type of pivot field...Create a new workbookWorkbookworkbook = new Workbook (); // Add...worksheet to the workbook Worksheet worksheet = workbook . Worksheets...