Read Range error


#1

Im getting this kind of error and i dont understand where the problem is. any ideas?


UiPath version 2016.2.6274 : Workbook Read Range problem
Read Range : Object reference not set to an instance of an object
How to change column name to column index?
How to change column name to column index?
#2

Since your Add Headers is checked, can you check if the 1st row of your excel sheet has blank cells? Probably Uipath is throwing null reference exception when trying to convert blank cell to datacolumn.

I may be wrong, also try with work book read range activity and see if you able to get the same error or any other by which you can figure what the issue is.


#3

I am also encountering same issues.
4 days before the same thing was working but now UIPath has started throwing errors if headers are blanks.
If we are downloading data from some application and we don’t know the range then how to handle it as it has started throwing errors.
@aksh1yadav @badita @andrzej.kniola any suggestions, why it is behaving like this???

Regards,
Rajat


#4

I got mine fixed uninstalling the latest excel activity update.


#5

Can you mention the steps how to install the older Excel activity then?


#6

Ok steps.

  1. Open Package manager
  2. Installed packages (All)
  3. Uninstall Excel.Activities
    (Restart UiPath)

For me it removed the latest update.
Some official steps would be good also, it just worked for me for now… i hope they will fix this soon.


#7

Yes It is confirmed that their is problem with latest Excel Activity packages updates @Gabriel_Tatu @cosmin.sandulescu

But this is only with Excel application scope with workbook activity it is working fine. Others can also confirm this?

Regards…!!
Aksh


#8

workbook works fine for me too. thanks for answers


#9

Yea, workbook is all well…But Excel activity scope is creating problem…so all earlier code is failing :frowning:… Can @UIpath team fix this?


#10

as i`ve asked on another topic, please attach the test file and the workflow, if its possible. if not, tell us what you are doing exactly and i will try to reproduce.
thanks.


#11

@Gabriel_Tatu Excel Application scope read range activity stopped converting blank cells into “ColumnN” data column if Add header is checked.

Excel Activity Version : 2.0.6333.17728

Csv helper : 2.13.5.0

excelupdate.xlsx (8.6 KB)
testExcel.xaml (11.2 KB)


#12

can you tell me please with which version of the excel package you’ve tested this and worked?


#13

Well mine is studio version 2016.2.6274 and excel version is 2.0.6333.17728


#14

excel package, not studio.


#15

Didn’t get a chance to check as auto update is checked.But I can say that it was working until May 12th.


#16

i`m asking this because with the previous version, it was the same behavior, so nothing changed.


#17

Will you be able to provide previous version so we can test on our end?

Is there a possibility that because of any other dependency that could got updated recently this issue is happening.


#18

in C:\Program Files\UiPath Studio\Packages you can find different versions of the packages
you can uninstall the existing package, and install the older one from a custom location


#19

For me before update it was working fine but after this update start getting this


#20

what i want to find out is the version of the package that worked for you, not the new one.