C# 导出 EXecl ，导出word，word转PDF

最新推荐文章于 2023-08-11 17:27:04 发布
最新推荐文章于 2023-08-11 17:27:04 发布
阅读量1k 收藏
点赞数
分类专栏： 实例
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/q_17600689511/article/details/92796327
版权 
	Aspose 这个插件导出的Execl 被标记了
	评估版权警告
	版权所有2003年至2019年aspose有限公司
	using Aspose.Words;//插件
	using NPOI.HSSF.UserModel;
	using NPOI.SS.Util;
	using NPOI.HPSF;导出Execl
	#region word 转pdf
    /// <summary>
    /// 
    /// </summary>
    /// <param name="filePath">word路径 </param>
    /// <param name="gzdWordpdf">pdf路径</param>
    /// <returns></returns>
   
    private byte[] ConvertWordToPDF(string filePath, string gzdWordpdf)
    {
        var stream = new MemoryStream();

        Aspose.Words.Document doc = new Aspose.Words.Document(filePath);
        doc.Save(stream, Aspose.Words.SaveFormat.Pdf);
        byte[] buffer = null;
        if (stream != null)
        {
            saveTofle(stream, gzdWordpdf);
            stream.Close();
        }
        return buffer;
    }
    #endregion

  1. #region 导出意见告知单
    private string HandleGuaranteeDoc(string rowguid)
    {
    string xmCode = “”;
    string xmName = “”;
    string tempFile = Path.GetFullPath(HttpRuntime.AppDomainAppPath.ToString() + @“FileManager\吉林省工程建设项目协同服务告知单.dot”).ToString(); //获取模板路 径，这个根据个人模板路径而定。
    Document doc = new Document(tempFile);
    DocumentBuilder builder = new DocumentBuilder(doc); //操作word

        //写入项目基本信息
    string sql = "select OPNUMGATHER,PROJECTNAME,JSDW,LANDNATURE,BUILTAREA,LANDAREA,RTCOORDX,LBCOORDX,LBCOORDY,RTCOORDY,XMYWLX from gsa_base_project where row_guid='" + rowguid + "'";
    DataTable dtXM = DataService.SystemDatabase.GetDataTable(sql);
    xmCode = dtXM.Rows[0]["OPNUMGATHER"].ToString();
    xmName = dtXM.Rows[0]["PROJECTNAME"].ToString();

    builder.MoveToBookmark("OPNUMGATHER");  //项目协同编码
    builder.Write(dtXM.Rows[0]["OPNUMGATHER"].ToString());
    builder.MoveToBookmark("PROJECTNAME");  //项目名称
    builder.Write(dtXM.Rows[0]["PROJECTNAME"].ToString());
    builder.MoveToBookmark("JSDW");  //建设单位
    builder.Write(dtXM.Rows[0]["JSDW"].ToString());
    builder.MoveToBookmark("LANDNATURE");  //项目属性用地性质
    builder.Write(dtXM.Rows[0]["LANDNATURE"].ToString());
    builder.MoveToBookmark("BUILTAREA");  //建筑面积
    builder.Write(dtXM.Rows[0]["BUILTAREA"].ToString());
    builder.MoveToBookmark("LANDAREA");  //用地规模
    builder.Write(dtXM.Rows[0]["LANDAREA"].ToString());
    builder.MoveToBookmark("RTCOORDX");  //东至
    builder.Write(dtXM.Rows[0]["RTCOORDX"].ToString());
    builder.MoveToBookmark("LBCOORDX");  //西至
    builder.Write(dtXM.Rows[0]["LBCOORDX"].ToString());
    builder.MoveToBookmark("LBCOORDY");  //南至
    builder.Write(dtXM.Rows[0]["LBCOORDY"].ToString());
    builder.MoveToBookmark("RTCOORDY");  //北至
    builder.Write(dtXM.Rows[0]["RTCOORDY"].ToString());

    builder.MoveToBookmark("OPTYPENAME");  //办理流程
    builder.Write(dtXM.Rows[0]["XMYWLX"].ToString());

    //写入意见
    sql = "select dqbm ,xtbmopinion from gsa_opiniontable t,gsa_base_project g  where  g.row_guid=t.xmguid and xmguid='" + rowguid + "'";
    DataTable dtYJ = DataService.SystemDatabase.GetDataTable(sql);

    for (int i = 0; i < dtYJ.Rows.Count; i++)
    {
        switch (dtYJ.Rows[i]["dqbm"].ToString())
        {
            case "自然资源部门":
                builder.MoveToBookmark("ZRZYOPINION");
                builder.Write(dtYJ.Rows[i]["xtbmopinion"].ToString());
                break;
            case "发改部门":
                builder.MoveToBookmark("FGBM");
                builder.Write(dtYJ.Rows[i]["xtbmopinion"].ToString());
                break;
            case "住建部门":
                builder.MoveToBookmark("JSBMYJ");
                builder.Write(dtYJ.Rows[i]["xtbmopinion"].ToString());
                break;
            case "生态部门":
                builder.MoveToBookmark("STHJBMYJ");
                builder.Write(dtYJ.Rows[i]["xtbmopinion"].ToString());
                break;
        }
    }
    #region 写入事项
    string sqlsx = "select t.*,a.TEMP_STAGE,a.MATTERNAME  from app_relationtable t,app_model_matter a where t.matterguid in(select matterguid from  app_model_matter  ) and  xmguid='" + rowguid + "' and  a.matterguid=t.matterguid";
    DataTable dtsx = DataService.SystemDatabase.GetDataTable(sqlsx);
    SXword(builder, dtsx);
    #endregion

    string dateStr = DateTime.Now.ToString("yyyy-MM");
    string pathDir = Path.Combine(OpenWebGIS.LiquidGIS.Common.Helper.PathHelper.FileManagerPath, "GZDFiles", dateStr);
    if (!System.IO.Directory.Exists(pathDir))
        System.IO.Directory.CreateDirectory(pathDir);
    //新建告知单文件
    string gzdWordpath = Path.Combine(pathDir, xmCode + xmName + ".doc");
    string gzdWordpdf = Path.Combine(pathDir, xmCode + xmName + ".pdf");
    if (System.IO.File.Exists(gzdWordpath))
        System.IO.File.Delete(gzdWordpath);
    string httppatch = "/FileManager/GZDFiles/" + dateStr + @"/" + xmCode + xmName + ".pdf"; //"http://" + host + ":" + Port + "/FileManager/" + dateStr + "/" + FileName;
    string insertsql = "update GSA_BASE_PROJECT  set GZDPATH='" + httppatch + "' where  row_guid='" + rowguid + "'";
    int kk = DataService.SystemDatabase.ExecuteNonQuery(insertsql);
    if (false == System.IO.Directory.Exists(pathDir))
    {
        //创建pic文件夹
        System.IO.Directory.CreateDirectory(pathDir);
    }

    doc.Save(gzdWordpath); //保存word
    //转换pdf
    ConvertWordToPDF(gzdWordpath, gzdWordpdf);
    return httppatch;
}
#endregion
	#region 从datatable中将数据导出到excel

    ///
    /// DataTable导出到Excel的MemoryStream
    ///
    /// 源DataTable
    /// 表头文本
    static MemoryStream ExportDT(DataTable dtSource, string strHeaderText)
    {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.CreateSheet() as HSSFSheet;

        #region 右击文件 属性信息
    {
        DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
        dsi.Company = "http://www.openwebgis.com/";
        workbook.DocumentSummaryInformation = dsi;

        SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
        si.Author = "OPENWEBGIS"; //填加xls文件作者信息
        si.ApplicationName = "OPENWEBGIS EXCEL EXPORT"; //填加xls文件创建程序信息
        si.LastAuthor = "LIQUIDGIS"; //填加xls文件最后保存者信息
        si.Comments = "版权所有 (C) 2007-2013 OpenWebGIS  All Rights Reserved "; //填加xls文件作者信息
        si.Title = "OPENWEBGIS EXCEL 文件导出"; //填加xls文件标题信息
        si.Subject = "OPENWEBGIS EXCEL"; //填加文件主题信息
        si.CreateDateTime = DateTime.Now;
        workbook.SummaryInformation = si;
    }

    #endregion

    HSSFCellStyle dateStyle = workbook.CreateCellStyle() as HSSFCellStyle;
    HSSFDataFormat format = workbook.CreateDataFormat() as HSSFDataFormat;
    dateStyle.DataFormat = format.GetFormat("yyyy-mm-dd");

    //取得列宽
    int[] arrColWidth = new int[dtSource.Columns.Count];
    foreach (DataColumn item in dtSource.Columns)
    {
        string caption = item.Caption;
        if (string.IsNullOrEmpty(caption)) caption = item.ColumnName;
        arrColWidth[item.Ordinal] = Encoding.GetEncoding(936).GetBytes(caption).Length;
    }
    for (int i = 0; i < dtSource.Rows.Count; i++)
    {
        for (int j = 0; j < dtSource.Columns.Count; j++)
        {
            int intTemp = Encoding.GetEncoding(936).GetBytes(dtSource.Rows[i][j].ToString()).Length;
            if (intTemp > arrColWidth[j])
            {
                arrColWidth[j] = intTemp;
                if (arrColWidth[j] > 250) arrColWidth[j] = 250;//The maximum column width for an individual cell is 255 characters
            }
        }
    }
    int rowIndex = 0;

    foreach (DataRow row in dtSource.Rows)
    {
        #region 新建表，填充表头，填充列头，样式

        if (rowIndex == 65535 || rowIndex == 0)
        {
            if (rowIndex != 0)
            {
                sheet = workbook.CreateSheet() as HSSFSheet;
            }
            #region 表头及样式
            {
                HSSFRow headerRow = sheet.CreateRow(0) as HSSFRow;
                headerRow.HeightInPoints = 25;
                headerRow.CreateCell(0).SetCellValue(strHeaderText);

                HSSFCellStyle headStyle = workbook.CreateCellStyle() as HSSFCellStyle;
                headStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.CENTER;
                HSSFFont font = workbook.CreateFont() as HSSFFont;
                font.FontHeightInPoints = 20;
                font.Boldweight = 700;
                headStyle.SetFont(font);

                headerRow.GetCell(0).CellStyle = headStyle;

                sheet.AddMergedRegion(new Region(0, 0, 0, dtSource.Columns.Count - 1));
                //headerRow.Dispose();
            }

            #endregion


            #region 列头及样式

            {
                HSSFRow headerRow = sheet.CreateRow(1) as HSSFRow;


                HSSFCellStyle headStyle = workbook.CreateCellStyle() as HSSFCellStyle;
                headStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.CENTER;
                HSSFFont font = workbook.CreateFont() as HSSFFont;
                font.FontHeightInPoints = 10;
                font.Boldweight = 700;
                headStyle.SetFont(font);


                foreach (DataColumn column in dtSource.Columns)
                {

                    string ColumnName = GetColnumnName(column.ColumnName);
                    string caption = column.Caption;
                    if (string.IsNullOrEmpty(ColumnName)) caption = column.ColumnName;
                    else
                        caption = ColumnName;
                    headerRow.CreateCell(column.Ordinal).SetCellValue(caption);
                    headerRow.GetCell(column.Ordinal).CellStyle = headStyle;

                    //设置列宽
                    sheet.SetColumnWidth(column.Ordinal, (arrColWidth[column.Ordinal] + 1) * 256);

                }

                //headerRow.Dispose();

            }

            #endregion

            rowIndex = 2;

        }

        #endregion

        #region 填充内容

        HSSFRow dataRow = sheet.CreateRow(rowIndex) as HSSFRow;
        foreach (DataColumn column in dtSource.Columns)
        {
            HSSFCell newCell = dataRow.CreateCell(column.Ordinal) as HSSFCell;

            string drValue = row[column].ToString();

            switch (column.DataType.ToString())
            {
                case "System.String": //字符串类型
                    double result;
                    if (isNumeric(drValue, out result))
                    {

                        double.TryParse(drValue, out result);
                        newCell.SetCellValue(result);
                        break;
                    }
                    else
                    {
                        newCell.SetCellValue(drValue);
                        break;
                    }

                case "System.DateTime": //日期类型
                    DateTime dateV;
                    DateTime.TryParse(drValue, out dateV);
                    newCell.SetCellValue(dateV);

                    newCell.CellStyle = dateStyle; //格式化显示
                    break;
                case "System.Boolean": //布尔型
                    bool boolV = false;
                    bool.TryParse(drValue, out boolV);
                    newCell.SetCellValue(boolV);
                    break;
                case "System.Int16": //整型
                case "System.Int32":
                case "System.Int64":
                case "System.Byte":
                    int intV = 0;
                    int.TryParse(drValue, out intV);
                    newCell.SetCellValue(intV);
                    break;
                case "System.Decimal": //浮点型
                case "System.Double":
                    double doubV = 0;
                    double.TryParse(drValue, out doubV);
                    newCell.SetCellValue(doubV);
                    break;
                case "System.DBNull": //空值处理
                    newCell.SetCellValue("");
                    break;
                default:
                    newCell.SetCellValue("");
                    break;
            }

        }

        #endregion

        rowIndex++;
    }
    using (MemoryStream ms = new MemoryStream())
    {
        workbook.Write(ms);
        ms.Flush();
        ms.Position = 0;

        //sheet;
        //workbook.Dispose();

        return ms;
    }
}

