getting text from cells in excel spreadsheet
I am trying to get the text from certain cells from an excel spreadsheet to use them in another application but while I can reliably click on different cells, I cannot grab the text.
Does anyone know how I could do this?
Re: getting text from cells in excel spreadsheet
Actually, to read values from Excel spreadsheets, you do not need to interact with Excel's GUI. Instead, you can use the Data-Driven Testing (DDT) feature or work with Excel via OLE. DDT is described in the "Data-Driven Testing" help topic.
As for using OLE, you can find some samples here: