\r\n
\r\n \r\n Hello,
\r\nI have the following code to read excel data from my VB.Net application.
\r\n
\r\nDim oXLApp As Excel.Application
\r\noXLApp = New Excel.Application()
\r\noXLApp.Workbooks.Open("fileName")
\r\n
\r\nAnd now I try to access a cell as
\r\n\'Line 1
\r\noXLApp.Range("cell1").Row where cell1 = cell name
\r\n
\r\n
\r\nSuppose, I change the cell name from cell1 to cell2 in my excel file, even then Line 1 executes correctly. I thought it would throw an exception because I have changed the cell name.
\r\n(Observation : In the excel file, I get a drop down in the name field just below the save button, it contains all the names that I have entered for the cells. And the above line works fine for all the names in the drop down, albeit some of the names are not being used by any cell)
\r\n
\r\nAm i missing something when using cell names instead of A-1 style way of accessing cells ??
\r\n
\r\nShankar\r\n
\r\n
\r\n\r\n\r\n
reading excel data
Threaded Mode
