Spreadsheet Data Transformation into Web Database using XSLT

Abstract

In the system of my paper, XML (Extensible Makeup Language) and XSLT (Extensible Stylesheet Language Transformation) technologies are used with intention of storing and retrieving the large amount of business finance data to the web database, the SQL server through the webpage. The emergence of XML is a significant advance in area of Business to Business (B2B) integration. User can store or transmit structured data using the highly flexible open standard, XML format. The input file must be the Microsoft Excel and transformed into XML file with schema so that the user can understand this on the webpage. As result of doing this paper, the achievement is that the integrated data could have been put into the web database for the Diamond Palace Company Limited. This is a good experience and knowledge as to conversion from Excel to XML. It also is a usage enterprise for the benefit of transferring large amount of data on the web database. This is a way of a system-structure as well as Client-Server Application Architecture.