2013年1月13日 星期日

[c#]如何在excel裡加入超連結

Range range = WorkSheet.get_Range(儲存格位置(ex:"I2"), Type.Missing);
Hyperlink hyperLink = (Hyperlink)range.Hyperlinks.Add(range, 超連結要連到哪(string), Type.Missing, Type.Missing, I2要顯示的文字(string));
真實程式範例:
Worksheet ws = (Worksheet)wb.Sheets[1];
...
...
...
for (int i = 0; i < TotalData; i++)
{
    ws.Cells[(i + 2), 1] = ObjDataList[i, 0];
    ws.Cells[(i + 2), 2] = ObjDataList[i, 1];
    ws.Cells[(i + 2), 3] = ObjDataList[i, 2];
    ws.Cells[(i + 2), 4] = ObjDataList[i, 3];
    ws.Cells[(i + 2), 5] = ObjDataList[i, 4];
    ws.Cells[(i + 2), 6] = ObjDataList[i, 5];
    ws.Cells[(i + 2), 7] = ObjDataList[i, 6];
    ws.Cells[(i + 2), 8] = ObjDataList[i, 7];
    ws.Cells[(i + 2), 9] = ObjDataList[i, 8];
    String tmp = (i + 2).ToString();
    Range range = ws.get_Range("I" + tmp, Type.Missing);
    Hyperlink hyperLink = (Hyperlink)range.Hyperlinks.Add(range, ObjDataList[i, 8], Type.Missing, Type.Missing, ObjDataList[i, 8]);
}

沒有留言: