商务合作:179001057@qq.com

c#2005 excel

技术2022-05-11  3


某平台价值19860元的编程课程资料免费领取【点我领取】


c#2005对excel的操作,只写了部分代码,以后会慢慢补充的。

/** Copyright(C) ryuusei Corporation 2009. All rights reserved.* 文件名 : TestOffice.cs* 系统名 : * 版本 : 0.0.0.0*/

using System;using System.Collections.Generic;using System.Text;using System.Data;using Excel=Microsoft.Office.Interop.Excel;using System.IO;class TestOffice{    /// <summary>    /// excel主函数    /// </summary>    /// <param name="strPath">excel的路径</param>    /// <param name="dt">传入datatable</param>    /// <returns>结果:成功 true;失败 false</returns>    public bool ExcelMain(string strPath, DataTable dt)    {        //返回值        bool retFlag = false;

        //判断datatable是否存在数据        if (dt.Rows.Count <= 0)        {            return retFlag;        }

        //判断文件是否存在        if (!File.Exists(strPath))        {            return retFlag;        }

        //设置文件属性为normal        File.SetAttributes(strPath,FileAttributes.Normal);

        //建立Excel对象        Excel.Application oXls = new Excel.Application();        // 获得workbook对象        Excel.Workbook templateBook = GetExcelBook(oXls, templateDt);        //获得worksheet对象        Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Sheets.get_Item(1);        //取消sheet保护        workSheet.Unprotect(Type.Missing);    }

    /// <summary>    /// 获得workbook对象    /// </summary>    /// <param name="oXls">excel对象</param>    /// <param name="strPath">excel的路径</param>    /// <returns>workbook对象</returns>    private Excel.Workbook GetExcelBook(Excel.Application oXls, string strPath)    {        Excel.Workbooks oBooks = oXls.Workbooks;        Excel.Workbook oBook = oBooks.Open(strPath,            Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

        return oBook;    }

    /// <summary>    /// 拷贝模板worksheet    /// </summary>    /// <param name="templateBook">workbook对象</param>    /// <param name="baseBook">模板workbook</param>    /// <returns>结果:成功 true;失败 false</returns>    private bool ExcelSheetAdd(Excel.Workbook templateBook, Excel.Workbook baseBook)    {        Excel.Worksheet sheet = (Excel.Worksheet)baseBook.Worksheets[1];        Excel.Worksheet to = (Excel.Worksheet)templateBook.Worksheets[1];        sheet.Copy(to, Type.Missing);

        return true;    }}


最新回复(0)