Add support for Excel Tables

[fzumstein]

see: http://www.jkp-ads.com/articles/Excel2007TablesVBA.asp
and: http://www.techrepublic.com/blog/10-things/10-reasons-to-use-excels-table-object/

Some notes:

import xlwings as xw
wb = xw.books.active
r = wb.sheets[0].range('A1').api.list_object.name.get()
wb.sheets[0].range('A1').api.list_object.list_rows[2].range_object.delete_range()
wb.sheets[0].range('A1').api.list_object.list_rows[1].range_object.insert_into_range(shift=kw.shift_down)

[jaymegordo]

+1 for this. It would be really nice to interact with listobjects through the xlwings api.

Functions for loading to/from dataframes would be great also.

[fzumstein]

note for mac properties:

{k.class_: k.list_object,
k.name: 'Table1',
k.display_name: 'Table1',
k.comment: '',
k.show_headers: True,
k.total: False,
k.show_autofilter: True,
k.table_style: app(pid=1150).workbooks['Book5'].worksheets['Sheet1'].list_objects[1].table_styles[1],
k.show_table_style_first_column: False,
k.show_table_style_last_column: False,
k.show_table_style_row_stripes: True,
k.show_table_style_column_stripes: False,
k.range_object: app(pid=1150).workbooks['Book5'].worksheets['Sheet1'].list_objects[1].range_object,
k.default: 'Table1',
k.active: False,
k.display_right_to_left: False,
k.cell_table: app(pid=1150).workbooks['Book5'].worksheets['Sheet1'].list_objects[1].cell_table,
k.total_row: k.missing_value,
k.header_row: app(pid=1150).workbooks['Book5'].worksheets['Sheet1'].list_objects[1].header_row,
k.insert_row: k.missing_value,
k.query_table: k.missing_value,
k.autofilter_object: app(pid=1150).workbooks['Book5'].worksheets['Sheet1'].list_objects[1].autofilter_object,
k.sort_object: app(pid=1150).workbooks['Book5'].worksheets['Sheet1'].list_objects[1].sort_object,
k.source_type: k.src_none}