PowerGrid CSV Settings


PowerGrid CSV - Setup

  • CSV File: (link) The path to the CSV file. This can be a local or http path to the file. Local path are recommended.
    • Default:
  • CSV Separator: (select) The separator used in the CSV file.
    • Default: Comma ,
    • Possible Values:
      • Comma ,
      • Semicolon ;
      • Colon :
      • Tilde ~
  • Markdown Support?: (checkbox) This will turn on suport for markdown in your CSV file. All markdown will be interpreted as html for you.
    • Default: false
  • Use Header Row?: (checkbox)
    • Default: false
  • Use Footer Row?: (checkbox)
    • Default: false
  • Scrollable Table?: (checkbox)
    • Default: false
  • Scroll Height: (number) The number of pixels that the scroallable area will be.
    • Enable: When Scrollable Table? is set to 1
    • Default: 300px
    • Min Value: 0px
    • Max Value: 6000px
  • Sortable Table?: (checkbox) Make the table columns sortable when the Headers are clicked.
    • Enable: When Use Header Row? is set to 1
    • Default: false
  • White Indicators?: (checkbox) Use white indicator images
    • Enable: When Sortable Table? is set to 1
    • Default: false
  • Show Pager?: (checkbox) Show a content pager at the bottom of the table.
    • Enable: When Sortable Table? is set to 1
    • Default: false
  • Rows per Page: (select) The number of rows to show per page.
    • Enable: When Show Pager? is set to 1
    • Default: 10
    • Possible Values:
      • 10
      • 20
      • 30
      • 40
      • 50
  • Pager Alignment: (select) The alignment of the pager box.
    • Enable: When Show Pager? is set to 1
    • Default: Left
    • Possible Values:
      • Left
      • Right
  • Searchable Table?: (checkbox)
    • Default: false
  • Search Alignment: (select) The alignment of the search box.
    • Enable: When Searchable Table? is set to 1
    • Default: Left
    • Possible Values:
      • Left
      • Right
  • Search label: (input) The text label displayed inside hte search box.
    • Enable: When Searchable Table? is set to 1
    • Default: Search

PowerGrid CSV - Borders

  • Inner Border: (select) Inner Border Style
    • Default: Solid
    • Possible Values:
      • None
      • Dotted
      • Dashed
      • Solid
      • Double
      • Groove
      • Ridge
      • Inset
      • Outset
  • Inner Size: (number)
    • Default: 1px
    • Min Value: 0px
    • Max Value: 10px
  • Inner Color: (color)
    • Allows Opacity: true
  • Only Bottom Border: (checkbox)
    • Default: false

  • Outer Border: (select) Outer Border Style
    • Default: Solid
    • Possible Values:
      • None
      • Dotted
      • Dashed
      • Solid
      • Double
      • Groove
      • Ridge
      • Inset
      • Outset
  • Outer Size: (number)
    • Default: 1px
    • Min Value: 0px
    • Max Value: 10px
  • Outer Color: (color)
    • Allows Opacity: true

