Export to excel

mengkoon007mengkoon007 MemberPosts:30Contributor I
edited November 2018 inHelp

Hi,

I have posted a process to the website and it is shown in table format.

I would like to allow end-user to be able to login and download the report to excel.

Can someone kindly advice how can i go about doing? Thanks.

Tagged:

Answers

  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:578Unicorn

    Hello@mengkoon007,

    It's really simple. Create a process that reads the data you are displaying as a table and use the Write Excel operator to write it into binary format. Take this output (the purple line in the process below) and use this as the result port.

    Next create a visualisation in your RapidMiner Server WebApp and select Binary as the output format.

    Give it a nice name for the downloaded file in the options (for example myExcel.xlsx)

    You can use RawHTML in place of the text (where it says "Download" in the component options) and you'll be able to change it into a button pretty easily.





    <宏/ >















Sign InorRegisterto comment.