I'm building a spreadsheet that has 40 customers. Each customer should have it's own page of data. I've attempted to use HorizontalPageBreaks between each customer section, and this works, except the data in all the columns is too wide to fit on one page across.
>> workbook.Worksheets(myReportName).HorizontalPageBreaks.Add(first_line_of_new_customer, 0)
The solution in Excel is to limit to "1 Page Width". I would like to use the FitToPagesWide method as shown below, but this appears to negate the HorizontalPageBreaks. How can I get both features to work together?
Thanks in advance, Jack
' PAGE SETUP
.PaperSize = PaperSizeType.PaperLetter
.FitToPagesWide = 1
.FitToPagesTall = totalcustomers
.Orientation = PageOrientationType.Landscape