JP2010205140A - Form output method and form processing system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable a system user to change a format without relying on a program and store in a form and print/output data corresponding to a formula calculation result and graph display or the like. <P>SOLUTION: An administrative client terminal 1 obtains format data whose definition is to be changed from a form format Excel data management DB 6, and changes format definition by operation on an Excel application. A user client terminal 10 starts a form output processing part 8 using a form ID as a parameter. The form output processing part obtains the data required for the specified form ID from the form data management DB 6 and the form format Excel data corresponding to the specified form ID from a form format Excel data management DB 7, creates a print image file, and delivers the file to the user client terminal 10 for printing. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a form output method and a form processing system, and in particular, in order to output accumulated electronic data as a form, a change in form format is defined, and data is stored at a predetermined position in the form format. The present invention relates to a form output method and form processing system.

  Conventionally, in the processing of a form using an information processing system, it is necessary to change the program in order to change the form format. In order to respond to the format change requested by the system user, a program in the system is required. It was necessary to change and respond.

  For this reason, for example, a technique described in Patent Document 1 or the like has been proposed as a conventional technique that can flexibly cope with a form format change. This prior art is to register elements output to a form and their coordinate positions in a DB so that the form can be automatically generated, and the form processing is independent of the program in the system. .

Japanese Patent Laid-Open No. 11-73472

  As described above, conventionally, changing the format of a form requires a program change in the system. In order to output a form in the format requested by the system user, the system user needs to have programming knowledge for the corresponding system. Had to have. For this reason, this conventional technique causes a problem that it is difficult for a user who does not have programming knowledge of the system to change the form format.

  The prior art described in Patent Document 1 can register a form element and its coordinate position in a DB and automatically generate a form format definition without a program. In addition, if it is necessary to display the calculation results using mathematical formulas as part of the format change on the form, it is necessary to change the program for the corresponding system. It was necessary to have programming knowledge. For this reason, as in the case described above, this conventional technique also has a problem that it is difficult for a user who does not have programming knowledge about the system to change the form format.

  In view of the above-described points, the object of the present invention is to allow the system user to change the format without a program in registering and outputting the format of the form, and to provide data corresponding to the calculation result, graph display, etc. An object is to provide a form output method and a form processing system which can be stored in a form and printed out.

  According to the present invention, the object is to provide a form output method in a form processing system for outputting electronic data stored in the system as a form. The form processing system includes a server, a management client terminal, and a user client terminal. The server includes an Excel application installed, an Excel add-in file in which a built-in function is defined, a form data management DB, and a form format Excel data management DB. And a management client terminal connected to the server acquires the format data whose definition is to be changed from the form format Excel data management DB in the server by specifying the form ID, Acquired form format Operate on the Excel application, change the format definition of the form body part, upload the changed form format in which the value of the function of the Excel add-in file is placed at any place in the form body part to the server, and The connected user client terminal starts up the form output processing unit in the server by setting the form ID as a parameter, and the form output processing unit converts the data necessary for the designated form ID into the form data Acquires from the management DB, acquires the form format Excel data corresponding to the specified form ID from the form format Excel data management DB, operates the form format Excel data with the Excel application, and stores the form data in the form format. And E The function of the cel add-in file is operated, arbitrary defined information is arranged in the body part of the form format, a print image file of the form body part is created and stored, and the user client terminal outputs the form This is achieved by downloading a print image file from the processing unit and causing the printer to print it.

  According to the present invention, since it is possible to define an arbitrary form format using a familiar general-purpose application without requiring programming knowledge in the system, the amount of work for changing the form format can be greatly reduced. It is possible to flexibly respond to various format definition requests using the Excel function.

