I am new to POI and perhaps someone has come up with a creative solution to my problem already and I have not stumbled across it yet.
Excel's SUM function apparently has a limit of 30 cells when they are comma separated (ie A2, B15, B 40...). When we pass our list to the excel file to transform and it contains more than 30 suppliers, the outermost totals row will be summing more than 30 cells that are not contiguous, so I can't use a colon. I just want to come up with the cleanest, easiest solution... Thank you, Jim Bury
