This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Has anyone found a way to write multiple tabs in a new/ existing Excel in SharePoint? I have used following tools/ methods so far, none of them effective. Only option for me is to write a file with a single tab.
Here is an example of writing to multiple tabs in a new/existing excel file. The block until done tool works by processing everything coming out of the first output first, the second output only starting after the first has completed, etc. The following example will write 5 sheets to the same Excel file, one at a time:
I have heard of a potential solution using report feature but couldn't build or test it myself, and don't have SP access now. If anyone can try and let the community know if it worked then that would be great.
I have similar issue with outputing xlsx to sharepoint folder but the problem is that this exact error comes up when outputing more than 2 tabs. It really gives me a headache why this is happening, anyone has found solution to this?