|
|
How to change cell background in excel sheet using perl
07-10-2008
|
|
wml::std::grid(3) EN Tools wml::std::grid(3) NAME
wml::std::grid - Layout Grid SYNOPSIS
#use wml::std::grid <grid [attributes]> <cell [attributes]>...</cell> : <cell [attributes]>...</cell> </grid> DESCRIPTION
The "<grid>" container tag provides a mixture between a HTML table and a TeX-like way of specifying its dimensions and the alignment of its cells. ATTRIBUTES
First the possible attributes for "<grid>": "summary" This attribute will be inserted into the "table" tag, see documentation of HTML 4.0 for details on why this attribute is recommended. "layout" This specifies the layout of the grid in X and Y dimension, i.e. "3x2" means 3 columns (x-dimension) and 2 rows (y-dimension). Default is "1x"NCELL where NCELL is the number of cell tags or in other words: Default is a top-down list. "align" This specifies the horizontal alignment of the cells in a row. The argument has to contain as many characters as there are cells in a row. The supported alignment characters are `"l"' (left), `"r"' (right) and `"c"' (center). Default is `"l...l"' (as much "l"'s as there are cells in a row). "valign" This specifies the vertical alignment of the cells in a column. The argument has to contain as many characters as there are cells in a column. The supported alignment characters are `"t"' (top), `"b"' (bottom) and `"m"' (middle). Default is `"t...t"' (as much "t"'s as there are cells in a column). "width" This is the corresponding attribute of the HTML "<table>" tag. Use it to set the width of the grid. Default is no specified width. "spacing" This is the corresponding attribute to "cellspacing" of the HTML "<table>" tag. Use it to set the spacing of cells in the grid, i.e. the space around the content of each cell. Default is 0 (no space). "padding" This is the corresponding attribute to "<cellpadding>" of the HTML "<table>" tag. Use it to set the padding between cells in the grid, i.e. the inter-cell space. Default is 0 (no space). "border" This is the corresponding attribute of the HTML "<table>" tag. Use it to set the border width of the grid. Default is 0 (no border). "bgcolor" This is the corresponding attribute of the HTML "<table>" tag. Use it to set the background color of the grid. Default is no specified color. "color" This sets the foreground (text) color of the grid's contents. Actually this sets the default for the same attribute of "<cell>". Default is no specified color. Second the possible attributes for "<cell>": "align" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the horizontal alignment of the cell's contents. Default is taken from the same attribute of "<grid>". "valign" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the vertical alignment of the cell's contents. Default is taken from the same attribute of "<grid>". "bgcolor" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the background color of a particular cell. Default is no specified color. "color" This sets the foreground (text) color of the cell's contents. This is done via the HTML "<font>" tag. Default is no specified color or the color from the same attribute of "<grid>". "rowspan" This is the corresponding attribute of the HTML "<td>" tag. Use it to span a cell over more then one row of the grid. Default is 1 row. "colspan" This is the corresponding attribute of the HTML "<td>" tag. Use it to span a cell over more then one column of the grid. Default is 1 column. "width" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the width of the cell. Default is no specified width. "height" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the height of the cell. Default is no specified height. EXAMPLE
<grid bgcolor="#000000" color="#ffffff" layout="3x2" align="llr" valign="tm"> <cell>A</cell> <cell>B</cell> <cell>C</cell> <cell>D</cell> <cell>E</cell> <cell>F</cell> </grid> AUTHOR
Ralf S. Engelschall rse@engelschall.com www.engelschall.com REQUIRES
Internal: P1, P2, P3, P5 External: -- SEE ALSO
HTML <"table">-tag. EN Tools 2014-04-16 wml::std::grid(3)