PowerGrid CSV - Style

  • Vertical Align: (select) The verticaal alignment of the text in the table
    • Default: Top
    • Possible Values:
      • Top
      • Middle
      • Bottom
      • Baseline
  • Body Alignment: (select) The alignment of the text in the table body
    • Default: Left
    • Possible Values:
      • Left
      • Right
      • Center
      • Justify
  • Background Style: (select) Background Style
    • Default: Transparent
    • Possible Values:
      • Transparent
      • Solid Color
      • Alternating Colors
  • Solid Bg: (color)
    • Enable: When Background Style is set to solid
    • Allows Opacity: true
  • Even Row Color: (color)
    • Enable: When Background Style is set to alternate
    • Allows Opacity: true
  • Odd Row Color: (color)
    • Enable: When Background Style is set to alternate
    • Allows Opacity: true
  • Body Text: (color)
    • Allows Opacity: true
  • Body Text: (number) The size of the body font.
    • Default: 12px
    • Min Value: 5px
    • Max Value: 50px

  • Head Alignment: (select) The alignment of the text in the header
    • Enable: When Use Header Row? is set to 1
    • Default: Left
    • Possible Values:
      • Left
      • Right
      • Center
  • Header BG Type: (select) The Style for the Header background
    • Enable: When Use Header Row? is set to 1
    • Default: Solid Color
    • Possible Values:
      • Transparent
      • Solid Color
      • Tiled Image
  • Header Color: (color)
    • Enable: When Header BG Type is set to solid
    • Allows Opacity: true
  • Header Tile: (image) The image to be used as the tile for each header cell
    • Enable: When Header BG Type is set to tile
    • Default:
  • Header Text: (color)
    • Enable: When Use Header Row? is set to 1
    • Allows Opacity: true
  • Header Weight: (select) Header Font Wieght
    • Enable: When Use Header Row? is set to 1
    • Default: Bold
    • Possible Values:
      • Normal
      • Bold
      • Bolder
      • Lighter
  • Header Text: (number) The size of the Header font.
    • Enable: When Use Header Row? is set to 1
    • Default: 12px
    • Min Value: 5px
    • Max Value: 50px

  • Foot Alignment: (select) The alignment of the text in the footer
    • Enable: When Use Footer Row? is set to 1
    • Default: Left
    • Possible Values:
      • Left
      • Right
      • Center
  • Footer BG Type: (select) The Style for the Footer background
    • Enable: When Use Footer Row? is set to 1
    • Default: Solid Color
    • Possible Values:
      • Transparent
      • Solid Color
      • Tiled Image
  • Footer Color: (color)
    • Enable: When Footer BG Type is set to solid
    • Allows Opacity: true
  • Footer Tile: (image) The image to be used as the tile for each footer cell
    • Enable: When Footer BG Type is set to tile
    • Default:
  • Footer Text: (color)
    • Enable: When Use Footer Row? is set to 1
    • Allows Opacity: true
  • Footer Text: (number) The size of the Footer font.
    • Enable: When Use Footer Row? is set to 1
    • Default: 12px
    • Min Value: 5px
    • Max Value: 50px
  • Footer Weight: (select) Footer Font Wieght
    • Enable: When Use Footer Row? is set to 1
    • Default: Bold
    • Possible Values:
      • Normal
      • Bold
      • Bolder
      • Lighter

  • Highlight: (select) Highlight certain rows or columns
    • Default: None
    • Possible Values:
      • None
      • Static - Row & Column
      • Static - Row
      • Static - Column
      • Hover - Row & Column
      • Hover - Row
      • Hover - Column
  • Hightlight BG Type: (select) Background type for the highlight
    • Default: Solid Color
    • Possible Values:
      • Transparent
      • Solid Color
      • Tiled Image
  • Highlight Color: (color)
    • Enable: When Hightlight BG Type is set to solid
    • Allows Opacity: true
  • Highlight Tile: (image) The image to be used as the tile for each highlight cell
    • Enable: When Hightlight BG Type is set to tile
    • Default:
  • Highlight Text: (color)
    • Allows Opacity: true
  • Highlight Weight: (select) Highlight Font Wieght
    • Default: Normal
    • Possible Values:
      • Normal
      • Bold
      • Bolder
      • Lighter
  • Highlight Row: (number) The row id that you want highlighted
    • Default: 0
    • Min Value: 0
    • Max Value: 100
  • Highlight Col: (number) The col id that you want highlighted
    • Default: 0
    • Min Value: 0
    • Max Value: 100

PowerGrid CSV - Custom Sizing

  • Custom Column Widths: (checkbox)
    • Default: false
  • Width Type: (select) So you want the width to be calculated in pixels or percent.
    • Enable: When Custom Column Widths is set to 1
    • Default: Pixels
    • Possible Values:
      • Pixels
      • Percent
  • Col0 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col0 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col1 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col1 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col2 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col2 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col3 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col3 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col4 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col4 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col5 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col5 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col6 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col6 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col7 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col7 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col8 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col8 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col9 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col9 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col10 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col10 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col11 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col11 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col12 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col12 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col13 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col13 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col14 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col14 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col15 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col15 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col16 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col16 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col17 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col17 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col18 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col18 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col19 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col19 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Col20 Width: (number) The width of the column
    • Enable: When Custom Column Widths is set to 1
    • Default: 0
    • Min Value: 0
    • Max Value: 1000
  • Col20 Align: (select) The alignment of the text in the column
    • Enable: When Custom Column Widths is set to 1
    • Default: Inherit
    • Possible Values:
      • Inherit
      • Left
      • Right
      • Center
      • Justify
  • Custom Row Heights: (checkbox)
    • Default: false
  • Row0 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row1 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row2 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row3 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row4 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row5 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row6 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row7 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row8 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row9 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row10 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row11 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row12 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row13 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row14 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row15 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row16 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row17 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row18 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row19 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row20 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row21 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row22 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row23 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row24 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row25 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row26 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row27 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row28 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row29 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px
  • Row30 Height: (number) The height of the row
    • Enable: When Custom Row Heights is set to 1
    • Default: 0px
    • Min Value: 0px
    • Max Value: 1000px

PowerGrid CSV - Cheat Sheet

  • Show Cheat Sheet?: (checkbox) Show the CSV Markup Cheat Sheet
    • Default: false