regarding write excel operator,after running the process it is showing memory buffer file.

sowndarya
sowndarya New Altair Community Member
edited November 2024 in Community Q&A
I'm trying to use the write excel operator with the input connection of analyse sentiment operator or other operators ,but it is showing memory buffered file in the result view.how to resolve it?I want to convert result into excel file.
Tagged:

Answers

  • varunm1
    varunm1 New Altair Community Member
    Hello @sowndarya

    Did you provide storage drive path in write excel operator? Did you connect "thr" port of write excel to "res"? 

    Memory buffered can be seen when rapidminer cannot interpret the data format. If possible provide your XML (View --> Show Panel --> XML) code for us to review.
  • mertcatar
    mertcatar New Altair Community Member
    @varunm1 i am taking this problem,too. Could you explain possible solution, please because i didn't understand fairly 
  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    edited November 2019
    Hi,

    the "fil" port is the excel file binary data. When you use "Write Excel", you specify a location on your disk for the Excel file to be written to. That's your final output, you're done, you don't connect the "fil" port to anything.
    The "fil" port should only be connected if you don't want to store your Excel file on disk, but instead for example upload it to Dropbox or Amazon S3. Then you pass that data to the Dropbox/S3/... operator and upload it. For just saving it to your local disk, just don't connect the port.



    Regards,
    Marco