#retion word 动态表格
public string SXYD(DocumentBuilder builder, string demp, string rowguid)
{
string sqlsx = “select t.*,a.TEMP_STAGE,a.MATTERNAME from app_relationtable t,app_model_matter a where t.matterguid in(select matterguid from app_model_matter ) and xmguid=’” + rowguid + “’ and a.matterguid=t.matterguid and t.bmmc=’” + demp + “’ and ( t.jsyd != ‘’ or t.SPYD !=’’)”;
DataTable dtsx = DataService.SystemDatabase.GetDataTable(sqlsx);
//设置各单元格的宽度
int w1 = 10;
int w2 = 50;
if (dtsx.Rows.Count > 0)
{

            //开始插入表格
            builder.StartTable();


            //设置基本格式
            builder.RowFormat.Borders.LineStyle = LineStyle.Thick;
            builder.RowFormat.HeightRule = HeightRule.Exactly;
            builder.RowFormat.Alignment = RowAlignment.Center;
            builder.CellFormat.FitText = true;
            //开始插入表格
            Table table = builder.StartTable();
            builder.CellFormat.VerticalAlignment = CellVerticalAlignment.Center;//垂直居中对齐
            builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;//水平居中对齐
            //builder.RowFormat.Height = 30 * dtsx.Rows.Count;//设置此行高度
            for (int i = 0; i < dtsx.Rows.Count; i++)
            {
                //开始插入第一行表头
                builder.InsertCell();
                builder.CellFormat.VerticalMerge = CellMerge.Previous;
                builder.CellFormat.HorizontalMerge = CellMerge.None;
                builder.CellFormat.Width = 1;
                builder.Writeln("建\n设\n要\n点\n和\n审\n批\n要\n点\n");
                builder.CellFormat.Width = 25;
                builder.InsertCell();
                builder.CellFormat.VerticalMerge = CellMerge.Previous;
                builder.CellFormat.HorizontalMerge = CellMerge.None;
                builder.CellFormat.Width = w1;
                builder.Writeln(dtsx.Rows[i]["BMMC"].ToString());
                builder.CellFormat.Width = 74;
                builder.InsertCell();
                builder.CellFormat.HorizontalMerge = CellMerge.Previous;
                builder.CellFormat.VerticalMerge = CellMerge.None;
                builder.CellFormat.Width = w2;
                builder.Writeln(dtsx.Rows[i]["MATTERNAME"].ToString() + ControlChar.LineBreak);
                builder.CellFormat.Width = 67;
                builder.InsertCell();
                builder.CellFormat.HorizontalMerge = CellMerge.None;
                builder.CellFormat.VerticalMerge = CellMerge.None;
                builder.CellFormat.Width = w2;
                builder.Writeln(dtsx.Rows[i]["JSYD"].ToString());
                builder.CellFormat.Width = 175;
                builder.InsertCell();
                builder.CellFormat.HorizontalMerge = CellMerge.None;
                builder.CellFormat.VerticalMerge = CellMerge.None;
                builder.CellFormat.Width = w2;
                builder.Writeln(dtsx.Rows[i]["SPYD"].ToString());
                builder.CellFormat.Width = 180;
                第三行 行头
                builder.RowFormat.Alignment = RowAlignment.Center;
                builder.EndRow();
            }
            table.AllowAutoFit = false;
            table.AutoFit(AutoFitBehavior.FixedColumnWidths);
            //table.AllowAutoFit = false;
            builder.EndTable();
        }

        return "";
    }

