//代码如下:总是在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());
}
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());
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货