Jump to content

Data files with multiple sheets

Recommended Posts

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?

Link to comment
Share on other sites

  • 1 year later...
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...