#endregion
///
/// DataTable导出到Excel文件
///
/// 源DataTable
/// 表头文本
/// 保存位置
public static void ExportDTtoExcel(DataTable dtSource, string strHeaderText, string strFileName)
{
using (MemoryStream ms = ExportDT(dtSource, strHeaderText))
{
using (FileStream fs = new FileStream(strFileName, FileMode.Create, FileAccess.Write))
{
byte[] data = ms.ToArray();
fs.Write(data, 0, data.Length);
fs.Flush();
}
}
}
public static bool isNumeric(String message, out double result)
{
Regex rex = new Regex(@"1?\d+[.]?\d*$");
result = -1;
if (rex.IsMatch(message))
{
result = double.Parse(message);
return true;
}
else
return false;

    }

  1. - ↩︎

能不写代码嘛
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
C# NPOI导出Excel，Words转PDF
01-17
C# NPOI导出Excel，Words转PDF，无水印Aspose.Words，Words模版导出PDF
C#将WORD转换为PDF的Demo
09-16
VS2010写的将Word转换成PDF的例子，例子页面为About.aspx，服务器需要安装Office2010
C# Word文档转PDF
最新发布
海洋的眼泪
08-11 1571
方案一：引用 Nuget包 Microsoft.Office.Interop.Word。方案二：引入com组件。
Word文档怎么转换为PDF格式？介绍两种方式
Fezzy0的博客
12-01 376
Word如何转PDF呢？介绍两种方式
C#导出execl表格
09-07
C#如何导出execl表格
C#大量数据导出到Excel自动分页导出
04-25
C#大量数据导出到Excel，超过65536行时自动分页导出
c# 导入导出execl 示例
03-02
使用C# 语言开发，涉及范围execl 生成，execl 导入 execl 导出
C# 导出execl
03-23
C# 导出execl
c# 导出execl xml html格式
05-27
c# 获得数据库数据，然后将得到的数据导出到execl格式中，无需office控件
C# .net 利用Npoi将Excel转Pdf(完整代码).rar
11-12
C# .net 利用Npoi将Excel转Pdf(完整代码)。 blog: https://blog.csdn.net/xjzdr/article/details/121287537
C#实现Word转为PDF的方法
12-31
这里主要提供一种将word文档转成PDF文档的实现； 具体实现看c#代码：要引入Microsoft.Office.Interop.Word;版本12.0.0.0 using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Text; using System.Runtime.InteropServices; using Microsoft.Office.Interop.Word; //Office 命名空间 namespace OfficeToPdf {
用C#.NET实现生成PDF文档和将WORD转换为PDF
02-16
用C#.NET实现生成PDF文档和将WORD转换为PDF
C#EXCEL转PDF，word转PDF
08-13
C# 调用office2010组件，将EXCEL转PDF和word转PDF，其中解决了excel文档列过多的问题，需要安装office2010。。
word转pdf c#实现
10-31
word转pdf的c#实现 同时发来俺这小白都理解了，发出来共享。
C#导出word或者pdf方法----适用于word排版可能随时会变化的情况
weixin_30725467的博客
06-09 171
实现步骤： 1、从数据库取出要导出到word上的数据，用C#操作生成一个数据XMl文件，例如：a.xml <?xml version="1.0" encoding="gb2312"?> <History> <Customer> <CustomerName>1111 </CustomerName>...
NPOI导入导出工具（内附PDF详解和示例代码）
04-26
使用了NPOI使导入导出Excel变得非常简单，还可以对Excel的样式进行编辑。相当强大，内附PDF资料详解，代码中有示例代码，这个版本只支持Excel2003。2.0支持2007，不过目前是beta版，最还不要使用。
使用第三方组件NPOI和iTextSharp根据DataTable导出Excel、Word、Pdf
功夫再高也怕菜刀 充分体现了科技的力量
02-06 6425
源码及组件下载地址：源码及NPOI 2.0和itextsharp-all-5.5.3源码如下：using System;using System.Collections.Generic;using System.Data;using System.Text;using NPOI;using NPOI.HPSF;using NPOI.HSSF;using NPOI.HSSF.UserModel;us
C#导出到Excel或PDF
luols的专栏
05-27 3805
C#导出到Excel和前文：Excel画斜线以及Excel宏的利用
c#dbf导出EXECL
07-27
你可以使用C#中的一些库来导出DBF文件到Excel。一个常用的库是NPOI，它可以帮助你进行Excel文件的读写操作。以下是一个简单的示例代码，演示如何将DBF文件导出到Excel： ```csharp using NPOI.HSSF.UserModel; ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值