代碼如下:
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”。
請各位大神幫忙看看應該如何解決,跪謝!
uj5u.com熱心網友回復:
電腦上安裝的是完整版本的excel么,位數(32/64)和你的程式的位數是否一致uj5u.com熱心網友回復:
裝了wps,好像還裝了office2007,從哪里能查看是否是完整版本?怎么查詢自己程式的位數?轉載請註明出處,本文鏈接:https://www.uj5u.com/net/24489.html
標籤:ASP.NET
