Parse Data from MS-Excel file

Expand Post »

Here's the problem:

One of my scripts allows users to upload MS-Excel files. When uploading the file, users are also required to enter details related to the file - details like start date, stop date, a description of what the file contains, and the file ID#.

This Excel file contains 1000s of data points each of which has a date and time record. Based on the dates entered in the form, I would like to grab only those records from the file that fall within these dates and dump all the selected data in a table in the DB.

Anyone know how I could do the "Selection of Records" part of the problem?

Thanks!

Similar Threads

find duplicates from a spreadsheet file in Computer Science
append/write data from a text file into an excel sheet without using database in PHP
EXCEL CSV FILES Handling in Java
Help! Parse error: parse error, unexpected T_STRING in PHP
Get data out of excel file stored as an image in MS SQL

cheapterp

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

33 posts
since Jun 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ColdFusion Forum Timeline: Setting Data Source with a .mdf?

Next Thread in ColdFusion Forum Timeline: Serialization failure in coldfusion

DaniWeb Message

Cancel Changes

User Name
Password