I need to ask how to create multiple new excel spreadsheet files problematically from an arraylist on the c# backgroundworker thread
currently I have a function that goes through a for each loop and :
xlApp = new Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
then it disposes of the excel object
by doing this in a backgroundworker thread, it causes all sorts of problems from blank worksheets to data split on multiple worksheets.
Would appreciate any feedback on how to go about this, basically want to show a marquee progressbar when the operation is being done, so I need to use the backgroundworker thread else if I don't use threading, the progressbar does not move, cause of all processing on the main GUI thread