topic Re: HELP PLEASE, Server Omits Data and Layout from Rendered Excel File in Alteryx Server Discussions

HELP PLEASE, Server Omits Data and Layout from Rendered Excel File

Shen-Tat — Fri, 27 Aug 2021 21:30:58 GMT

Hi everyone,

I hope someone can help me with this. My project is intended to output several sheets of data to a single excel file, each sheet of which has a simple layout. On the top, a summary report. On the bottom, the detail table. When I run this analytic app from Developer, it works perfectly. When I run it from Server, the summary portion drops out. I only see in the final excel files black cells with no data in them. See the attached App and its outputs.

To run this, all that you would need to change is to change the network address in Formula (2).

I hope to hear from someone!

Thanks,

Shen-Tat

Re: HELP PLEASE, Server Omits Data and Layout from Rendered Excel File

jrgo — Mon, 30 Aug 2021 17:30:40 GMT

I think you discovered a bug. I ran. your workflow with version 2019.4 and the output didn't black-out those 2 top rows, but when I tested in v2021.2, I get the same result you're describing.

Not sure if the latest, 2021.3, has any difference, but I'd suggest submitting a ticket to Support@alteryx.com.

Re: HELP PLEASE, Server Omits Data and Layout from Rendered Excel File

Shen-Tat — Mon, 30 Aug 2021 18:00:56 GMT

Will do. Thanks for taking time to test this,

Re: HELP PLEASE, Server Omits Data and Layout from Rendered Excel File

raychase — Mon, 30 Aug 2021 22:12:50 GMT

This is a known issue:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/DE33649-Excel-xlsx-rendered-from-Report-Text-turns-with-black/ta-p/768756

Re: HELP PLEASE, Server Omits Data and Layout from Rendered Excel File

Shen-Tat — Mon, 30 Aug 2021 22:15:30 GMT

This is not a color issue. This is a DATA and color issue. I will correct for the bgcolor, however, the data are not rendering out of the tool. Do you know a resource for this?

Re: HELP PLEASE, Server Omits Data and Layout from Rendered Excel File

CristianoJ — Wed, 01 Sep 2021 18:53:13 GMT

This issue, DE33649, got fixed in the 2021.3 release as per the release notes at this link:

https://help.alteryx.com/release-notes/designer/designer-20213-release-notes

Re: HELP PLEASE, Server Omits Data and Layout from Rendered Excel File

Shen-Tat — Thu, 23 Sep 2021 22:40:23 GMT

This is NOT a bg color issue. The data (if you look at the workflow I uploaded) do not pass through to the output file. Perhaps someone, other than the first person, who saw the relevant issue, can see this? I do not know how to more clearly paraphrase this. I don't care about the color. I care about the summary data, which is not printing on the output.