HI. I believe that with the conversion licence, you can do what you want with: xdmp:excel-convert
Barring that, you could always run openoffice as a headless server for conversion purposes. Kind Regards, David Ennis Kind Regards, David Ennis David Ennis *Content Engineer* [image: HintTech] <http://www.hinttech.com/> Mastering the value of content creative | technology | content Delftechpark 37i 2628 XJ Delft The Netherlands T: +31 88 268 25 00 M: +31 63 091 72 80 [image: http://www.hinttech.com] <http://www.hinttech.com> <https://twitter.com/HintTech> <http://www.facebook.com/HintTech> <http://www.linkedin.com/company/HintTech> On 16 October 2014 20:00, Gary Russo <[email protected]> wrote: > I need to extract worksheet metadata called “defined name” from Excel > 97/2003 formatted spreadsheets. > > > > The ISYS xdmp:document-filter() API is limiting because it only extracts > the text. > > > > It does not extract any worksheet metadata. > > > > Does anyone know of a workaround for this? > > > > My only thought is to upload the “Excel 97/2003” xls file and then convert > it on the server to an “Excel 2010” xlsx format. > > > > Once it’s in an Excel 2010 format, I can easily extract the “defined name” > metadata. > > > > This is what it looks like in “Excel 2010” files. > > > > <definedNames> > <definedName name="LastYr">Revenue!$B$6:$B$15</definedName> > <definedName name="ThisYr">Revenue!$C$6:$C$15</definedName> > <definedName name="Variance">Revenue!$D$6:$D$15</definedName> > </definedNames> > > > > > > Thanks, > > Gary Russo > > > > > > *Gary Russo* > > *Enterprise NoSQL Developer* > > *Phone: 212-404-8639 <212-404-8639>* > > *Skype: garyprusso* > > *http://garyrusso.wordpress.com <http://garyrusso.wordpress.com>* > > > > _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
