Tools/ExcelExport.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using NPOI.HSSF.UserModel;
using NPOI.SS.Util;
using NPOI.SS.Converter;
using NPOI.XSSF.Util;
using System.Drawing;
using AgingTest.DataProcess;
using System.IO;

namespace AgingTest.Tools
{
    public class ExcelExport
    {

        public XSSFWorkbook EstUserExport(TestData tempData, string Name)
        {

            string temp = "";
            int currRow = 0;
            int tempRow = 0;
            double temp1 = 0;
            int i1 = 0;
            string fileName = "土建核价单 " + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ff");
            //创建07版Excel文件对象
            XSSFWorkbook book = new XSSFWorkbook();
            ISheet sheet1 = book.CreateSheet("汇总表");
            ISheet sheet2 = book.CreateSheet("上电检测");
            ISheet sheet3 = book.CreateSheet("寻找电机零位");
            ISheet sheet4 = book.CreateSheet("点动测试测试");
            ISheet sheet5 = book.CreateSheet("前置工况测试");
            ISheet sheet6 = book.CreateSheet("外特性测试");
            ISheet sheet7 = book.CreateSheet("速度精度测试");
            ISheet sheet8 = book.CreateSheet("位置精度测试");
            ISheet sheet9 = book.CreateSheet("特定工况测试");


            XSSFCellStyle fCellStyle = (XSSFCellStyle)book.CreateCellStyle();
            XSSFFont ffont = (XSSFFont)book.CreateFont();
            ffont.FontHeight = 220;
            ffont.FontName = "宋体";
            ffont.Color = new XSSFColor(Color.Black).Indexed;
            fCellStyle.SetFont(ffont);
            fCellStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;//垂直对齐
            fCellStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;//水平对齐
            //IDataFormat format = book.CreateDataFormat();
            //fCellStyle.DataFormat = format.GetFormat("#,##0.00 ");//这是设置为3位数货币样式,#表示空位保留
            fCellStyle.BorderLeft = BorderStyle.Thin;
            fCellStyle.BorderRight = BorderStyle.Thin;
            fCellStyle.BorderTop = BorderStyle.Thin;
            fCellStyle.BorderBottom = BorderStyle.Thin;

            //汇总表部分      
            sheet1.SetColumnWidth(0, 5000);
            sheet1.SetColumnWidth(1, 5000);