I have some excel sheets with Japanese font. My project requirement is that to populate dynamic data into these excel sheets and later convert into in pdf. It should do some basic mathematical operation as wel. Is it possible using aspose. Please guide me.
Hi there,
I have some more doubts. I am looking for this tool for my project procurement.
- Does it need any installation of excel/ word or adobe or any other software.
- Our server is on Suse Linux machine. Will it fine.
- As you mentioned for font we need to install true font. Is there is any other issue other than this.
- Is it possible to perform cell operation like addition/ multiplication of some rows and show result. Please give an example.
Thanks.
Hi again,
- You do not need to install Excel or any other office application in order to work with Aspose.Cells APIs.
- Aspose.Cells for Java APIs only require the Java runtime to be installed. If it is present on your Linux server, you will not face any problems.
- Most Linux flavors do not come with TrueType fonts pre-installed therefore it is advised to manually install/place the required fonts on the machine where you need to perform the rendering operations.
- Yes, you can use any of the Excel’s built-in formulas in your worksheet and later call the Workbook.calculateFormula method in order to calculate the function values. Please check the following piece of code for better understanding.
Workbook book = new Workbook();
// Access the default/first worksheet from the collection
Worksheet sheet = book.getWorksheets().get(0);
// Access Cells collection from default worksheet
Cells cells = sheet.getCells();
// Input some static data
cells.get(“A1”).putValue(2);
cells.get(“B1”).putValue(3);
// Insert some formulas based on static values as above
cells.get(“A3”).setFormula(“A1+B1”);
cells.get(“B3”).setFormula(“A1*B1”);
cells.get(“C3”).setFormula(“A1/B1”);
cells.get(“D3”).setFormula(“A1-B1”);
// Calculate formulas
book.calculateFormula();
// Render to PDF
book.save(dir + “output.pdf”);