Exporting to excel from a Workshop Table Widget

Ask the Community
1

I am building an app that contains a tabbed section.

I can go to every tab except one and export directly to excel.

However, on one of the Tabs, the result is an unreadable txt file.

How can I fix this issue?

2

Hi @LenStringer a few questions and steps you can try to debug:

  • How large are the tables you are exporting (Rows X Columns)?
  • Are you using the table → right click “export to excel”, “export to csv” functions or have you embedded a download button which is backed by the different object sets shown in the tabbed container? → Have you alternated the different options and get the same output?
  • What exactly do you mean by unreadible text file? If you open notepad++ does it give you an error or is it not rightly parsed as a table when opened in excel?
  • → It might be, that the data you are exporting from this one tab contains a character that messes up csv / excel parsing. Have you tried only exporting one row with very few “clean” columns from that table?

I believe best would be you share screenshots of the workshop table configurations that work/don’t work.

2 Likes
3

Hi @PhilM

I finally figured it out. There was a toggle under the Right-Click Menu configuration that was turned on. The toggle was CONFIGURE FILE NAME under ENABLE EXPORT TO EXCEL. When the toggle was turned off, it worked.

1 Like
4

Glad to hear you found the issue @LenStringer! I am understanding correctly, the file name option was toggled, but no valid file name variable was provided? My expectation would have been that the whole table widget would then appear as „not configured correctly“ but who knows :wink: