Data files with multiple sheets

[Dmiller35]

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?

[Jon Ricoh]

Dmiller,

Here is some code for you to be able to call a certain sheet in an excel file.

var xdf = new ExternalDataFileEx("data.xls", "Excel", "Sheet 2");

 

[Dmiller35]

Thanks Jon,

But that won't that just define the data source? I won't necessarily combine the sources together, right?