Common/export.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using System.Data;
using Aspose.Cells;
using System.Web;
using System.Drawing;

namespace ExportFile
{
    public class port
    {
        //导出操作
        public static Boolean export(List<export> list, String path)
        {
            try
            {
                if (list.Count > 0)
                {
                    Workbook wb = new Workbook();
                    int intSeet = 0;

                    #region "表格样式"
                    wb.Styles.Add();
                    wb.Styles[0].VerticalAlignment = TextAlignmentType.Center;
                    wb.Styles[0].HorizontalAlignment = TextAlignmentType.Center;
                    wb.Styles[0].Font.Color = ColorTranslator.FromHtml("#000000");
                    wb.Styles[0].Font.Size = 10;
                    wb.Styles[0].Font.Name = "宋体";
                    wb.Styles[0].Font.IsBold = true;
                    wb.Styles[0].Pattern = BackgroundType.Solid;
                    wb.Styles[0].ForegroundColor = ColorTranslator.FromHtml("#CCFFFF");
                    wb.Styles[0].Borders[BorderType.TopBorder].Color = Color.Black;
                    wb.Styles[0].Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
                    wb.Styles[0].Borders[BorderType.BottomBorder].Color = Color.Black;
                    wb.Styles[0].Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
                    wb.Styles[0].Borders[BorderType.LeftBorder].Color = Color.Black;
                    wb.Styles[0].Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
                    wb.Styles[0].Borders[BorderType.RightBorder].Color = Color.Black;
                    wb.Styles[0].Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
                    wb.Styles.Add();
                    wb.Styles[1].VerticalAlignment = TextAlignmentType.Center;
                    wb.Styles[1].HorizontalAlignment = TextAlignmentType.Center;
                    wb.Styles[1].Font.Color = ColorTranslator.FromHtml("#000000");
                    wb.Styles[1].Font.Size = 10;
                    wb.Styles[1].Font.Name = "宋体";
                    wb.Styles[1].ForegroundColor = Color.Yellow;
                    wb.Styles[1].Pattern = BackgroundType.Solid;
                    wb.Styles[1].Font.IsBold = false;
                    wb.Styles[1].Borders[BorderType.TopBorder].Color = Color.Black;
                    wb.Styles[1].Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
                    wb.Styles[1].Borders[BorderType.BottomBorder].Color = Color.Black;
                    wb.Styles[1].Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
                    wb.Styles[1].Borders[BorderType.LeftBorder].Color = Color.Black;
                    wb.Styles[1].Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
                    wb.Styles[1].Borders[BorderType.RightBorder].Color = Color.Black;
                    wb.Styles[1].Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
                    wb.Styles.Add();
                    wb.Styles[2].VerticalAlignment = TextAlignmentType.Center;