Extracting data from an uploaded .xls/.csv file
Posted: Wed Feb 28, 2007 10:50 am
I have an upload form on my page that excepts .xls or .csv files, and I need to find a way to extract the rows of the file and store them in a database.
I have done this the reverse way (pulling items from mysql and exporting as .xls files), but I'm not sure how to parse the values out of the file that is uploaded.
If anyone has encountered this, and knows a simple (or complex) way to get these values, that information would be greatly appreciated in advance.
Thanks.
I have done this the reverse way (pulling items from mysql and exporting as .xls files), but I'm not sure how to parse the values out of the file that is uploaded.
If anyone has encountered this, and knows a simple (or complex) way to get these values, that information would be greatly appreciated in advance.
Thanks.