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 = 15; //Applying the style to the A1 cell worksheet.Cells["A1"].SetStyle(style); //Adding a numeric value to "A2" cell worksheet.Cells["A2"].PutValue(20); //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 = 9; //Applying the style to the A2 cell worksheet.Cells["A2"].SetStyle(style); //Adding a numeric value to "A3" cell worksheet.Cells["A3"].PutValue(2546); //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 = 6; //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(20); //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(2546); //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);
!!!转发请注明出处和作者名称。
!!!转发请注明出处和作者名称。
!!!转发请注明出处和作者名称。
重要的事,说三遍。