How to read binary excel XLSB files using Python in UiPath Studio Web

A super short tutorial on how to use our new Python 2.0.0-preview activity package on Studio Web to read *.xlsb Excel files with a python script.

Step 1 - Create a new solution on studio.uipath.com

Navigate to our Studio Web and create a new solution, or upload the project sample provided below.

Step 2 - Build the rest of the process

Please see the video below on how the process is built:

Sample project

You can upload this sample solution below in Studio Web:
Read XLSB File.uis (6.4 KB)

Like so:

5 Likes

Hi,

Do you intend to have another developer activities implemented in the future?
What about VB .Net or C# activities?

Thank you!

1 Like

In Studio Web specifically? There are some ways to invoke custom code already, although not as streamlined as it could be:

  • Invoke Code activity (VB.NET and C#)
  • Publish a custom cross-platform library in Studio Desktop with coded workflows and then use that library in Studio Web

We’re aware that there is room for improvement, and I’m lobbying internally for a better custom code experience.

1 Like

Ok, got it, thank you.
Another question here:
I have a coded workflow library used in a web project. Let’s say is version 1.0.1.
I update the library and publish again to Orchestrator Tenant Library Feed to version 1.0.2.
I open the web project using Studio Desktop, update the reference to the version 1.0.2 of the library.
I’m syncing again in web. The web project should contain now a reference to the updated library, right?
Most of the times, I have an error here

After a lot of retries (syncing again from desktop to web), it seems finally has updated the reference and I can see it at the right version

Do you know if is a bug here or I’m doing something wrong?
It takes some time to be updated these references from feed?

Yes, I would expect this to happen immediately.

This might be the case. Does this happen every time you do it this way, or only occasionally?


Edit. I think there is a delay of up to 1 hour for the service behind the activities search engine to start showing the new activities. Let me test something and I’ll come back with more information :slight_smile:

@Bogdan_Istrate

I verified my assumptions and chatted with the team for further insights.

The short answer is that the search service, which links what is published on the feed with what shows up in Studio Web, is refreshed on a schedule. This means there might be up to an hour delay before your custom activity appears in SW.

This also means that your attempts to republish weren’t effective, and simply waiting would have been enough.

I tested this with a solution in Studio Web that contained a custom library version 1.0.1. I then published another version (1.0.2) and tried the following:

  • immediately refresh it → it remained at 1.0.1
  • refresh it after 1 hour → it auto-updated to 1.0.2

Once the search service refreshes, you will see your activity in Studio Web. There is no need for any Studio Desktop adaptations if you simply want to add the new library activity to the project in Studio Web. Anything published to the orchestrator feed should appear in Studio Web (albeit with that maximum 1-hour delay):

1 Like

Hi,

This is what I saw it also testing again. If I wait enough time, the activity is updated in my project!

Thank you very much!