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

--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.

To install SQL::Type::Guess, copy and paste the appropriate command in to your terminal.

cpanm SQL::Type::Guess

perl -MCPAN -e shell
install SQL::Type::Guess

For more information on module installation, please visit the detailed CPAN module installation guide.

	Global
`s`	Focus search bar
`?`	Bring up this help dialog

	GitHub
`g` `p`	Go to pull requests
`g` `i`	go to github issues (only if github is preferred repository)

	Search terms
module: (e.g. module:Plugin)
distribution: (e.g. distribution:Dancer auth)
author: (e.g. author:SONGMU Redis)
version: (e.g. version:1.00)