Selecting Multiple Ranges for Print Area

Mar 17, 2012 at 11:35 PM

Hi,

Is it possible to select multiple ranges in EPPlus?  I'd like to set the print area to be two disjoint areas [in VBA this can be done by doing something like Range("A1:B:30","D1:E:30")].

 

Coordinator
Mar 18, 2012 at 9:35 PM

Yes, just put a comma before the next range...

Worksheet.Cells["A1:B30,D1:E30"]

Have a look at the FAQ for some more examples

Jan