I am trying to copy all data from worksheet1 and paste the values into worksheet2 at the same position I am using office 2003 and the Interlop library.
Here is my code;
public void CreateExcelWorksheet()
{
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
Console.WriteLine("EXCEL could not be started. Check that your office installation.");
return;
}
xlApp.Visible = true;
Workbook wb = xlApp.Workbooks.OpenXML(@"C:\XML_Export.xml", Type.Missing, 2);
Worksheet worksheet1 = wb.Worksheets[1] as Worksheet;
Worksheet worksheet2 = wb.Worksheets[2] as Worksheet;
worksheet1.UsedRange.Copy(Type.Missing);
worksheet2.PasteSpecial(Microsoft.Office.Interop.Excel.XlPasteType.xlPasteValues, false, false, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
For some reason after the paste command the following exception occurs:
Exception from HRESULT: 0x800A03EC
Could anyone help?
