Take a look at the Advanced Reporting extension fromOld World Computingwhich has a lot of functionality for working with Exel beyond the basic "Write Excel" operator. I am sure@landwould be happy to answer any additional questions you have about it.
Brian T. Lindon Ventures Data Science Consulting from Certified RapidMiner Experts
2
rfuentealbaModerator, RapidMiner Certified Analyst, Member, University ProfessorPosts:568Unicorn
Besides the excellent suggestion by@Telcontar120about the Advanced Reporting extension developed by@landand that I totally second, I think that your issue has a simple solution: if all you want to do is to sort attributes due to some criteria, you should just put theReorder Attributesoperator before theWrite Exceloperator. Then you can manually order the attributes to suit your needs.
yes, I think it comes down to what you mean by correct order of cells: You can sort the data set's rows using Sort operator or reorder the columns using the Reorder Attributes operator. If you need to write the data (or multiple data sets) into the correct position within an excel sheet, you can do this using our Advanced Reporting extesion. The clue is, that you can fill in data there, but the formatting and every content will be copy from a template file. By this you can design simple static reports and even include charts. If you fill in the data with rapidminer and the charts are using this data, they will automatically be updated. Whenever someone opens the excel file, s/he can directly inspecting the data visually.
Greetings,
Sebastian
PS: There soon will be a shop system where you can automatically pay and get licenses for our extensions
2
sgenzerAdministrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager
PS: There soon will be a shop system where you can automatically pay and get licenses for our extensions
Woot woot! Great job Old World Computing and@land! Can't wait to see it!
Contributor I
Answers
Take a look at the Advanced Reporting extension fromOld World Computingwhich has a lot of functionality for working with Exel beyond the basic "Write Excel" operator. I am sure@landwould be happy to answer any additional questions you have about it.
Lindon Ventures
Data Science Consulting from Certified RapidMiner Experts
Besides the excellent suggestion by@Telcontar120about the Advanced Reporting extension developed by@landand that I totally second, I think that your issue has a simple solution: if all you want to do is to sort attributes due to some criteria, you should just put theReorder Attributesoperator before theWrite Exceloperator. Then you can manually order the attributes to suit your needs.
Hope this helps,
Hi,
yes, I think it comes down to what you mean by correct order of cells: You can sort the data set's rows using Sort operator or reorder the columns using the Reorder Attributes operator. If you need to write the data (or multiple data sets) into the correct position within an excel sheet, you can do this using our Advanced Reporting extesion. The clue is, that you can fill in data there, but the formatting and every content will be copy from a template file. By this you can design simple static reports and even include charts. If you fill in the data with rapidminer and the charts are using this data, they will automatically be updated. Whenever someone opens the excel file, s/he can directly inspecting the data visually.
Greetings,
Sebastian
PS: There soon will be a shop system where you can automatically pay and get licenses for our extensions
Woot woot! Great job Old World Computing and@land! Can't wait to see it!
Scott