Question

c# 为excel单元格添加链接时,总是出现异常来自 HRESULT:0x800A03EC

//代码如下:总是在sheet1.Hyperlinks.Add(range, "http://www.abc123.com", Missing.Value, Missing.Value, Missing.Value);这句出现异常来自 HRESULT:0x800A03EC,寻遍google和百度,什么改变语言选项,先保存再来设等各种方法,无一有用,有知道的朋友请不吝赐教,谢谢!!!

Control.CheckForIllegalCrossThreadCalls = false;
OpenFileDialog ofd = new OpenFileDialog();
ofd.Title = "打开(Open)";
ofd.FileName = "";
ofd.InitialDirectory = exePath;
ofd.InitialDirectory = System.Windows.Forms.Application.StartupPath;
ofd.Filter = "Excel文件|*.xls";
ofd.ValidateNames = true;
ofd.CheckFileExists = true;
ofd.CheckPathExists = true;
try
{
if (ofd.ShowDialog() == DialogResult.OK)
{
Microsoft.Office.Interop.Excel.ApplicationClass myExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
Workbook wb = myExcel.Workbooks.Open(ofd.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
Worksheet sheet1 = (Worksheet)wb.Sheets[1];
Range range = sheet1.get_Range("a1", "a1");
//下面这行代码总是报{"异常来自 HRESULT:0x800A03EC"}
sheet1.Hyperlinks.Add(range, "http://www.abc123.com", Missing.Value, Missing.Value, Missing.Value);

wb.Save();
}

}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}

Answer 1

这个错误 有很多种情况
下面是我在运用中发现的
1 单个单元格存放内容过多
2存放数据行过长
3存在“=”等，让excel翻译为函数操作的字符
4excel的权限问题
5操作系统问题
6操作的excel版本与客户端版本不符

追问

hehe,我也搞不清楚是什么原因,难道真的是因为操作系统的原因?我用的是Xp

追答

具体怎么样我就不知道了。。。