Location:
Search - PHPExcelPars
Search list
Description: 修改后的PHPExcelParser4。
修改内容：
1，原来sample取出excel时是使用的Unicode编码。导致插入mysql时也写入unicode
现在把Unicod编码转换成GBK后再在网页上显示及写入数据库.此部分修改的是U2html这个function。
2，打
开数据库连接后增加 set Names gbk
3，默认选中把excel的第一列作为字段名
4，默认不选中如果存在表则删除选项
5，原来对表名及字段名有过滤掉一些字符如"-"，现在则取消了这个过滤，我觉得在excel第一列或在操作过程中由人工确定更合适。-Revised PHPExcelParser4. Changes: 1, the original excel when the sample is taken out of the Unicode encoding used. Mysql lead when inserted into the unicode encoding Unicod now after the GBK into a web page display and write the database. This section is amended U2html this function. 2, open the database connection after the set Names' gbk ' 3, the default select the first column to excel as a field of 4, the default is not selected table if the delete option 5, the original name of the table and field names are filter out some characters such as "-" , and now removed the filter, I think that the first column in excel or in the process to determine a more appropriate by the artificial.
Platform: |
Size: 97280 |
Author: zaobao |
Hits:
Description: 可以把EXCEL表中数据输入到SQL的表格中-input DATA TO SQL FROM EXCEL
Platform: |
Size: 88064 |
Author: alan |
Hits: