Balisage Paper: Getting Useful XML out of Microsoft Excel

Balisage: The Markup Conference 2022
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

×

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

×

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

×

Adrian McMenamin. 2011. Using XSLT to manipulate an SVG file. https://cartesianproduct.wordpress.com/2011/07/16/using-xslt-to-manipulate-an-svg-file/

×

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

×

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

×

"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