I created a report on Alteryx for output into multiple tabs in Excel but I want it to not show the gridlines in the page layout.
Is there a way to do this?
Thanks in advance :)
Solved! Go to Solution.
Alteryx output doesn't create configuration options within Excel. That being said, if you are outputing the data to a "RAW DATA" tab in a known workbook, you can create a PIVOT table that references the "RAW DATA" and customize that pivot to your heart's content. If you change the pivot table options for data to REFRESH on open, then as Alteryx writes to the file, the user will open to a formatted page. Writing to a tableau workbook might also solve the problem for you.
If you were writing the data to an ODBC data source, you might create a workbook in EXCEL that is formatted appropriately and connect to the external data.
Just a few thoughts for you.
Thanks,
Mark
Mark offers a great suggestion and is a good path if you users insist on Excel as a front end point of interaction.
Expanding on Mark's reply- if you don't have an actual database (odbc) to write to, you could also consider having Alteryx output to a .csv data file. Your Excel 'template' .xlsx file would then connect to that text file by going to the 'Data' > 'Get External Data' > 'From text'. .csv is an option there and that is your 'data source'
Dear MarqueeCrew,
could you kindly explain better the procedure you described in your previous post?
If I have create a table, should I creat also a pivot in addition or just a pivot?
Best regards