Ranorex User Guide recommends xlsb format

Ranorex Studio, Spy, Recorder, and Driver.
gilbar16
Posts: 109
Joined: Wed Mar 26, 2014 6:23 pm

Ranorex User Guide recommends xlsb format

Post by gilbar16 » Tue Oct 06, 2015 6:47 pm

Hello,

The Ranorex User Guide recommends the use of the binary (xlsb) format to use for excel data files. Is this still true? (In Lesson 3: Data-Driven Testing)
Note: It is recommended to store your Excel data files in the native binary format xlsb instead of the suggested default format xlsx. The binary format is up to ten times faster than xlsx, and supported since Microsoft Office 2007.

Right below the User Guide page though, the sample screen shots are showing the use of .xls or .xlsx format.

Also, I had a short demo/session with Ranorex Support and the excel file used in the session was also a .xlsx or whatever default format excel uses and not the binary (xlsb).

I'm a little confused and need some clarification on this.

Thanks.
Gilbert

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

Re: Ranorex User Guide recommends xlsb format

Post by odklizec » Wed Oct 07, 2015 7:25 am

Hi,

Binary files are faster to process. I believe this is the main and only reason why it's recommended to uses xlsb over xlsx.
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