Go Back   MarcomCentral (PTI) and FusionPro User Communities > Software-Related Talk > The JavaScript Library


Thread Tools Search this Thread Display Modes
Old June 23rd, 2022, 11:57 AM
Dmiller35 Dmiller35 is offline
Junior Community Member
Join Date: Jun 2020
Location: South Carolina, USA
Posts: 19
Default Data files with multiple sheets

I don't come across this often but I've had a few jobs lately where the customer supplies us with an excel data file that contains multiple "sheets". Is there a way for FP to process all of the sheets at the same time? Right now, I'm pulling up each sheet, outputting the file, then switching the data source. Just wanted to know if there was a less time consuming way to handle this.

If that is possible, then is there a way to output the files based on the "sheets"?
For example, I'm currently working on some name badges. I have 3 different lots of badges so I'll need to have 3 different pdf files. Can I program a rule for OnNewOutputFile that will split the file based on the "sheet" in the data file?
FusionPro VDP Creator 13.0.2 | MacOS 13.1 | Acrobat DC
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -7. The time now is 02:36 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
(c) 2011, PTI Marketing Technologies™, Inc.