writeCacheToExcelFile ( string pathOrigine , boolean isXLSXformat , boolean _pathDestination ) : void
Write data from the cache to an Excel file.
It is the logical end action after using writeInExcelCache to send your data in the real Excel file.
Sometimes you need the isXLSXformat=true with xls !
Debug
If you have this error :
org.apache.poi.hssf.usermodel.HSSFWorkbook cannot be cast to org.apache.poi.xssf.usermodel.XSSFWorkbook
Set another value to isXLSXformat
See also
clearExcelCachewriteInExcelCache
Parameters
pathOrigine
Path for Excel file of origine. It helps us to find data in the cache implemented by readExcel and writeInExcelCache.
isXLSXformat
XLSX or XLS? (if wrong generate an error HSSFWorkbook/XSSFWorkbook Exception)
_pathDestination (optional)
Path for Excel file of destination where data will be written. If null (this is most of the time the case), it is the same than pathOrigine.