I am working on a C# web application using VS2010.
I call a method to try and convert 4 particular worksheets within each workbook I process
into CSV type files.
Do you know how I can correct my error?
I seem to have no problem converting the first worksheet into a CSV file.
The file comes out as "105 Internal 08-28-2013_Bank Credits (A).csv".
I want to name the ouput CSV file as the combination of 4 components:
1) the workbook name (without the .XLS, followed by
2) an underscore
3) followed by the worksheet name
4) followed by .CSV (the file type)
However, it seems that after I convert this first worksheet, that I am accidentally
changing the workbook name through my assignment variables.
After I read the worksheet named "Bank Credits (A)", it seem I mess up the name of the following worksheets.
The 2nd worksheet comes out as concatenation of the 1st and 2nd worksheet names:
105 Internal 08-28-2013_Bank Credits (A)_Bank Debits (B).csv
My code is in the attached file.