Hello Community,
I am creating an xlsx file with the standard output file function, Context.createOutputObject().
Is there any way to create a filter for each column in this excel table?
Thanks in advance!
Hi,
well, you could use a template file for creating the output file...
_strConfigFile = sNameTemplate;
_abTemplateFile = Context.getFile(_strConfigFile, Constants.LOCATION_SCRIPT);
_oWorkbook = Context.createExcelWorkbook(_sFileName, _abTemplateFile);
BR Robert
_strConfigFile = Context.getScriptInfo(Constants.SCRIPT_NAME) + ".xlsx";
_abTemplateFile = Context.getFile(_strConfigFile, Constants.LOCATION_SCRIPT);
_oWorkbook = Context.createExcelWorkbook(_sFileName, _abTemplateFile);
Works with xlsx as target as well... You just have to set the output format for the output file to xlsx
Hi, another way is to create xlsx file by direct using of apache POI library. Method: XSSFSheet.addValidationData(validation);
BR, Ilya