Working with Excel inside a Citrix VM

Hi all

I have Ui path installed in a VM and then the robot installed in a Citrix VM (so different locations)

The client advises we can’t take data outside of the Citrix VM and we need to work with Excel files. Is there any solution anybody can think of to read the data. We have tried Table Extraction but that only works with what data is onscreen and Ui Path have since advised us this won’t work (we have a ticket with them)

We could use Macros to break the Excel file down in to lots of smaller ones so each one only contains rows shown on screen but this would create 100’s of files so isn’t really feasible. We are trying to talk the customer in to letting us take data outside of Citrix (e.g connect to a folder inside the UiPath VM so we can use normal Ui path activities) but until this is agreed does anybody have any suggestions, please?

Thanks
Jordan

This is a tough one. They have tied your hands by making you use an excel file in Citrix.
It partly depends on how complex the data is.

I have solved something similar in the past by using ctrl+a and ctrl+c and then converting the data on the clipboard to a datatable.

If the Excel file is more complex though, this becomes trickier.

Hey Jon,

Thanks for replying! The Excel file is large (like up to 3000 rows) but it is quite simple data (like names and addresses etc) so you solution may work and sounds intriguing. How did you convert it (the clipboard) in to a datatable, if you don’t mind me asking?

Thanks
Jordan

Hi @jordrowley

You can use shared drive for excel data transfer if you have.

regards
Loveleet Saini

Basically a combination of these actions
When the text is on the clipboard it is converted to a tab delimited table. You can then use the Wizard for ‘Generate Data Table’ to specify a tab as the delimiter.
Quick warning, don’t edit from the properties pane. For some stupid reason a tab is not read as a tab in the properties pane.

You’d have to confirm with the client that using the clipboard is ok. If they say no then I think you need to say there is no way for this to work, if the robot cannot read any data into its memory then this is not possible.

1 Like

The topic specifically states they cannot take data out of the Citrix VM.

Thanks Jon, this looks a real good solution so I will give it a try. Good work!

Thanks
Jordan

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.