Ranorex Forum

Hello,
I am trying to access a spreadsheet in my application similar to excel. However, I am not sure how to access it in code, When I click on any cell it gets noted as coordinates and not as ow in column. I know how to access a table.
Currently I am just using clipboard verification for some validations but it will be real nice if I can validate all data at once.
Thanks

Hi Barkha,

Please post a Ranorex Snapshot of your application under test.
Also please take a look at the code examples on Ranorex Website. There is an example on how to validate a whole table at once.

Sincerely,
asdf

I have to use RawText via GDI Capture to read our desktop app spreadsheet, as it's not accessible via Ranorex.

Hello,
I could not share the snapshot , However, Here is how its arranged in the controls. I am trying to access the cells in ppspread but it does not identify individual cells in the spreadsheets.

Hi,

I'm afraid that without (at very least) snapshot, there is nothing anyone here (including support folks) can do or suggest. Even with snapshot, it may be impossible to suggest something reliable. I would suggest to contact directly Ranorex folks at [email protected]. They may arrange a remote session with you and eventually provide some suggestions.

Hello,
So I reached a conclusion that fpspreadsheets are not supported yet. For my purposes , I simply traverse using tabs and copy the data I want to validate. Then I use the Code Example Validate clipboard to verify the value. It is not the best way but Since I need to only look some values it works as for now.
Just in case .