Convert xls files into sql script
- python 2.x
- python lib: xlrd
command(python generateSQL.py [output file name,default:result.sql])
It will read excel sheets one by one. Each sheet as a database table. Read the first row of each sheet as the table name, will stop when first meet a blank cell in this row. Then read rest rows as data, empty row will be skiped.