Skip to main content
Solved

Excel worksheet to Sharepoint > How to hide fields

  • November 20, 2023
  • 2 replies
  • 193 views
epro_admin
Contributor
Forum|alt.badge.img+7

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.

Best answer by hkingsbury

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)

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+65
  • hkingsburyCelebrity
  • Celebrity
  • Best Answer
  • November 20, 2023

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)

epro_admin
Contributor
Forum|alt.badge.img+7
  • epro_adminContributor
  • Author
  • Contributor
  • November 23, 2023

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

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.