python给excel添加超链接_c#教程之c#在excel中添加超链接示例分享

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Excel = Microsoft.Office.Interop.Excel;

namespace ExcelExample

{

class Program

{

static void Main(string[] args)

{

Excel.Application excelApp = new Excel.Application(); // Creates a new Excel Application

excelApp.Visible = true; // Makes Excel visible to the user.

// The following line if uncommented adds a new workbook

//Excel.Workbook newWorkbook = excelApp.Workbooks.Add();

// The following code opens an existing workbook

string workbookPath = "F:\\11.xlsx"; // Add your own path here

Excel.Workbook excelWorkbook = null;

try

{

excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0,

false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true,

false, 0, true, false, false);

}

catch

{

//Create a new workbook if the existing workbook failed to open.

excelWorkbook = excelApp.Workbooks.Add();

}

// The following gets the Worksheets collection

Excel.Sheets excelSheets = excelWorkbook.Worksheets;

// The following gets Sheet1 for editing

string currentSheet = "Sheet1";

Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);

// The following gets cell A1 for editing

Excel.Range excelCell = (Excel.Range)excelWorksheet.get_Range("A1", "B1");

// The following sets cell A1's value to "Hi There"

excelCell.Value2 = "Hi There";

Excel.Worksheet excelWorksheet2 = (Excel.Worksheet)excelSheets.get_Item("Sheet2");

Excel.Range excelCell2 = (Excel.Range)excelWorksheet2.get_Range("A1", Type.Missing);

excelCell2.Value2 = "Hi Here";

// Add hyperlinks to the cell A1

//excelWorksheet.Hyperlinks.Add(excelCell,"http:\\www.baidu.com",Type.Missing,"baidu",Type.Missing);

// Add hyperlinks from "sheet1 A1" to "sheet2 A1"

excelWorksheet.Hyperlinks.Add(excelCell, "#Sheet2!A1", Type.Missing, Type.Missing, Type.Missing);

// Close the excel workbook

//excelWorkbook.Close(true,Type.Missing,Type.Missing);

//Quit the excel app

//excelApp.Quit();

}

}

}