原创:windows窗体(winform)中嵌入显示Excel工作表。
环境: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是我写的一个操作excel的类 http://www.cnblogs.com/emanlee/archive/2007/05/31/766520.html 。
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是我写的一个操作excel的类 http://www.cnblogs.com/emanlee/archive/2007/05/31/766520.html 。
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 地球OL攻略 —— 某应届生求职总结
· 周边上新:园子的第一款马克杯温暖上架
· Open-Sora 2.0 重磅开源!
· .NET周刊【3月第1期 2025-03-02】
· [AI/GPT/综述] AI Agent的设计模式综述