ExcelConnector: Specify "all" for Worksheet Range?

Ask general questions here.
mrt
Posts: 259
Joined: Mon Mar 16, 2020 11:31 am

ExcelConnector: Specify "all" for Worksheet Range?

Post by mrt » Wed Dec 16, 2020 2:29 pm

Hey folks,

when using an Excel connector via Code, one mandatory property is the WorksheetRange.
https://www.ranorex.com/Documentation/R ... tRange.htm

The example reads just
"A1:X20"
for a certain range.

But how do I specify full range, so everything on the sheet without restrictions?

In this post: compare-excel-structure-and-content-t9546.html @diogogmaio stated that putting "" is sufficient, but in my case this does not work, it only selects the very first cell, A1.

Any ideas?

Thank you, BR

User avatar
Mike K
Certified Professional
Certified Professional
Posts: 28
Joined: Wed Jun 28, 2017 5:58 pm

Re: ExcelConnector: Specify "all" for Worksheet Range?

Post by Mike K » Thu Dec 17, 2020 2:52 pm

Try selecting 'Auto-range' this should select all the data posted on the Excel sheet.