|
Title: Create .xlsx with Apache POI framework Post by: Stefan S. on May 23, 2017, 09:28:51 am Hello,
I have the following problem: I want to create an excel-sheet and want to set the print setup(gridlines, fitToPage, landscape) in my genero-code. In a first attempt i create the excel-sheet as in the example "Using the Apache POI framework" explained(fjs-fgl-3.00.00-manual). In this example an .xls-file is created. It works good, but in the Java HSSF-Classes some print setup options are not integrated (e.g. "fitToWidth"). So i try in a second attempt to use the XSSF-Classes. My research in the internet has revealed that this creates the more modern file-format .xlsx. The switch to XSSF and the printsetup-settings worked now perfectly, but there is another problem: The german "Umlaute" (äöü) are not displayed correctly. With HSSF it was no problem, with XSSF it does not work. What ist the diffrence regarding the language settings between HSSF and XSSF? The genero-code is the same, i have only switched from HSSF to XSSF. Thanks for your help! |