I’m generating a DataTable by importing data from a SQLite database and enabling it to be exported to Excel. However, I don’t load all the columns from the DB into the table because the ‘Abstract’ column has over 100 characters but I would like it to be exported along with the shown columns.
I thought of loading the ‘abstract’ column into the table but not displaying it (although couldn’t do it) or working a way around it by making an Export button myself.
Is there an easy way to do any of those or a more viable option? Thanks!