SYSTEMS, METHODS, AND MEDIA FOR PROCESSING A SPREADSHEET FOR STORAGE IN A DATABASE

摘要

A system, a method, and a medium for processing a spreadsheet to store the spreadsheet to a database are provided to process/store the spreadsheet to the database by automatically processing records of the spreadsheet and applying a conventional validation/business process logic. A request for processing the spreadsheet including a plurality of records to store the spreadsheet to the database is received(502). A configuration file related to the spreadsheet is generated by receiving more than one name of a business object related to the record of the spreadsheet, metadata for more than one column of the spreadsheet, and the name of a back-end business component related to the spreadsheet. The generated configuration file is accessed(508). A new business object is generated for each record of the spreadsheet, and is populated based on the records and the configuration file(514). Each new business object is transferred to a back-end business application(516).