Unable to launch xlsb files

Help Studio
1

Dear all,

I have an issue to launch xlsb files because it has a lot of formulas and takes a lot of time to open ( ~10 minutes or more).

While I disable auto formulas on the excel file then the file opens normally but this option should be automatic ( according to business rules ).
Do you have any suggestions on how to handle this situation ?

2

Handling large XLSB files with many formulas that take a long time to open can be challenging, but there are several strategies you can use in UiPath to address this issue while still adhering to business rules. One approach is to optimize the Excel file or use alternative methods to extract the required data without opening the file directly. Here are some suggestions:

Read content Without Opening the File:

  • Instead of opening the XLSB file, you can use UiPath activities to interact with the file without opening it. For example, you can use the “Read Range” activity from the Excel activities package to read data from specific worksheets or named ranges without opening the file.

Filter and Extract Relevant Data:

  • If the XLSB file contains a large amount of data, consider filtering and extracting only the data you need. This can reduce the time it takes to work with the file. Use Excel activities to apply filters and extract specific data ranges.

=Optimize the Excel File:

  • You can work with the file owner to optimize the XLSB file by reducing unnecessary formulas, using Excel’s “Calculate Now” or “Calculate Sheet” options to pre-calculate results, and removing unused data or worksheets. This can significantly reduce the file’s load time.

Split Large Files:

  • If possible, you can split the large XLSB file into smaller, more manageable files, each containing a subset of the data. This can reduce the time required to work with individual files.

@m.fokas post opening the file what you want to do, if you can be more specific I can provide the solution based on your requirement.

3

@m.fokas

If you are only reading try using workbook activities…if update is also needed then use excel as db and try that way it would be faster than using excel activities

Cheers