Need help excel

Technology specific object identification, supported applications, web technologies, and 3rd party controls.
utantextremo
Posts: 1
Joined: Tue Sep 22, 2020 6:11 pm

Need help excel

Post by utantextremo » Sun Oct 04, 2020 6:09 am

I'm trying to open, examine, modify and close excel spreadsheets generated by a call to an API end point. The creation, opening and closing is all happening without issue. What I have a problem with is that the spreadsheet has been changed so that the first sheet has a unique name in each file to match the filename. Recording actions in studio appears to create a recording that can add the figures I want to certain cells but this was when the sheet name remained unchanged from one file to the next.

The XPath to the cells in question appears to include the sheet name. Is there any way of having an XPath that uses the sheet index instead? That way the name would be irrelevent.

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 6553
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: Need help excel

Post by odklizec » Mon Oct 05, 2020 6:11 pm

Hi,

Have you tried to simply remove the dynamic part of xpath? 😉 Unfortunately, it’s hard to suggest something reliable, without seeing the xpath and excel file, eventually, snapshot (NOT screenshot) of the excel file. Can you provide these pieces of required information?
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration

User avatar
JosephY
Posts: 5
Joined: Mon Feb 04, 2019 9:57 am

Re: Need help excel

Post by JosephY » Fri Mar 19, 2021 12:39 pm

utantextremo wrote:
I need to modify my excel spreadsheets to do my homework for me and make a unique name for each file. Is it possible to have an XPath which could use the sheet index?
Hello,

I simply edited the path in Spy. In case someone has the same question.