You are reading a single comment by @chez_jay and its replies.
Click here to read the full conversation.
-
Is that a response to me, and does it actually work?
I'm not going to use it though, because I never want to be asked to look at this XLSX again.
chez_jay-
Is that a response to me, and does it actually work?
Yes and yes, I just tested it.
I'm not going to use it though, because I never want to be asked to look at this XLSX again.
Fair dos. Just saw your edit, I can't blame you!
-
As the Excel security model is so crap this is also a great way to read data from files protected by a password. I've heard.
Drakien
dubtap
Assuming the Excel file is in .xlsx, you could rename that to .zip, unzip the file, find the XML for the sheet you want, edit that with a text editor, and then reverse the steps to build the .xlsx back again.
The file you want to edit is in folder xl\worksheets_rels in file sheet1.xml.rels (replace "sheet1" with the name of the sheet).