in reply to Re^4: grep confusion
in thread grep confusion

'Apparently', Spreadsheet::ParseExcel::SaveParser has issues 'editing' existing XLS files:

"An Excel file is a binary file within a binary file. It contains several interlinked checksums and changing even one byte can cause it to become corrupted"
-https://groups.google.com/forum/#!topic/spreadsheet-writeexcel/FeEx0vXQErQ

I believe I am going to have to 'rewrite' the 'optional changes after creation' section of my program to read in the existing XLS with Spreadsheet::ParseExcel then 'recreate' a new copy of the XLS with Spreadsheet::WriteExcel and then overwrite the previous XLS with this new 'modified' copy. I'll post my results when I get this rewritten...(I did notice that 'irronius' errors appear more-so when I tried modifying a cell)

Has anyone seen this sliced bread thing? I's better than... sliced... well... never mind...

Replies are listed 'Best First'.
Re^6: grep confusion
by PriNet (Monk) on Sep 11, 2017 at 03:05 UTC
    Final Notes:
    (for anyone following)
    There WAS an issue using the Spreadsheet::ParseExcell module, it really does not like modifying the XLS file then trying to read it back immediately. I ended up re-writing (with some difficulty, not alot of precise info on it) using the Spreadsheet::Read module, which seems (so far), to work just ducky. I appreciate all the time and effort everyone gave with help on my project, I believe I'm to the point of using Use Tk to actually start my script doing something. I ended up not using the grep function as of yet, I may refer to the help provided when I get to the actual GUI part... Thanx a gigabyte to everyone that followed up on my issues (btw; I still get the subscript -1 issue arbitrarily, I will investigate that next).
    In the words of the Swartz... "I'll be back"
    Thanx again, I'll email twinkies out tomorrow.

    Has anyone seen this sliced bread thing? I's better than... sliced... well... never mind...
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom