一个把CSV数据导入数据库的工具.
支持Excel导出的CSV数据。
支持自定义函数。
This class creates sql to import into tables in any mysql table - you
specify the fieldname in the csv - and the mysql field in your db that
this relates to. It supports database queries to get values to go into
final sql (so you can link tables) and it supports running custom
functions to get values for the final sql too. - and static values for
other fields.
It does some validation on the final sql to check that you have all the
fields that are required etc.
There is also some (experimental) xls file import support providing you
have xlhtml installed on the machine the class is running on. (it will
locate it and moan if you haven\'t) This works if the excel file only has 1
page but if it has multiple pages then im working on it ;)