Hi All,
I am trying to allow the users to export data from sheets which we have in a dashboard. I am currently using getUnderlyingTablesAsync() & .getUnderlyingTableDataAsync to do the export. The export part works fine.
Currently the user see all the sheets some of which are hidden and do not have any data.
Is there a way to identify hidden sheets / sheets with dimension of 1px, so that these sheets are not shown to the user when exporting data from.
Any help in this would be really great. Thanks.
Hi Diego Parker,
Thanks for your reply. I actually did check the link you shared, but i need to do some processing on the data before its exported, hence I am using getUnderlyingTablesAsync() & getUnderlyingTableDataAsync.
But the issue is I am unable to hide some of the sheets which do not have relevant data. The current workflow is such that the user sees a list of sheets in the dropdown from which the export can be done. But the sheets dropdown currently lists all sheets. I want to show only relevant sheets
Thanks.
