Hello, I am creating a pivot table in idea, and the script runs fine. The question is, how do I send this table to Excel through other scripts, since IDEA does not save it. any idea how to do it?, I want to automate all the tasks, but this is a small problem.
ortizmario6025@...
Offline
Last seen: 2 months 3 weeks ago
Joined: 09/03/2021 - 11:54
You would have to first export it to IDEA which you can do through the pivot script and then take the IDEA file and export it to Excel. There are limitations in thet you can only have one field selected as a row and a column, if you have multiple fields I don't think you can perform an export to IDEA.
Yes, I have tried, I will look for another way, thanks