I want to define a list of columns as an Excel PrintArea (by EPPlus, c#). I can define interval (first and last column of area) but I don't know how to define separate columns (for instance: A, C, F, G).
I can set interval like this:
listSheet.PrinterSettings.PrintArea = listSheet.Cells["A,G"];
PrintArea
is an ExcelRangeBase
so you can set it link any other range:
listSheet.PrinterSettings.PrintArea = listSheet.Cells["A:A,G:G"];
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With