How to read binary excel sheet using uipath

Help
1

Hi Team,

I want to read binary excel sheet,i tried using excel application scope with read range activity.i got sheet not found exception.

Can you please help me here

TIA

2

Hi,

Share the Excel sheet please? Make sure the sheet name in the excel sheet is same that you have mentioned in the read range activity.

Thanks

3

@cheersrpa check sheet name once, if sheet name is correct give space at end of sheet name in read range activity

4

tried,getting null exception (Object reference not set to an instance of an object.",)

5

@cheersrpa in default value of datatable New New System.Data.DataTable() and try once if this is not possible share ur excel with sample data and workflow

6

the data is confidential, i cant share the input file

7

@cheersrpa try by giving default value to datatable variable as New System.Data.DataTable() and also check whether u have assigned output variable to read range activity and also check read other input and output variables once

8

My Input file will come in binary format (.xlsb). but bot is unable to read.So my next step is i want to convert this file to .xlsx file using macro or vba code.

Can someone tell me how to get that vba or macro code?

Thanks

9

Hi @cheersrpa,

I found this thread:

Following it, I made this small example. Could you give it a try if it works, and then replace my example file with yours?
Randomprocess.zip (33.0 KB)

3 Likes
10

hey @loginerror

thanks for the helpā€¦when i run your workflow alone (sample given in above post).i am getting the output.But i tried with my sample data.it doesnot work for me.

i am getting the below error.

message": ā€œRead Range: A column named ā€˜*ā€™ already belongs to this DataTableā€.

11

@cheersrpa

This error occur when columns have similar name in excel, Check the columns once

12

hey @Manjuts90

i checked the column headers ā€¦it has unique names only

13

Could you debug the issue a bit this way:

  1. Make a backup of your file
  2. Remove all columns except for the first one
  3. Try to run in in my example.
  4. If it will work, add more columns, one by one and keep testing until it stops.

We need to be sure whether it is a bug in the activity or something specific to your file :slight_smile: (or maybe both to some extent)

1 Like
14

hey @loginerror

the above error bcoz of one more hidden row was there with some special charactes(*.ā€œ,ā€)

now i removedā€¦it worked perfectly.

Thank you soo much :slight_smile:

1 Like