Skip to content

duolaAOA/excel_parse

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

对各种文本格式数据的清洗与导入Mysql

excel_to_mysql

  • 索引本地指定目录下所有excel文件, 提取每个字段 批量导入mysql, 表名按文件名创建表名

json_clean

  • 将干扰字符剔除, 转为干净的json数据并保存数据库‘

xls_to_mysql

  • 批量处理excel数据, 导入mysql

About

excel数据入库,文本数据清洗

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages