CN103197855A - Method and device for inputting image files - Google Patents
Method and device for inputting image files Download PDFInfo
- Publication number
- CN103197855A CN103197855A CN2013101373334A CN201310137333A CN103197855A CN 103197855 A CN103197855 A CN 103197855A CN 2013101373334 A CN2013101373334 A CN 2013101373334A CN 201310137333 A CN201310137333 A CN 201310137333A CN 103197855 A CN103197855 A CN 103197855A
- Authority
- CN
- China
- Prior art keywords
- input
- input control
- image file
- control
- code
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- User Interface Of Digital Computer (AREA)
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
The present invention relates to the image file process field, more in particular to a kind of image file input method and device.
Background technology
Continuous development and progress along with social economy, technical field, each financial institution (for example, the class of business of bank etc.) carrying out is more and more various, the file of this feasible voucher class that relates to is also more and more diversified, for example, Chang Yong voucher class file has cash on bank, check only for account, remittance voucher, pay-in slip and leads to voucher etc. in real time.Certainly except bank, other industry also relates to the file of voucher class, for example accounting profession, logistic industry, express delivery industry etc., and the voucher class file that wherein relates to has accounting voucher, warehouse-in document, freight bill, parcel post receipt etc.Industry, industry that the file of above-mentioned voucher class not only relates to are wide, and for the different business of different industries, different enterprise even same enterprise, the form of voucher class file, pattern are all inequality.How electronic equipments such as credentials file input computing machine miscellaneous are preserved, operation such as processing, become the technical matters that presses for solution.
Present most voucher class file is with JPEG(Joint Photographic Experts Group) form, PNG(Portable Network Graphic) etc. form exist.The file input method of existing voucher class, major part is at the specific Input Software of the special exploitation of the voucher of a certain particular type, the cost of development of Input Software although it is so is low, construction cycle is also shorter, but when the form of voucher class file, when pattern changes to some extent, must revise software code, exploitation again, but the limitation of software range of application is bigger.The reusable of this type of Input Software, compatible relatively poor, the cost that software is safeguarded is also than higher.In addition, this type of software mostly directly with Excel unit form as with the interbedded formation of user's I/O because Excel unit form is bigger with binding character between the unit form, the also difficult input demand that satisfies than complexity.
Summary of the invention
The invention provides a kind of image file input method, utilize input control as the input tool that receives image file, and the response events code that utilizes storage responds and handles operation to image file, improve the compatibility to diversified image file, the reusability of code, reduced the cost of code maintenance.
According to the first aspect of embodiment of the present invention, a kind of image file input method is provided, this method comprises:
Receive image file by input control, described image file is sent to the excel worksheet shows, but wherein said image file comprises one or more input areas;
But the input area at described image file arranges input control, and the position coordinates that described input control is showed in described excel worksheet is set;
But utilize input control to receive the input request of input equipment at described input area according to described position coordinates, and carry out input operation according to the response events code of the described input control of described input request call, wherein said input control comprises the response events code of the worksheet code area that is stored in the VBE correspondence in advance.
According to the second aspect of embodiment of the present invention, a kind of image file inputting device is provided, this device comprises:
Receiving element is used for receiving image file by input control, described image file is sent to the excel worksheet shows, but wherein said image file comprises one or more input areas;
The unit is set, but is used at the input area of described image file input control being set, and the position coordinates that described input control is showed in described excel worksheet is set;
Processing unit, but be used for utilizing input control to receive the input request of input equipment at described input area according to described position coordinates, and carry out input operation according to the response events code of the described input control of described input request call, wherein said input control comprises the response events code of the worksheet code area that is stored in the VBE correspondence in advance.
Implement image file input method and device that embodiment of the present invention provides, not only can adapt to diversified image file input demand, improve the treatment effeciency of image file input, and can improve the utilization factor that realizes importing the program code of handling, reduce the cost of code development, maintenance.
Description of drawings
Fig. 1 illustrates the process flow diagram according to the image file input method of embodiment of the present invention.
Fig. 2 illustrates the image file input form according to embodiment of the present invention.
Fig. 3 illustrates the structural representation according to the image file inputting device of embodiment of the present invention.
Fig. 4 illustrates the configuration diagram according to the image file inputting device of embodiment of the present invention.
Fig. 5 illustrates the code schematic form according to embodiment of the present invention.
Embodiment
For the purpose, technical scheme and the advantage that make embodiments of the invention is clearer, the present invention is described in further detail below in conjunction with accompanying drawing.
Referring to Fig. 1, illustrate the process flow diagram according to the image file input method of embodiment of the present invention, this image file input method specifically can comprise the steps:
S101 receives image file by input control, described image file is sent to the excel worksheet shows, but wherein said image file comprises one or more input areas;
S102, but at the input area of described image file input control is set, and the position coordinates that described input control is showed in described excel worksheet is set;
S103, but utilize input control to receive the input request of input equipment at described input area according to described position coordinates, and carry out input operation according to the response events code of the described input control of described input request call, wherein said input control comprises the response events code of the worksheet code area that is stored in the VBE correspondence in advance.
In embodiments of the present invention, image file to be entered can be the image file of jpeg format, such image file can corresponding voucher class file miscellaneous, for example can be bank cash on bank voucher, check only for account voucher, pay-in slip voucher, can also be the voucher such as warehouse-in document, freight bill, parcel post receipt of other industry.These voucher class files can be converted to corresponding format by scanner, and (for example, image file JPEG) for example, can be arranged to scanner resolution and be 96dpi, pantograph ratio and be 100, pattern is that black and white text scans.The image file that scanning obtains can be kept on the local computer, also can be kept on other computing equipments that can carry out image file processing and operation excel, those skilled in the art can carry out relative set, the local computer that is not limited to mention in the present embodiment according to using needs.Need to prove, but the image file in the embodiment of the present invention can comprise one or more input areas, but the input field that input area like this can corresponding original certificate class file, for example, can be input fields such as user account, user name, address, fund type, capitalization date, small letter date in the voucher class file used of bank.In the description of this paper, but input area and input field do not have strict differentiation, are used interchangeably.
Image file input method of the present invention mainly realizes by Microsoft Visual Basic, for the treatment of handling with forms and the various logic of user interactions, wherein mainly comprise module, generic module and designer, in module, deposit various processing procedures and function, generic module provides the interface that service externally is provided, and comprises in the designer that all and user carry out mutual forms.Forms in the embodiment of the present invention refer to the container of control, are a window or dialog box, are used for constituting the user interface part of using.In the embodiment of the present invention, utilize input control to obtain the jpeg format image file from local computer, and the image file that obtains is sent to the excel worksheet shows.But the image file in the embodiments of the present invention comprises one or more input areas, for example, can be the voucher category information such as number of the account, date, the amount of money etc.After obtaining image file, but can input control be set at the input area of image file, but the input area in correspondence can arrange an input control, also a plurality of input controls can be set, and those skilled in the art can arrange accordingly according to using needs.For example, at the number of the account input area of image file a number of the account input control is set, is used for receiving the digital number of the account of arabic numeral form; At the date input area one or three date input controls are set, three input controls of year, month, day for example are set respectively, perhaps year, month, day is input to together a control; At amount of money input area one or two input control of the amount of money is set, for example, the amount of money input control of an arabic numeral form can be set, amount in figures input control and an amount in Chinese character input control corresponding with the amount in figures of this arabic numeral form of an arabic numeral form also can be set, amount to two input controls.After but the input area of image file arranges input control, the position coordinates of input control can be set, can change the position of input control by the position coordinates of adjusting input control.Input control can be ActiveX control, and input control can refer to the object on excel worksheet or forms in the present embodiment, is used alternately by user and application program.ActiveX control has event, and can merge with other controls.Event in the embodiment of the present invention can refer to the action that an object can be recognized, for example, mouse is double-clicked or pressed certain keyboard etc., and can write code and make response at described action.For example, typical event can be worksheet event, forms event and control event etc.Input control in the embodiment of the present invention can be the TextBox control, and it is a kind of in the ActiveX control, can be used for obtaining input or shows text, is generally used for editable text.Text box can show a plurality of row, can enter a new line to text and make its size that meets control, can also add some basic formattings.
Input control in the embodiment of the present invention (for example, the TextBox control) different with the excel cell, it can be in the excel worksheet the optional position, and be not similar to constraint between the such cell of excel cell between each input control (for example, TextBox control).Thereby, the kind of the receivable image file of image file input method of the present invention is more various, and for the image file that changes (for example, when but change takes place in the input area of newly-increased image file or image file or input field), need not the update routine code, reduced the maintenance cost of software code significantly.
Input control in the embodiment of the present invention can at random move at excel worksheet presentation layer by adjusting position coordinates, and can satisfy comparatively complicated input, displaying demand by adjusting coordinate overlapping and dislocation placement at presentation layer.In addition, the various attributes of input control can also be set, comprise, but be not limited to, position coordinates, length, width, highly, font size etc., can arrange one or more of above-mentioned attribute, but further promote the diversity of the input area of image file.And, can also have backup and restore funcitons to control property.
It is multiple that but input area of the present invention or input field can have, and can classify to it, type according to classification is come control is named, for example, but for input area or the input field of user account correspondence, but can the input control called after number of the account input control of this input area or input field will be positioned at.In the embodiments of the present invention, also provide the maintenance function of input control, comprise increase, deletion input control.When the input field of image file increases input control, the image file that receives as the bottom reference frame, is inserted ActiveX control at the image file of excel worksheet, as the input tool of image file, for example can be form as shown in Figure 2.Because inserting ActiveX control must be at the VBE(Visual at this control place Basic Editor) object worksheet code area hand-coding response time code.For solving this technical matters, preserved the required response events code of various input controls in the embodiment of the present invention in advance in the worksheet code area of VBE correspondence, for example, code that can be as shown in Figure 5, when wherein in the TextBox1 control, receiving " 123 ", the response events code adds " 1 " with " 123 ", and assignment is to the A1 cell.Comprise a lot of objects among the VBE, for example window, engineering, module, forms etc.VBA, Visual Basic for Applications is a kind of macrolanguage of Visual Basic, can be used to the expanded application formula.In the embodiment of the present invention, utilize the VBA code to be implemented in the event response code that writes the input control correspondence in the VBE object of corresponding worksheet automatically by operation VBE object, make the reusability of input method code significantly promote.And, write the mode of code by this code, can increase at any time according to the input needs and have the input control that response events is handled, and need not large-scale update routine code, improved the extensibility of input code widely.When the deletion input control, can remove the event response code of this input control in VBE.
For the response events code in the embodiment of the present invention, consider in VBE and preserve, from the maintenance of code or the reliability the escalation process, and the security of source code is set out, the response events code is packaged into DLL(Dynamic Link Library, dynamic link library), by the forms in the interface interchange " designer " of " generic module " definition among the DLL and process and the function in " module ", finish event response and processing.For example, the mouse of presentation layer input control and button correspondence, KeyEvent respond the interface that all can define by the generic module of DLL and respond processing.In the embodiments of the present invention, but but can utilize corresponding input control to receive the input request of input equipment according to being somebody's turn to do the residing position coordinates of input area or input field at input area or input field, and according to the response events code execution input operation of importing the described input control of request call, wherein said input control comprises the response events code of the worksheet code area that is stored in the VBE correspondence in advance.It is pointed out that input equipment of the present invention comprises equipment such as mouse, keyboard, the input request of input equipment can be carried out with the form of clicking or double-clicking mouse, press a certain button of keyboard.For example, in one embodiment of the invention, " the amount in figures input control " in the excel worksheet receives user's mouse and double-clicks event, by the user's forms " amount of money typing forms " in the event response interface interchange designer that calls the DLL definition.When receiving amount in figures, trigger the change event at these " amount of money typing forms ", call the capital and small letter amount of money transfer process in the public module, amount in figures is converted to amount in Chinese character, the capital and small letter amount of money is shown in the amount of money input control of presentation layer simultaneously.In the embodiments of the present invention, can also carry out miscue to the input content of input control, for example, for amount in figures input forms, can limit and only receive the input of numeral and radix point.
In other embodiments of the present invention, mouse is double-clicked the date input control of presentation layer, trigger the DbClick event, response events code call date forms provide calendar to select input for the user, and the date that the user selects from calendar is passed to the date input control show, finish the filling in of input field of an image file.Again for example, in some embodiments, mouse is double-clicked number of the account, name in an account book, or any one input control in three input controls of mechanism of opening an account, trigger the DbClick event, response time code call account information typing forms, the key word of the search domain reception input of forms (for example, it can be number of the account, in name in an account book and the mechanism that opens an account any one) time, automatically trigger the change event of these forms, (comprise number of the account in this worksheet at the worksheet of preserving account information, information such as name in an account book and the mechanism that opens an account) search and the data that the key word of importing mates are selected matched data is presented at number of the account by mouse subsequently, name in an account book and three input controls of mechanism of opening an account.In other words, input method of the present invention can be finished the input of three input controls relevant with this input control by activating an input control, has significantly improved the input treatment effeciency of image file.In addition, in the embodiments of the present invention, but can also realize input area between the different images file or input field synchronously.For example, under the higher situation of each input field same ratio of first image file and second image file, after each input field of first image file is finished the input processing, can be when starting the input of second image file, prompting further improves the input treatment effeciency of image file with the input content synchronization of each input field of first image file each input control to second image file.
Referring to Fig. 3, illustrate the structural representation according to the image file inputting device of embodiment of the present invention, this input media 300 specifically can comprise as lower unit:
Receiving element 301 is used for receiving image file by input control, described image file is sent to the excel worksheet shows, but wherein said image file comprises one or more input areas;
In the embodiments of the present invention, input media 300 can be combined with data carrier and library of object that excel provides, is deployed in the computer equipment, mainly realizes by Microsoft Visual Basic.Wherein, input media of the present invention can be divided into presentation layer, function treatment layer and infrastructure service layer from functional hierarchy, specifically can be as shown in Figure 4.Receiving element 301, unit 302 is set can belongs to presentation layer, processing unit can belong to the function treatment layer, and the infrastructure service layer can utilize library of object and the data carrier service of excel.Presentation layer can utilize the excel worksheet to show the image file that receiving element receives, and can add input control on worksheet, with the input tool of this input control as image file.
Receiving element 301 receivable image files can be the image files of jpeg format, such image file can corresponding voucher class file miscellaneous, for example can be bank cash on bank voucher, check only for account voucher, pay-in slip voucher, can also be the voucher such as warehouse-in document, freight bill, parcel post receipt of other industry.These voucher class files can be converted to corresponding format by scanner, and (for example, image file JPEG) for example, can be arranged to scanner resolution and be 96dpi, pantograph ratio and be 100, pattern is that black and white text scans.The image file that scanning obtains can be kept on the local computer.But the image file in the embodiment of the present invention can comprise one or more input areas, but the input field that input area like this can corresponding original certificate class file, for example, can be input fields such as user account, user name, address, fund type, capitalization date, small letter date in the voucher class file used of bank.
Receiving element 301 utilizes input control to obtain the jpeg format image file from local computer, and the image file that obtains is sent to the excel worksheet shows, but the image file in the embodiment of the present invention comprises one or more input areas, for example, can be voucher category information such as number of the account, date, the amount of money etc.But unit 302 is set at the input area of image file input control is set, but at the input area of correspondence an input control can be set, also a plurality of input controls can be set, those skilled in the art can arrange accordingly according to using needs.Unit 302 is set after but the input area of image file arranges input control, the position coordinates of input control can be set, can change the position of input control by the position coordinates of adjusting input control.Input control can be ActiveX control, can refer to the object on excel worksheet or forms in the present embodiment, is used alternately by user and application program.ActiveX control has event, and can merge with other controls, the event in the embodiment of the present invention can refer to the action that an object can be recognized, for example, mouse is double-clicked or is pressed certain keyboard etc. at keyboard, and can write code and make response at described action.For example, typical event can be worksheet event, forms event and control event etc.Input control in the embodiment of the present invention can be the TextBox control, and it is a kind of in the ActiveX control, can be used for obtaining input or shows text, is generally used for editable text.Text box can show a plurality of row, can enter a new line to text and make its size that meets control, can also add some basic formattings.
Input control in the embodiment of the present invention (for example, the TextBox control) different with the excel cell, it can be in the excel worksheet the optional position, and be not similar to constraint between the such cell of excel cell between each input control (for example, TextBox control).Thereby, the kind of the receivable image file of image file inputting device of the present invention is more various, and for the image file that changes (for example, when but change takes place in the input area of newly-increased image file or image file or input field), need not the update routine code, reduced the maintenance cost of software code significantly.
Input control in the embodiment of the present invention can be at random mobile at excel worksheet presentation layer by adjusting position coordinates, and can adjust position coordinates overlapping and dislocation placement at presentation layer by the unit is set, can satisfy comparatively complicated input, displaying demand.In addition, can also be by the various attributes that the unit arranges input control be set, comprise, but be not limited to, position coordinates, length, width, highly, font size etc., can arrange one or more of above-mentioned attribute, but further promote the diversity of the input area of image file.And, can also have backup and restore funcitons to control property.
It is multiple that but input area of the present invention or input field can have, and can classify to it, type according to classification is come control is named, for example, but for input area or the input field of user account correspondence, but can the input control called after number of the account input control of this input area or input field will be positioned at.In the embodiments of the present invention, also provide the maintenance function of input control, comprise increase, deletion input control.When the input field of image file increases input control, the image file that receives as the bottom reference frame, is inserted ActiveX control at the image file of excel worksheet, as the input tool of image file, for example can be form as shown in Figure 2.Because inserting ActiveX control must be at the VBE(Visual at this control place Basic Editor) object worksheet code area hand-coding response time code.For solving this technical matters, preserved the required response events code of various input controls in the embodiment of the present invention in advance in the worksheet code area of VBE correspondence.Comprise a lot of objects among the VBE, for example window, engineering, module, forms etc.VBA is a kind of macrolanguage of Visual Basic, can be used to the expanded application formula.In the embodiment of the present invention, utilize the VBA code to be implemented in the event response code that writes the input control correspondence in the VBE object of corresponding worksheet automatically by operation VBE object, make the reusability of input method code significantly improve.And, write the mode of code by this code, can increase at any time according to the input needs of image file and have the input control that response events is handled, and need not large-scale update routine code, improved the extensibility of input code widely.When the deletion input control, can remove the event response code of this input control in VBE.
For the response events code in the embodiment of the present invention, consider in VBE and preserve, from the maintenance of code or the reliability the escalation process, and the security of source code is set out, the response events code is packaged into DLL, by the forms in the interface interchange " designer " of " generic module " definition among the DLL and process and the function in " module ", finish event response and processing.For example, the mouse of presentation layer input control and button correspondence, KeyEvent respond the interface that all can define by the generic module of DLL and respond processing.In the embodiments of the present invention, but but can utilize corresponding input control to receive the input request of input equipment according to being somebody's turn to do the residing position coordinates of input area or input field at input area or input field, and according to the response events code execution input operation of importing the described input control of request call, wherein said input control comprises the response events code of the worksheet code area that is stored in the VBE correspondence in advance.It is pointed out that input equipment of the present invention comprises equipment such as mouse, keyboard, the input request of input equipment can be carried out with the form of clicking or double-clicking mouse, press a certain button of keyboard.For example, in one embodiment of the invention, " the amount in figures input control " in the excel worksheet receives user's mouse and double-clicks event, by the user's forms " amount of money typing forms " in the event response interface interchange designer that calls the DLL definition.When receiving amount in figures, trigger the change event at these " amount of money typing forms ", call the capital and small letter amount of money transfer process in the public module, amount in figures is converted to amount in Chinese character, the capital and small letter amount of money is shown in the amount of money input control of presentation layer simultaneously.In the embodiments of the present invention, can also carry out miscue to the input content of input control, for example, for amount in figures input forms, can limit and only receive the input of numeral and radix point.
In other embodiments of the present invention, mouse is double-clicked the date input control of presentation layer, trigger the DbClick event, response events code call date forms provide calendar to select input for the user, and the date that the user selects from calendar is passed to the date input control show, finish the filling in of input field of an image file.Again for example, in some embodiments, mouse is double-clicked number of the account, name in an account book, or any one input control in three input controls of mechanism of opening an account, trigger the DbClick event, response time code call account information typing forms, the key word of the search domain reception input of forms (for example, it can be number of the account, in name in an account book and the mechanism that opens an account any one) time, automatically trigger the change event of these forms, (comprise number of the account in this worksheet at the worksheet of preserving account information, information such as name in an account book and the mechanism that opens an account) search and the data that the key word of importing mates are selected matched data is presented at number of the account by mouse subsequently, name in an account book and three input controls of mechanism of opening an account.In other words, input media of the present invention can be finished the input of three input controls relevant with this input control by activating an input control, has significantly improved the input treatment effeciency of image file.In addition, in the embodiments of the present invention, but can also realize input area between the different images file or input field synchronously.For example, under the higher situation of each input field same ratio of first image file and second image file, after each input field of first image file is finished the input processing, can be when starting the input of second image file, prompting further improves the input treatment effeciency of image file with the input content synchronization of each input field of first image file each input control to second image file.
In sum, image file input method and device that embodiment of the present invention provides, insert the input field information that input control comes the input picture file by the presentation layer at the excel worksheet, under the situation that need not revise source program code, can receive diversified image file, greatly reduce the cost that program code is safeguarded, and be encapsulated as the DLL form by the response events code with input control and be stored in the worksheet of VBE correspondence, improved the reusability of program code and the reliability of code maintenance and upgrading.
Through the above description of the embodiments, those skilled in the art can be well understood to the present invention and can realize by the mode of software combined with hardware platform, can certainly all implement by hardware.Based on such understanding, all or part of can the embodying with the form of software product that technical scheme of the present invention contributes to background technology, this computer software product can be stored in the storage medium, as ROM/RAM, magnetic disc, CD etc., comprise that some instructions are with so that a computer equipment (can be personal computer, server, the perhaps network equipment etc.) carry out the described method of some part of each embodiment of the present invention or embodiment.
Above disclosed only is a kind of preferred embodiment of the present invention, can not limit the present invention's interest field certainly with this, and therefore the equivalent variations of doing according to claim of the present invention still belongs to the scope that the present invention is contained.
Claims (14)
1. an image file input method is characterized in that, comprising:
Receive image file by input control, described image file is sent to the excel worksheet shows, but wherein said image file comprises one or more input areas;
But the input area at described image file arranges input control, and the position coordinates that described input control is showed in described excel worksheet is set;
But utilize input control to receive the input request of input equipment at described input area according to described position coordinates, and carry out input operation according to the response events code of the described input control of described input request call, wherein said input control comprises the response events code of the worksheet code area that is stored in the VBE correspondence in advance.
2. the method for claim 1 is characterized in that, described input control comprises ActiveX control.
3. method as claimed in claim 2 is characterized in that, described input control comprises the TextBox control.
4. as any described method in the claim 1 to 3, it is characterized in that, described response events code is encapsulated as the DLL dynamic base, by forms and the public procedure in the module and the function in the interface interchange designer of generic module definition among the DLL, finishes event response and processing.
5. as any described method in the claim 1 to 3, it is characterized in that described input control is removable in described excel worksheet by adjusting described position coordinates.
6. method as claimed in claim 5 is characterized in that, described input control is by adjusting the overlapping and dislocation in described excel worksheet of described position coordinates.
7. method as claimed in claim 6 is characterized in that, by the attribute that the unit arranges described input control is set, described attribute comprise following one or more: position coordinates, length, width, highly, font size.
8. an image file inputting device is characterized in that, comprising:
Receiving element is used for receiving image file by input control, described image file is sent to the excel worksheet shows, but wherein said image file comprises one or more input areas;
The unit is set, but is used at the input area of described image file input control being set, and the position coordinates that described input control is showed in described excel worksheet is set;
Processing unit, but be used for utilizing input control to receive the input request of input equipment at described input area according to described position coordinates, and carry out input operation according to the response events code of the described input control of described input request call, wherein said input control comprises the response events code of the worksheet code area that is stored in the VBE correspondence in advance.
9. device as claimed in claim 8 is characterized in that, described input control comprises ActiveX control.
10. device as claimed in claim 9 is characterized in that, described input control comprises the TextBox control.
11. as any described device of claim 8 to 10, it is characterized in that, described response events code is encapsulated as the DLL dynamic base, by forms and the public procedure in the module and the function in the interface interchange designer of generic module definition among the DLL, finishes event response and processing.
12., it is characterized in that described input control is removable in described excel worksheet by adjusting described position coordinates as any described device of claim 8 to 10.
13. device as claimed in claim 12 is characterized in that, described input control is by adjusting the overlapping and dislocation in described excel worksheet of described position coordinates.
14. device as claimed in claim 13 is characterized in that, the described unit that arranges also is used for arranging the attribute of described input control, described attribute comprise following one or more: position coordinates, length, width, highly, font size.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101373334A CN103197855A (en) | 2013-04-19 | 2013-04-19 | Method and device for inputting image files |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101373334A CN103197855A (en) | 2013-04-19 | 2013-04-19 | Method and device for inputting image files |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103197855A true CN103197855A (en) | 2013-07-10 |
Family
ID=48720485
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013101373334A Pending CN103197855A (en) | 2013-04-19 | 2013-04-19 | Method and device for inputting image files |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103197855A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111130995A (en) * | 2019-12-16 | 2020-05-08 | 维沃移动通信有限公司 | Image control method, electronic device, and storage medium |
-
2013
- 2013-04-19 CN CN2013101373334A patent/CN103197855A/en active Pending
Non-Patent Citations (7)
| Title |
|---|
| EXCEL之家: "《别怕，Excel VBA其实很简单》", 31 October 2012, 人民邮电出版社 * |
| 何宗伍: "Excel实现票据套打高效化", 《华南金融电脑》 * |
| 刘德军: "用Excel轻松实现财务凭证封面套打", 《消费导刊》 * |
| 刘德军: "用Excel轻松实现财务凭证封面套打", 《消费导刊》, no. 09, 8 May 2009 (2009-05-08) * |
| 王鑫: "Excel在支票套打印模板设计中的应用", 《中国管理信息化》 * |
| 韩加国: "《Excel VBA从入门到精通》", 31 August 2009, 化学工业出版社 * |
| 魏汪洋: "《从零开始学Excel VBA》", 28 February 2011, 电子工业出版社 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111130995A (en) * | 2019-12-16 | 2020-05-08 | 维沃移动通信有限公司 | Image control method, electronic device, and storage medium |
| CN111130995B (en) * | 2019-12-16 | 2021-08-10 | 维沃移动通信有限公司 | Image control method, electronic device, and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR101203335B1 (en) | Using a word processor with accounting data | |
| US9400806B2 (en) | Image triggered transactions | |
| US10169320B2 (en) | Assistive technology for the visually impaired | |
| US9213893B2 (en) | Extracting data from semi-structured electronic documents | |
| CN102939612A (en) | Merging modifications to user interface components while preserving user customizations | |
| CN104123608B (en) | A kind of method and apparatus for establishing accounting records | |
| WO2009018296A1 (en) | Method for data interchange | |
| CN102831741A (en) | Transaction information processing system and processing method thereof | |
| US20130265592A1 (en) | System and method for creating multi-formatted documents via an online portal | |
| US20110204138A1 (en) | Bank account consolidated management system | |
| CN103019636A (en) | Voucher design printing method and system | |
| EP2775444A1 (en) | Information processing system, information processing apparatus, method of controlling an information processing apparatus, and program | |
| CN103136776A (en) | Invoice face value dynamic allocation method | |
| CN102044091A (en) | Self-service ticketing system | |
| CN202887310U (en) | Client device and teller device | |
| CN103092479B (en) | A kind of methods, devices and systems by right button transitional information | |
| US8564808B2 (en) | Systems and methods for processing of variable documents | |
| JP2010244227A (en) | Accounting input storage device | |
| CN112270594B (en) | Salary data display method, device, computer equipment and storage medium | |
| CN102479353A (en) | Method and device for generating reimbursement list by using credit card in enterprise resource planning (ERP) system and ERP system | |
| CN102982624A (en) | Printing method for point-of-sale (POS) machine trading center based on threshold limit value (TLV) format data | |
| AU2019100146A4 (en) | Digital Invoice Wallet: Methods, Applications, Systems and Processes for Transferring Invoices to Buyers Seamlessly in Digital Format without the Need for Buyers to Share Their Personal Details | |
| JP2018206289A (en) | Accounting processing support system, method and program | |
| CN107528839A (en) | The collocation method and device of a kind of interface packets | |
| CN103197855A (en) | Method and device for inputting image files |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130710 |