private void Form1_Load(object sender, System.EventArgs e)
{
fpSpread1.ActiveSheet.Columns[1].Width = 200;
// セルへのハイパーリンク
fpSpread1.AsWorkbook().ActiveSheet.Hyperlinks.Add("B3", "", "Sheet1!A1", "Click here to go to A1", "Goto A1");
// URLへのハイパーリンク
fpSpread1.AsWorkbook().ActiveSheet.Hyperlinks.Add("B5", "http://www.google.com/", "", "Click here to go to Google website", "Google Website");
}
private void button1_Click(object sender, EventArgs e)
{
// Excelのインポート/エクスポート
fpSpread1.OpenExcel("..\\..\\Hyperlinks.xlsx");
//fpSpread1.SaveExcel("..\\..\\Hyperlinks.xlsx", FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);
}
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
FpSpread1.ActiveSheet.Columns(1).Width = 200
' セルへのハイパーリンク
FpSpread1.AsWorkbook().ActiveSheet.Hyperlinks.Add("B3", "", "Sheet1!A1", "Click here to go to A1", "Goto A1")
' URLへのハイパーリンク
FpSpread1.AsWorkbook().ActiveSheet.Hyperlinks.Add("B5", "http://www.google.com/", "", "Click here to go to Google website", "Google Website")
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
' Excelのインポート/エクスポート
FpSpread1.OpenExcel("..\\..\\Hyperlinks.xlsx")
'FpSpread1.SaveExcel("..\\..\\Hyperlinks.xlsx", FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat)
End Sub