Excel worksheet
C#
1
Posts
1
Posters
0
Views
1
Watching
-
Hi all I am having the code which was reading the .xls file like this(code below) but now in that .xls file,I have two sheets file1 and file2 now how can i go to particular sheet depending upon the input from the user Excel.Workbook theWorkbook = this.Excelobj.Workbooks.Open(DataClass2.exc_inputFileName, 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,0, true,false,false); Excel.Sheets sheets = theWorkbook.Worksheets; Excel.Worksheet excelWorksheet = (Excel.Worksheet)sheets.get_Item(1); Excel.Range tempRange = (Excel.Range) excelWorksheet.get_Range("A1","IV1");
Ankit Aneja "Nothing is impossible. The word itself says - I M possible"