这篇博客介绍了如何在Java和C#中使用Aspose.Cells库来设置Excel单元格的样式，包括日期、百分比和货币格式。通过创建Workbook对象，添加工作表，然后设置单元格的值和样式，可以实现自定义显示格式。最后，保存文件到指定路径。
//Instantiating a Workbook object
Workbook workbook = newWorkbook();//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
最低0.47元/天 解锁文章
扫一扫
664
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
