Convert Excel Output to ZIP, Change docProps, Convert Back to Excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a running issue with the fact that Alteryx places Alteryx in the Company name under an Excel workbook's properties. Presently, I have to remind myself to manually change after the initial Output to Excel. Once changed, it should remain unchanged so long as the Alteryx Output tool is set to Overwrite Sheet/Range.
Using this post as inspiration Community Post, is there a way to build a workflow/macro that runs after your Output that converts the Excel file to a .zip and then modifies app.xml and core.xml files found under the docProps folder, and then renames/converts the file back to .xlsx? (BTW, Alteryx must already be doing this as it inserts Alteryx in to the company field when creating an Excel output.)
???
- Labels:
- Output
- Run Command
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @hellyars,
Not quite inline with that post but you could use the python tool to zip files like this (just need to change where the file is and where you want to zip it):
I've attached an example workflow.
All the best,
Ira
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@IraWatt The primary issue I want to tackle is changing the default company entered into Excel properties from Alteryx to my own value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I believe the company name is set in the app.xml not core which is a bit awkward, the only library I have found that can change that programmatically is here: DocumentSummaryInformation (EasyXLS API Documentation)
