¡á Grid.SetExcelTitle

SECTION

 

Method

SINCE

 

1.1.0.56

DESCRIPTION

 

GridToExcel »ç¿ë½Ã ¿¢¼¿¹®¼­ÀÇ Title ºÎºÐÀ» ¼³Á¤ÇÑ´Ù.

SYNTAX

 

GridID.SetExcelTitle(Option, Value)

POSSIBLE VALUES

 

ÇØ´ç¾øÀ½

PARAMETERS

 

LONG Option : TitleÀ» Ãß°¡ÇÒ Áö(1), Ãß°¡µÈ TitleµéÀ» ClearÇÒ Áö(0) ¼³Á¤

BSTR Value : Title·Î Ç¥ÇöµÉ ³»¿ë

* Value ¼³Á¤¿¹

GridID.SetExcelTitle(1, ¡°value:Title Value; font-face:±¼¸²Ã¼; font-size:30pt; font-color:blue; font-bold; font-underline; font-italic; bgcolor:#ffffff; align:center; line-color:red; line-width:2pt; skiprow:1;¡±);

°¢ ¼Ó¼º°£ÀÇ ±¸ºÐÀÚ´Â ¼¼¹ÌÄÝ·Ð(;)ÀÌ¸ç ¼Ó¼º¸í°ú ¼Ó¼º°ªÀÇ ±¸ºÐÀÚ´Â ÄÝ·Ð(:)ÀÌ´Ù.

value ¼Ó¼º : Excel¿¡ ÂïÇôÁú TitleÀÇ ¹®ÀÚ¿­ (¡®Title¡¯)

font-face ¼Ó¼º : ±Û²Ã ¼³Á¤ (¡®±¼¸²Ã¼¡¯)

font-size ¼Ó¼º : ÆùƮũ±â ¼³Á¤ (¡®30pt¡¯)

font-color ¼Ó¼º : ÆùÆ®»ö±ò ¼³Á¤ (¡®blue¡¯, blue´ë½Å ±×¿¡ ´ëÇÑ rgb°ª ¡¯ #0000ff ¡® »ç¿ë°¡´É)

font-bold ¼Ó¼º : ÆùÆ®¸¦ ±½°Ô Ç¥Çö (¼Ó¼º°ª ¾øÀ½)

font-underline ¼Ó¼º : ÆùÆ®¿¡ ¹ØÁ٠ǥÇö (¼Ó¼º°ª ¾øÀ½)

font-italic ¼Ó¼º : ÆùÆ®¸¦ ÀÌÅŸ¯À¸·Î Ç¥Çö (¼Ó¼º°ª ¾øÀ½)

bgcolor ¼Ó¼º : ¹è°æ»ö±ò ¼³Á¤ (¡®#ffffff¡¯, ÀÌ°ÍÀº ¡®white¡¯¿Í µ¿ÀÏ)

align ¼Ó¼º : Á¤·Ä ¼³Á¤ (¡®center¡¯, ÀÌ¿Ü¿¡ ¡®left¡¯, ¡®right¡¯ ¼³Á¤ °¡´É)

line-color ¼Ó¼º : ¿Ü°û¼± »ö±ò ¼³Á¤ (¡®red¡¯)

line-width ¼Ó¼º : ¿Ü°û¼± Å©±â ¼³Á¤ (¡®2pt¡¯, line-color¿Í line-width ¼Ó¼ºÀ» ¼³Á¤ÇÏÁö ¾ÊÀ¸¸é

¿Ü°û¼± ¾øÀ½)

skiprow ¼Ó¼º : TitleÀÌ Ãâ·ÂµÇ´Â row ¹Ø¿¡ °ø¹é»óÅ·ΠµÑ rowÀÇ °³¼ö ¼³Á¤ (¡®1¡¯)

row-height ¼Ó¼º : GridToOffice »ç¿ë½Ã TitleÀÇ ³ôÀ̸¦ ÁöÁ¤ÇÑ´Ù. (NP - ¹ÌÁö¿ø MAX - 1,2,1,388 UMX - 2,0,1,388)

[ÁÖÀÇ»çÇ×]

1. row-height ¼Ó¼ºÀº GridToOffice¸¸ Áö¿øÇÑ´Ù.

2. GridToOffice »ç¿ë½Ã skiprow ¼Ó¼ºÀº ¸¶Áö¸·¿¡ »ç¿ëÇØ¾ß ÇÑ´Ù.

RETURN VALUES

 

ÇØ´ç¾øÀ½

EXAMPLE

 

[JavaScript]

<SCRIPT language=javascript>

function XXX() {

GridID.SetExcelTitle(0, "");

GridID.SetExcelTitle(1, "value:Title\nMulti Line;font-face:±¼¸²Ã¼;font-size:30pt;font-color:black;font-bold;font-underline;bgcolor:#ffffff;align: center;line-color:red;line-width:2pt;skiprow:1;");

GridID.SetExcelTitle(1, "value:(SubTitle);font-face:'±¼¸²Ã¼';font-size:18pt;font-color:black;bgcolor:#99ffff;align:center;line-color:blue;line-width:1pt;skiprow:1;");

GridID.SetExcelTitle(1, "value : 2003/10/09;        font-face: '±¼¸²Ã¼';font-size: 16pt;font-color: black;font-italic;bgcolor:#ff9999;align:right;line-color: red;line-width: 0.5pt;skiprow: 2;");

}

</SCRIPT>

SAMPLE

 

./sample/SetExcelTitle_s1.html

SEE ALSO

 

GridToExcel, GridToOffice