JP4068008B2 - Spreadsheet software linkage processing apparatus and method - Google Patents

Description

[0001]
[Industrial application fields]
The present invention relates to a data processing system that performs business processing using a terminal computer such as a personal computer or a workstation (hereinafter referred to as PC / WS) and a host computer, and spreadsheet software that operates on the PC / WS; The present invention relates to spreadsheet software linkage processing that enables online linkage processing with a program or data on a host computer.
[0002]
[Prior art]
In recent years, in order to perform business processing and the like, an increasing number of users introduce spreadsheet software that operates on a PC / WS. Accordingly, it is desired to improve the efficiency of business processing and the like by linking the spreadsheet software on the PC / WS with the processing on the host computer connected to the PC / WS via a line.
[0003]
An example of a conventional spreadsheet software cooperation processing apparatus is shown in the prior application “Spreadsheet software cooperation processing apparatus” (Japanese Patent Laid-Open No. 5-73590). In this spreadsheet software cooperation processing apparatus, first, a prototype worksheet that is definition information of tabular data created by spreadsheet software is transmitted from the PC / WS to the host computer. Based on the received original worksheet, the host computer creates a record area source sentence that defines the record area in the table and a worksheet format definition body that is format information necessary for creating the distribution worksheet. Then, a record area source sentence is incorporated into an application program that performs database processing or the like on the host computer, and the application program is executed. The application program outputs a specific data processing result as a record designated by the record area source sentence. Next, while referring to the worksheet format definition body, the host computer embeds the contents of the record output by the application program in a table to create a table-type distribution worksheet. Since the distribution worksheet is created based on the original worksheet sent from the PC / WS, it is in a format that can be processed by the spreadsheet software on the PC / WS. The created distribution worksheet is transmitted from the host computer to the PC / WS and used as a processing target of the spreadsheet software. The spreadsheet software performs table data reorganization and display processing based on the distribution worksheet.
[0004]
Thus, according to the conventional spreadsheet software cooperation processing apparatus, the distribution worksheet embedded with the data on the host can be automatically distributed from the host computer to the PC / WS. The data input process is improved.
[0005]
[Problems to be solved by the invention]
However, the conventional spreadsheet software cooperation processing apparatus has the following problems.
[0006]
The conventional spreadsheet software linkage processing device was able to deliver a worksheet from the host computer to the PC / WS, but the worksheet entered using the PC / WS spreadsheet software was operated on the host computer. In order to use it as an application program and to use it as host computer data, it is necessary to incorporate special processing in consideration of the characteristics of spreadsheet software. However, since the worksheet format definition is not open to the user, the contents cannot be used. Therefore, for the data input to the host computer using a table meter Sanso software, the user must perform the task of incorporating the complex processing to the application program.
[0007]
In addition, regarding the distribution of the worksheet to the PC / WS, it is necessary to newly create an application program for distributing the worksheet that operates on the host computer. Therefore, in order to input data from the host computer to the PC / WS, the user must create a new application program.
[0008]
The present invention provides a spreadsheet software linkage processing apparatus and method capable of easily performing linkage processing between spreadsheet software on a terminal computer such as a PC / WS and a program or data on a host computer. With the goal.
[0009]
[Means for Solving the Problems]
FIG. 1 is a diagram showing the principle of an information processing system provided with a spreadsheet software cooperation processing apparatus according to the present invention in a host computer 1 . The information processing system in FIG. 1 includes a host computer 1 and a terminal computer 21 connected via an online line, and a display device 25 for the terminal computer 21. The terminal computer 21 includes a transmission unit 22, a reception unit 23, and a spreadsheet software 24. Further, the spreadsheet software linkage processing device in the host computer 1 includes a communication processing unit 2, a record area source sentence generation means 4, a worksheet format definition body generation means 5, an application program execution means 7, and a data input worksheet analysis. Means 9, form print data creation means 12, and delivery worksheet creation means 14 are provided.
[0010]
In FIG. 1, the spreadsheet software 24 on the terminal computer 21 performs a spreadsheet process and displays the table on the display device 25. The transmission means 22 transmits the original worksheet 3 and the data input worksheet 11 created by the spreadsheet software 24 to the communication processing unit 2 via the online line.
[0011]
The communication processing unit 2 receives the prototype worksheet 3 and the data input worksheet 11 generated by the spreadsheet software 24 from the terminal computer 21. The record area source sentence generation means 4 analyzes the definition information on the individual data of the table constituting the prototype worksheet 3, and generates the record area source sentence 6 including the array data of the record area.
[0012]
The worksheet format definition body generating unit 5 generates a worksheet format definition body 10 including definition information on the form of the worksheet from the original worksheet 3.
[0013]
Application program execution unit 7, the record area source text 6 produced is incorporated, performed by referring to row earthenware pots Applied program processes input data notified in the record area specified by the record area source text 6 To do.
[0014]
Data input worksheet analyzing means 9, with reference to the work sheet format definition 10 analyzes the data input worksheet 11 generates input data, the input data in the record area of the application program Notice.
[0015]
The application program execution means 7 executes an application program that instructs the output of the form print data 13 used for printing the form usable by the spreadsheet software 24 as data.
[0016]
In response to an instruction from the application program, the form print data creation means 12 creates form print data 13, and the distribution worksheet creation means 14 refers to the form appearance definition information 16 relating to the form appearance described above. A distribution worksheet 15 is created from the printed form print data 13.
[0017]
The communication processing unit 2 transmits the distribution worksheet 15 to the terminal computer 21.
On the other hand, the receiving means 23 of the terminal computer 21 receives the distribution worksheet 15 from the communication processing unit 2 via the online line, and the spreadsheet software 24 performs processing using the data included in the distribution worksheet 15. .
[0018]
[Action]
The terminal computer 21 and the host computer 1 exchange worksheet information such as the original worksheet 3, the data input worksheet 11, and the distribution worksheet 15, and perform cooperative processing related to spreadsheets.
[0019]
First, in the host computer 1, the record area source sentence 6 is automatically generated by the record area source sentence generation means 4 from the original worksheet 3 created using the spreadsheet software 24 on the terminal computer 21, and the application program Can incorporate the record area source sentence 6. Also, a worksheet / format definition body 10 is generated from the same original worksheet 3 by the worksheet / format definition body generation means 5, and the data input worksheet analysis means 9 uses this to generate a data input worksheet 11. Can be analyzed.
[0020]
Both the record area source sentence 6 and the worksheet format definition body 10 are generated from the same original worksheet 3 and have common information on the attributes of the data items. The application program execution means 7 receives the input data converted into the format of the record area source sentence 6 by the data input worksheet analysis means 9 and causes the application program to perform processing such as calculation using the input data.
[0021]
As a result, the data created by the spreadsheet software 24 is automatically input to the application program, and the rich operability of the spreadsheet software 24 can be utilized for data input processing to the host computer 1. In addition, data can be input to the host computer more easily than a conventional spreadsheet software cooperation processing apparatus.
[0022]
When the application program issues an instruction to output the form print data 13, the form print data creation unit 12 creates the form print data 13 in accordance with the form defined by the form appearance definition information 16. The form print data 13 is data conventionally used to print a form in the host computer 1, and the printed form has a format approximate to a table created by the spreadsheet software 24. From the form print data 13, a distribution worksheet 15 in a form that can be processed by the spreadsheet software 24 is generated by the distribution worksheet generation means 14. At this time, the data item information included in the form appearance definition information 16 is referred to.
[0023]
The created distribution worksheet 15 is transmitted to the terminal computer 21 by the communication processing unit 2, and the spreadsheet software 24 performs processing such as spreadsheet using data included therein.
[0024]
As a result, the contents of the form output by the host computer 1 are automatically input to the terminal computer 21 and can be used for the processing of the spreadsheet software 24. Further, it is not necessary to create a new distribution program as compared with the conventional spreadsheet software cooperation processing apparatus, and data can be distributed more easily.
[0025]
【Example】
Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
FIG. 2 is a configuration diagram of the spreadsheet software cooperation processing apparatus according to the first embodiment of this invention. 2 is provided in the host computer 1 of FIG. 1, and includes a record area source sentence generation unit 31, a worksheet format definition body generation unit 32, and a data input worksheet analysis unit 33. . The record area source sentence generation unit 31, the worksheet format definition body generation unit 32, and the data input worksheet analysis unit 33 are realized by an arithmetic processing function of a CPU (central processing unit) (not shown) in the host computer 1. .
[0026]
In FIG. 2, the prototype worksheet 3 is created by the spreadsheet software 24 of the terminal computer 21, then transmitted to the host computer 1 and received by the communication processing unit 2. In this example, the original worksheet 3 describes a table composed of three columns A, B, and C. The first row to the sixth row represent the array of cells in the table, and the seventh row to the tenth row. Up to the eye is the record data item description section.
[0027]
“January sales” in the first row represents an annotation for the entire table, and “Product name”, “Quantity”, and “Sales” in the second row correspond to the data items in columns A, B, and C, respectively. Represents a headword. “! A”, “! B”, and “! C” in the third line represent variable names corresponding to “product name”, “quantity”, and “sales”, respectively. The results of data processing in the host computer 1 are stored in these variables. The fourth and fifth lines are the same as the third line. “Total” on the 6th line is a headword that represents the total for each product name on the 3rd to 5th lines. “@SUM (B3: B5)” is a variable on the 3rd to 5th lines! This represents a function for calculating the sum of B, and “@SUM (C3: C5)” is a variable on the 3rd to 5th lines! This represents a function for calculating the sum of C.
[0028]
“RECORD NAME = REC001” on the seventh line represents the record definition, and the eighth to ninth lines represent the description of each data item. For example, “A DATA PIC = (N, 8)...” On the 8th line is a variable! This indicates that the data type of A is N (Japanese) and the length is 8 characters, and “B DATA PIC = (9,6)... It represents that the data type of B is 9 (numeric) and the length is 6 characters (6 digits). The 10th line is the same as the 9th line.
[0029]
The record area source sentence generation unit 31 analyzes the record / data item description part of the prototype worksheet 3 and generates the record area source sentence 6. In this embodiment, the application program 34 described in the COBOL language generates the record area source sentence 6 as the COPY library 35 that can be incorporated into the program by the COPY phrase.
[0030]
The worksheet format definition body generation unit 32 refers to the original worksheet 3 and generates a worksheet format definition body 10 including cell information and data item information. In this embodiment, the format is generated as a format library 36 having the worksheet format definition body 10 as a member.
[0031]
The application program 34 incorporates the record area source sentence 6 into the program by a COPY phrase “COPY REC001”, and issues an OPEN instruction, a READ instruction, and a CLOSE instruction. The OPEN command opens a display file having the record specified by the record area source sentence 6 as its component, reads the contents of the display file by a READ command, and closes the display file by a CLOSE command. Here, the display file refers to a virtual file for accessing a display, a printer, or the like, and includes the contents of the data input worksheet 11 in this embodiment.
[0032]
The data input worksheet 11 is a worksheet in which variables and function values in the table of the original worksheet 3 are replaced with specific input data. After being generated by the spreadsheet software on the terminal computer 21, the host computer 1 is transmitted. The data input worksheet analysis unit 33 refers to the worksheet format definition body 10, extracts input data from the received data input worksheet 11, and applies it to the application program 34 incorporating the record area source sentence 6. The input data is notified in the same format as the record area source sentence 6. At this time, the input data is converted into the format of the record area source sentence 6, and the application program 34 can perform processing using individual data input from the terminal computer 21.
[0033]
FIG. 3 shows an example of a worksheet format definition body 10 corresponding to the original worksheet 3 of FIG. The worksheet format definition body 10 shown in FIG. 3 includes cell information 41 and data item information 42. The cell information 41 includes a cell address indicating the position of the cell in the table of the original worksheet 3, a cell type indicating the cell type, a specific character string / variable name / function which is the content of the cell, and other cells. An attribute is described. In the data item information 42, a variable name corresponding to the data item, a data type indicating the variable type, an item length indicating the variable length, an offset in the corresponding record, and the number of repetitions of the same variable are described. The
[0034]
FIG. 4 shows an example of a data input worksheet 11 corresponding to the original worksheet 3 of FIG. The data input worksheet 11 shown in FIG. 4 includes the variables “! A”, “! B”, “! C” on the 3rd to 5th rows and the function “6” on the 6th row in the table of the original worksheet 3 in FIG. @SUM (B3: B5) ”and“ @SUM (C3: C5) ”are each replaced with specific data.
[0035]
Next, the record area source sentence generation process by the record area source sentence generation unit 31 and the worksheet format definition body generation process by the worksheet format definition body generation unit 32 will be described with reference to FIGS.
[0036]
FIG. 5 is a flowchart of the record area source sentence generation process. For example, the record area source sentence 6 is generated from the original worksheet 3 of FIG. 2 by the record area source sentence generation process of FIG. When the process is started in FIG. 5, the record area source sentence generation unit 31 first extracts definition information about the record or data item from the record / data item description unit of the prototype worksheet 3 (step S <b> 1). If there is no definition information, it is determined that the record / data item description portion has ended (step S2, Yes), and the process ends. Next, it is determined whether or not the extracted definition information corresponds to a record definition (step S3). If it is a record definition, a record statement generation process is performed (step S5). And the process after step S1 is repeated.
[0037]
For example, since the definition information on the seventh line of the original worksheet 3 in FIG. 2 corresponds to the record definition, “01” is set as the level information, and the designated record name is set (step S5). As a result, “01 REC001” in the first line of the record area source sentence 6 in FIG. 2 is generated.
[0038]
If the definition information relates to the data item in step S3, a data sentence generation process is performed (step S4). In the data sentence generation process, level information is set, a data item name, a data item attribute, and a data item length are obtained and set. And the process after step S1 is repeated.
[0039]
For example, the definition information on the eighth line of the original worksheet 3 in FIG. 2 corresponds to the first data item definition, so level information “02” is set, and the group item name “REC001-DATA” of the data item is set. . This group item name is added to identify an array of data items set to a lower level “10”. Next, level information “10” and data item name “A” are set. Further, the data item attribute and the data item length are combined and set as array data such as “OCCURS 3” and “PIC N (8)”. Here, N (8) represents a Japanese character string having a data item length of 8, and “OCCURS 3” represents that the same type of character string is repeated three times. The same processing is performed for the definition information on lines 9 and 10 to generate a data sentence of level “10”.
[0040]
FIG. 6 is a flowchart of the worksheet format definition body generation process. 6, for example, the worksheet format definition body 10 in FIG. 3 is generated from the original worksheet 3 in FIG. 2. When the processing is started in FIG. 6, the worksheet format definition body generating unit 32 first substitutes 1 for each of the control variables m and n (steps S11 and S12), and m rows n of the original worksheet 3 Cell information of the column is extracted (step S13). Next, it is determined whether the extracted cell information is a variable cell or a fixed value cell (step S14). If it is a variable cell, variable cell conversion processing is performed (step S15). If it is a fixed value cell, fixed value cell conversion processing is performed. Is performed (step S16). Note that a cell for which a function is set is processed as a fixed value cell.
[0041]
Next, it is determined whether or not cell information of all columns in m rows has been extracted (step S17). If the extraction of cell information has not been completed, n is set to n + 1 (step S18), and the processing after step S13 is performed. repeat. If extraction of cell information for all columns is completed in step S17, it is next determined whether or not cell information for all rows has been extracted (step S19). If the extraction of the cell information has not been completed, m is set to m + 1 and n is set to 1 (steps S20 and S21), and the processes after step S13 are repeated. When it is determined in step S19 that extraction of cell information for all rows has been completed, the process ends.
[0042]
In the variable cell conversion process in step S15, attribute information is extracted from the cell information, and the cell and the data item are associated with each other and converted into worksheet format definition information. For example, since the cell information of 3 rows and 1 column (3 rows and A columns) in FIG. 2 represents the variable “! A”, the cell information “A3” corresponding to the cell information 41 in the worksheet format definition body 10 in FIG. ”, Cell type“ variable ”, and variable name“ A ”are set, and associated with the variable name“ A ”in the data item information 42 using the pointer. In the column of the variable name “A” in the data item information 42, the data type “N”, the item length “8”, the in-record offset “0”, and the repetition number “3” are set. “(First in the array)” in the variable name column of the cell information 41 represents the first of the variables of the same name repeated three times. Similar processing is performed for the other variable cells.
[0043]
Further, in the fixed value cell conversion processing in step S16, attribute information and character string information are extracted from the cell information and converted into worksheet format definition information. For example, the cell information of 1 row 1 column (1 row A column) in FIG. 2 represents the fixed value “January sales”, so the cell information 41 includes the corresponding cell address “A1”, cell type “fixed value”. ", The character string" Sales for January "is set. In the case of a fixed value cell, unlike the case of a variable cell, it is not necessary to associate with the data item information 42. Similar processing is performed for other fixed value cells.
[0044]
By repeating such processing, a worksheet format definition body 10 as shown in FIG. 3 is finally generated.
The application program 34 in which the record area source sentence 6 is incorporated by the COPY phrase reads the data input worksheet 11 from the display file by the READ instruction, and causes the data input worksheet analysis unit 33 to analyze the contents. Next, processing of the READ instruction and data input worksheet analysis processing by the data input worksheet analyzer 33 will be described with reference to FIGS.
[0045]
FIG. 7 is a processing flowchart of the READ instruction. When the processing is started in FIG. 7, the application program 34 first checks the parameters of the display file (step S31), and if it is found that the data input worksheet 11 received from the terminal computer 21 is included, this is stored in the memory. (Step S32). Then, the data input worksheet analysis unit 33 is called to request analysis of the captured data input worksheet 11, and an input record is generated (step S33). Next, a return code is set (step S34), and the process returns to the processing of the next instruction of the application program 34.
[0046]
FIG. 8 is a flowchart of the data input worksheet analysis process performed by the data input worksheet analyzer 33 called in step S33 of FIG. When the processing is started in FIG. 8, the data input worksheet analysis unit 33 first substitutes 1 for each of the control variables m and n (steps S41 and S42), and the m rows of the data input worksheet 11 The n columns of cell information are extracted (step S43). Next, referring to the worksheet format definition body 10, it is determined whether the extracted cell information is a variable cell or a fixed value cell (step S44). At this time, the cell in which the function is set is included in the fixed value cell.
[0047]
For example, the cell address of the cell in the 1st row and 1st column (1st row A column) of the data input worksheet 11 in FIG. 4 is A1, and the cell type corresponding to the cell address A1 in the cell information 41 in FIG. 3 is a fixed value. Therefore, it can be seen that this cell is a fixed value cell. Similarly, the cell address of the cell in the 3rd row and 1st column (3rd row and A column) of the data input worksheet 11 is A3, and the cell type corresponding to the cell address A3 in the cell information 41 is a variable. It can be seen that the cell is a variable cell. In addition, since the cell address of the cell of 6 rows and 2 columns (6 rows and B columns) is B6 and the corresponding cell type is a function, this cell is treated as a fixed value cell.
[0048]
In the case of a fixed value cell, the character string information is already set in the worksheet format definition body 10, so that it is not necessary to read it. Therefore, it is determined whether or not cell information of all columns of m rows has been extracted (step S46). If the extraction of cell information has not been completed, n is set to n + 1 (step S47), and the processing after step S43 is performed. repeat. If the extraction of the cell information of all the columns is completed in step S46, it is next determined whether the cell information of all the rows has been extracted (step S48). If the extraction of the cell information has not been completed, m is set to m + 1 and n is set to 1 (steps S49 and S50), and the processes after step S43 are repeated. Then, when it is determined in step S48 that the extraction of the cell information of all the rows has been finished, the processing is finished.
[0049]
In the case of a variable cell in step S44, input data conversion processing is performed to read the information (step S45), and processing subsequent to step S46 is performed. In the input data conversion process, character string information is extracted from the variable cell, and the data item information corresponding to the variable cell at the cell address is obtained by referring to the worksheet format definition body 10. Then, the character string extracted from the variable cell is converted in accordance with the data type specified by the data item information and assembled as a record.
[0050]
For example, since the cell of 3 rows and 1 column (3 rows and A columns) of the data input worksheet 11 is a variable cell, the character string “Japanese sake” is extracted. Next, the data item information 42 is accessed using the pointer stored in the cell address A3 in the cell information 41 of the worksheet format definition body 10, and the data type, item length, and record in the corresponding variable name A Get the offset. Then, the character string “Japanese sake” is converted in accordance with the data item information to generate an input record. Further, since the cell in the 3rd row and 2nd column (3rd row and B column) of the data input worksheet 11 is also a variable cell, the character string “100” is extracted. Next, the data item information 42 is accessed using the pointer stored in the cell address B3 in the cell information 41, and the corresponding variable name B information is obtained. Then, the character string “100” is converted in accordance with the data item information, and an input record suitable for the format of the record area source sentence 6 is generated. Similar processing is performed for the other variable cells.
[0051]
When the character strings are extracted from all the variable cells included in the data input worksheet 11 in this way, the data input worksheet analysis unit 33 notifies the application program 34 of the generated input record. The application program 34 reads an input record using the incorporated record area source sentence 6 and performs processing such as calculation.
[0052]
According to the first embodiment, the data input worksheet analysis unit 33 automatically extracts input records from the data input worksheet 11 by using the worksheet format definition body 10. Data input from 24 to the application program 34 is facilitated.
[0053]
Although the application program 34 is described in the COBOL language in the first embodiment, the present invention can be similarly applied to application programs described in other languages. The original worksheet 3 shown in FIG. 2 is only an example, and can correspond to other arbitrary table data. In this case, the record area source sentence 6 and the worksheet format definition body 10 corresponding to the original worksheet 3 are also generated.
[0054]
Next, a second embodiment of the present invention will be described with reference to FIGS.
FIG. 9 is a configuration diagram of a spreadsheet software cooperation processing apparatus according to the second embodiment of this invention. The spreadsheet software cooperation processing apparatus of FIG. 9 is provided in the host computer 1 of FIG. The distribution worksheet creation unit 53 is realized by the arithmetic processing function of the CPU in the host computer 1. 9 is a printing device such as a printer connected to the host computer 1, for example.
[0055]
In FIG. 9, form print data 13 is form print data created by the form print data creation means 12 of the host computer 1 upon receiving an output instruction from the application program. For example, until now, a form 52 has been printed based on the form print data 13 by the form print data printing apparatus 51. The form 52 has a format suitable for the table created by the spreadsheet software 24, and the data can be re-input to the terminal computer 21 and used for processing. In this example, the form 52 represents an order list of products, and includes columns for order number, product name, quantity, unit price, and subtotal. For example, the order quantity of the product XXXXXXX with the order number 12000 is 100, the unit price is ¥ 5,000, and the subtotal is ¥ 500,000. In addition, the total amount of all orders received is ¥ 800,000.
[0056]
The distribution worksheet creation unit 53 creates the distribution worksheet 15 from the form print data 13 with reference to the form appearance definition information 16. The form appearance definition information 16 is definition information that is referred to when the form print data creation unit 12 creates the form print data 13, and includes field information 54 and data item information 55. In FIG. 9, the distribution worksheet 15 is created as a worksheet having 31 rows and 6 columns. Each item on the distribution worksheet 15 is arranged at a position approximate to the case where it is printed on the form 52.
[0057]
FIG. 10 shows field information 54 corresponding to the form 52 of FIG. 9, and FIG. 11 shows data item information 55 corresponding to the form 52 of FIG. The field information 54 stores the position of each field in the table of the form 52, the type of the fixed field or variable field, the character string / data item name, and the character size. The data item information 55 stores the data item name of the variable field. Stores attributes about. In the field information 54 of FIG. 10, each row position corresponds to a row with the same number in the distribution worksheet 15 in FIG. 9, and each column value 1, 11, 23, 31, 41, 49 is Corresponding to columns A, B, C, D, E, and F, respectively.
[0058]
The data item attributes stored in the data item information 55 include a data type, an item length, an in-record offset, a repetition count, and a numerical value editing attribute. Among these, the data type, item length, offset within record, and number of repetitions have the same meaning as the data item information 42 in FIG. The information of each variable field of the field information 54 is related to the information of the corresponding data item in the data item information 55 using a pointer in advance. For example, since the field information 54 in the 3rd row and 31st column of the field information 54 has a data item “SHAMEI”, a pointer indicating the information “SHAMEI” in the data item information 55 is stored.
[0059]
FIG. 12 is a flowchart of a delivery worksheet creation process by the delivery worksheet creation unit 53. For example, the distribution worksheet 15 is generated from the form print data 13 of FIG. 9 by the distribution worksheet generation processing of FIG. When the processing is started in FIG. 12, the distribution worksheet creation unit 53 first extracts field information corresponding to the first item in the form 52 from the form appearance definition information 16 (step S51), and starts from the form print data 13. The print content of the line is taken out (step S52). Next, it is determined whether or not the line position of the extracted field information (item information) matches the line position of the extracted print content (step S53). If the two do not match, the print content of the next line is extracted from the form print data 13 (step S54), and the determination in step S53 is performed again.
[0060]
If the two row positions match in step S53, cell generation processing is performed (step S55), and it is determined whether or not the final information (final item) of the field information 54 has been reached (step S56). If the final item has not been reached, the field information corresponding to the next item in the form 52 is extracted from the form appearance definition information 16 (step S57), and the processes in and after step S53 are repeated. If it is determined in step S56 that the final item has been reached, the process ends.
[0061]
In the cell generation processing in step S55, a corresponding character string is extracted from the print contents based on the column position of the extracted item information and the item length of the corresponding data item. Then, one cell is generated from the row position and column position of the item information, the item length of the data item, and the extracted character string. If this process is performed for all print contents of the form print data 13, a distribution worksheet 15 is generated.
[0062]
For example, in the 3 rows and 31 columns of the field information 54 in FIG. 10, the field type is “variable” and the data item name is “SHAMEI”. Therefore, the data item information 55 of FIG. 11 is accessed using the pointer, and the item length 13 of the data item “SHAMEI” is obtained. Next, from the position corresponding to the 31 columns of the print content corresponding to the 3 rows, the character string “INC. ○○ Products Is set as a cell of the distribution worksheet 15. Since the position information of 3 rows and 31 columns of the field information 54 corresponds to the cell position of the 3 rows and D columns of the distribution worksheet 15, ○○ Products "Is set in a region of length 13 starting from the cell position of 3 rows and D columns.
[0063]
Since the data item name in the 5th row and 1st column of the field information 54 is “NUMBER”, the data item information 55 is accessed using the pointer, and the item length 8 of the data item “NUMBER” is obtained. Therefore, a character string “8” in length from the position corresponding to one column of the print content corresponding to five lines. 12000 "is read out and set as a cell in the 5th row and Ath column of the distribution worksheet 15. Similar processing is performed for variable print contents at other positions.
[0064]
Here, when the field type of the field information 54 is “fixed”, since there is no corresponding data item name, the character string of the print content is read as it is and set to the corresponding cell position. Alternatively, since the same character string is stored in the field information 54, the character string can be read out and set to the corresponding cell position.
[0065]
The distribution worksheet 15 created in this way is transferred from the distribution worksheet creation unit 53 to the communication processing unit 2 and transmitted to the terminal computer 21 by the communication processing unit 2. In the terminal computer 21, the distribution worksheet 15 is received by the receiving means 23 and processed by the spreadsheet software 24. As a result, the form print data 13 originally created for printing the form 52 in the host computer 1 can be secondarily used by the spreadsheet software 24.
[0066]
According to the second embodiment, the form appearance definition information 16 that has been used for printing the form 52 so far can be directly used for the distribution worksheet creation process. Therefore, it is not necessary to create a new application program or the like on the host computer 1, and the form print data 13 can be easily distributed to the terminal computer 21.
[0067]
In the second embodiment, the form 52 shown in FIG. 9 is merely an example, and the present invention can correspond to other arbitrary forms. In this case, the form appearance definition information 16 corresponding to the form is also used.
[0068]
【The invention's effect】
According to the present invention, the linkage processing between the spreadsheet software on the terminal computer such as a PC / WS and the host computer is automatically performed, and the business processing using the spreadsheet software is made efficient. At this time, the user does not need to newly create an application program or the like for the cooperation processing. Specifically, first, data can be input to the host computer as an extension of the data tabulation work using spreadsheet software. In addition, if there is already a lot of work to distribute the aggregate data of the host computer in a form, and the distributed form needs to be re-aggregated using the spreadsheet software of the terminal computer, the data to the terminal computer Input work can be reduced.
[Brief description of the drawings]
FIG. 1 is a principle diagram of the present invention.
FIG. 2 is a configuration diagram of a first embodiment of the present invention.
FIG. 3 is a diagram illustrating an example of a worksheet format definition body in the first embodiment.
FIG. 4 is a diagram showing an example of a data input worksheet in the first embodiment.
FIG. 5 is a flowchart of record area source sentence generation processing in the first embodiment;
FIG. 6 is a flowchart of a worksheet format definition body generation process in the first embodiment.
FIG. 7 is a processing flowchart of a READ instruction in the first embodiment.
FIG. 8 is a flowchart of a data input worksheet analysis process in the first embodiment.
FIG. 9 is a configuration diagram of a second embodiment of the present invention.
FIG. 10 is a diagram illustrating an example of field information in the second embodiment.
FIG. 11 is a diagram showing an example of data item information in the second embodiment.
FIG. 12 is a flowchart of a delivery worksheet creation process in the second embodiment.
[Explanation of symbols]
DESCRIPTION OF SYMBOLS 1 Host computer 2 Communication processing part 3 Prototype worksheet 4 Record area source sentence generation means 5 Worksheet format definition body generation means 6 Record area source sentence 7 Application program execution means 8 Database 9 Data input worksheet analysis means 10 Worksheet Format definition body 11 Data input worksheet 12 Form print data creation means 13 Form print data 14 Distribution worksheet creation means 15 Distribution worksheet 16 Form appearance definition information 21 Terminal computer 22 Transmission means 23 Reception means 24 Spreadsheet software 25 Display Device 31 Record area source sentence generation unit 32 Worksheet format definition generation unit 33 Data input worksheet analysis unit 34 Application program 35 COPY library 36 Format library 41 Cell information 42, 55 Over data item information 51 form the print data printing device 52 form 53 distribution worksheet creation unit 54 field information

Claims (1)

Provided in the host computer that performs processing to distribute the output data output by the instruction of the application program to the terminal computer that operates the spreadsheet software that performs spreadsheet processing based on the worksheet information via the online line In the spreadsheet software linkage processing device,
Application program execution means for executing the application program for instructing output of form print data used for printing the form usable as data by the spreadsheet software;
In response to an instruction from the application program, form print data creation means for creating the form print data;
With reference to the form appearance definition information describing the line position, column position, and item length of the data item in the form table, the line position of each data item matches the line position of each print content of the form print data. A corresponding character string is extracted from the print content with the matching line position based on the column position and the item length of the data item with the matching line position, and the distribution is made up of cell information including the character string. A distribution worksheet creation means for creating a worksheet;
A spreadsheet software cooperation processing apparatus comprising: communication processing means for transmitting the distribution worksheet to the terminal computer .

Images