Read Column Crashing UiPath


#1

Scenario:

I’m trying to run a column from an Excel file. I used it previously, but when trying to use it again UiPath craches

Steps to reproduce:

I’m attaching XAML file. The second test is the one that it crashes. I’ve tried also to include it the read column in a container, but it says that the file is being used.
TextExcelReadColumn.xaml (9.0 KB)

Current Behavior:

Crashing

Expected Behavior:

Read column

Studio/Robot/Orchestrator Version: 2016.2.6232. With the same version it has worked for another process with the second test in the XAML file

Last stable behavior:
Last stable version:

OS Version: Windows 7 Pro.
Others if Relevant: (workflow, logs, .net version, service pack, etc):


#2

Can you check if you have the latest excel activity package installed, It might be the issue, I had problems reading a range with the latest one, so I downgrade to the one @aksh1yadav shared.

:slight_smile:


#3

@beesheep

and this is not looking like a read range error it is something else that is forcing uipath to crash and one more thing @selrac
you are running this in debugging mode?


#4

I had the same problem running in debbug mode or just running it. Putting the read column activity inside a try catch and run it it crashed also.

I’ve updated Excel package and now I’m getting another error that maybe explain why I had the error before. It is a problem as files I need to work with are xlsb :sweat: Is there a way around this?


#5

Your format is not supported. Uipath right now not deals with Excel binary worksheets.
May be @adrian can give us more info on this.

Regards…!!
Aksh


#6

Thanks Aksh for the confirmation.

It is going to be a tough one as most of the files I need to work on are binary.


#7

Hey @selrac

Sorry for late reply… was really forgot about this.

Well Workbook Activities still are not support .xlsb format but with Excel application scope and its related activities you will be able to deal with such files and data.

If you wants sample as well let me know :slight_smile:

Regards…!!
Aksh


#8

Thanks Aksh for you reply.

In the end I diverted to use the standard Excel format for the process I was developing.

I’ll give it a try with the Excel application scope

Thanks

c.


#9

Just test it it for another process I need to use and it works perfectly.

Thanks

c.