Excel导入导出类

最新推荐文章于 2023-04-03 21:33:20 发布
最新推荐文章于 2023-04-03 21:33:20 发布
阅读量304 收藏
点赞数
分类专栏： C# 文章标签：  Excel导入导出类  Excel导出类  Excel导入类 NPOI类  Excel npoi
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wmingcsharp/article/details/102958744
版权 
/******************************************************************
**-----------------------------------------------------------------
** Copyright (c) 2014
** Name: 
** Version: 1.0
** Author:   ming
*  npoi: version 2.4.1.0
** Last Edit Time: 2019-11-07
** Remarks: Excel导入导出类
**-----------------------------------------------------------------
******************************************************************/


using NPOI.HPSF;
using NPOI.HSSF.UserModel;
using NPOI.HSSF.Util;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Reflection;

namespace Cmlabs
{
    public class ExcelNPOIHelper
    {
        int perSheetCount = 50000;//每个sheet要保存的条数
        public ExcelNPOIHelper()
        { }

        /// <summary>
        /// 最大接收5万条每页，大于5万时，使用系统默认的值(4万)
        /// </summary>
        /// <param name="perSheetCounts"></param>
        public ExcelNPOIHelper(int perSheetCounts)
        {
            if (perSheetCount <= 50000)
                perSheetCount = perSheetCounts;
        }

        private IFont GetFont(IWorkbook workbook, HSSFColor color)
        {
            IFont font = workbook.CreateFont();
            font.Color = color.Indexed;
            font.FontHeightInPoints = 10;
            font.Boldweight = 700;
            font.FontName = "宋体";
            font.IsItalic = false;
            return font;
        }

        private void SetCellValues(ICell cell, string cellType, string cellValue)
        {
            switch (cellType)
            {
                case "System.String": //字符串类型
                    cell.SetCellValue(cellValue);
                    break;
                case "System.DateTime": //日期类型
                    DateTime dateV;
                    DateTime.TryParse(cellValue, out dateV);
                    cell.SetCellValue(cellValue);
                    break;
                case "System.Boolean": //布尔型
                    bool boolV = false;
                    bool.TryParse(cellValue, out boolV);
                    cell.SetCellValue(boolV);
                    break;
                case "System.Int16": //整型
                case "System.Int32":
                case "System.Int64":
                case "System.Byte":
                    int intV = 0;
                    int.TryParse(cellValue, out intV);
                    cell.SetCellValue(intV);
                    break;
                case "System.Decimal": //浮点型
                case "System.Double":
                    double doubV = 0;
                    double.TryParse(cellValue, out doubV);
                    cell.SetCellValue(doubV);
                    break;
                case "System.DBNull": //空值处理
                    cell.SetCellValue("");
                    break;
                default:
                    cell.SetCellValue("");
                    break;
            }
        }

        private void SetProperty(HSSFWorkbook workbook)
        {
            DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
            dsi.Company = "";
            workbook.DocumentSummaryInformation = dsi;

            SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
            si.Author = "ming"; //填加xls文件作者信息
            si.ApplicationName = "ApplicationName"; //填加xls文件创建程序信息
            si.LastAuthor = "ming"; //填加xls文件最后保存者信息
            si.Comments = "ming"; //填加xls文件作者信息
            si.Title = "Excle"; //填加xls文件标题信息
            si.Subject = "Excle导出文件";//填加文件主题信息
            si.CreateDateTime = DateTime.Now;
            workbook.SummaryInformation = si;
        }

        private ICellStyle GetXlsStyle(HSSFWorkbook workbook)
        {
            //表头样式
            ICellStyle style = workbook.CreateCellStyle();
            style.Alignment = HorizontalAlignment.Center;
            HSSFColor.Green green = new HSSFColor.Green();
            style.SetFont(GetFont(workbook, green));
            return style;
            /*
            //内容样式
            style = workbook.CreateCellStyle();
            style.Alignment = HorizontalAlignment.Center;
            HSSFColor.Blue blue = new HSSFColor.Blue();
            style.SetFont(GetFont(workbook, blue));
            */
        }

        private ICellStyle GetXlsxStyle(XSSFWorkbook workbook)
        {
            //表头样式
            ICellStyle style = workbook.CreateCellStyle();
            style.Alignment = HorizontalAlignment.Center;
            HSSFColor.Green green = new HSSFColor.Green();
            style.SetFont(GetFont(workbook, green));
            return style;
        }

