Game development
In order to manipulate formulas in Apache POI, we use the method setCellFormula(«formula») of HSSFCell class. Similar to Microsoft Excel, we can use mathematics formulas (A1+B2+C3, B5*A2, …) and Excel’s functions (SUM, COUNT, MAX, …). When we use excel functions, Seguir leyendo Apache POI: Usage of formulas and excel functions
In the previous entry about apache POI, we saw how to create excel files with Java and Apache POI. This time, we’ll see how to customize the style of these excel files. How to create a style for a cell Seguir leyendo Apache POI: How to define styles for excel files
Commonly it’s necessary to manage Microsoft Excel files from Java applications. It can be usefull, for example, to export / import data, report generation, etc. Apache POI is a library from Apache fundation, which has become a de facto standard Seguir leyendo How to generate MS Excel files from Java with Apache POI