server/aspnetapp/Helper/exportExcel.cs

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

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

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;

namespace aspnetapp.Helper
{
    public class exportExcel
    {
        public static Stylesheet _stylesheet = new Stylesheet();
        public static int sheetNo = 0;
        public static List<cellstyle> cstyle = new List<cellstyle>();
        public static SpreadsheetDocument _doc { get; set; }
        public static MemoryStream _stream { get; set; }
        public static WorkbookPart _wbPart { get; set; }
        public static Workbook _wb { get; set; }
        public static Sheet _sheet { get; set; }
        public static Sheets _sheets { get; set; }
        public static WorksheetPart _worksheet1 { get; set; }
        public static SheetData _SheetData { get; set; }
        public static Worksheet _worksheet { get; set; }
        public exportExcel(int a)
        {
        }
        /// <summary>
        /// 自行书写样式,无模板
        /// </summary>
        public exportExcel()
        {
            _stream = new MemoryStream();
            _doc = SpreadsheetDocument.Create(_stream, SpreadsheetDocumentType.Workbook, true);
            _wbPart = _doc.AddWorkbookPart();
            _wbPart.Workbook = new Workbook();
            _worksheet1 = _wbPart.AddNewPart<WorksheetPart>();
            _worksheet1.Worksheet = new Worksheet(new SheetData());

            Sheets sheets = _doc.WorkbookPart.Workbook.AppendChild(new Sheets());
            Sheet sheet = new Sheet() { Id = _doc.WorkbookPart.GetIdOfPart(_worksheet1), SheetId = 1, Name = "Sheet1" };
            sheets.Append(sheet);
            _SheetData = _worksheet1.Worksheet.GetFirstChild<SheetData>();

            if (cstyle.Count() == 0)
            {
                _stylesheet.Fonts = new Fonts();
                _stylesheet.Borders = new Borders();
                _stylesheet.CellFormats = new CellFormats();

                cellstyle cs = new cellstyle();
                StyleIndex(cs);//初始化样式表将第一个cellformat初始化为初始样式
            }

            //写样式表
            WorkbookStylesPart stylepart = _doc.WorkbookPart.AddNewPart<WorkbookStylesPart>();
            stylepart.Stylesheet = new Stylesheet();
            stylepart.Stylesheet = SetStyle();
        }