首页 > 代码库 > C#在excel中添加超链接

C#在excel中添加超链接

1.新建一个项目

2.给项目添加引用:Microsoft Excel 12.0 Object Library (2007版本)

using Excel = Microsoft.Office.Interop.Excel;

3.对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();        }    }}

参考:

http://support.microsoft.com/kb/302084/zh-cn

http://www.codeproject.com/Articles/5123/Opening-and-Navigating-Excel-with-C

C#在excel中添加超链接