Temp Folder Issue

Sep 3, 2009 at 3:34 PM
Edited Sep 3, 2009 at 9:45 PM

Please help...

My temp folder has

C:\Documents and Settings\gjoshi\Local Settings\Temp\TMP_Z128964680502045715\xl\worksheets\sheet1.xml

But the code is looking for C:\Documents and Settings\gjoshi\Local Settings\Temp\TMP_Z128964680502045715\xl\worksheets\sheet161.xml

I dont know why code is looking for Sheet161.xml



Actually if I delete the sheet then I cannot loop thur the datatable.


Example if I create a WorkBook with 1 Sheet

and  then use the code to loop it works but if I delete the Sheet and add a new sheet to the Workbook then I cannot loop.

Step "

1.Create a workbook with 3 sheet.

2.Use code to get data in dataset.

Works fine.

3.Delete the sheet from Workbook

4.Add a new sheet.

5. Use code to get data in dataset.

Not working.







Please help