| | |
Parse Data from MS-Excel file
Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
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!
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 (Computer Science)
- append/write data from a text file into an excel sheet without using database (PHP)
- EXCEL CSV FILES Handling (Java)
- Help! Parse error: parse error, unexpected T_STRING (PHP)
- Get data out of excel file stored as an image (MS SQL)
- PHP Parse Microsoft Excel htm (PHP)
- How to call a EJB method from Session bean method (Java)
- traslate by C++ a EXCEL sintax in a C++ sintax (C++)
- Vynotl.exe (Windows 95 / 98 / Me)
Other Threads in the ColdFusion Forum
- Previous Thread: Setting Data Source with a .mdf?
- Next Thread: Serialization failure in coldfusion
Views: 1421 | Replies: 0
| Thread Tools | Search this Thread |
Tag cloud for ColdFusion





