# -*- coding: utf-8 -*-
# New output.print_table() method
from pyrevit import script # DB, forms, revit
# Management of output window
output = script.get_output()
output.set_title("New output.print_table() method")
output.set_width(1100)
output.set_height(900)
output.close_others()
output.show()
# Test data as 2D list in 4 columns
table_data_a = [
["444444", "longueur", "12.00", "41"],
["44444444", "longueur", "12.20", "01"],
["444444444444444444", "longueur", "22.02", "12"],
["4444444444444", "longueur", "11.00", "44"],
["444444444444444444", "longueur", "12.11", "99"],
["44444444444444", "longueur", "12.03", "110"],
["123456456", "987654", "22.45", "41"]
]
# Test data as 2D list in 3 columns with linkify
table_data_b=[
[u'L\xe9gende', 'Legend 02 Wall types (sur 2 feuilles)', ' '],
[' ', 'Feuille A102', 'Permit plan Zone A'],
[' ', 'Feuille A103', 'Permit plan Zone B'],
[u'L\xe9gende', 'Legend 00 Fire safety (sur 2 feuilles)', ' '],
[' ', 'Feuille A102', 'Permit plan Zone A'],
[' ', 'Feuille A103', 'Permit plan Zone B'],
[u'L\xe9gende', 'Legend 04 Section references (sur 3 feuilles)', ' '],
[' ', 'Feuille A101', 'General plan'],
[' ', 'Feuille A102', 'Permit plan Zone A'],
[' ', 'Feuille A103', 'Permit plan Zone B'],
[' ', 'Feuille A104', 'Permit plan Zone C'],
[' ', 'Feuille A105', 'Permit plan Zone D'],
[' ', 'Feuille A106', 'Permit plan Zone E']
]
# Column header titles
columns = ["NUMBERS", "STRINGS", "DECIMALS", "PERCENTAGE"]
# Formatting options for data cells using python string formatting
# formats = ['{}', '{}', '{}', '{}%']s
formats=['{:.5}', '{}', '', '{}%'] # According to pyRevit docs
# Example values for string formatting of data cells :
# {:.5} # Characters 0 - 5. Works for numbers and strings
# {}% # Add % at end. Works for numbers and strings
# {:>10} # Might work, but probably does not override the HTML alignment
# {:.^10} # Centering with width 10 characters
# Values for column_widths are percentage or pixels, for example "20%" or "180px" (CSS)
column_widths = ["20%", "20%", "40%", "20%"]
# Text-alignment or header row titles (CSS)
column_head_align_styles = ["center", "left", "right", "center"]
# Text-alignment or header row titles (CSS)
column_data_align_styles = ["right", "left", "right", "center"]
# Option for vertical borders (horizontal are on by default) (CSS)
column_vertical_border_style = "border:black solid 1px"
# Text-style for the last row of data (CSS)
last_line_style="color:red; font-weight:bold"
# Option to repeat the header at the bottom (useful for long tables) (bool)
repeat_head_as_foot = True if len(table_data_a)>14 else False # Automatic option by table length
# Overall tablee width in percentage or pixels, for example "20%" or "180px" (CSS)
table_width_style="100%"
output.print_table(table_data_a,
title="New print_table method (variable width)",
columns=columns,
column_head_align_styles=column_head_align_styles,
column_data_align_styles=column_data_align_styles,
column_widths = column_widths,
column_vertical_border_style=column_vertical_border_style,
formats=formats,
last_line_style=last_line_style,
repeat_head_as_foot=repeat_head_as_foot,
table_width_style=table_width_style)
columns = ["Sél/Zoomer", "Légende > Feuilles", "Nom de feuille"]
column_head_align_styles = ["center", "left", "left"]
column_data_align_styles = ["right", "left", "left"]
column_vertical_border_style = None
last_line_style=None
repeat_head_as_foot = True if len(table_data_b)>12 else False # Automatic option by table length
column_widths = ["115px", "auto", "auto"]
table_width_style="800px"
row_striping = False
output.print_table(table_data_b,
title="New print_table method (fixed width) ",
columns=columns,
column_head_align_styles=column_head_align_styles,
column_data_align_styles=column_data_align_styles,
column_widths = column_widths,
column_vertical_border_style=column_vertical_border_style,
formats=None,
last_line_style=last_line_style,
repeat_head_as_foot=repeat_head_as_foot,
table_width_style=table_width_style,
row_striping=row_striping)