Writing into multiple sheets in an Excel

varunm1
varunm1 New Altair Community Member
edited 2024 05 in Community Q&A
Hello,

Is it possible to write into multiple sheets in an excel?

I tried using the same excel file name but changed the sheet names in "Write excel" operator for different subprocess. This is not working as it is replacing the old excel file with the new sheet name.

Is there any other way I can write into multiple sheets using excel operator in RM?

Thank you

Tagged:

Best Answer

Answers

  • IngoRM
    IngoRM New Altair Community Member
    Answer ✓
    Not with the regular Write Excel operator.  There are a couple of workarounds for this:
    1. using a third-party extension (not free)
    2. using an R script
    3. using a Python script
    Hope this helps,
    Ingo
  • varunm1
    varunm1 New Altair Community Member
    edited 2019 20
    Thanks, @IngoRM I did a workaround with joins into a single sheet. Our research can't afford a paid extension  ;)

    I somehow missed these workarounds already available on the community. They are useful.
  • sgenzer
    sgenzer
    Altair Employee
    @varunm1 you may wish to try pinging @land directly to see if Old World Consulting offers any discounts for researchers or others in education.

    Scott
  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Hi,

    My team has estimated the effort of implementing this feature recently, so it's quite safe to say it will make its way into the product eventually.
    No timeframe yet, so don't call me out after the next release and complain if it's not there yet, otherwise I will have to stop giving little sneak peeks here ;)

    Regards,
    Marco
  • land
    land New Altair Community Member
    In general we are open to give discounts to academics. On the other hand, the extension costs not even 30 €. Even a discount of 60% would not really significantly reduce the amount, don't you think :)

    Nice to see, that his might eventually becomes a standard feature.
  • varunm1
    varunm1 New Altair Community Member
    edited 2019 21
    Thanks for the generous responses. I am pleased with RM and partners contribution to research and education by providing a free version. We try to do our best as well in making RM a more familiar platform in the research community (at least in my areas) by citations and presentations. :smile:
  • WASmith
    WASmith New Altair Community Member
    Glad to see that RM is considering adding this functionality. We have had to implement some workarounds in Python. I have not done a lot of comparisons (for obvious reasons), but I think Python is able to write excel files much more quickly than RM.

    Either way, this seems to be a good candidate for someone to create a building block that wraps a python and/or R short-term fix. I started to look into it today and one challenge will be being able to pass the building block an unknown number of example sets from RM.