/*?====================================================================
???Licensed?to?the?Apache?Software?Foundation?（ASF）?under?one?or?more
???contributor?license?agreements.??See?the?NOTICE?file?distributed?with
???this?work?for?additional?information?regarding?copyright?ownership.
???The?ASF?licenses?this?file?to?You?under?the?Apache?License?Version?2.0
???（the?“License“）;?you?may?not?use?this?file?except?in?compliance?with
???the?License.??You?may?obtain?a?copy?of?the?License?at

???????http://www.apache.org/licenses/LICENSE-2.0

???Unless?required?by?applicable?law?or?agreed?to?in?writing?software
???distributed?under?the?License?is?distributed?on?an?“AS?IS“?BASIS
???WITHOUT?WARRANTIES?OR?CONDITIONS?OF?ANY?KIND?either?express?or?implied.
???See?the?License?for?the?specific?language?governing?permissions?and
???limitations?under?the?License.
====================================================================?*/

using?System;
using?System.Text;
using?System.IO;
using?NPOI.HSSF.UserModel;
using?NPOI.HPSF;
using?NPOI.POIFS.FileSystem;

using?NPOI.HSSF.Util;
using?NPOI.SS.UserModel;


/*?This?sample?is?copied?from?poi/hssf/usermodel/examples/Hyperlink.java?*/
namespace?AddHyperlinkInXls
{
????class?Program
????{
????????static?void?Main（string[]?args）
????????{
????????????InitializeWorkbook（）;

????????????////cell?style?for?hyperlinks
????????????////by?default?hyperlinks?are?blue?and?underlined
???????????ICellstyle?hlink_style?=?hssfworkbook.CreateCellstyle（）;
????????????IFont?hlink_font?=?hssfworkbook.CreateFont（）;
????????????hlink_font.Underline?=?（byte）FontUnderlineType.SINGLE;
????????????hlink_font.Color?=?HSSFColor.BLUE.index;
????????????hlink_style.SetFont（hlink_font）;

????????????ICell?cell;
????????????ISheet?sheet?=?hssfworkbook.CreateSheet（“Hyperlinks“）;

????????????//URL
????????????cell?=?sheet.CreateRow（0）.CreateCell（0）;
????????????cell.SetCellValue（“URL?link“）;
????????????HSSFHyperlink?link?=?new?HSSFHyperlink（HyperlinkType.URL）;
????????????link.Address?=?（“http://poi.apache.org/“）;
????????????cell.Hyperlink?=?（link）;
????????????cell.Cellstyle?=?（hlink_style）;

????????????//link?to?a?file?in?the?current?directory
????????????cell?=?sheet.CreateRow（1）.CreateCell（0）;
????????????cell.SetCellValue（“File?link“）;
????????????link?=?new?HSSFHyperlink（HyperlinkType.FILE）;
????????????link.Address?=?（“link1.xls“）;
????????????cell.Hyperlink?=?（link）;
????????????cell.Cellstyle?=?（hlink_style）;

????????????//e-mail?link
????????????cell?=?sheet.CreateRow（2）.CreateCell（0）;
????????????cell.SetCellValue（“Email?link“）;
????????????link?=?new?HSSFHyperlink（HyperlinkType.EMAIL）;
????????????//note?if?subject?contains?white?spaces?make?sure?they?are?url-encoded
????????????link.Address?=?（“mailto:poi@apache.org?subject=Hyperlinks“）;
????????????cell.Hyperlink?=?（link）;
????????????cell.Cellstyle?=?（hlink_style）;

????????????//link?to?a?place?in?this

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-10-09?23:03??npoi?2.0?官網下載\
?????目錄???????????0??2013-03-06?07:20??npoi?2.0?官網下載\npoi\
?????目錄???????????0??2013-03-07?10:24??npoi?2.0?官網下載\npoi\dotnet2\
?????文件??????200704??2013-03-06?07:13??npoi?2.0?官網下載\npoi\dotnet2\ICSharpCode.SharpZipLib.dll
?????文件?????1624064??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet2\NPOI.dll
?????文件??????387072??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet2\NPOI.OOxml.dll
?????文件???????79872??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet2\NPOI.Openxml4Net.dll
?????文件?????????120??2013-03-06?07:13??npoi?2.0?官網下載\npoi\dotnet2\NPOI.Openxml4Net.dll.config
?????文件?????1316864??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet2\NPOI.OpenxmlFormats.dll
?????文件?????2144246??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet2\NPOI.xml
?????目錄???????????0??2013-03-07?10:24??npoi?2.0?官網下載\npoi\dotnet3.5\
?????文件??????200704??2013-03-06?07:13??npoi?2.0?官網下載\npoi\dotnet3.5\ICSharpCode.SharpZipLib.dll
?????文件?????1624064??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet3.5\NPOI.dll
?????文件??????387072??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet3.5\NPOI.OOxml.dll
?????文件???????79872??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet3.5\NPOI.Openxml4Net.dll
?????文件?????????120??2013-03-06?07:13??npoi?2.0?官網下載\npoi\dotnet3.5\NPOI.Openxml4Net.dll.config
?????文件?????1316864??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet3.5\NPOI.OpenxmlFormats.dll
?????文件?????2144246??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet3.5\NPOI.xml
?????目錄???????????0??2013-03-07?10:24??npoi?2.0?官網下載\npoi\dotnet4\
?????文件??????200704??2013-03-06?07:13??npoi?2.0?官網下載\npoi\dotnet4\ICSharpCode.SharpZipLib.dll
?????文件?????1624064??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet4\NPOI.dll
?????文件??????387072??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet4\NPOI.OOxml.dll
?????文件???????79872??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet4\NPOI.Openxml4Net.dll
?????文件?????1316864??2013-03-06?07:17??npoi?2.0?官網下載\npoi\dotnet4\NPOI.OpenxmlFormats.dll
?????文件?????2145032??2013-03-06?07:13??npoi?2.0?官網下載\npoi\dotnet4\NPOI.xml
?????目錄???????????0??2013-03-05?08:33??npoi?2.0?官網下載\npoi\examples\
?????目錄???????????0??2013-03-05?08:33??npoi?2.0?官網下載\npoi\examples\hssf\
?????目錄???????????0??2013-03-05?08:33??npoi?2.0?官網下載\npoi\examples\hssf\AddHyperlinkInXls\
?????文件????????4432??2013-03-05?08:10??npoi?2.0?官網下載\npoi\examples\hssf\AddHyperlinkInXls\AddHyperlinkInXls.csproj
?????文件?????????257??2013-03-05?08:10??npoi?2.0?官網下載\npoi\examples\hssf\AddHyperlinkInXls\AddHyperlinkInXls.csproj.vspscc
?????文件????????4498??2013-03-05?08:10??npoi?2.0?官網下載\npoi\examples\hssf\AddHyperlinkInXls\Program.cs
............此處省略485個文件信息