Hi - I am calling passing in a datatable and a string parameter - which will populate and name a worksheet, respectively. This method will be called multiple times and should create a new spreadsheet everytime it is called. The method is working,
but it is overwriting an existing spreadsheet instead of adding a new spreadhseet each time. What am I misssing? Is it the string?
(dt.Rows.Count > 0)
p = new
"Office Open XML xlsx Processor"
//Create a sheet
//tried both of these
sheet = p.Workbook.Worksheets[s];
(sheet == null)
//Add a new sheet...
sheet = p.Workbook.Worksheets.Add(s);