没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
Excel 操作类
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Reflection;
using Excel;
using System.IO;
using System.Data.OleDb;
using System.Data;
using System.Diagnostics;
using System.Threading;
using first.Modules;
namespace first.Middle
{
/// <summary>
/// ExcelPrint 的摘要说明。
/// </summary>
public class ExcelPrint
{//Excel 操作类
object missing=Missing.Value ;
private Excel.Application myexcel = new Excel.Application() ;
private FrmProsessNoBar bar = null;
//系统配置文件目录
private string AppPath = System.Windows.Forms.Application.StartupPath +"\dbconfig.ini";
//模板文件的存放目录
private string _excelFolder = "";
public string ExcelFolder
{
get {return _excelFolder;}
set {_excelFolder = value;}
}
//xls 文件复制的临时目录
private string _excelTemp = "";
public string ExcelTemp
{
get {return _excelTemp;}
set {_excelTemp = value;}
}
//被复制的 xls 模板文件全路径
private string _excelCopyName = "";
public string ExcelCopyName
{
get {return _excelCopyName;}
set {_excelCopyName = value;}
}
//复制完成后的 xls 临时文件全路径
private string _excelTempName = "";
public string ExcelTempName
{
get {return _excelTempName;}
set {_excelTempName = value;}
}
private string ExcelName = "";//模板名称
public ExcelPrint()
{
//
// TODO: 在此处添加构造函数逻辑
//
// this.ExcelFolder = IniInfo.getIniInfo(this.AppPath,"ExcelPrint","ExcelFolder");
// this.ExcelTemp = IniInfo.getIniInfo(this.AppPath,"ExcelPrint","ExcelTemp");
this.ExcelFolder = System.Windows.Forms.Application.StartupPath + "\\ExcelFolder\\";
this.ExcelTemp = System.Windows.Forms.Application.StartupPath + "\\ExcelTemp\\";
}
/// <summary>
/// 打开复制的 XLS 模板
/// </summary>
/// <param name="path">模板文件名</param>
public ExcelPrint(string fileName)
{
try
{
// this.ExcelFolder = IniInfo.getIniInfo(this.AppPath,"ExcelPrint","ExcelFolder");
// this.ExcelTemp = IniInfo.getIniInfo(this.AppPath,"ExcelPrint","ExcelTemp");
this.ExcelFolder = System.Windows.Forms.Application.StartupPath + "\\ExcelFolder\\";
this.ExcelTemp = System.Windows.Forms.Application.StartupPath + "\\ExcelTemp\\";
ExcelCopyName = this.ExcelFolder + fileName + ".xls";
ExcelTempName = this.ExcelTemp + fileName + getSystemTime() + ".xls";
ExcelName = fileName;
}
catch(System.Exception ex)
{
Console.Write(ex.Message);
}
}
/// <summary>
/// 复制模板文件
/// </summary>
public bool ExcelCopy()
{
try
{
if (!isExistFolderOrFile())
{
return false;
}
else
{
File.Copy(@ExcelCopyName,@ExcelTempName,true);
}
}
catch(System.Exception ex)
{
Console.Write(ex.Message);
return false;
}
return true;
}
public void OpenTempXls()
{
this.ThredShowBar();
//myexcel.Workbooks.Open
(@ExcelTempName,missing,missing,missing,missing,missing,missing,missing,missing,missing,m
issing,missing,missing,missing,missing); //2003 excel 版本代码
myexcel.Workbooks.Open
(@ExcelTempName,missing,missing,missing,missing,missing,missing,missing,missing,missing,m
issing,missing,missing); //2000 excel 版本代码
// myexcel.Visible = true;
myexcel.Visible = false;
}
public void SetXlsVisible()
{
if (bar != null)
{
bar.Close();
}
myexcel.Visible = true;
}
剩余13页未读,继续阅读
资源评论
wuyq11
- 粉丝: 4961
- 资源: 9
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功