Header_Column Formatting to Appended Sheet.zip (866.1 KB)
See enclosed workflow. I am hoping to get the header style and column spacing in the appended sheet to match the style in the “Contract Tracker” sheet.
Have searched and searched, but still hoping this can be automated with Excel Classic version.
When enclosing the workflows, Do also enclose it’s project.json file, as there would be some incompatibilities or version changes that will be observed when also reverting back with our version of projects in place.
Is the Format going to be the same always ? If so, I believe you could keep a Template of that Excel sheet separately, then Before writing the modified data, use Copy File Activity, which would basically copy the Template file and rename it to your required format, then write the data to it using Write Range activity from the A2 range.
This should keep the Header/Column format the same.
Think I’m getting close. I’ve created the template but want it to apply to an appended sheet on dt_FinalTable. Does copy file apply the template to all sheets, including appended ones or is another step needed?
Thank you all for your suggestions and advice.
Tried to follow along your tips but not exactly sure.
I thought I was close with the idea add the template as a sheet to one of my source documents.
After it was read and used for comparison, that sheet would be copied with format to the final version of the sheet. Didn’t work. Sigh. See enclosed code with copy sheet commented out. Excel Template Copy Sheet.zip (902.6 KB)
Appreciate all the feedback
Hi. Sorry for the confusion.
I am trying to use above workflow to get autofit columns on the “Uncommon Rows” appended sheet.
People have suggested using copy sheet that would read a template and provide that functionality.
It’s the presentation factor. The bot can successfully sort through 20,000 rows of data and provide the user the uncommon rows between two excel files, yet doesn’t have the ability to spread the data out (autofit) so it is not crammed together.
TLDR: looking for a successful way to get autofit working using Excel classic without invoke VBA
As mentioned previously, we can prepare a Template based on the Excel sheet format required, then copying the sheet from this template to the First File, then after the Uncommon rows are found we write the data to this sheet starting from the Range A2, as the headers are already a part of the sheet.
@supermanPunch Thank you so, so much for your comments, review, and workflow.
The header issue is now fixed, however the output has changed when enhancements were made.
The bot’s purpose is to compare the two rows of uncommon output and highlight the differences: