4,816
社区成员
发帖
与我相关
我的任务
分享
using Spire.Xls;
namespace NumberFormat_XLS
{
class Program
{
static void Main(string[] args)
{
//创建Workbook对象
Workbook workbook = new Workbook();
//获取工作表
Worksheet sheet = workbook.Worksheets[0];
//指定单元格数据
CellRange cell1 = sheet.Range["A1"];
CellRange cell2 = sheet.Range["B1"];
CellRange cellNum = sheet.Range["A2"];
cell1.Value2 = 4;
cell2.Value2 = 3;
//应用公式并设置数据格式
cellNum.Formula = "=A1/B1";
sheet.Range["A2"].NumberFormat = ".00%";
//保存文档
workbook.SaveToFile("output.xlsx", ExcelVersion.Version2013);
System.Diagnostics.Process.Start("output.xlsx");
}
}
}