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

前端技术 2023/09/08 C#

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

本文地址：https://www.stayed.cn/item/21003

转载请注明出处。

本站部分内容来源于网络,如侵犯到您的权益,请 联系我

我的博客

人生若只如初见，何事秋风悲画扇。

我的标签

随笔档案