An investigation into transforming spreadsheet data using XML: A dissertation submitted in partial fulfilment of the requirements for the degree of Bachelor of Applied Computing (Honours)

Zhang, X. Y.2020-04-072020-04-072003https://hdl.handle.net/10182/11710Spreadsheets used for managing data often have problems when the data is stored in an unnormalised way. These problems can be solved by creating normalised tables in a database. The process for transforming the data is difficult when done by hand. We propose a way of using Extensible Markup Language (XML) and Extensible Stylesheet Language Transformation (XSLT) to transform spreadsheet data. Transforming spreadsheets data using XSLT was first investigated in a simple way which was for a particular transformation. We tried a more general applicable method using parameters in XSLT. The trials of transforming spreadsheet using XSLT are the basic of the further research about spreadsheet normalisation and transformation.vii, 54 pagesenhttps://researcharchive.lincoln.ac.nz/pages/rightsspreadsheet normalisationXMLXSLTExtensible Markup LanguageExtensible Stylesheet Language TransformationAn investigation into transforming spreadsheet data using XML: A dissertation submitted in partial fulfilment of the requirements for the degree of Bachelor of Applied Computing (Honours)DissertationDigital thesis can be viewed by current staff and students of Lincoln University only. If you are the author of this item, please contact us if you wish to discuss making the full text publicly available.ANZSRC::08 Information and Computing SciencesANZSRC::0803 Computer SoftwareQ112859234