09-12-2017 10:22 AM
I want to output two reports vertically within one Excel worksheet using ods tagsets.excelxp, and apply autofilters on both reports. However when I use ods tagsets.excelxp options(autofilter='all'), only the first report has the autofilter. It doesn't apply to the second report. Is there anyway to have autofilter on both reports? Thanks!
09-12-2017 10:30 AM
No, this is not possible. Nor is is possible in Excel as far as I am aware. You could export your data to CSV, then have an Excel file with some VBA to read this CSV data and put the result into two Tables each with their own filters. However it is worth mentioning at this point that Excel is not a good data medium, nor is it a reporting enviroment. Perhaps consider what you are doing, and if (there will be) a better way of doing things.