读取Excel出现异常来自HRESULT:0x800A03EC报错
代码如下:
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "Excel文件(*.xls)|*.xls";
ofd.FilterIndex = 1;
ofd.RestoreDirectory = true;
if (ofd.ShowDialog() == DialogResult.OK)
{
Microsoft.Office.Interop.Excel.Application myexcel = new Microsoft.Office.Interop.Excel.Application();
if (myexcel == null)
{
MessageBox.Show("文件不存在!");
}
myexcel.Visible = false;
myexcel.DisplayAlerts = false;
myexcel.AlertBeforeOverwriting = false;
Microsoft.Office.Interop.Excel.Workbooks workbooks = myexcel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(ofd.FileName);
Microsoft.Office.Interop.Excel.Sheets sheets = workbook.Worksheets;
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.Item[3];
Microsoft.Office.Interop.Excel.Range range;
range = worksheet.UsedRange;
。。。。。。。。
该代码为打开一个Excel文件并读取其中数据,在我工作电脑win10系统可以正常运行,但是在另一个工位电脑win7系统运行时,当选择打开文件后,在运行到Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(ofd.FileName); 弹出“未处理COMException”,“异常来自HRESULT:0x800A03EC”。
请各位大神帮忙看看应该如何解决,跪谢!