create and concatenate styled tables

styled_table()

Create a StyledTable object

export functions

write_png()

Write a styledTable object to png

write_pdf()

Write a styledTable object to pdf

write_excel()

Write a StyledTable to an Excel sheet

create_latex_table()

Generate the LaTeX code for a StyledTable

append_latex_table()

Append the LaTeX code for a StyledTable to an existing LaTeX table code

create_latex_table_body()

Generate the LaTeX code for a StyledTable without begintabular and endtabular

change font styles

set_excel_font_name()

Set font name for the Excel tables

set_latex_font_name()

Set font name for LaTeX tables

set_excel_font_size()

Set font size for the Excel tables

set_latex_font_size()

Set LaTeX font size

set_font_color()

Set font color

set_bold()

Set bold font

set_excel_boldweight()

Set excel_boldweight font

set_italic()

Set italic font

set_underline()

Set underlined font

set_strikeout()

Set strikout font

set_rotation()

Set rotation of cell content

set_indent()

Set indentation of cell content

set_fill_color()

Set fill color of cells

change cell alignment

set_horizontal()

Set horizontal alignment of cells

set_excel_vertical()

Set vertical alignment of cells

set_latex_vertical_move()

Set vertical movement of cell content for LaTeX table generation

change row height and column width

set_excel_row_height()

Method set_excel_row_height.

set_latex_row_height()

Method set_latex_row_height.

set_excel_col_width()

Method set_excel_col_width.

set_latex_col_width()

Method set_latex_col_width.

change table border

set_border_position()

Set border position of cells

set_border_color()

Set border color of cells

set_excel_border_pen()

Set border pen of cells

change value display

set_excel_data_format()

Set data format of cells

set_excel_pre_process()

Set pre processing of cell content for excel table generation

set_latex_pre_process()

Set pre processing of cell content for LaTeX table generation

various styling functions

set_excel_wrapped()

Set wrapped cell

set_excel_locked()

Set locked cell

set_excel_hidden()

Set hidden cell

merge cells

merge_cells()

Merge multiple cells in a StyledTable object

merge_equal_cells()

Merge all cells of StyledTable object whose cell values are equal

remove columns and rows

remove_col()

Remove columns from a StyledTable object

remove_row()

Remove rows from a StyledTable object

predefined table styling functions

The following functions style your table header and table body in the same way that is used for the published tables of the Austrian national statistics institute ‘Statistik Austria’.

format_stat_header()

Method format_stat_header.

format_stat_body()

Method format_stat_body.

format_stat_sub_heading()

Method format_stat_sub_heading

format_stat_absolute()

Method format_stat_absolute

format_stat_relative()

Method format_stat_relative

cross table creation

The following functions allow the easy creation of cross tables (pivot tables) with multiple header levels and sub tables.

create_cross_table_body()

Create a styled cross table body

create_cross_table_header()

Method create_cross_table_header

count rows/columns

count_rows()

Count number of rows in a StyledTable

count_cols()

Count number of columns in a StyledTable