Excel Extract from SQL Table Editor
Hi Team,
Is there any way to extract the SQL Table Editor to an Excel File?
Currently I have a SQL table editor with multiple pages and the default extract method by right clicking on the column...
Forum Discussion
We addressed this by adding an Export button above the SQL Table Editor that invokes a Workspace Business Rule. The rule queries the relational data and uses the OpenXML library to generate a fully compatible XLSX file.
The approach works very well, though it is non-trivial to implement. We ultimately invested the time because the capability is now core to our partner solution, Revfore Flex. We also use the same OpenXML library for importing Excel data back into relational tables.
When we originally built this, AI functionality was limited, so you may be able to implement a similar pattern more quickly today with AI assistance. If an XLSX output is a hard requirement, I’m happy to share some pointers