Using xlsx or csv file to pick up files

[LasseThid]

We have a costumer who has a number of posters in a folder on our server.
Every week they send us an xlsx and a csv file containing names of files and the number of copies they want of those files.
At the moment I have to copy every file listed in the xlsx/csv file, rename them with a numerical prefix and add the amount at the end of the file name and then copy them to the input folder for the printer. This should be an ideal job to automate, but how can I read the rows of text from the xlsx/csv file and have them pick up the correct file while keeping track of which position in the list they have?
Can I convert the xlsx/csv to xml-files and then create an xml file for each entry containing the poisition, file name and amount and then use that to inject the file from the archive and rename the files using the meta data from the xml?

Any ideas or suggestions are gratefully accepted.

Thanks

[jan_suhr]

Hi Lars,


Take a look at my app Excel to XML. it will do the job for you

[LasseThid]

Sweet! Will do for sure...

Thanks Jan!