Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Style Worksheet

Francois Botha edited this pageFeb 26, 2018 ·3 revisions

StyleWorksheet.jpg

varworkbook=newXLWorkbook();varws=workbook.Worksheets.Add("Style Worksheet");ws.Style.Font.Bold=true;ws.Style.Font.FontColor=XLColor.Red;ws.Style.Fill.BackgroundColor=XLColor.Cyan;// The following cells will be bold and red// because we've specified those attributes to the entire worksheetws.Cell(1,1).Value="Test";ws.Cell(1,2).Value="Case";// Here we'll change the style of a single cellws.Cell(2,1).Value="Default";ws.Cell(2,1).Style=XLWorkbook.DefaultStyle;// Let's play with some rowsws.Row(4).Style=XLWorkbook.DefaultStyle;ws.Row(4).Height=20;ws.Rows(5,6).Style=XLWorkbook.DefaultStyle;ws.Rows(5,6).Height=20;// Let's play with some columnsws.Column(4).Style=XLWorkbook.DefaultStyle;ws.Column(4).Width=5;ws.Columns(5,6).Style=XLWorkbook.DefaultStyle;ws.Columns(5,6).Width=5;workbook.SaveAs("StyleWorksheet.xlsx");

FAQ

Examples

Real world scenarios

Time Savers

Performance and Memory

Misc

Inserting Data/Tables

Styles

Ranges

Rows

Columns

Page Setup (Print Options)

AutoFilters

Comments

Dev docs

Clone this wiki locally


[8]ページ先頭

©2009-2025 Movatter.jp