RE: How to "clone" values of a workbook

2016-05-12 Thread Murphy, Mark
Hmm... I'm not real sure what you mean by "read the data from excel and transform them to an output format" are you using POI or an alternate tool to do that? It seems to me that this might be the bottleneck rather than the create the workbook part. But if "create a new instance of the workbook"

extracting hyperlinks from xlsx with XSSFEventBasedExcelExtractor?

2016-05-12 Thread Allison, Timothy B.
All, On TIKA-1454, one of our users asked to add extraction of hyperlinks from xlsx. It looks like hyperlink info appears at the end of the sheet.xml (after the in the section). Are there any recommendations for merging hyperlink info with the actual cells via XSSFEventBasedExcelExtractor

Re: How to "clone" values of a workbook

2016-05-12 Thread Kai Grabfelder
Hi Mark, we are generating a WEB UI (tables) based on data in the calculated workbook. Basically we are iterating over all cells in all rows of all sheets and transforming them to HTML. We did some performance analysis and the bad part was always the instantiation of the workbook - depending on

Re: How to "clone" values of a workbook

2016-05-12 Thread Blake Watson
I am doing exactly what Kai is, with the specification that the user input and output can come from web representations (or RESTfully) of the spreadsheet, so POI isn't exactly involved in those. (I used the To-HTML example from Ken Arnold—and what a treat to run into one of the fathers of Rogue her

Re: extracting hyperlinks from xlsx with XSSFEventBasedExcelExtractor?

2016-05-12 Thread Nick Burch
On Thu, 12 May 2016, Allison, Timothy B. wrote: On TIKA-1454, one of our users asked to add extraction of hyperlinks from xlsx. It looks like hyperlink info appears at the end of the sheet.xml (after the in the section). Are there any recommendations for merging hyperlink info with the act