C#在excel中添加超链接

gxm771208

原文地址：http://www.cnblogs.com/luxiaoxun/p/3219141.html

1.新建一个项目

2.给项目添加引用：Microsoft Excel 12.0 Object Library （2007版本）
using Excel = Microsoft.Office.Interop.Excel;

3.对excel的简单操作：如下代码“添加超链接”等。

1. 
   
2. using System;
   
3. using System.Collections.Generic;
   
4. using System.Linq;
   
5. using System.Text;
   
6. using Excel = Microsoft.Office.Interop.Excel;
   
7. 
   
8. namespace ExcelExample
   
9. {
   
10.     class Program
    
11.     {
    
12.         static void Main(string[] args)
    
13.         {
    
14.             Excel.Application excelApp = new Excel.Application();  // Creates a new Excel Application
    
15.             excelApp.Visible = true;  // Makes Excel visible to the user.
    
16. 
    
17.             // The following line if uncommented adds a new workbook
    
18.             //Excel.Workbook newWorkbook = excelApp.Workbooks.Add();
    
19. 
    
20.             // The following code opens an existing workbook
    
21.             string workbookPath = "F:\\11.xlsx";  // Add your own path here
    
22. 
    
23.             Excel.Workbook excelWorkbook = null;
    
24. 
    
25.             try
    
26.             {
    
27.                 excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0,
    
28.                     false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true,
    
29.                     false, 0, true, false, false);
    
30.             }
    
31.             catch
    
32.             {
    
33.                 //Create a new workbook if the existing workbook failed to open.
    
34.                 excelWorkbook = excelApp.Workbooks.Add();
    
35.             }
    
36. 
    
37.             // The following gets the Worksheets collection
    
38.             Excel.Sheets excelSheets = excelWorkbook.Worksheets;
    
39. 
    
40.             // The following gets Sheet1 for editing
    
41.             string currentSheet = "Sheet1";
    
42.             Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);
    
43. 
    
44.             // The following gets cell A1 for editing
    
45.             Excel.Range excelCell = (Excel.Range)excelWorksheet.get_Range("A1", "B1");
    
46. 
    
47.             // The following sets cell A1's value to "Hi There"
    
48.             excelCell.Value2 = "Hi There";
    
49. 
    
50.             Excel.Worksheet excelWorksheet2 = (Excel.Worksheet)excelSheets.get_Item("Sheet2");
    
51.             Excel.Range excelCell2 = (Excel.Range)excelWorksheet2.get_Range("A1", Type.Missing);
    
52.             excelCell2.Value2 = "Hi Here";
    
53. 
    
54.             // Add hyperlinks to the cell A1
    
55.             //excelWorksheet.Hyperlinks.Add(excelCell,"http:\\www.baidu.com",Type.Missing,"baidu",Type.Missing);
    
56. 
    
57.             // Add hyperlinks from "sheet1 A1" to "sheet2 A1"
    
58.             excelWorksheet.Hyperlinks.Add(excelCell, "#Sheet2!A1", Type.Missing, Type.Missing, Type.Missing);
    
59. 
    
60.             // Close the excel workbook
    
61.             //excelWorkbook.Close(true,Type.Missing,Type.Missing);
    
62. 
    
63.             //Quit the excel app
    
64.             //excelApp.Quit();
    
65.         }
    
66.     }
    
67. }
    

复制代码

参考：
http://support.microsoft.com/kb/302084/zh-cn
http://www.codeproject.com/Artic ... gating-Excel-with-C