Reading Excel files with restricted labels
My company has developed a straight up obsession with document labels. 🙄 While annoying before, now they went even further in this madness and now have both protected and unprotected for almost all categories. Unfortunately, since they added the protected before the unprotected as the first option, most users just go with the first one. Now, even though I can open any of the documents as MS figures it out from my account credentials, when I try to open a label protected file in Knime, I can’t. If I add my account pwd to Knime, it doesn’t work as, I’m assuming, it’s trying to unlock it based on a password, not the stupid label, so it fails.
Just so we are all on the same page, I am talking about these labels.
As mentioned, since it’s the first option, user just add that. On opening such a file, MS asks for no credentials and no passwords, you belonging to the company is the “key” to open it in this particular case.
In the excel reader, as far as I can see, there is only a password option:
I have tried this as is not enough, it doesn’t work. Does anyone have a solution for this particular conundrum?
Thank you.