Package com.aspose.cells

Examples of com.aspose.cells.Workbook.save()


font.setColor(color);

cell.setStyle(style);
   
    //Saving the Excel file
    workbook.save("data/AsposeColors.xls");
   
    System.out.println("Aspose Colors Created.");

  }
}
View Full Code Here


   
    cells.hideRow(2); //Hiding the 3rd row of the worksheet
    cells.hideColumn(1); //Hiding the 2nd column of the worksheet
   
    //Saving the modified Excel file in default (that is Excel 2003) format
    workbook.save("data/hideUnhideCells_Aspose.xls");

        //Print message
        System.out.println("Rows and Columns hidden successfully.");          

  }
View Full Code Here

    //Dragging the third field to the data area.
    pivotTable.addFieldToArea(PivotFieldType.DATA,2);

    //Saving the Excel file
    workbook.save("data/AsposePivotTable.xls");
   
    // Print Message
    System.out.println("Pivot Table created successfully.");
  }
}
View Full Code Here

    //Setting the current page number and page count at the right footer
    pageSetup.setFooter(2, "&Pof&N");
   
    //Saving the workbook
    workbook.save("data/AsposeHeaderFooter.xls");

    System.out.println("Aspose Header Footer Created.");
  }
}
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.