源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

c#在excel中添加超链接示例分享

  • 时间:2021-02-07 22:26 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:c#在excel中添加超链接示例分享
1.新建一个项目 2.给项目添加引用:Microsoft Excel 12.0 Object Library (2007版本)
[u]复制代码[/u] 代码如下:
using Excel = Microsoft.Office.Interop.Excel;
3.对excel的简单操作:如下代码“添加超链接”等。
[u]复制代码[/u] 代码如下:
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();         }     } }
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部