Nice addition, a question though, How would you smartly remove this column from the exported data via the exportExcel as it appears its just a button for action but with no data to export. is there a way to check if a column is displayColumn? I believe this will ease the decision to remove it while building columns at ws.columns = lastHeaderGroup.headers .filter((h) => h.column.getIsVisible())
Good catch, I did not think about this! My approach is to use the meta property on TanStack tables where you can store anything for your own use: tanstack.com/table/v8/docs/api/core/column-def#meta . Im the export I filter out all the columns that have the attribute "noExport" in this meta. Here is the commit with all my changes: github.com/phartenfeller/sveltekit-1.0-sqlite-demo-app/commit/4f19a250e6534fd88b2e9b6dc90bf26672859466
I was wondering if you have a video on how to add a simple query to an email template? For example a simple "select name, job description, empnum from employees where dept = ( a passed variable) Is there something I can watch to help me with this?
Looks really useful!
Nice addition, a question though, How would you smartly remove this column from the exported data via the exportExcel as it appears its just a button for action but with no data to export. is there a way to check if a column is displayColumn? I believe this will ease the decision to remove it while building columns at ws.columns = lastHeaderGroup.headers
.filter((h) => h.column.getIsVisible())
Good catch, I did not think about this!
My approach is to use the meta property on TanStack tables where you can store anything for your own use: tanstack.com/table/v8/docs/api/core/column-def#meta .
Im the export I filter out all the columns that have the attribute "noExport" in this meta.
Here is the commit with all my changes: github.com/phartenfeller/sveltekit-1.0-sqlite-demo-app/commit/4f19a250e6534fd88b2e9b6dc90bf26672859466
@hartenfellerdev thanks for response. I have reviewed the code, this is a cleaner and better approach than the one I had hacked around. Thanks.
I was wondering if you have a video on how to add a simple query to an email template?
For example a simple "select name, job description, empnum from employees where dept = ( a passed variable)
Is there something I can watch to help me with this?
It's in the video 😅😅