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!
Best Reply
RG
_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
4 Replies
-
RG
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
-
Hi, another way is to create xlsx file by direct using of apache POI library. Method: XSSFSheet.addValidationData(validation);
BR, Ilya
-
Hello Robert,
thanks for your reply. However, with the "CreateExcelWorkbook" I can only create a xls file rather a xlsx file.
Do you know any similar method but the outcome is a xlsx file? Thanks.
-
Best replyRG
_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