        /// <summary>
        /// 从IDataReader导出到excle(xls)文件
        /// </summary>
        /// <param name="excelFileName"></param>
        /// <param name="dtIn"></param>
        private void ExportToXlsFromReader(string excelFileName, IDataReader reader, bool isMultiSheet = true)
        {
            int sheetCount = 1;//当前的sheet数量
            int currentSheetCount = 0;//循环时当前保存的条数，每页都会清零
            HSSFWorkbook workbook = new HSSFWorkbook();
            SetProperty(workbook);
            ISheet sheet = workbook.CreateSheet("Sheet" + sheetCount.ToString());
            //填充表头
            ICell cell = null;
            IRow rowHeader = sheet.CreateRow(0);
            ICellStyle style = GetXlsStyle(workbook);
            for (int i = 0; i < reader.FieldCount; i++)
            {
                cell = rowHeader.CreateCell(i);
                cell.SetCellValue(reader.GetName(i));
                cell.CellStyle = style;
            }
            //填充内容
            IRow row = null;
            while (reader.Read())
            {
                if (isMultiSheet)
                {
                    if (currentSheetCount >= perSheetCount)
                    {
                        sheetCount++;
                        currentSheetCount = 0;
                        sheet = workbook.CreateSheet("Sheet" + sheetCount.ToString());
                        row = sheet.CreateRow(currentSheetCount);
                        for (int j = 0; j < rowHeader.Cells.Count; j++)
                        {
                            cell = row.CreateCell(j);
                            cell.SetCellValue(rowHeader.Cells[j].StringCellValue);
                            cell.CellStyle = style;
                        }
                    }
                }

                currentSheetCount++;
                try
                {
                    row = sheet.CreateRow(currentSheetCount);
                    for (int j = 0; j < reader.FieldCount; j++)
                    {
                        cell = row.CreateCell(j);
                        cell.CellStyle = style;
                        SetCellValues(cell, reader[j].GetType().ToString(), reader[j].ToString());
                    }
                }
                catch (ArgumentException ep)
                {
                    if (ep.Source == "NPOI" && ep.Message.Contains("Invalid row number"))
                    {
                        throw new Exception("65535");
                    }
                }
                catch
                { }
            }
            FileStream fs = new FileStream(excelFileName, FileMode.CreateNew, FileAccess.Write);
            workbook.Write(fs);
            fs.Close();
        }

        /// <summary>
        /// 从IDataReader导出到excle(xlsx)文件
        /// </summary>
        /// <param name="excelFileName"></param>
        /// <param name="dtIn"></param>
        private void ExportToXlsxFromReader(string excelFileName, IDataReader reader, bool isMultiSheet = true)
        {
            int sheetCount = 1;//当前的sheet数量
            int currentSheetCount = 0;//循环时当前保存的条数，每页都会清零
            XSSFWorkbook workbookx = new XSSFWorkbook();
            ISheet sheet = workbookx.CreateSheet("Sheet" + sheetCount.ToString());
            //填充表头
            ICell cell = null;
            IRow rowHeader = sheet.CreateRow(0);
            ICellStyle style = GetXlsxStyle(workbookx);
            for (int i = 0; i < reader.FieldCount; i++)
            {
                cell = rowHeader.CreateCell(i);
                cell.SetCellValue(reader.GetName(i));
                cell.CellStyle = style;
            }
            //填充内容
            IRow row = null;
            while (reader.Read())
            {
                if (isMultiSheet)
                {
                    if (currentSheetCount >= perSheetCount)
                    {
                        sheetCount++;
                        currentSheetCount = 0;
                        sheet = workbookx.CreateSheet("Sheet" + sheetCount.ToString());
                        //这种写法从第二页不要表头 上下互相注释就是
                        row = sheet.CreateRow(currentSheetCount);
                        for (int j = 0; j < rowHeader.Cells.Count; j++)
                        {
                            cell = row.CreateCell(j);
                            cell.SetCellValue(rowHeader.Cells[j].StringCellValue);
                            cell.CellStyle = style;
                        }
                    }
                }

                currentSheetCount++;
                row = sheet.CreateRow(currentSheetCount);
                for (int j = 0; j < reader.FieldCount; j++)
                {
                    cell = row.CreateCell(j);
                    cell.CellStyle = style;
                    SetCellValues(cell, reader[j].GetType().ToString(), reader[j].ToString());
                }
            }
            FileStream fs = new FileStream(excelFileName, FileMode.CreateNew, FileAccess.Write);
            workbookx.Write(fs);
            fs.Close();
        }

