Does Excel binary hold "old" information?

emp1953 has asked for the wisdom of the Perl Monks concerning the following question:

I have a script that uses CPAN's Spreadsheet::ParseExcel It parses the spreadsheet just fine except that it parses a worksheet that was deleted from the workbook. At one time the workbook contained 3 worksheets. The third was deleted years ago but the script still finds the 3rd worksheet which is blank, but this is annoying. Thanks for any help

Comment on Does Excel binary hold "old" information?

Replies are listed 'Best First'.
Re: Does Excel binary hold "old" information? by huck (Prior) on Feb 28, 2017 at 03:57 UTC
are you sure it was deleted. Or could it have just been hidden, https://support.office.com/en-us/article/Hide-or-show-worksheets-or-workbooks-69f2701a-21f5-4186-87d7-341a8cf53344, or VeryHidden http://www.excel-university.com/make-an-excel-worksheet-very-hidden/?	[reply]
Re: Does Excel binary hold "old" information? by choroba (Cardinal) on Feb 28, 2017 at 02:58 UTC
Crossposted to StackOveflow. Crossposting is OK, but it's considered polite to inform about it to avoid duplicate work of people not attending both sites. ($q=q:Sq=~/;[c](.)(.)/;chr(-\|\|-\|5+lengthSq)`"S\|oS2"`map{chr \|+ord }map{substrSq`S_+\|`\|}3E\|-\|`7**2-3:)=~y+S\|`+$1,++print+eval$q,q,a, [download]	[reply] [d/l]
Re: Does Excel binary hold "old" information? by GotToBTru (Prior) on Feb 28, 2017 at 13:41 UTC
Looks like an Excel problem, not a Perl problem. Excel forum may have suggestions to make sure deleted stuff is actually deleted instead of just disconnected. Perhaps physically moving the file on the drive? Saving in different formats? But God demonstrates His own love toward us, in that while we were yet sinners, Christ died for us. Romans 5:8 (NASB)	[reply]


Come for the quick hacks, stay for the epiphanies.
	PerlMonks