in reply to best way to change xml record using XML::Simple?
Why not use a simple database? The schema is already defined within the excel spreadsheet, and you'd get away from data integrity errors (your solution is not multi-user safe). And you would still be able to create the spreadsheet whenever necessary using something like Spreadsheet::WriteExcel. You already seem to be doing much of the work already; using a db would allow SQL to more efficiently update just the row that needed to be instead of chugging through the entire XML file each and every time.
|
---|
Replies are listed 'Best First'. | |
---|---|
NO DBs allowed
by waxmop (Beadle) on Feb 24, 2003 at 18:53 UTC | |
by merlyn (Sage) on Feb 24, 2003 at 19:13 UTC |
In Section
Seekers of Perl Wisdom