Perl program to add 3 columns to an existing excel file and generate random values
Posted on 2007-11-20
I have just started to learn perl so I am a complete novice.
I have a basic excel table(which will be exported to mySQL eventually).
At the moment the table has columns for title,author, description, category and imageurl.
I would like a perl program which would take the existing .xls file, open it, and add 3 new columns called ID, Price, and Currentstock, and to have each of these columns populated with random numerical (1-9999 for ID, 1-50 for Price, and 0-200 for Currentstock) for each title listed in the title column.
I hope I have explained clearly, and thanks for your help.