如何在Excel导出中设置从一个工作表到另一个工作表的链接 [英] How to set a link from one sheet to another in Excel Export

问题描述

我正在使用C#通过工作表将数据从数据表导出到Excel.在我的第一张工作表中，一列中有所有工作表名称.
我的问题是如何在第一张工作表中设置链接.如果我单击第一张工作表中的任何值，它将转到该工作表.请使用C#使用代码帮助我.

预先感谢，
T.Saravanan

Hi,

I am Export a data from datatable to Excel by sheet-wise using C#.In my first sheet have a all sheet name''s in one column.
My question is how to set a link in first sheet values.If i click any value in first sheet it goes to that sheet.Please any one help to me with code using C#.

Advance Thanks,
T.Saravanan

推荐答案

我也有答案.

objRange = objSheet.get_Range("A1"，"A3");
objSheet.Hyperlinks.Add(objRange，"，"Sheet2！A1"，"，objSheet.Name);


在Excel导出方法中添加此编码.

objSheet->图纸对象
objRange->范围对象

谢谢&问候，
T.Saravanan;)

Hi,

I am also got an answer.

objRange=objSheet.get_Range("A1","A3");
objSheet.Hyperlinks.Add(objRange,"","Sheet2!A1","",objSheet.Name);


Add this coding in Excel Export Method.

objSheet --> Sheet Object
objRange --> Range Object

Thanks & Regards,
T.Saravanan ;)

记录宏.然后将其转换为C#代码.

我记录下来了看起来很简单.

Record a macro while doing that. Then convert that to c# code.

I recorded it. Looks quite simple.

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="Sheet3!A1", TextToDisplay:="abc"

如果您使用的是C#4.0以下的版本，则必须提供默认的Type.Missing，用于所有不需要的参数.一个重要的参数是地址，我敢肯定还有其他参数.我正在谈论使用Interop时的 ActiveSheet.Hyperlinks.Add 方法.
:)

If you''re using anything less than C# 4.0 you''ll have to provide the default Type.Missing for all the expected params that are not of any use to you. One sunch param is the Address and I''m sure there are others. I''m talking about the ActiveSheet.Hyperlinks.Add method, when using Interop.
:)

这篇关于如何在Excel导出中设置从一个工作表到另一个工作表的链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！