Data Resolution

Question

Hello guys,

Please suggest me for the below issue

I have an Excel file named DataSet which has 5 different sheets.

I want to add an extra 6th sheet in that excel file generated through Render tool.

I am unable to add it with other five and also unable to rename the 6th sheet.

Thanks in advance:)

atcodedog05 · Answer

@Polite123

Hmm... thats bad

But yes render tool works only on replace data not append data.

I will let you know if i find anything or any workaround.

Polite123 · Answer

It didn't work @atcodedog05 😞

atcodedog05 · Answer

Hi @Polite123

Render tool supports only replace functionality it doesnt support append functionality.

A workaround would be read the previous files sheets and use union to add new data and write it through render. By this you would have merged old and new data of a sheet.

Hope this helps 🙂