Excel Utility - Get Number of Rows

[SakshiShivhare]

Hi,

We have recently upgraded the VM's memory from 32 bit to 64 bit and we are facing an issue with the "Get Number of rows" action for Excel Utility. It is not giving the appropriate/Correct output and giving some random numbers as output.  

What can be the solution to get correct number of rows from Excel.

------------------------------
Sakshi Shivhare
Application Development Senior Analyst
Accenture
Pune
------------------------------

[SakshiShivhare]

I have created the data item to set direction enum and it worked. Thank you so much for your response and solution.

------------------------------
Sakshi Shivhare
Application Development Senior Analyst
Accenture
Pune
------------------------------

[michaeloneil]

Good to know Sakshi Im glad its working for you now and hopefully it resolves the issue you were having.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

[AnkitShukla]

Can you share how to call for get row number

------------------------------
Ankit Shukla
RPA Developer
Arvius Software Pvt Ltd.
Noida
------------------------------

[michaeloneil]

Hi @Ankit Shukla

The action is in the object MS Excel - Extended and the action is called Get number of rows. 

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------