Examples of using the Abstract Tables command line utilities

abtab-examples.sh

user@host ~$ gem install abstract-tables

# convert csv file to an Excel Spreadsheet:
user@host ~$ atcat your-file.csv xls://your-file.xls

# dump a table into an Excel Spreadsheet:
user@host ~$ atcat atcat dbi://pg/localhost/the_database_name/some_table xls://some-table.xls

# dump a list of tables into an Excel Spreadsheet:
user@host ~$ atcat dbi://pg/localhost/the_database_name xls://tables-and-rowcounts.xls

user@host ~$ atcat people.xls
id	fname	lname	website
1	Kyle	Burton	http://asymmetrical-view.com/
2	Trotter	Cashion	http://www.trottercashion.com/
3	Aaron	Feng	http://www.aaronfeng.com/
4	Toby	Di Pasquale	http://cbcg.net/


# view the contents of an xls file:
user@host ~$ atview xls://people.xls

Record[1]
[  1] id     : 1
[  2] fname  : Kyle
[  3] lname  : Burton
[  4] website: http://asymmetrical-view.com/

Record[2]
[  1] id     : 2
[  2] fname  : Trotter
[  3] lname  : Cashion
[  4] website: http://www.trottercashion.com/

Record[3]
[  1] id     : 3
[  2] fname  : Aaron
[  3] lname  : Feng
[  4] website: http://www.aaronfeng.com/

Record[4]
[  1] id     : 4
[  2] fname  : Toby
[  3] lname  : Di Pasquale
[  4] website: http://cbcg.net/