Grooper 21.00.0082 is available as of 12-12-2023! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.00.0042 is available as of 03-22-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.1.0018 is available as of 04-15-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Options
How will Grooper Render a Multi-Tab Excel Spreadsheet
tmartin
Posts: 82 ✭✭
I have a customer that receives excel spreadsheets via email. These spreadsheets contain 1 to many tabs. Is there a way to make each tab a page within a parent document in Grooper?
0
Answers
You may want to reach out to our Client Fulfillment team as I believe they've made some custom scripts that allow something close to what you're looking for.
You may also want to ask them about functionality behind getting the data out of the spreadsheet as a .csv text file that Grooper could consume natively as a text file, and do simple pattern matching from there.
rkinard@bisok.com
The first script from @Brian essentially piggy backs off the "Print to pdf" functionality that exists within Excel natively. There are options for how multipile sheets should be handled... Either all as one big output PDF or as individual sub-documents for each sheet. It also gives you control over output resolution and scaling, similar to what you have in Excel when choosing to print the file.
The other is from @jgodwin. This one takes an approach of converting each sheet of the excel file to a .CSV file. In most cases, extraction can easily be performed from the .CSV file and the visual characteristics of the worksheet aren't really relevant. I've heard rumors that a flavor of this custom activity will become out of the box Grooper functionality in a future release, but I can't speak to the specifics or the ETA at this time.
Product Manager
mharrison@bisok.com