c#控制台数据导出excel文件 (1)

using System;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using System.IO;

namespace exportExcel
{
    class program
    {
        static void Main()
        {
            TaxCal tc = new TaxCal(5000);
            tc.Print();
            tc.ExportExcel();
        }
    }
    class TaxCal
    {
        public TaxCal(double bill)
        {
            Bill = bill;
        }

        const double RATE = 0.18;
        public double Bill { get; private set; }
        public double Tip { get { return Bill * RATE; } }

        public void Print()
        {
            Console.WriteLine();
            Console.WriteLine($"账单总额:{Bill,10:c}");
            Console.WriteLine($"小费数额:{Tip,10:c}({RATE:p1})");
            Console.WriteLine("".PadRight(44, '-'));
            Console.WriteLine($"账单实付:{Bill + Tip,10:c}");
        }

        public void ExportExcel()
        {
            var fileName = @"H:EXceltxt.xls";//设置一个文件位置
            IWorkbook workbook;
            ISheet sheet;
            if (File.Exists(fileName))
            {
                using var sr = File.OpenRead(fileName);
                workbook = new HSSFWorkbook(sr);
                sheet = workbook.GetSheetAt(0);
            }
            else //如果文件不存在，创建并使用它
            {             
                workbook = new HSSFWorkbook();
                sheet = workbook.CreateSheet();
                //插入数据
                var headValues = new[] { "账单总额", "小费数额", "小费税率", "账单实付" };
                var head = sheet.CreateRow(0);
                for (int i = 0; i < headValues.Length; i++)
                {
                    head.CreateCell(i).SetCellValue(headValues[i]);
                }
            }
            var row1Values = new[] { Bill, Tip, RATE, Bill + Tip };
            var row1 = sheet.CreateRow(sheet.LastRowNum + 1);
            for (int i = 0; i < row1Values.Length; i++)
            {
                row1.CreateCell(i).SetCellValue(row1Values[i]);
            }
            using var sw = File.OpenWrite(fileName);
            workbook.Write(sw);

        }
    }

}

最后

以上就是典雅日记本最近收集整理的关于c#控制台数据导出excel文件 (1)的全部内容，更多相关c#控制台数据导出excel文件内容请搜索靠谱客的其他文章。