Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.Hyperlink

305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
       
        if(linkList != null && !linkList.isEmpty())
        {
          for(Object hyperlink : linkList)
          {
            Hyperlink link = (Hyperlink)hyperlink;
            link.setAddress(anchor.getRefersToFormula());
          }
        }
       
      }
      for (Object pageIndex : pageLinks.keySet())
      {
        List linkList = (List)pageLinks.get(pageIndex);
        if(linkList != null && !linkList.isEmpty())
        {
          for(Object hyperlink : linkList)
          {
            Hyperlink link = (Hyperlink)hyperlink;
            if(isOnePagePerSheet)
            {
              link.setAddress("'" + workbook.getSheetName(((Integer)pageIndex).intValue() - 1)+ "'!A1");
            }
            else
            {
              link.setAddress("'" + workbook.getSheetName(0)+ "'!A1");
            }
          }
        }
       
      }
View Full Code Here
1650
1651
1652
1653
1654
1655
1656
1657
1658
1659
1660
1661
1662
1663
1664
1665
1666
1667
1668
1669
1670
1671
1672
1673
1674
1675
1676
1677
1678
1679
1680
1681
1682
1683
1684
1685
1686
1687
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
1715
1716
1717
1718
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735
1736
 
  protected void setHyperlinkCell(JRPrintHyperlink hyperlink)
  {
   
    String href = null;
    Hyperlink link = null;
    JRHyperlinkProducer customHandler = getHyperlinkProducer(hyperlink);
    if (customHandler == null)
    {
      switch (hyperlink.getHyperlinkTypeValue())
      {
        case REFERENCE:
        {
          href = hyperlink.getHyperlinkReference();
          if (href != null)
          {
            link = createHelper.createHyperlink(Hyperlink.LINK_URL);
              link.setAddress(href);
          }
          break;
        }
        case LOCAL_ANCHOR :
        {
          href = hyperlink.getHyperlinkAnchor();
          if (href != null)
          {
            link = createHelper.createHyperlink(Hyperlink.LINK_DOCUMENT);
              if(anchorLinks.containsKey(href))
              {
                ((List)anchorLinks.get(href)).add(link);
              }
              else
              {
                List hrefList = new ArrayList();
                hrefList.add(link);
                anchorLinks.put(href, hrefList);
              }
             
          }
          break;
         
        }
        case LOCAL_PAGE :
        {
          Integer hrefPage = hyperlink.getHyperlinkPage();
          if (hrefPage != null)
          {
            link = createHelper.createHyperlink(Hyperlink.LINK_DOCUMENT);
              if(pageLinks.containsKey(hrefPage))
              {
                ((List)pageLinks.get(hrefPage)).add(link);
              }
              else
              {
                List hrefList = new ArrayList();
                hrefList.add(link);
                pageLinks.put(hrefPage, hrefList);
              }
          }
          break;
        }
        case REMOTE_ANCHOR :
        {
          href = hyperlink.getHyperlinkReference();
          if (href != null && hyperlink.getHyperlinkAnchor() != null)
          {
            href = href + "#" + hyperlink.getHyperlinkAnchor();
            link = createHelper.createHyperlink(Hyperlink.LINK_FILE);
              link.setAddress(href);
             
          }
          break;
         
        }
        case REMOTE_PAGE :
        {
          href = hyperlink.getHyperlinkReference();
          if (href != null && hyperlink.getHyperlinkPage() != null)
          {
            href = href + "#JR_PAGE_ANCHOR_0_" + hyperlink.getHyperlinkPage().toString();
            link = createHelper.createHyperlink(Hyperlink.LINK_FILE);
              link.setAddress(href);
             
          }
          break;
         
        }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
121
    // Add one more, and re-check
    Row r17 = sheet.createRow(17);
    Cell r17c = r17.createCell(2);

    Hyperlink hyperlink = createHelper.createHyperlink(Hyperlink.LINK_URL);
    hyperlink.setAddress("http://poi.apache.org/spreadsheet/");
    hyperlink.setLabel("POI SS Link");
    r17c.setHyperlink(hyperlink);

    assertEquals(5, sheet.getNumHyperlinks());
    doTestHyperlinkContents(sheet);
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
   
    // Add one more, and re-check
    Row r17 = sheet.createRow(17);
    Cell r17c = r17.createCell(2);
   
    Hyperlink hyperlink = createHelper.createHyperlink(Hyperlink.LINK_URL);
    hyperlink.setAddress("http://poi.apache.org/spreadsheet/");
    hyperlink.setLabel("POI SS Link");
    r17c.setHyperlink(hyperlink);
   
    assertEquals(5, sheet.getNumHyperlinks());
    doTestHyperlinkContents(sheet);
   
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
93
    // Add one more, and re-check
    Row r17 = sheet.createRow(17);
    Cell r17c = r17.createCell(2);

    Hyperlink hyperlink = createHelper.createHyperlink(Hyperlink.LINK_URL);
    hyperlink.setAddress("http://poi.apache.org/spreadsheet/");
    hyperlink.setLabel("POI SS Link");
    r17c.setHyperlink(hyperlink);

    assertEquals(5, sheet.getNumHyperlinks());
    doTestHyperlinkContents(sheet);
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
   
    // Add one more, and re-check
    Row r17 = sheet.createRow(17);
    Cell r17c = r17.createCell(2);
   
    Hyperlink hyperlink = createHelper.createHyperlink(Hyperlink.LINK_URL);
    hyperlink.setAddress("http://poi.apache.org/spreadsheet/");
    hyperlink.setLabel("POI SS Link");
    r17c.setHyperlink(hyperlink);
   
    assertEquals(5, sheet.getNumHyperlinks());
    doTestHyperlinkContents(sheet);
   
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
154
155
    // Add one more, and re-check
    Row r17 = sheet.createRow(17);
    Cell r17c = r17.createCell(2);

    Hyperlink hyperlink = createHelper.createHyperlink(Hyperlink.LINK_URL);
    hyperlink.setAddress("http://poi.apache.org/spreadsheet/");
    hyperlink.setLabel("POI SS Link");
    r17c.setHyperlink(hyperlink);

    assertEquals(5, sheet.getNumHyperlinks());
    doTestHyperlinkContents(sheet);
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
    // Add one more, and re-check
    Row r17 = sheet.createRow(17);
    Cell r17c = r17.createCell(2);

    Hyperlink hyperlink = createHelper.createHyperlink(Hyperlink.LINK_URL);
    hyperlink.setAddress("http://poi.apache.org/spreadsheet/");
    hyperlink.setLabel("POI SS Link");
    r17c.setHyperlink(hyperlink);

    assertEquals(5, sheet.getNumHyperlinks());
    doTestHyperlinkContents(sheet);
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
        Sheet sh = wb.createSheet("test");
        Row row = sh.createRow(0);
        CreationHelper helper = wb.getCreationHelper();

        Cell cell1 = row.createCell(1);
        Hyperlink link1 = helper.createHyperlink(Hyperlink.LINK_URL);
        cell1.setHyperlink(link1);
        assertNotNull(cell1.getHyperlink());
        cell1.removeHyperlink();
        assertNull(cell1.getHyperlink());

        Cell cell2 = row.createCell(0);
        Hyperlink link2 = helper.createHyperlink(Hyperlink.LINK_URL);
        cell2.setHyperlink(link2);
        assertNotNull(cell2.getHyperlink());
        cell2.setHyperlink(null);
        assertNull(cell2.getHyperlink());
View Full Code Here
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
        final Workbook wb = new XSSFWorkbook();
        final Sheet sheet = wb.createSheet();
        Row row = sheet.createRow(0);

        Cell cell1 = row.createCell(1);
        Hyperlink link1 = new XSSFHyperlink(Hyperlink.LINK_URL);
        cell1.setHyperlink(link1);
        assertNotNull(cell1.getHyperlink());
        cell1.removeHyperlink();
        assertNull(cell1.getHyperlink());

        Cell cell2 = row.createCell(0);
        Hyperlink link2 = new XSSFHyperlink(Hyperlink.LINK_URL);
        cell2.setHyperlink(link2);
        assertNotNull(cell2.getHyperlink());
        cell2.setHyperlink(null);
        assertNull(cell2.getHyperlink());
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.usermodel.Hyperlink

  • bad.robot.excel.cell.HyperlinkCell
  • net.sf.jasperreports.engine.export.JRXlsExporter
  • org.apache.poi.xssf.streaming.TestSXSSFCell
  • org.apache.poi.xssf.usermodel.TestXSSFCell
  • org.apache.poi.xssf.usermodel.TestXSSFHyperlink
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.