Balisage Paper: Getting Useful XML out of Microsoft Excel
August 1 - 5, 2022
The materials listed below were provided by the speaker as supplements to a
presentation at Balisage. These materials may include the slides or visuals used in
the
presentation; supplementary material, such as code samples or a demonstration application;
and/or the paper accompanying the presentation (if it has not been provided in XML).
These
materials have been zipped for easy download and are identified by a brief description
of
the contents. The materials themselves are untouched
, that is, they
have not been tested or edited by Balisage: The Markup Conference or by Mulberry
Technologies, Inc. As such, they are included on this website AS IS
,
i.e., as provided by the speaker, with no warranties, express or otherwise, made by
Balisage
or Mulberry.
Slides and Materials
- Bal2022-Udeshani-presentation-pptx.zip: Presentation slides in Microsoft PowerPoint (pptx)
Microsoft Corporation. February 15, 2022. Office Implementation Information for ISO/IEC 29500 Standards Support. https://interoperability.blob.core.windows.net/files/MS-OI29500/%5bMS-OI29500%5d.pdf
Spreadsheet styles. http://officeopenxml.com/SSstyles.php
Microsoft Office, API Reference. https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.sheetformatproperties?view=openxml-2.8.1
"Retrieving data from Excel XML using XSLT". https://stackoverflow.com/questions/33422652/retrieving-data-from-excel-xml-using-xslt
"How to turn an XML file into SVG using XSL?" https://stackoverflow.com/questions/8056671/how-to-turn-an-xml-file-into-svg-using-xsl
XSLT to generate SVG tutorial. 2016. http://edutechwiki.unige.ch/en/XSLT_to_generate_SVG_tutorial
Florent Georges. 2008. Simple SVG chart generation with XSLT. http://fgeorges.blogspot.com/2008/04/simple-svg-chart-generation-with-xslt.html
Max Froumentin, Vincent Hardy, W3C. Using XSLT and SVG together: a survey of case studies. https://www.w3.org/People/maxf/papers/2002-07-SVGOpen/svgopen.html
SVG attribute reference. https://developer.mozilla.org/en-US/docs/Web/SVG/Attribute
A pure XSLT/SVG pie chart. https://www.sleepingdog.org.uk/svg/chart/pie/
SvgCharts4XSL. https://franklinefrancis.github.io/SvgCharts4Xsl/
Adrian McMenamin. 2011. Using XSLT to manipulate an SVG file. https://cartesianproduct.wordpress.com/2011/07/16/using-xslt-to-manipulate-an-svg-file/
SVG: Scalable Vector Graphics. https://developer.mozilla.org/en-US/docs/Web/SVG
Ben Hauser. Content XML 3.0 and earlier. https://help.typefi.com/hc/en-us/articles/228240428-Content-XML-3-0-and-earlier
Laura Powers. 2021. "Local style overrides". https://help.typefi.com/hc/en-us/articles/360001491415#h_3be5e014-f255-49b8-8454-6c7681861b1a
Erik Bruchez. "Unzipping an Excel 2007 .xlsx file and extracting data in XPL/XSLT". https://gist.github.com/ebruchez/1245692
Dave Bruns. "Excel customer number formats". https://exceljet.net/custom-number-formats
Appendix A: Full XML schema. https://docs.microsoft.com/en-us/openspecs/office_standards/ms-xlsx/6624db33-496c-47f7-a562-a54cb01b133f
Apache POI - HSSF and XSSF Limitations. https://poi.apache.org/components/spreadsheet/limitations.html
Harvey Bingham. OASIS Technical Resolution TR 9503:1995, Exchange Table Model Document Type Definition. https://www.oasis-open.org/specs/a503.htm
Ari Nordström. 2020. "Pipelined XSLT Transformations". Presented at Balisage: The Markup Conference 2020, Washington, DC, July 27 - 31, 2020. In Proceedings of Balisage: The Markup Conference 2020. Balisage Series on Markup Technologies, vol. 25. https://www.balisage.net/Proceedings/vol25/print/Nordstrom01/BalisageVol25-Nordstrom01.html. doi:https://doi.org/10.4242/BalisageVol25.Nordstrom01
David Maus. 2018. XProc Step by Step: Implementing a DOCX to TEI step. https://dmaus.name/blog/2018.14/index.html
XProc 3.0: An XML Pipeline Language, Community Group Report 1 July 2022. https://spec.xproc.org/master/head/xproc/
Norman Walsh, Achim Berndzen. 2019. "XProc 3.0". Presented at Balisage: The Markup Conference 2019, Washington, DC, July 30 - August 2, 2019. In Proceedings of Balisage: The Markup Conference 2019. Balisage Series on Markup Technologies, vol. 23. https://www.balisage.net/Proceedings/vol23/print/Walsh02/BalisageVol23-Walsh02.html. doi:https://doi.org/10.4242/BalisageVol23.Walsh02
Erik Siegel. 2020. XProc 3.0 - Strategies for merging documents. https://www.xml.com/articles/2020/11/16/xproc-30-strategies-merging-documents/#sect-pass-as-collection
"How do I convert Excel Serial Date Numbers in an XML file to mm/dd/yyyy for SQL Server in an SSIS Package?" https://stackoverflow.com/questions/64018372/how-do-i-convert-excel-serial-date-numbers-in-an-xml-file-to-mm-dd-yyyy-for-sql
"How to change date format in Excel and create custom formatting". https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#excel-date-format