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 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?
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.