For my use case, I have to read multiple XLSB files (over 150 MB in size). Using Excel Application Scope and activities, it’s taking over 15 minutes to read a single file. Is there any other way to read XLSB files which is quicker and more efficient?
I went through some posts on the Forum itself but couldn’t find anything promising. Would appreciate any suggestions!
Thank you,
Vasu
Update (2/16/2025)
I’m still looking for an efficient and fast way to read .xlsb files in the UiPath. The Excel activities / invoke code is taking about 20 minutes to read a 136 KB file, I’ve observed that it takes about 20-40 minutes to read file sizes ranging from 130 KB - 140 MB, which is weird.
Would really appreciate if anyone can assist with this!
Hi @vasundhara.sharma,
The 15 minutes read time you mentioned - is that when you run in “Debug” mode? How long does it take if you do a “Run” or “Run File” instead?
I’m still looking for an efficient and fast way to read .xlsb files in the UiPath. The Excel activities / invoke code is taking about 20 minutes to read a 136 KB file, I’ve observed that it takes about 20-40 minutes to read file sizes ranging from 130 KB - 140 MB, which is weird.
Would really appreciate if anyone can assist with this!
Yes, i did try invoke code and it’s still taking the same amount of time. I’m using Microsoft.Office.Interop.Excel.Application in invoke code to read the file.
Another way that takes slightly less time is converting the .xlsb file into .xlsx and then reading the .xlsx file, it takes about 13 minutes to do the entire operation whereas the reading the .xlsb file takes 20 minutes.
The read range doesn’t work as expected though when converting the file. I want to read data in range “B6:C” (i want to read B and C columns only, starting from B6), but this range input doesn’t seem to work. Maybe i’m doing something wrong.
If i leave read range blank, it reads only first 3 rows because the 4th row is blank and the actual table starts from B6.