It is a block diagram which shows the structure of the form processing system by one Embodiment of this invention. It is a figure explaining operation | movement until it registers and prints a form format with the form output method by one Embodiment of this invention. It is a figure explaining the internal structure of Excel data at the time of form format registration by embodiment of this invention. It is a figure explaining the internal structure of Excel data at the time of the form output by embodiment of this invention.

  Embodiments of a form output method and form processing system according to the present invention will be described below in detail with reference to the drawings.

  FIG. 1 is a block diagram showing the configuration of a form processing system according to an embodiment of the present invention, and FIG. 2 is a diagram for explaining operations until a form format is registered and printed by a form output method according to an embodiment of the present invention. FIG. 3 is a diagram for explaining the internal structure of Excel data when registering a form format according to the embodiment of the present invention. FIG. 4 is a diagram for explaining the internal structure of Excel data when outputting a form according to the embodiment of the present invention.

  As shown in FIG. 1, a form system according to an embodiment of the present invention includes a server 2, a user client terminal 10 used by a user, and a management client terminal 1 used by a system administrator via a network. Connected and configured. A printer 11 that outputs a form is connected to the network or the user client terminal 10.

  As described above, the server 2 includes the main storage device 101, the external storage device 102 such as an HDD, the CPU 103, and the communication device 104 for connection to a network. The main storage device 101 is loaded with a form print processing unit 8 for outputting a form according to the embodiment of the present invention. The form print processing unit 8 is constituted by a program and is executed by the CPU 103 to construct functions necessary for the present invention. The form print processing unit 8 acquires a form data and a form format. The function unit 82 stores the form data in the form format data area, and the function unit 83 holds the print image of the form body part in Excel data. The external storage device 102 stores a form format, Excel data management DB 6 and form data management DB 7 used in the present invention.

  The management client terminal 1 manages the form format, and an Excel application is installed in the terminal 1 and an Excel add-in file 4 in which an embedded function is defined is arranged. The server 2 is operated by a system having a form format registration / printing function according to the present invention. An Excel application is installed in the server 2 and an Excel add-in in which a built-in function is defined. File 9 is arranged.

  The above-described Excel add-in file is an API function in which a unique logic is embedded, and can be used as an Excel function. The Excel add-in file arranged in the embodiment of the present invention is designated as 18 in FIG. As shown, if the Excel sheet name, key information for data search, and column name to be acquired are set, the row that matches the key information is selected and specified in the data of the table structure existing in the corresponding sheet. A function that extracts data that matches the column name and returns the value is embedded. The same Excel add-in file is arranged in the management client terminal 1 and the server 2.

  As shown in FIG. 3B, Excel data, which is a form format, is divided into a form body part (sheet) 19 and a form data part 20, and the format 22 of the form body part is preliminarily created when the format is created. By defining 21 the function call of the Excel add-in file 18 defined therein, the form print processing unit 8 outputs a table structure to the data unit 20 as shown in FIG. By storing the data 23, the function of the Excel add-in file 18 described above operates, the corresponding data is extracted from the data 23 of the data part 20, and is shown as 24 in the form body part in FIG. Set to be. As a result, data extracted from the data part is stored at a predetermined position of the form.

  The table structure data 23 set here is the table structure data defined in the form data management DB 7, and the key information is table key information that can uniquely identify a row in the table structure data. It is. The form print processing unit 8 sets a table name in the form data management DB 7 to a new sheet in the target Excel data, and performs data arrangement of the corresponding table.

  Next, with reference to FIG. 2, the processing operation of the form format registration according to the embodiment of the present invention will be described.

(1) First, the management client 1 acquires the format data whose definition is to be changed from the form format Excel data management DB 6 on the server 2 by specifying the form ID, and downloads the file to the management client 1 ( Process 12).

(2) Next, the downloaded form format (Excel data) 3 is operated on the Excel application to change the format definition of the form body part. At that time, the table name in the form data management DB 7 storing the data to be displayed on the form is designated as a parameter for designating the sheet in the above-described API function of the Excel add-in file. As key information for data search, information that can select a unique row in the corresponding table is specified, and a column name that is a data acquisition target in the uniquely selected row is specified. Then, the modified form format (Excel data) 5 in which the value of this function is arranged at an arbitrary place in the form body part is uploaded to the server 2 (process 13).

  With the above processing, a new form format in which a form format is arbitrarily defined can be registered.

  The print image of the form format registered here is as shown in the form body part format 22 in FIG. 3B. The line and column framework, the colors attached to the columns, and the like are as described above. Is defined as a form format.

  Next, with reference to FIG. 2, the processing operation of the form output according to the embodiment of the present invention will be described.

