using Spire.Xls;

namespace SetNumberFormat
{
    class Program
    {
        static void Main(string[] args)
        {
            // 創(chuàng)建 Workbook 對象
            Workbook workbook = new Workbook();

            // 獲取第一張工作表
            Worksheet sheet = workbook.Worksheets[0];

            // 整數(shù)
            sheet.Range["A1"].NumberValue = 123;
            sheet.Range["A1"].NumberFormat = "00";

            // 千分隔
            sheet.Range["A2"].NumberValue = 1234.5678;
            sheet.Range["A2"].NumberFormat = "#,##0.00";

            // 百分比
            sheet.Range["A3"].NumberValue = 0.12345;
            sheet.Range["A3"].NumberFormat = "0.0%";

            // 帶文本的數(shù)字
            sheet.Range["A4"].NumberValue = 1234;
            sheet.Range["A4"].NumberFormat = ""數(shù)量： "0";

            // 貨幣格式
            sheet.Range["A5"].NumberValue = 1234.5678;
            sheet.Range["A5"].NumberFormat = "￥#,##0.00";

            // 科學計數(shù)法
            sheet.Range["A6"].NumberValue = 1234.5678;
            sheet.Range["A6"].NumberFormat = "0.00E+00";

            // 日期
            sheet.Range["A7"].NumberValue = 45930;
            sheet.Range["A7"].NumberFormat = "yyyy-MM-dd";

            // 時間
            sheet.Range["D13"].NumberValue = 0.5;
            sheet.Range["D13"].NumberFormat = "h:mm:ss AM/PM";

            // 保存結(jié)果
            workbook.SaveToFile("數(shù)字格式.xlsx", ExcelVersion.Version2016);
        }
    }
}