NAME
sheet-to-sql - output the CREATE TABLE statement for an Excel sheet or CSV file
SYNOPSIS
sheet-to-sql myfile.xls
sheet-to-sql myfile.csv --header=2
OPTIONS
- --sheet=NUM
-
Number of the sheet to use. Counting starts at 1. Default is 1.
- --header=NUM
-
Line in which the column headers are. Counting starts at 1. Default is 1.
- --keep-headers
-
Do not convert the headers to something that SQL wants but keep them as they are in the sheet. Default is to convert the headers to something nice.