Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
3 years ago

Writing multiple data in a single excel file sheet

Hi, Good day,

I have got a requirement to append the data in an excel as the incoming data is coming from various sources. Since the append operation is not allowed, I would like to know if is there any way of loading the data in different sheet names in the same excel file.?

Thanks,
Harshavardhana

excel

3 Replies

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    3 years ago

    Hi @Harsha3,

    Solution provided by @marjan.karafiloski should work, it has worked for me previously. Please test it out at your end, you can also rename the sheet names, make it more dynamic including the current date as well.

    For example, sampleSheet_Date.now(), remember to select the “=” decorator for customizing the name dynamically based on date.

  • Harsha3's avatar
    Harsha3
    New Contributor III
    3 years ago

    Thanks so much, may I know how to read excel with multiple sheet names without passing the value as a parameter i.,e wanted to read the data in all the sheets in excel at once without being passed as a parameter each time.