csv file excel BOM for non-ascll characters

Sometimes you need to export a table to the Excel and other spreadsheets. CSV file saved in UTF-8 seems to be sufficiently universal format. But there is problem with non-ASCII characters in Excel. Excel default encoding depends on the system. The workaround is to put three magical bytes to the file beginning. They are called…

POI use excel function

was writing some xls file processing code need to use excel build in function XIRR Need to use Cell’s setCellType to CELL_TYPE_FORMULA Then setCellFormula   sample code: