How to get hyperlink info using XSSF EventUserModel

[Isao Kadowaki <is...@gmail.com>]

Hi,
I'm now studying how to read an Excel 2010 file using
xssf.eventuserrmodel in poi 3.8.
XLSX2CSV.java and XSSFEventBasedExcelExtractor.java were good examples
for me to how to use XSSFReader and XSSFSheetXMLHandler.
Now I want to extract hyper link information in the same way, but I
cannot find any sample codes in the package.

Can I use the xssf.eventusermodel package to get hyperlink information
such as display name and address?
If the answer is Yes, could you please show me a sample code to do that?
If the answer is No, do I need to write a code calling SAX from scratch?

Thanks,
Isao

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: How to get hyperlink info using XSSF EventUserModel

[Nick Burch <ni...@alfresco.com>]

On Thu, 5 Apr 2012, Isao Kadowaki wrote:
> I'm now studying how to read an Excel 2010 file using 
> xssf.eventuserrmodel in poi 3.8. XLSX2CSV.java and 
> XSSFEventBasedExcelExtractor.java were good examples for me to how to 
> use XSSFReader and XSSFSheetXMLHandler. Now I want to extract hyper link 
> information in the same way, but I cannot find any sample codes in the 
> package.

You could try looking at Excel Extractor in Apache Tika, if memory serves 
it does event based xlsx extraction and gets hyperlinks
http://svn.apache.org/repos/asf/tika/trunk/tika-parsers/src/main/java/org/apache/tika/parser/microsoft/ooxml/XSSFExcelExtractorDecorator.java

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org