        /// <summary>
        /// 从DataTable导出到excle(xls)文件
        /// </summary>
        /// <param name="excelFileName"></param>
        /// <param name="dtIn"></param>
        private void ExportToXls(string excelFileName, DataTable dtIn, bool isMultiSheet = true)
        {
            int sheetCount = 1;//当前的sheet数量
            int currentSheetCount = 0;//循环时当前保存的条数，每页都会清零
            HSSFWorkbook workbook = new HSSFWorkbook();
            SetProperty(workbook);
            ISheet sheet = workbook.CreateSheet("Sheet" + sheetCount.ToString());
            //填充表头
            ICell cell = null;
            IRow rowHeader = sheet.CreateRow(0);
            ICellStyle style = GetXlsStyle(workbook);
            for (int i = 0; i < dtIn.Columns.Count; i++)
            {
                cell = rowHeader.CreateCell(i);
                cell.SetCellValue(dtIn.Columns[i].ColumnName);
                cell.CellStyle = style;
            }
            //填充内容
            IRow row = null;
            for (int i = 0; i < dtIn.Rows.Count; i++)
            {
                if (isMultiSheet)
                {
                    if (currentSheetCount >= perSheetCount)
                    {
                        sheetCount++;
                        currentSheetCount = 0;
                        sheet = workbook.CreateSheet("Sheet" + sheetCount.ToString());
                        row = sheet.CreateRow(currentSheetCount);
                        for (int j = 0; j < rowHeader.Cells.Count; j++)
                        {
                            cell = row.CreateCell(j);
                            cell.SetCellValue(rowHeader.Cells[j].StringCellValue);
                            cell.CellStyle = style;
                        }
                    }
                }

                currentSheetCount++;
                try
                {
                    row = sheet.CreateRow(currentSheetCount);
                    for (int j = 0; j < dtIn.Columns.Count; j++)
                    {
                        cell = row.CreateCell(j);
                        cell.CellStyle = style;
                        SetCellValues(cell, dtIn.Columns[j].DataType.ToString(), dtIn.Rows[i][j].ToString());
                    }
                }
                catch (ArgumentException ep)
                {
                    if (ep.Source == "NPOI" && ep.Message.Contains("Invalid row number"))
                    {
                        throw new Exception("65535");
                    }
                }
                catch
                { }
            }
            FileStream fs = new FileStream(excelFileName, FileMode.CreateNew, FileAccess.Write);
            workbook.Write(fs);
            fs.Close();
        }

        /// <summary>
        /// 从DataTable导出到excle(xlsx)文件
        /// </summary>
        /// <param name="excelFileName"></param>
        /// <param name="dtIn"></param>
        private void ExportToXlsx(string excelFileName, DataTable dtIn, bool isMultiSheet = true)
        {
            int sheetCount = 1;//当前的sheet数量
            int currentSheetCount = 0;//循环时当前保存的条数，每页都会清零
            XSSFWorkbook workbookx = new XSSFWorkbook();
            ISheet sheet = workbookx.CreateSheet("Sheet" + sheetCount.ToString());
            //填充表头
            ICell cell = null;
            IRow rowHeader = sheet.CreateRow(0);
            ICellStyle style = GetXlsxStyle(workbookx);
            for (int i = 0; i < dtIn.Columns.Count; i++)
            {
                cell = rowHeader.CreateCell(i);
                cell.SetCellValue(dtIn.Columns[i].ColumnName);
                cell.CellStyle = style;
            }
            //填充内容
            IRow row = null;
            for (int i = 0; i < dtIn.Rows.Count; i++)
            {
                if (isMultiSheet)
                {
                    if (currentSheetCount >= perSheetCount)
                    {
                        sheetCount++;
                        currentSheetCount = 0;
                        sheet = workbookx.CreateSheet("Sheet" + sheetCount.ToString());
                        //这种写法从第二页不要表头 上下互相注释就是
                        row = sheet.CreateRow(currentSheetCount);
                        for (int j = 0; j < rowHeader.Cells.Count; j++)
                        {
                            cell = row.CreateCell(j);
                            cell.SetCellValue(rowHeader.Cells[j].StringCellValue);
                            cell.CellStyle = style;
                        }
                    }
                }

                currentSheetCount++;
                row = sheet.CreateRow(currentSheetCount);
                for (int j = 0; j < dtIn.Columns.Count; j++)
                {
                    cell = row.CreateCell(j);
                    cell.CellStyle = style;
                    SetCellValues(cell, dtIn.Columns[j].DataType.ToString(), dtIn.Rows[i][j].ToString());
                }
            }
            FileStream fs = new FileStream(excelFileName, FileMode.CreateNew, FileAccess.Write);
            workbookx.Write(fs);
            fs.Close();
        }

