Method and device for converting spreadsheet file into web format file

Abstract

An embodiment of the invention discloses a method and device for converting a spreadsheet file into a web format file. The method includes reading spreadsheet file data to be converted into a web format file; inputting the read spreadsheet file data to a pre-established spreadsheet model unit correspondingly; deleting left useless data when editing the spreadsheet file from the spreadsheet model unit for inputting the spreadsheet file data, and obtaining model data to be converted; generating the web format file from the model data to be converted. The spreadsheet file data comprises pattern data and worksheets comprised by workbooks to compose the spreadsheet file data. According to the embodiment, converting cost can be reduced, usability and portability of the converting method can be improved, storage space can be saved, and display effect of a browser can be improved.

Description

technical field [0001] The invention relates to computer technology, in particular to a method and device for converting an electronic form file into a web page format file. Background technique [0002] Electronic forms (usually EXCEL format files) can input, output, and display user data. It can help users make various complex table documents, perform cumbersome user data calculations, and perform various complex statistical operations on the input user data. Display A table with excellent visibility. At the same time, it can also visually display a large amount of boring user data into a variety of beautiful color business charts, which greatly enhances the visibility of user data. In addition, the electronic form can also print out various statistical reports and statistical charts. [0003] At present, electronic forms have been widely used in today's office transaction processing activities. Usually, people use spreadsheet software (for example, Microsoft OFFICE, Yo...

AI Technical Summary

Problems solved by technology

[0016] In the prior art, the electronic form file is converted into an HTML webpage format file method completely dependent on the core technology of a certain specific electronic form software, and most of the electronic form software is commercial software, resulting in higher cost of use; and the conversion method and Conversion tools need to be limited to specific development platforms. For example, using Microsoft technology will be limited to .net or C++ development platforms, while Yongzhong conversion components need to be limited to JAVA development platforms, thus reducing the usability and portability of conversion methods;

[0017] There may be useless data left over from editing the table in the HTML web format file converted by the existing technology. For example, the seemingly blank area is recorded as non-empty (NULL) when the actual table is stored, causing the conversion tool to convert this part of the blank area Conversion to HTML web pages, resulting in wasted storage space and discounted presentation effects

Images