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
Skype: garyprusso
http://garyrusso.wordpress.com
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
