Unable to read file of extension .xlsb

Help Studio
1

Hello everyone, can we read .xlsb file through UiPath Studio? If yes then please let me know, how can I do that..

Thanks!

2

@Rajneesh_Kumar

Use Excel Application Scope

Inside it use Use Excel File pass your.xlsb file path here.

3

You cannot read .xlsb using Workbook activities, but you can read it using Excel-based activities. The easiest way is to open the file with Excel Application Scope or Modern Excel (Use Excel File) and then use Read Range. If Excel is not installed, you can use OLEDB connection, but this requires extra setup. Recommended method: Use Excel Application Scope → Read Range.

How to use (quick list):

  1. Add Excel Application Scope
  2. Select your .xlsb file
  3. Place a Read Range activity inside
  4. Output to a DataTable