        public DataTable Import(string fileName, string sheetName, bool hasheader)
        {
            FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);
            HSSFWorkbook workbook = new HSSFWorkbook(fs);
            fs.Close();
            sheetName = string.IsNullOrEmpty(sheetName) ? workbook.GetSheetName(0) : sheetName;
            HSSFSheet sheet = workbook.GetSheet(sheetName) as HSSFSheet;
            IEnumerator ie = sheet.GetRowEnumerator();

            HSSFRow row = null;
            while (ie.MoveNext())
            {
                row = ie.Current as HSSFRow;//取一行,为了得到column的总数
                break;
            }

            IList<string> lst = new List<string>();
            DataTable dt = new DataTable();
            if (hasheader)
            {
                for (int i = 0; i < row.LastCellNum; i++)
                {
                    if (!lst.Contains(row.Cells[i].StringCellValue))
                    {
                        dt.Columns.Add(row.Cells[i].StringCellValue);
                        lst.Add(row.Cells[i].StringCellValue);
                    }
                    else
                        dt.Columns.Add(row.Cells[i].StringCellValue + i.ToString());
                }
            }
            else
            {
                for (int i = 0; i < row.LastCellNum; i++)
                {
                    dt.Columns.Add("A" + i.ToString());
                }
                ie.Reset();
            }
            DataRow drow = null;
            HSSFCell cell = null;
            while (ie.MoveNext())
            {
                row = ie.Current as HSSFRow;
                drow = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    if (row.GetCell(i) == null)
                    {
                        drow[i] = null;
                        continue;
                    }
                    cell = row.GetCell(i) as HSSFCell;
                    switch (cell.CellType)
                    {
                        case CellType.Blank:
                            //drow[i] = "[null]";
                            drow[i] = "";
                            break;
                        case CellType.Boolean:
                            drow[i] = cell.BooleanCellValue;
                            break;
                        case CellType.Error:
                            drow[i] = cell.ErrorCellValue;
                            break;
                        case CellType.Formula:
                            //drow[i] = "=" + cell.CellFormula;
                            drow[i] = "=" + cell.NumericCellValue;
                            break;
                        case CellType.Numeric:
                            drow[i] = cell.NumericCellValue;
                            break;
                        case CellType.String:
                            drow[i] = cell.StringCellValue;
                            break;
                        case CellType.Unknown:
                            break;
                        default:
                            drow[i] = null;
                            break;
                    }
                }
                dt.Rows.Add(drow);
            }
            return dt;
        }

        public string Export(string excelFileName, DataTable dtIn, bool isMultiSheet = false)
        {
            if (Path.GetExtension(excelFileName).ToUpper() == ".XLSX")
            {
                ExportToXlsx(excelFileName, dtIn, isMultiSheet);
            }
            else
                ExportToXls(excelFileName, dtIn, isMultiSheet);
            return excelFileName;
        }

        public string Export(string excelFileName, IDataReader reader, bool isMultiSheet = false)
        {
            if (Path.GetExtension(excelFileName).ToUpper() == ".XLSX")
            {
                ExportToXlsxFromReader(excelFileName, reader, isMultiSheet);
            }
            else
                ExportToXlsFromReader(excelFileName, reader, isMultiSheet);
            return excelFileName;
        }

        public string Export<T>(string excelFileName, IList<T> lst)
        {
            int sheetCount = 1;//当前的sheet数量
            int currentSheetCount = 0;//循环时当前保存的条数，每页都会清零

            HSSFWorkbook workbook = new HSSFWorkbook();
            SetProperty(workbook);
            //表头样式
            ICellStyle style = workbook.CreateCellStyle();
            style.Alignment = HorizontalAlignment.Center;
            HSSFColor.Black green = new HSSFColor.Black();
            style.SetFont(GetFont(workbook, green));

            //内容样式
            //style = workbook.CreateCellStyle();
            //style.Alignment = HorizontalAlignment.Center;
            //HSSFColor.Blue blue = new HSSFColor.Blue();
            //style.SetFont(GetFont(workbook, blue));

            ISheet sheet = workbook.CreateSheet("Sheet" + sheetCount.ToString());

            ICell cell = null;
            //填充表头
            IRow rowHeader = sheet.CreateRow(0);
            PropertyInfo[] infos = lst[0].GetType().GetProperties();
            for (int i = 0; i < infos.Length; i++)
            {
                cell = rowHeader.CreateCell(i);
                cell.SetCellValue(infos[i].Name);
                cell.CellStyle = style;
            }
            string result = null;
            IRow row = null;
            foreach (T item in lst)
            {
                if (currentSheetCount >= perSheetCount)
                {
                    sheetCount++;
                    currentSheetCount = 0;
                    sheet = workbook.CreateSheet("Sheet" + sheetCount.ToString());
                    //这种写法从第二页不要表头 上下互相注释就是
                    row = sheet.CreateRow(currentSheetCount);
                    for (int j = 0; j < rowHeader.Cells.Count; j++)
                    {
                        cell = row.CreateCell(j);
                        cell.SetCellValue(rowHeader.Cells[j].StringCellValue);
                        cell.CellStyle = style;
                    }
                }
                //if (sheetCount == 1)//因为第一页有表头，所以从第二页开始写
                //    row = sheet.CreateRow(currentSheetCount + 1);
                //else//以后没有表头了，所以从开始写，都是基于0的
                //    row = sheet.CreateRow(currentSheetCount);
                currentSheetCount++;
                for (int j = 0; j < infos.Length; j++)
                {
                    cell = row.CreateCell(j);
                    cell.CellStyle = style;
                    result = infos[j].GetValue(item, null) != null ? infos[j].GetValue(item, null).ToString() : "";
                    SetCellValues(cell, infos[j].PropertyType.FullName, result);
                }
            }
            FileStream fs = new FileStream(excelFileName, FileMode.CreateNew, FileAccess.Write);
            workbook.Write(fs);
            fs.Close();
            return excelFileName;
        }
    }
}

 

