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!
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
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.
_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);
Example: https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LinkedDropDownLists.java
BR, Ilya