I have a workspace the writes to an excel file based off an excel template. The template has all of the rows set to filtered. How can I get the final output to include the filtered rows so I don't have to apply the filter every time I open the generated workbook?
Page 1 / 1
Hi,
Until unless you maintain
1. column as user attribute
2. row with xlsx_row_id
3. Sheet name as Feature Type Name
4. Writer mode as Update Cell Contents
it wont be any problem in writing in excel even if filter is applied
Unfortunately, I don't think that what you want to do is possible right now. Can you contact the support team with your request (http://safe.com/support)? Give them the reference PR#54202 which I think is an existing enhancement request for the same functionality. They will be able to tell you if it is the same issue, and if there is a workaround.