Excel filter for column

Posted by Ye Ding

Posted on Thu, 05/16/2019 - 12:30 in Reports & Macros

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!

3.4k

by Robert Goldenbaum

Posted on Thu, 05/16/2019 - 14:07

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

by Ye Ding Author

Posted on Fri, 06/07/2019 - 13:21

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.

by Robert Goldenbaum

Posted on Fri, 06/07/2019 - 13:53

_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