File output for Execute Python

mpineda

Hi,

I have this issue and I hope you can help me solve it. What I want, is to download an Excel file from RapidMiner Web with a conditional formatting. This Excel file is an output of a process on the RapidMiner Studio.

I usually do this with the Write Excel operator.. but I want to customize the file with conditional formatting, and this can't be done with that.

So, I use the Execute Python operator and with code give the format I want to the file.. but this works if I write the file on my local repository. This is close to solve my issue, but what I want is to download that file from RapidMiner Web.. so the output of the process should be a file that keeps the given format.

That is my idea.. but I don't quite know how to do it. Also if you have different ideas that can solve my problem, are very welcome.

Thanks a lot!!

rfuentealba

Hello, @mpineda,

Have you seen the Advanced Reporting Extension? It seems to do what you want.

https://marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_adv_reporting

All the best,

Rodrigo.

mpineda

Hi @rfuentealba

I already take a quick look to this extension, but not quite solve the problem

Although, thanks a lot!

btamas

Hi @mpineda ,

if you want to use your own format, you can save your spreadsheet directly in the python code. Alternatively you can return a file descriptor object from the rm_main() method in python, and then use the Write File operator to save it in Studio directly to a file. I think both approach will solve your problem.

If this doesn't help, you could provide me more details about your problem (you can also write me a private message, if you like) and maybe I could show you a better solution.

All the best:
Bence Tamás