Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^3: Parsing error

by pryrt (Abbot)
on Jan 30, 2023 at 22:00 UTC ( [id://11150043]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Parsing error
in thread Parsing error

I can't use Spreadsheet::Read as I have to input missing zip codes

You apparently misunderstood me. I wasn't saying "use Spreadsheet::Read instead of Excel::Writer::XLSX ". I was saying "use Spreadsheet::Read instead of using a manual open and a while(<FH>) loop to read the old spreadsheet in, and continue to use Excel::Writer::XLSX as the way to write your new file out".

I just brought up Text::CSV (*) because you seemed to be treating the spreadsheet you were reading as a text file, and CSV is the only pure-text spreadsheet format that I know about, so I thought maybe you were confused about file formats. Since your input file is actually named SRC185.xlsx then it is not a CSV file and you cannot use Text::CSV . (*: CSV is a text-based spreadsheet; CVS is a pharmacy chain or a version-control system that served as a precursor to SVN; VCS is the generic abbreviation for version control software; there are too many valid anagrams of that TLA.)

So in case it wasn't stated succinctly enough yet:

Replies are listed 'Best First'.
Re^4: Parsing error
by MoodyDreams999 (Beadle) on Jan 31, 2023 at 15:34 UTC
    Thank you for clarifying that for me, we use csv's alot so I may play around with that module here eventually, but for this purpose I don't need to turn it into a cvs yet in the process for convenience. Thats something I will probably be working towards eventually though.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11150043]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (3)
As of 2024-03-29 06:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found