Grouping data
Moderator: General Moderators
Grouping data
Let say I have the records of students (name, address, phone no, course etc..) in a cd. This record let say in MS Excel format. I want to extract all the records into my system and automatically put all the records into their group. In my system, I have 4 group :Town A, B, C and D. I want the system put all the students record into their group base on their location (which town) automatically from the data on the cd. Anybody get the idea how to make this?
-
fastfingertips
- Forum Contributor
- Posts: 242
- Joined: Sun Dec 28, 2003 1:40 am
- Contact:
-
fastfingertips
- Forum Contributor
- Posts: 242
- Joined: Sun Dec 28, 2003 1:40 am
- Contact:
Also a fast way is to save your excel file into a csv format then use the "fgetcsv" function.
All this because Excel files are binary and cannot be read by PHP.
The only way to do this would be to have Excel installed on a windows server which is running PHP and then convert the file using COM functions. This solution will only work on a server running Windows.
Hm also there is another possibility: ODBC
All this because Excel files are binary and cannot be read by PHP.
The only way to do this would be to have Excel installed on a windows server which is running PHP and then convert the file using COM functions. This solution will only work on a server running Windows.
Hm also there is another possibility: ODBC
You can read Excel files, but the script ain't free
http://www.zakkis.ca/products/index.php?s=6&p=37
http://www.zakkis.ca/products/index.php?s=6&p=37
MarkDo you need a script that can read MS Excel files and save the data in
database, HTML pages and etc.? Do you want to do it with PHP under Unix and
Linux but without using Windows tools like COM? Then PHP - Excel file parser
is the right tool for you. All you will need is just our excelparser.php and
PHP enabled web server without any further tools.
The Professional version of PHP Excel Parser, has the debug function,
support multiple Excel font and formula processing! It also reads Excel
Dates prior 01.01.1970!
What's new in 4.0 version:
Support MAC Excel files