Environment: C #2005, excel2003.
1. The effect after implementation is as follows:
()
2. Implementation Code :
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 file (*. xls) | *. xls | XML format table (*. XML) | *. xml ";
Myopenfiledialog. filterindex = 2;
Myopenfiledialog. Title = "select XML file ";
Myopenfiledialog. initialdirectory = "C :\\";
Myopenfiledialog. restoredirectory = true;
Dialogresult DR = myopenfiledialog. showdialog ();
If (DR = dialogresult. OK)
{
Try
{
This. axspreadsheetexcel. xmlurl = myopenfiledialog. filename;
}
Catch
{
MessageBox. Show ("error ");
}
}
}
Private void buttonconvert_click (Object sender, eventargs E)
{// XLS-> XML and open
Openfiledialog myopenfiledialog = new openfiledialog ();
Myopenfiledialog. Filter = "Excel file (*. xls) | *. xls ";
Myopenfiledialog. filterindex = 1;
Myopenfiledialog. Title = "select Excel file ";
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 ("Conversion error ");
}
}
}
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 file (*. xls) | *. xls ";
Myopenfiledialog. filterindex = 1;
Myopenfiledialog. Title = "select Excel file ";
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 ("Conversion error ");
}
}
}
Private void buttonsave_click (Object sender, eventargs E)
{
Savefiledialog mysavefiledialog = new savefiledialog ();
Mysavefiledialog. Title = "Name of the exported Excel file ";
Mysavefiledialog. Filter = "Excel file | *. xls ";
String exportexcelfile;
Mysavefiledialog. initialdirectory = syscommon. Fetch data. exportexcelpath;
Dialogresult mydr = mysavefiledialog. showdialog ();
If (mydr = dialogresult. OK)
{
Exportexcelfile = mysavefiledialog. filename;
This. axspreadsheetexcel. Export (exportexcelfile, sheetexportactionenum. ssexportactionnone,
Sheetexportformat. ssexportasappropriate );
}
}
}
}
Among them, excelprocess is a class http://www.cnblogs.com/emanlee/archive/2007/05/31/766520.html that I write to Operate Excel.