topic Re: Dataflux 2.8 - How to add additional tabs to a excel file output in SAS Data Management

Dataflux 2.8 - How to add additional tabs to a excel file output

beamer108 — Fri, 05 Nov 2021 13:14:09 GMT

I currently have a datajob that writes output to a .xls file. It contains one tab with all the data I need. The business now wants another tab added to the same worksheet that contains some of the columns from the first tab as well as some additional columns. How do I add another tab to the same worksheet?

Re: Dataflux 2.8 - How to add additional tabs to a excel file output

VincentRejany — Fri, 05 Nov 2021 16:36:41 GMT

Tried with the following configuration and it worked

Re: Dataflux 2.8 - How to add additional tabs to a excel file output

beamer108 — Fri, 05 Nov 2021 17:04:39 GMT

Thank you I will give this a try.

Re: Dataflux 2.8 - How to add additional tabs to a excel file output

beamer108 — Mon, 11 Jul 2022 19:50:05 GMT

This worked great when I ran it on the client machine but when I tried to run it on the server it does not work. I reached out to our admin team and because of our set up our df configuration on the server is not compatible with an excel driver. Not sure if I captured that correctly but basically I was told due to how we are set up its not an option. So to resolve the issue I worked with our SAS EG experts and we created the job using SAS code and our customer is receiving the output in the format they needed. Thanks for the advice and guidance.

Re: Dataflux 2.8 - How to add additional tabs to a excel file output

RacheLGomez123 — Mon, 26 Dec 2022 06:59:13 GMT

Hold down SHIFT, and then select the same number of existing sheet tabs of the worksheets that you want to insert in the open workbook. For example, if you want to add three new worksheets, select three sheet tabs of existing worksheets. On the Home tab, in the Cells group, click Insert, and then click Insert Sheet.

Regards,
Rachel Gomez

Re: Dataflux 2.8 - How to add additional tabs to a excel file output

beamer108 — Tue, 27 Dec 2022 12:14:31 GMT

Thank you Rachael for responding. I actually was looking for within the Dataflux process how to create a worksheet that contains multiple tabs containing data on output. I found that due to how our admins set up our dataflux the option isn't available on our server so I've found the solution using SAS programming. Thanks again for responding, but at this time I am all set.