SetRowStyle Method

C#

void SetRowStyle( 
   int row,
   ZennoTableStyle style
)

Parameters

row

Type: System.Int32

The cell's row, zero-based index.

style

Type: ZennoLab.InterfacesLibrary.ProjectModel.ZennoTableStyle

The style for excel row.

The following code using IZennoTable Interface for setting cell style.

C#

// get table by name "MyTable"
var table = project.Tables["MyTable"];
 
// create style
var style = new ZennoTableStyle
{
    HorizontalAlignment = InterfacesLibrary.Enums.Table.ExcelStyle.HorizontalAlignment.Right,
    VerticalAlignment = InterfacesLibrary.Enums.Table.ExcelStyle.VerticalAlignment.Bottom,
    Font = new Font("Comic Sans MS", 20, FontStyle.Italic | FontStyle.Underline, GraphicsUnit.Point),
    FontColor = Color.Red
};
style.SetBorder(InterfacesLibrary.Enums.Table.ExcelStyle.Borders.Right | InterfacesLibrary.Enums.Table.ExcelStyle.Borders.DiagonalUp, Color.Blue, InterfacesLibrary.Enums.Table.ExcelStyle.LineStyle.DashDot);
            
// set style
table.SetRowStyle(0, style);

PHP

// get table by name "MyTable"
$table = $project->Tables->get_Item("MyTable");
 
// create style
$style = new ZennoTableStyle;
$style->HorizontalAlignment = InterfacesLibrary::Enums::Table::ExcelStyle::HorizontalAlignment->Right;
$style->VerticalAlignment = InterfacesLibrary::Enums::Table::ExcelStyle::VerticalAlignment->Bottom;
$style->Font = new Font("Comic Sans MS", 20, FontStyle->Italic | FontStyle->Underline, GraphicsUnit->Point);
$style->FontColor = Color->Red;
style->SetBorder(InterfacesLibrary::Enums::Table::ExcelStyle::Borders->Right | InterfacesLibrary::Enums::Table::ExcelStyle::Borders->DiagonalUp, Color->Blue, InterfacesLibrary::Enums::Table::ExcelStyle::LineStyle->DashDot);
            
// set style
$table->SetRowStyle(0, $style);

Target Platforms: Desktop: Windows XP SP3 and older. Server: Windows Server 2003 and older.

Reference

IZennoTable Interface
IZennoTable Members
SetCellStyle Method
SetColumnStyle Method