程序目的：ＥＸＣＥＬ文件存放数据，根据提供的模板，生成相应的word文件，每条数据生成一页数据。
Ｅｘｃｅｌ操作：取数据
using System;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
namespace WorkBookForHKAccountDoc
{
public class ExcelOperation
{
public delegate void ErrorEventHandler(object sender, OnErrorEventArgs e);
public event ErrorEventHandler OnError = null;
public delegate void InfoEventHandler(object sender, OnPrintInfoEventArgs e);
public event InfoEventHandler OnPrintInfo = null;
获取EXCEL中用户信息列表
}
}
数据结构：
using System;
using System.Collections.Generic;
using System.Text;
namespace WorkBookForHKAccountDoc
{
public class AccountInfo
{
public string txtClient_Main_Account;
public string txtClient_Properity;
public string txtClient_Sub_Account;
public string txtShort_Name;
public string txtChinese_Name;
public string txtOpen_Date;
public string txtStatus;
}
}
Ｗｏｒｄ文件操作：
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Office.Interop.Word;
namespace WorkBookForHKAccountDoc
{
public class WordOperation
{
public delegate void ErrorEventHandler(object sender, OnErrorEventArgs e);
public event ErrorEventHandler OnError = null;
public delegate void InfoEventHandler(object sender, OnPrintInfoEventArgs e);
public event InfoEventHandler OnPrintInfo = null;
private int intCopyNum = 1;
生成用户信息文档
生成用户ID表格文档
CommonFunctions
}
}
MAINFORM：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace WorkBookForHKAccountDoc
{
public partial class MainForm : Form
{
public MainForm()
{
InitializeComponent();
}
private void MainForm_Load(object sender, EventArgs e)
{
initializeComBox();
}
private void btnXlsFileUp_Click(object sender, EventArgs e)
{
OpenFileDialog file = new OpenFileDialog();
file.Title = "选择Excel资源";
file.Filter = "xls files(*.xls)|*.xls" +
"|All files(*.*)|*.*";
if (file.ShowDialog() == DialogResult.OK)
{
txtXlsFilePathName.Text = file.FileName;
}
file.Dispose();
}
private void btnXlsFileUp2_Click(object sender, EventArgs e)
{
OpenFileDialog file = new OpenFileDialog();
file.Title = "选择Excel资源";
file.Filter = "xls files(*.xls)|*.xls" +
"|All files(*.*)|*.*";
if (file.ShowDialog() == DialogResult.OK)
{
txtXlsFilePathName2.Text = file.FileName;
}
file.Dispose();
}
private void btnDocFileUp_Click(object sender, EventArgs e)
{
OpenFileDialog file = new OpenFileDialog();
file.Title = "选择Doc文档";
file.Filter = "doc files(*.doc)|*.doc" +
"|All files(*.*)|*.*";
if (file.ShowDialog() == DialogResult.OK)
{
txtDocFilePathName.Text = file.FileName;
}
file.Dispose();
}
private void btnDocAccountFileUp_Click(object sender, EventArgs e)
{
OpenFileDialog file = new OpenFileDialog();
file.Title = "选择Doc文档";
file.Filter = "doc files(*.doc)|*.doc" +
"|All files(*.*)|*.*";
if (file.ShowDialog() == DialogResult.OK)
{
this.txtDocAccountFilePathName.Text = file.FileName;
}
file.Dispose();
}
private void btnGenerateAccInfoDocs_Click(object sender, EventArgs e)
{
if (!validateTag1())
{
return;
}
try
{
ExcelOperation xlsOp = new ExcelOperation();
xlsOp.OnPrintInfo += new ExcelOperation.InfoEventHandler(OnPrintInfo);
xlsOp.OnError += new ExcelOperation.ErrorEventHandler(OnError);
System.Collections.Generic.List<AccountInfo> list = xlsOp.getAccountList(this.txtXlsFilePathName.Text);
int intTmp = 1;
if (comboBox1.SelectedIndex > 0)
{
intTmp = Convert.ToInt32(this.comboBox1.SelectedItem);
}
WordOperation docOp = new WordOperation();
docOp.OnError += new WordOperation.ErrorEventHandler(OnError);
docOp.OnPrintInfo += new WordOperation.InfoEventHandler(OnPrintInfo);
object objDocMouldFileAccInfo = txtDocFilePathName.Text;
docOp.generateDocumentDoc(list, GetConfigValue("strSaveAccountInfoDocPath"), objDocMouldFileAccInfo,intTmp);
MessageBox.Show("执行完毕！");
}
catch (Exception ex)
{
OnError(this, new OnErrorEventArgs("", ex));
}
}
private void btnGenerateAccIDDocs_Click(object sender, EventArgs e)
{
if (!validateTag2())
{
return;
}
try
{
ExcelOperation xlsOp = new ExcelOperation();
xlsOp.OnPrintInfo += new ExcelOperation.InfoEventHandler(OnPrintInfo);
xlsOp.OnError += new ExcelOperation.ErrorEventHandler(OnError);
System.Collections.Generic.List<AccountInfo> list = xlsOp.getAccountList(this.txtXlsFilePathName2.Text);
WordOperation docOp = new WordOperation();
docOp.OnError += new WordOperation.ErrorEventHandler(OnError);
docOp.OnPrintInfo += new WordOperation.InfoEventHandler(OnPrintInfo);
object objDocMouldFileAccID = txtDocAccountFilePathName.Text;
docOp.generateTableDoc(list, GetConfigValue("strSaveAccountIDDocPath"), objDocMouldFileAccID);
MessageBox.Show("执行完毕！");
}
catch (Exception ex)
{
OnError(this, new OnErrorEventArgs("", ex));
}
}
void OnError(object sender, OnErrorEventArgs e)
{
listBox1.Items.Add(e.AccountID + " | " + e.InnerException.Message);
this.Refresh();
}
void OnPrintInfo(object sender, OnPrintInfoEventArgs e)
{
listBox1.Items.Add(e.StrEventInfo);
listBox1.SelectedIndex = listBox1.Items.Count - 1;
this.Refresh();
}
void initializeComBox()
{
object objComBoxItem = "--用户信息拷贝数--";
this.comboBox1.Items.Add(objComBoxItem);
for (int i = 1; i <= 10; i++)
{
objComBoxItem = i;
this.comboBox1.Items.Add(objComBoxItem);
}
comboBox1.SelectedIndex = 0;
}
bool validateTag1()
{
if (this.txtDocAccountFilePathName.Text == "" || txtXlsFilePathName.Text == "")
{
MessageBox.Show("请选择需要的文件!");
return false;
}
else
{
return true;
}
}
bool validateTag2()
{
if ( this.txtDocAccountFilePathName.Text == "" || txtXlsFilePathName2.Text == "")
{
MessageBox.Show("请选择需要的文件!");
return false;
}
else
{
return true;
}
}
string GetConfigValue(string strCfgName)
{
string strRet = System.Configuration.ConfigurationSettings.AppSettings[strCfgName];
if (!strRet.EndsWith(@"\"))
{
strRet = strRet + @"\";
}
return strRet;
}
}
}
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。