Skip to main content
  • EN

Hi there, I have a workspace that fills out an excel spreadsheet and then pushes this into Sharepoint. I want to hide the first five columns in the spreadsheet (so I can unhide them when I need to check, but the user doesn't have to see it). How do I do that?

 

I tried hiding them in the spreadsheet in Microsoft 365/Excel Online, but they revert to showing every time the process runs.

 

I tried in the FeatureWriter Paramaters> Edit Column Formatting> Cell Protection> Hidden in the first five columns, but that didn't work.

imageThanks in advance for any guidance you can provide.

I'm guessing the reason why the columns are un-hidden is because you have the writer set to 'overwrite existing file'.

 

One potential solution would be to use a template file, and in that template you will have the first five columns hidden. When the write writes the data (regardless of the overwrite existing file setting) it will use the template as the starting point (instead of an empty excel doc)

Thanks @hkingsbury​ ! I was avoiding using the template file, but have made the switch over, and it's a huge improvement.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.