mingcsharp
关注
专栏目录
C#通用Excel导入导出工具类
03-31
本篇文章将深入探讨“C#通用Excel导入导出工具类”的实现原理及应用，主要涉及的技术点包括反射、特性以及如何创建一个高效的Excel导入导出解决方案。 首先，我们要理解反射在C#中的作用。反射是一种强大的机制，它...
XSSFWorkbook对象的write方法内会将传入的资源流自动关闭 导致下载excel失败
yangmengcsdn的博客
08-25 2094
解决方法: 将XSSFWorkbook转换成ByteArrayOutputStream，用ByteArrayOutputStream对象将流写入zip对象中。
DocummentSummaryInformation和SummaryInformation类的信息
huangyushi的专栏
12-06 4817
NPOI学习B篇(NPOI 如何创建Excel文件摘要信息(DocummentSummaryInformation和SummaryInformation类的信息) ▲Step by Step:    △首先引用以下这些命名空间：     using　NPOI.HSSF.UserModel;     using　NPOI.HPSF;     using　NPOI.POIFS
Apache POI 操作Excel常用方法
最新发布
weixin_49832841的博客
04-03 4792
Apache POI是一个流行的API，允许程序员使用Java程序创建，修改和显示MS Office文件。它是由Apache软件基金会开发和分发的开源库，用于使用Java程序设计或修改Microsoft Office文件。
NPOI操作EXCEL
dominates的专栏
10-14 1520
组件及文档下载地址：http://download.csdn.net/detail/dominates/6383597
Excel的导入&导出
weixin_57397512的博客
10-23 205
Excel的介绍 Excel分为两个版本03和07 03版最多只能存储65536条数据 07版没有限制 导入导出Excel的技术 org.apache.poi （Apache） EasyExcel (阿里巴巴) POI导出Excel Workbook workbook = new HSSFWorkbook(); 针对03版 先把数据一次性写入内存，再一次性写入Excel中。 速度很快，但最多只能写入65536行数据 Workbook workbook = new XSSFWorkb
Excel导入导出
03-28
在提供的压缩包文件中，可能包含已经封装好的方法和DLL，这些预封装的方法简化了Excel导入导出的过程，使得开发者可以直接调用，而无需关心底层的实现细节。这通常会提高开发效率，减少错误，并且便于代码维护。 ...
php excel导入导出类
05-10
在PHP开发中，处理Excel文件是一项常见的任务，无论是导入数据到数据库、导出报表还是进行数据分析，PHPExcel库都提供了一种强大而灵活的方式。PHPExcel是一个开源的PHP类库，它允许开发者读取和写入多种不同的Excel...
Excel导入导出工具类
10-20
Excel导入导出工具类，基于POI实现；紧密结合实体类，导入功能返回List，方便MyBatis批量导入。导出功能自带下载功能。
C# winform Excel导入导出类
04-24
C# winform Excel导入导出类，可以导出Excel,可以导入excel。支持07以上或以下版本，需要引用com组件里的microsoft excel，不需要安装其他插件。
Winform中通过NPOI导出Excel的三种方式HSSFWorkbook，XSSFWorkbook，SXSSFWorkbook示例代码.zip
05-29
Winform中通过NPOI导出Excel的三种方式HSSFWorkbook，XSSFWorkbook，SXSSFWorkbook示例代码
java：excel文件读写二、poi写xls和xlsx
a232884c的博客
03-16 2419
java:excel文件读写二、poi实践 1.前言 apache poi官网：https://poi.apache.org/ 在讲解组件api时，提到了EXCEL（HSSF，XSSF）中，如何同时兼容写入xls和xlsx文件的使用，地址如下： https://poi.apache.org/components/spreadsheet/converting.html 官方指明更新到poi的3.5版本，可以用一种兼容的方式操作xls和xlsx，依赖配置如下： <!-- xls --> &l
使用POI操作Excel时new XSSFWorkbook ()报错java.lang.NoSuchMethodError解决方案
dianti5444的博客
07-15 1184
使用最新的POI3.11时，在运行 Workbook workBook = new XSSFWorkbook ();这段代码时出现错误： java.lang.NoSuchMethodError: javax.xml.stream.XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory; at org...
java poi excel导入导出execl表
qq_44905786的博客
07-07 155
java poi excel导入导出execl表 import java.math.BigDecimal; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Iterator; import java.util.Map; import org.apache.poi.hpsf.SummaryInformation; import org.apache.poi.hssf.usermodel.HSSFCell;
使用POI操作Excel时new XSSFWorkbook ()报错
热门推荐
javanewnewman的博客
08-08 2万+
Workbook wb = null; Sheet sheet = null; //temp1 根据后缀判断是xls/xlsx if (suffixName.endsWith("xls")) { wb = new HSSFWorkbook(input); } else if (suffixName.endsWith("xlsx")) { wb = new XSSFWorkbook...
C# HSSFWorkbook与XSSFWorkbook的区别和.xls和.xlsx的区别
mxw_133的博客
04-13 1万+
.xls和.xlsx的区别1、.xls是2003版Office Microsoft Office Excel 工作表的格式，用03版Office，新建Excel默认保存的Excel文件格式的后缀是.xls；2、.xlsx是2007版Office Microsoft Office Excel 工作表的格式，用07版Office，新建Excel默认保存的的Excel文件格式后缀是.xlsx。3、07版...
NPOI-Excel系列-1002.创建带有Document Summary Information和Summary Information的Excel文件
weixin_30902675的博客
04-28 746
1. 1 using NPOI.HSSF.UserModel; 2 using NPOI.HPSF; 3 using NPOI.POIFS.FileSystem; 4 using Microsoft.VisualStudio.TestTools.UnitTesting; 5 using System.IO; 6 using System; 7 namespace N...
POI生成的excel的文件属性
xspacing的博客
09-22 1318
使用POI为生成的excel添加文件属性
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值