项目中需要经常用到Excel、Word、pdf等的模板导出,以下是自己总结的简单版的模板导出,复杂的导出类似,只需稍加修改就好。以下导出代码是在WinForm开发中点击某个click事件时触发的:
private void btn_download_Click(object sender, EventArgs e)
{
SaveFileDialog _saveFileDialog = new SaveFileDialog();
_saveFileDialog.Filter = "Microsoft Excel (*xls)|*.xls";
_saveFileDialog.Title = "导出导入模板";
_saveFileDialog.FileName = "大宗原材料合同导入模板";
if(_saveFileDialog.ShowDialog() == DialogResult.OK)
{
Stream _stream = _saveFileDialog.OpenFile();
StreamWriter _streamWriter = new StreamWriter(_stream, Encoding.GetEncoding("GB2312"));
string _columnName = string.Empty;
_columnName += "*合同号\t*母材\t*供应商\t期货月\t*单价\t*订单数量\t匹配顺序";
_streamWriter.WriteLine(_columnName);
_streamWriter.Close();
_stream.Close();
}
}
当然模板的导入也有,不过我们暂时不在这里多讲了,等将代码规范以后在贴上来供大家借鉴。
该部分在msdn上的链接如下:
http://msdn.microsoft.com/zh-cn/library/9tah40xd(v=VS.80).aspx
http://msdn.microsoft.com/zh-cn/library/system.io.stream(VS.80).aspx
http://msdn.microsoft.com/zh-cn/library/system.io.streamwriter(VS.80).aspx