C# Aspose.Cells 如何设置单元格样式

//Instantiating a Workbook object

Workbook workbook = new Workbook();

//Adding a new worksheet to the Workbook object

int i = workbook.Worksheets.Add();

//Obtaining the reference of the newly added worksheet by passing its sheet index

Worksheet worksheet = workbook.Worksheets[i];

//Adding the current system date to "A1" cell

worksheet.Cells["A1"].PutValue(DateTime.Now);

//Getting the Style of the A1 Cell

Style style = worksheet.Cells["A1"].GetStyle();

//Setting the display format to number 15 to show date as "d-mmm-yy"

style.Number = ;

//Applying the style to the A1 cell

worksheet.Cells["A1"].SetStyle(style);

//Adding a numeric value to "A2" cell

worksheet.Cells["A2"].PutValue();

//Getting the Style of the A2 Cell

style = worksheet.Cells["A2"].GetStyle();

//Setting the display format to number 9 to show value as percentage

style.Number = ;

//Applying the style to the A2 cell

worksheet.Cells["A2"].SetStyle(style);

//Adding a numeric value to "A3" cell

worksheet.Cells["A3"].PutValue();

//Getting the Style of the A3 Cell

style = worksheet.Cells["A3"].GetStyle();

//Setting the display format to number 6 to show value as currency

style.Number = ;

//Applying the style to the A3 cell

worksheet.Cells["A3"].SetStyle(style);

//Saving the Excel file

workbook.Save("C:\\book1.xls", SaveFormat.Excel97To2003);

当然开发人员还可以为单元格设置自定义显示样式，下面的代码就怎么设置单元格自定义显示样式做举例：

//Instantiating a Workbook object

Workbook workbook = new Workbook();

//Adding a new worksheet to the Excel object

int i = workbook.Worksheets.Add();

//Obtaining the reference of the newly added worksheet by passing its sheet index

Worksheet worksheet = workbook.Worksheets[i];

//Adding the current system date to "A1" cell

worksheet.Cells["A1"].PutValue(DateTime.Now);

//Getting the style of A1 cell

Style style = worksheet.Cells["A1"].GetStyle();

//Setting the custom display format to show date as "d-mmm-yy"

style.Custom = "d-mmm-yy";

//Applying the style to A1 cell

worksheet.Cells["A1"].SetStyle(style);

//Adding a numeric value to "A2" cell

worksheet.Cells["A2"].PutValue();

//Getting the style of A2 cell

style = worksheet.Cells["A2"].GetStyle();

//Setting the custom display format to show value as percentage

style.Custom = "0.0%";

//Applying the style to A2 cell

worksheet.Cells["A2"].SetStyle(style);

//Adding a numeric value to "A3" cell

worksheet.Cells["A3"].PutValue();

//Getting the style of A3 cell

style = worksheet.Cells["A3"].GetStyle();

//Setting the custom display format to show value as currency

style.Custom = "£#,##0;[Red]$-#,##0";

//Applying the style to A3 cell

worksheet.Cells["A3"].SetStyle(style);

//Saving the Excel file

workbook.Save("C:\\book1.xls", SaveFormat.Excel97To2003);

C# Aspose.Cells 如何设置单元格样式的相关教程结束。