Method and device for inputting image files

Abstract

The invention provides a method for inputting image files. The method includes receiving an image file comprising one or more input areas via an input control and transmitting the image file to an excel worksheet to display the image file; arranging the input control in the corresponding input area of the image file; setting position coordinates of the input control displayed in the excel worksheet; receiving an input request of input equipment by the aid of the input control in the input area according to the position coordinates; and calling a response event code of the input control according to the input request to execute input operation. The input control comprises the response event code which is preliminarily stored in a worksheet code area corresponding to a VBE (visual basic editor). The invention further provides a corresponding device. The method and the device have the advantages that the image file input processing efficiency can be improved, and the utilization rate of program codes for input processing is increased.

Description

technical field [0001] The invention relates to the field of image file processing, and more specifically, to an image file input method and device. Background technique [0002] With the continuous development and progress of social economy and technology, financial institutions (for example, banks, etc.) carry out more and more types of business, which makes the documents involved in certificates more and more diverse, for example, commonly used Voucher documents include cash checks, transfer checks, wire transfer vouchers, billing slips, real-time pass vouchers, etc. Of course, in addition to banks, other industries also involve voucher documents, such as accounting industry, logistics industry, express delivery industry, etc. The voucher documents involved include accounting vouchers, warehousing documents, shipping documents, postal parcel receipts, etc. . The above-mentioned voucher documents not only cover a wide range of industries and industries, but also have dif...

AI Technical Summary

Problems solved by technology

Most of the existing voucher file input methods are to develop specific input software for a specific type of voucher. Although the development cost of such input software is low and the development cycle is relatively short, when the format of voucher files , When the style changes, the software code must be modified and redeveloped, and the scope of application of the software is limited

The reusability and compatibility of such input software are poor, and the cost of maintaining the software is relatively high

In addition, most of these software directly use Excel cell tables as the interaction layer with user input / output. Due to the strong constraints between Excel cell tables and cell tables, it is difficult to meet more complex input requirements.

Images