Python in Excel

Feature request
1

Starting to explore Python in Excel, I think that is a good idea to assign priority to a Phyton Transform, just thinking about it…

2

Is this based on capability or on preference, compared with Javascript?

3

What is it that you want to do in Python that you can’t already do with standard Easy Data Transform transforms?

1 Like
4

Andy,

I am very happy with it; my main concern is about the future. I’ve started taking my first steps with Python in Excel (PiE), but what I’m really interested in could become a challenge down the road (I really love EDT).

PiE runs on Microsoft servers, which has both advantages and disadvantages, and it also has limitations in terms of access to Python libraries—only those available on Microsoft’s servers can be used.

I wonder whether, as PiE becomes more widely accessible, it might reduce the market for other alternatives like EDT, which is something I would not like to see happen. To mitigate that risk, perhaps a Python transform with fewer limitations than PiE could become a competitive advantage—but that’s just my personal thinking.

5

I think there is plenty of room in the maket for Python/code based tools and for visual tools like Easy Data Transform. They each have their strengths and weaknesses.

2 Likes
6

@msalz, I am still curious for an answer to my query. EDT already provides javascript for very unusual cases, and almost all problems are solvable without that resort. Is your interest in Python-in-EDT based on specific capability, or on personal interest or preference?

7

You can also create Transfo A, B, C and put the IFS in python that uses the “-cli” command (EDT runs in shadow mode) then again new Transfo and dedicated .py

You put “the easy part” in .py and the complexity in EDT and run them both. This way you get the glue (python) and the brain (EDT), it is superfast and versatile.

1 Like