windows窗体(winform)中嵌入显示Excel工作表。
来源:互联网 发布:森林旅游数据 编辑:程序博客网 时间:2024/05/09 15:19
环境:c#2005,Excel2003.
1 实现后的效果如下图:
(截图)
2 实现代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Owc11;
namespace CityToProvince.GUILayer
{
public partial class frmExcel : Form
{
public frmExcel()
{
InitializeComponent();
}
private void buttonOpen_Click(object sender, EventArgs e)
{
OpenFileDialog myOpenFileDialog = new OpenFileDialog();
myOpenFileDialog.Filter = "Excel文件(*.xls)|*.xls|xml格式表格(*.xml)|*.xml";
myOpenFileDialog.FilterIndex = 2;
myOpenFileDialog.Title = "选择xml文件";
myOpenFileDialog.InitialDirectory = "c:\\";
myOpenFileDialog.RestoreDirectory = true;
DialogResult dr = myOpenFileDialog.ShowDialog();
if (dr == DialogResult.OK)
{
try
{
this.axSpreadsheetExcel.XMLURL = myOpenFileDialog.FileName;
}
catch
{
MessageBox.Show("错误");
}
}
}
private void buttonConvert_Click(object sender, EventArgs e)
{//xls->xml and open
OpenFileDialog myOpenFileDialog = new OpenFileDialog();
myOpenFileDialog.Filter = "Excel文件(*.xls)|*.xls";
myOpenFileDialog.FilterIndex = 1;
myOpenFileDialog.Title = "选择Excel文件";
myOpenFileDialog.InitialDirectory = "c:\\";
myOpenFileDialog.RestoreDirectory = true;
DialogResult dr = myOpenFileDialog.ShowDialog();
if (dr == DialogResult.OK)
{
try
{
ExcelProcess.ExcelProcess myExcel = new ExcelProcess.ExcelProcess();
myExcel.OpenFileName = myOpenFileDialog.FileName;
string saveXmlName = myOpenFileDialog.FileName.ToString().Replace("xls", "xml");
if (System.IO.File.Exists(saveXmlName))
{
System.IO.File.Delete(saveXmlName);
}
myExcel.SaveFileName = saveXmlName;
myExcel.OpenExcelFile();
myExcel.SaveExcelAsXML();
myExcel.CloseExcelApplication();
}
catch
{
MessageBox.Show("转换错误");
}
}
}
private void buttonClose_Click(object sender, EventArgs e)
{
//this.axSpreadsheetExcel.XMLURL = null;
this.Close();
}
private void buttonConvertOpen_Click(object sender, EventArgs e)
{
//xls->xml and open
OpenFileDialog myOpenFileDialog = new OpenFileDialog();
myOpenFileDialog.Filter = "Excel文件(*.xls)|*.xls";
myOpenFileDialog.FilterIndex = 1;
myOpenFileDialog.Title = "选择Excel文件";
myOpenFileDialog.InitialDirectory = "c:\\";
myOpenFileDialog.RestoreDirectory = true;
DialogResult dr = myOpenFileDialog.ShowDialog();
if (dr == DialogResult.OK)
{
try
{
ExcelProcess.ExcelProcess myExcel = new ExcelProcess.ExcelProcess();
myExcel.OpenFileName = myOpenFileDialog.FileName;
string saveXmlName = myOpenFileDialog.FileName.ToString().Replace("xls", "xml");
if (System.IO.File.Exists(saveXmlName))
{
System.IO.File.Delete(saveXmlName);
}
myExcel.SaveFileName = saveXmlName;
myExcel.OpenExcelFile();
myExcel.SaveExcelAsXML();
myExcel.CloseExcelApplication();
this.axSpreadsheetExcel.XMLURL = saveXmlName;
}
catch
{
MessageBox.Show("转换错误");
}
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
SaveFileDialog mySaveFileDialog = new SaveFileDialog();
mySaveFileDialog.Title = "导出Excel文件的名称";
mySaveFileDialog.Filter = "Excel文件|*.xls";
string exportExcelFile;
mySaveFileDialog.InitialDirectory = SysCommon.ShareData.ExportExcelPath;
DialogResult mydr = mySaveFileDialog.ShowDialog();
if (mydr == DialogResult.OK)
{
exportExcelFile = mySaveFileDialog.FileName;
this.axSpreadsheetExcel.Export(exportExcelFile, SheetExportActionEnum.ssExportActionNone,
SheetExportFormat.ssExportAsAppropriate);
}
}
}
}
其中ExcelProcess操作类 http://www.cnblogs.com/emanlee/archive/2007/05/31/766520.html 。
摘自:http://www.cnblogs.com/emanlee/archive/2006/02/18/333064.html
- windows窗体(winform)中嵌入显示Excel工作表。
- winform中嵌入窗体到panel
- 实现c#中winform窗体嵌入并操作可视化Excel表格
- winform窗体中操作Excel
- 在WinForm中嵌入Word和Excel
- C# Winform 窗体美化(九、嵌入窗体)
- C#操作Word(二)——将Word文档嵌入到WinForm窗体中
- C#操作Word(二)——将Word文档嵌入到WinForm窗体中
- 在Winform窗体中显示AutoCAD文件(dwg文件)
- C#.net Winform 如何将窗体嵌入Panle中
- C#在控制台工程中嵌入winform窗体
- 【二次开发】将CATIA嵌入到Winform窗体中
- exe程序嵌入Winform窗体
- winform 嵌入 外部 exe窗体
- winform窗体中动态显示时间
- winform中窗体显示和传值
- winform窗体中动态显示时间
- C#实现在Winform中嵌入Word和Excel
- ts文件不能正常播放的问题
- ubuntu进不去了
- UNIX网络编程——select函数的并发限制和 poll 函数应用举例
- 关于浓缩即食燕窝好不好
- crontab shell 执行失效之注意事项
- windows窗体(winform)中嵌入显示Excel工作表。
- UML用例图中包含、扩展、泛化关系
- lftp命令小结
- struts2.0之拦截器
- 格格热南方烦恼
- android异步 比较
- VM中不能建共享文件夹,不能与windows 之间复制 粘贴的解决方法
- c++沉思录笔记(13章代码)
- RTSP - RTP over TCP