(1) The user client terminal 10 activates the form output processing unit 8 in the server 2 by setting the form ID as a parameter (process 16).

(2) In the activated form output processing unit 8, the function unit 81 that acquires the form data and the form format acquires data necessary for the designated form ID from the form data management DB 7, and The form format Excel data corresponding to the designated form ID is acquired from the form format Excel data management DB 6 (processes 14 and 15).

(3) Then, the function unit 82 for storing the form data in the form format data area operates the form format Excel data from the Excel application, and stores the above-described form data in the form format Excel data. Data storage here refers to creating an Excel sheet for each form of the acquired table name and storing the data of the corresponding table in each sheet.

(4) When the data storage is completed, the API function of the Excel add-in file operates and any defined information is arranged in the form body part of the form format Excel data. The function unit 83 that holds the print image of the form body part in Excel data of the form print processing unit 8 creates and saves a print image file of the form body part.

(5) The user client terminal 10 downloads the created print image file, and uses the printer 11 connected to the client terminal 10 for the user or connected to the network to obtain the print image file. Print.

  As described above, a series of processing of form format change / registration and form output is completed.

  Each process in the above-described embodiment of the present invention is configured by a program and can be executed by a CPU included in the present invention. These programs are stored in a recording medium such as an FD, CDROM, or DVD. It can be provided and can be provided by digital information via a network.

1 Client terminal for management 2 Server 3 Form format (Excel data)
4, 9, 18 Excel add-in file 5 Changed form format Excel data 6 Form format Excel data management DB
7 Form data management DB
8 Form print processing section 10 Client terminal 11 Printer 19 Form body section (sheet)
20 Form data part (sheet)
21 Function definition in the Excel file in the form body part 22 Format of the form body part 23 Table structure data defined in the form data management DB 81 Function part for obtaining the form format and form data 82 Form data Functional unit that stores the image in the form format data area 83 Functional unit that holds the print image of the form body part in Excel data

Claims (2)

In the form output method in the form processing system for outputting the electronic data stored in the system as a form,
The form processing system includes a server, a management client terminal, a user client terminal, and a printer.
The server includes an Excel add-in file in which an Excel application is installed and a built-in function is defined, and includes a form data management DB, a form format Excel data management DB, and a form print processing unit.
The management client terminal connected to the server acquires the format data whose definition is to be changed from the form format Excel data management DB in the server by specifying the form ID, and operates the acquired form format on the Excel application. Change the format definition of the form body part, upload the changed form format in which the value of the function of the Excel add-in file is arranged at an arbitrary location of the form body part to the server,
The user client terminal connected to the server starts the form output processing unit in the server by setting the form ID as a parameter,
The form output processing unit obtains data necessary for the designated form ID from the form data management DB, obtains form format Excel data corresponding to the designated form ID from the form format Excel data management DB, Operate the form format Excel data with the Excel application, store the form data in the form format, operate the functions of the Excel add-in file, place the defined arbitrary information in the body part of the form format, Create and save a print image file of the body part,
The form output method, wherein the user client terminal downloads a print image file from the form output processing unit and causes a printer to print it. In the form processing system to output the electronic data stored in the system as a form,
A server, a management client terminal, a user client terminal, and a printer;
The server includes an Excel add-in file in which an Excel application is installed and a built-in function is defined, and includes a form data management DB, a form format Excel data management DB, and a form print processing unit.
The management client terminal connected to the server acquires the format data whose definition is to be changed from the form format Excel data management DB in the server by specifying the form ID, and operates the acquired form format on the Excel application. Change the format definition of the form body part, upload the changed form format in which the value of the function of the Excel add-in file is arranged at an arbitrary location of the form body part to the server,
The user client terminal connected to the server starts the form output processing unit in the server by setting the form ID as a parameter, and causes the form output processing unit to create a print image file. Download the print image file, print it on the printer,
The form output processing unit obtains data necessary for the designated form ID from the form data management DB, obtains form format Excel data corresponding to the designated form ID from the form format Excel data management DB, Operate the form format Excel data with the Excel application, store the form data in the form format, operate the functions of the Excel add-in file, place the defined arbitrary information in the body part of the form format, A form processing system that creates and saves a print image file of the body part.

Images