[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Extracting a XLSX directly using XSLT 3 and Saxon
On 06.07.2022 18:39, Gayanthika Udeshani gudeshani@xxxxxxxxxx wrote:
On closer look, it seems even Saxon HE can treat an xlsx file as a zip archive if you pass in the right configuration property (example worked for me with Windows Powershell on the command line for Saxon HE 11 and 10) B --zipUriPattern:'.*\.xlsx' From there you can use e.g. B uri-collection('excel-sheet1.xlsx') to get the URIs of (some or all?) contained files, it appears, and then you can read the XML files with the doc function e.g. doc('jar:file:/C:/SomePath/SomeDir/excel-sheet1.xlsx!/xl/workbook.xml') But as Mike said, the whole structure is rather complicated, with all the references across various files you either need to know your way around Spreadsheet ML or perhaps already have a stylesheet by someone that learned to process such a structure to extract/transform the spreadsheet data.
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|