Skip to main content
Solved

Excel worksheet to Sharepoint > How to hide fields

  • November 20, 2023
  • 2 replies
  • 122 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)

View original
Did this help you find an answer to your question?

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+51
  • 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.

Reply


Helpful Members This Week

Community Stats

30,942
Posts
117,252
Replies
38,742
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.