void Cp ()
{
OpenFileDialog openFileDialog1 = new OpenFileDialog ();
Openfiledialog1.title = "Please select source file";
Openfiledialog1.filter = "Excel file (*.xls) |*.xls";
Openfiledialog1.showdialog ();
if (OpenFileDialog1.FileName.Equals (""))
{
MessageBox.Show ("Please select an Excel file!");
}
Else
{
Microsoft.Office.Interop.Excel.Application Excel = new Microsoft.Office.Interop.Excel.Application ();
Workbook Workbook = Excel. Workbooks.Open (Openfiledialog1.filename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
SaveFileDialog SaveFileDialog = new SaveFileDialog ();
Savefiledialog.filename = "Unnamed table. xls";
Savefiledialog.defaultext = ". xls";
Savefiledialog.fileok + = new CancelEventHandler (Delegate (object sender, CancelEventArgs e)
{
Workbook Workbook1 = Excel. Workbooks.Open (Savefiledialog.filename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Worksheet Worksheet = (Worksheet) workbook. SHEETS[1];
Worksheet. Copy (Workbook1. SHEETS[1], Type.Missing);
Workbook1. Save ();
Workbook1. Close (False, Type.Missing, Type.Missing);
Excel. DisplayAlerts = false;
});
if (savefiledialog.showdialog () = = DialogResult.Cancel)
{
return true;
}
Workbook. Save ();
Workbook. Close (False, Type.Missing, Type.Missing);
Excel. Quit ();
Excel = null;
Gc. Collect ();
}
}
[Transfer from others ' blogs] Excel Worksheet Copy