首页 > 代码库 > 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中添加超链接
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。