JP5672732B2 - Spreadsheet generation program, spreadsheet generation device, and spreadsheet generation method - Google Patents

Description

  The present invention relates to a technique for generating a spreadsheet from print data.

A table composed of rows and columns used in spreadsheet software is called a spreadsheet.
Conventionally, when printing data is output to a spreadsheet, the printing data is output on a grid-like spreadsheet, that is, a spreadsheet having a fine cell width and cell height. This is because the layout of the table is determined by the cell width and the cell height, but the printing is determined by the coordinate position by dots.

Japanese Patent No. 3987066 JP-A-11-167475 International Publication WO2009 / 001462

  As described above, when print data is output to a spreadsheet of spreadsheet software, the print data is output to a grid-like spreadsheet. When a table with fine cell width and cell height is generated like a grid-like spreadsheet, useless cells increase and the data cannot be used for secondary use. Therefore, there is a problem that the user needs to manually adjust the layout and cells after outputting the print data to a grid-like spreadsheet (see FIG. 49).

  Also, print data corresponding to a plurality of tables is output to one spreadsheet, such as 2UP for printing a document for two pages on one sheet of paper or 4UP for printing a document for four pages at the time of printing. There is a request to display a plurality of tables on one spreadsheet. However, also in this case, the layout must be adjusted manually. When synthesizing tables having different layouts, for example, when synthesizing Table 1 and Table 2 shown in FIG. 50, the layout of the spreadsheet depends on the cell width and cell height of Table 1. Therefore, in order to maintain the layout of Table 2, it is necessary to manually add rows and columns and adjust the cell width (column width) and cell height (row height). That is, in FIG. 50, after synthesizing two tables, it is necessary to manually adjust the column width for the portion corresponding to Table 2. Further, after the composition, if the line width is adjusted for the portion corresponding to Table 2, the layout of the copy destination is destroyed, so adjustments such as adding a line are necessary manually. Since complicated adjustments are required in this way, there is a function of combining 2UP and 4UP at the time of printing and printing on paper, but print data corresponding to a plurality of tables is output on one spreadsheet from the beginning. There was no technology.

  Accordingly, the present invention provides a technique that enables generation of a single spreadsheet that outputs print data corresponding to a plurality of tables, which is a spreadsheet that does not require manual cells or layout adjustment. The purpose is to do.

  According to one aspect of the disclosure, there is provided a program that causes an information processing apparatus to execute an intermediate data generation step, a post-synthesis position information generation step, a format definition determination step, a synthesis step, and a spreadsheet output step.

  In the intermediate data generation step, a plurality of intermediate data corresponding to each table are obtained from the print data corresponding to the plurality of tables, including all items of positional information in the table of the plurality of items included in the tables. Generate.

  In the post-combination position information generation step, the position information of each item included in the intermediate data is corrected to the post-combination position information based on the control information for table composition for the plurality of intermediate data.

  The format definition determining step synthesizes and outputs the plurality of tables based on position information after combining the items included in the intermediate data and cell control information defining a basic cell size. Determine the format definition of the sheet.

  The synthesis step first calculates cell position information indicating in which cell on the spreadsheet based on the format definition each item is arranged based on the position information after the combination of the items. . And the cell information which stored the information regarding the item arrange | positioned at the cell corresponding to this cell position information is produced | generated, and this cell information for all the cells of this spreadsheet is output as synthetic data.

  The spreadsheet output step converts each cell information of the composite data into spreadsheet format data, and outputs the spreadsheet using cell information for all the cells of the spreadsheet as spreadsheet format data.

  In another aspect, there is provided an information processing apparatus including intermediate data generation means, post-composition position information generation means, format definition determination means, composition means, and spreadsheet output means that operate in the same manner as the above steps. .

  Moreover, in another aspect, the method which an information processing apparatus performs according to the said program is also provided.

  According to one aspect of the disclosure, it is possible to generate a spreadsheet that does not require manual cell or layout adjustment and that outputs print data corresponding to a plurality of tables. As a result, the work efficiency of the user and the like can be improved, and the secondary availability of the print data can be improved.

It is a figure which shows the structure of the spreadsheet production | generation system of this embodiment. It is a figure which shows the structure of information processing apparatus. It is a figure which shows the more detailed structure of the spreadsheet production | generation system of this embodiment. It is a figure explaining the coordinate axis in this embodiment. It is a figure explaining the division in this embodiment. It is a figure explaining the data structure of print data and format definition information. It is a figure explaining the data structure of <1> item information of format definition information. It is a figure explaining an edit format. It is a figure explaining the data structure of <2> ruled line information of format definition information. It is a figure explaining the data structure of intermediate data (table). It is a figure explaining the data structure of <1> item information of intermediate data (table). It is a figure explaining the data structure of <2> ruled line information of intermediate data (table). It is a figure explaining the data structure of <3> logic coordinate information (before composition) of intermediate data (table). It is a figure explaining the data structure of <4> length and width size of intermediate data (table). It is a figure explaining the data structure of table composition control information. It is a figure which shows an example of table synthesis control information. It is a figure explaining the data structure of intermediate data management information. It is a figure which shows an example (the 1) of intermediate data management information. It is a figure which shows an example of the list of the size of the table | surface corresponding to intermediate data. It is a figure explaining the procedure for calculating the length and breadth size after (5) intermediate data composition of intermediate data management information. It is a figure which shows an example (the 2) of intermediate data management information. It is a figure explaining the data structure of logical coordinate information (after composition). It is a figure explaining the calculation method of logical coordinate information (after composition). It is a figure explaining the data structure of cell control information. It is a figure explaining the data structure of cell definition information. It is a figure which shows an example of the ascending order sort of logical coordinate information (after composition). It is a figure explaining concretely the determination of the format definition of a spreadsheet. It is a figure explaining the data structure of cell information. It is a figure explaining the outline of cell coupling | bonding. It is a figure which shows the whole system flow of the spreadsheet production | generation system of this embodiment. It is a figure which shows the detailed flow of the intermediate data production | generation process (S301) of FIG. It is a figure which shows the detailed flow of the intermediate data management information generation process (S302) of FIG. It is a figure which shows the detailed flow of the cell definition information generation process (S303) of FIG. It is a figure which shows the detailed flow of the calculation process (S332) of the cell width of FIG. It is a figure which shows the detailed flow of the determination process (S344 and S346) of the cell width of FIG. It is a figure which shows the detailed flow of the calculation process (S334) of the cell height of FIG. It is a figure which shows the detailed flow of the determination process (S364 and S366) of the cell height of FIG. It is a figure which shows the detailed flow of the intermediate data synthetic | combination process (S304) of FIG. It is a figure which shows the detailed flow of the cell position conversion process (S385) of FIG. It is a figure explaining the cell position conversion process (S385) of FIG. 38 with reference to a specific example. It is a figure which shows the detailed flow of the data setting process (S386) of FIG. It is a figure which shows the detailed flow of the format setting process (S387) of FIG. It is a figure which shows the detailed flow of the setting process (S388) of the font and arrangement | positioning attribute of FIG. It is a figure which shows the detailed flow of the setting process (S389) of the cell coupling | bonding of FIG. It is a figure which shows the detailed flow of the ruled line and shaded setting process (S390) of FIG. It is a figure which shows the detailed flow of the spreadsheet production | generation process (S305) of FIG. It is a figure which shows an example of the data of an XML format. It is a figure which shows an example at the time of synthesize | combining the printing data corresponding to two tables, and producing | generating one spreadsheet by this embodiment. It is a figure explaining the conventional problem at the time of outputting print data to a spreadsheet. It is a figure explaining the problem at the time of synthesize | combining the printing data corresponding to two tables, and producing | generating one sheet of spreadsheet.

Hereinafter, an embodiment of a spreadsheet generation device will be described with reference to the drawings.
FIG. 1 shows a configuration of a spreadsheet generation system 1 of the present embodiment.
The spreadsheet generation system 1 generates a single spreadsheet by combining print data corresponding to a plurality of tables, and includes an intermediate data generation device 2, an intermediate data synthesis device 3, and a spreadsheet output device 4.

  The print data corresponding to the table is created by a user or the like using the business application 8 or the form definition tool 9 and stored as print data 5 and format definition information 6 in a storage device of the information processing apparatus. The spreadsheet generation system 1 uses the print data 5 and the format definition information 6 as input information.

  The intermediate data generation device 2 of the spreadsheet generation system 1 generates intermediate data from the print data 5 and the format definition information 6. In this embodiment, data in each column in the table, that is, a character string or numerical value indicating a heading or the like is referred to as an “item”. Also, information corresponding to each item, and information including item data, its format, editing format, item position information, etc. is referred to as item information. The intermediate data is generated including item information corresponding to all items, information such as ruled lines / shading of the table, position information before combining each item, and vertical and horizontal sizes of the table before combining. Intermediate data is generated corresponding to each table. For example, when combining print data corresponding to two tables, two intermediate data are generated.

  In the intermediate data synthesizing apparatus 3, first, position information after table synthesis is obtained for all items included in the plurality of intermediate data. Next, based on the position information of the obtained items, the format definition of the spreadsheet to be generated (specifying the cell width and cell height of the spreadsheet) is determined. Then, all the items included in the intermediate data are arranged on the spreadsheet based on the format definition, and the cell in which each item is arranged is specified. Thereby, cell information including item information of items to be arranged is generated for each cell. Further, when it is detected that there is an item arranged across a plurality of cells based on information indicating the range of items included in the item information, information for combining the cells is further added to the cell information. Record. This combines the cells of the spreadsheet.

From the processing as described above, cell information corresponding to all the items is generated, and all the cell information is output as synthesized data corresponding to one spreadsheet.
Finally, the spreadsheet output device 4 converts cell information, which is composite data, into a spreadsheet format and outputs a spreadsheet 7.

  As described above, in this embodiment, first, print data corresponding to a plurality of tables is converted to generate a plurality of intermediate data. Then, the plurality of intermediate data are combined to generate combined data corresponding to one spreadsheet. Further, the composite data is converted into a spreadsheet format to generate a spreadsheet. As described above, in the present embodiment, by using the intermediate data, print data corresponding to a plurality of tables can be output to one spreadsheet. Further, when synthesizing the intermediate data, the synthesizing process is performed so that the layouts of the respective tables are not destroyed and as many unnecessary cells as possible are not generated. This eliminates the need for manual cell and layout adjustment after the spreadsheet is generated, thereby improving the work efficiency of the user and the like. In addition, the secondary availability of print data can be improved.

The spreadsheet generation system 1 shown in FIG. 1 is realized by an information processing apparatus having a hardware configuration as shown in FIG.
2 includes a central processing unit (CPU) 10, a read only memory (ROM) 11, a random access memory (RAM) 12, a communication interface 13, an input device 14, an output device 15, and a storage device 16. A drive device 17 for the portable storage medium 19 is provided. These units included in the information processing apparatus 22 are connected by a bus 18.

  The information processing device 22 is connected to the network 20 via the communication interface 13. The network 20 is an arbitrary network such as a local area network (LAN) or the Internet.

  The CPU 10 loads the program into the RAM 12 and executes the program while using the RAM 12 as a working area, thereby causing the information processing apparatus 22 to function as the spreadsheet generation system 1. That is, the CPU 10 functions as a spreadsheet generation system by realizing a processing flow to be described later according to a program. At this time, the data storage unit such as intermediate data is realized by the RAM 12, for example, but may be realized by both the RAM 12 and the storage device 16.

  The program may be stored in advance in the ROM 11 or the storage device 16, provided from the program provider 21 via the network 20, and stored in the storage device 16. Alternatively, the data may be stored in the portable storage medium 19, loaded from the portable storage medium 19 set in the driving device 17 into the RAM 12, and executed by the CPU 10. As the portable storage medium 19, various types of storage media such as an optical disk such as a Compact Disc (CD) and a Digital Versatile Disk (DVD), a magneto-optical disk, a magnetic disk, and a nonvolatile semiconductor memory can be used.

  The input device 14 is a pointing device such as a mouse or a keyboard. The output device 15 is a display device such as a liquid crystal display. The storage device 16 may be a magnetic disk device such as a hard disk device or another type of storage device.

  As described above, it has been described that the spreadsheet generation system 1 of the present embodiment is configured by the information processing apparatus. Hereinafter, the spreadsheet generation system 1 of the present embodiment will be described in more detail.

First, FIG. 3 shows a more detailed configuration of the spreadsheet generation system 1.
The spreadsheet generation system 1 includes an intermediate data generation unit 30, an intermediate data management information generation unit 31, a cell definition information generation unit 32, an intermediate data synthesis unit 33, and a spreadsheet output unit 34. The intermediate data generation unit 30 is included in the intermediate data generation device 2. In addition, the intermediate data management information generation unit 31, the cell definition information generation unit 32, and the intermediate data synthesis unit 33 are included in the intermediate data synthesis device 3. The spreadsheet output unit 34 is included in the spreadsheet output device 4.

Each part will be described below, but the structure of information (data, etc.) generated by each part will be described later with reference to the drawings.
The intermediate data generating unit 30 generates intermediate data (table) 36 for table composition from the format definition information and the print data 35 by the number of tables to be synthesized on one spreadsheet. That is, for example, in the case of 2UP, intermediate data (table) 36 corresponding to two tables is generated, and in the case of 4UP, intermediate data (table) 36 corresponding to four tables is generated.

  The print data is a record in which character string data corresponding to each item in the table is serially stored. The format definition information is information that defines the format of the table. The intermediate data (table) 36 includes, from print data and information included in the format definition information, item information corresponding to each item in the table, information such as ruled lines and shades in the table, and information on the vertical and horizontal sizes of the table. It is generated including. The intermediate data (table) 36 includes logical coordinate information (before synthesis) that is position information indicating the print position of each item.

  The intermediate data management information generating unit 31 generates intermediate data management information 39 from the table composition control information 37 and the intermediate data (table) 36. The table composition control information 37 is information for designating the size of the print sheet, the sheet direction, and the number of tables to be composed on one sheet. The intermediate data management information generation unit 31 acquires the vertical and horizontal sizes of each table to be combined from the intermediate data (table) 36, and calculates the vertical and horizontal sizes after the intermediate data combination based on the acquired sizes. The intermediate data management information 39 includes information included in the table composition control information 37, vertical and horizontal sizes after the intermediate data composition, and reference information (link) to the intermediate data (table) 36 corresponding to each table.

  In addition, the intermediate data management generator 31 calculates logical coordinate information (after synthesis) 38. Before describing the logical coordinate information, the coordinate axes will be described first. FIG. 4 shows coordinate axes. The vertical axis is y and the horizontal axis is x, the y axis increases downward, and the x axis increases rightward. A “section” is a portion of each piece of paper that is divided to arrange each table when 2UP or 4UP is performed. In the case of 2UP, for example, as shown in FIG. 5A, the section 1 and the section 2 are arranged in order from the left on the paper that is long in the horizontal direction. In the case of 4UP, for example, as shown in FIG. 5B, the sections 3 and 4 are sequentially arranged from the left below the sections 1 and 2.

  First, the intermediate data management information generation unit 31 calculates correction information for shifting each table from the origin and placing it in each section. For example, since the table arranged in the section 2 must be moved leftward with respect to the section 1, correction information in which the x coordinate is moved rightward by the amount of the table arranged in the section 1, for example ( a, 0) (where a is the width of section 1). Next, the calculated correction information is added to the logical coordinate information (before composition) included in the intermediate data (table) 36, and logical coordinate information (after composition) 38 indicating the print position of each item is calculated. The logical coordinate information (after synthesis) 38 calculated in this way indicates the position information of each item when the tables are synthesized.

  Next, the cell definition information generation unit 32 generates cell definition information 41 from the logical coordinate information (after synthesis) 38 and the cell control information 40. The cell control information 40 is information given in advance as setting information or the like. The cell control information 40 includes a cell width and a cell height of a spreadsheet to be generated, that is, a cell width (basic cell width), a cell height (basic cell height), and a rounding that are basic for determining the format definition. Information specifying the width and rounding height. Using the cell control information 40 and the logical coordinate information (after synthesis) 38, the optimum cell width (column width) and cell height (row height) of the generated spreadsheet are determined, and the cell definition information 41 (Generate spreadsheet format definition).

  Next, the intermediate data composition unit 33 generates cell information 42 that is data immediately before the spreadsheet is generated from the intermediate data (table) 36, the intermediate data management information 39, and the cell definition information 41.

  That is, the intermediate data synthesis unit 33 first calculates which cell of the spreadsheet defined by the cell definition information 41 is arranged for a certain item of the intermediate data (table) 36 and corresponds to the item. Cell information 42 including item information is generated. Thereafter, from the information indicating the item range corresponding to the item being processed, the range of the cell corresponding to the range occupied by the item is specified, and if necessary, the cell range on the spreadsheet is determined based on the specified cell range. Information to be combined is recorded in the cell information 42. Further, a range such as ruled lines / shading is specified and stored in the cell information 42. This process is performed for all items of the intermediate data (table) 36. Then, the generated all cell information 42 is passed to the processing of the next spreadsheet output unit 34 as composite data corresponding to one spreadsheet.

Finally, the spreadsheet output unit 34 converts the cell information 42 for all cells on the spreadsheet into a spreadsheet format and outputs the spreadsheet 43.
As described above, in this embodiment, the number corresponding to the table for synthesizing the intermediate data (table) 36 from the print data and the format definition information 35 is generated. Next, intermediate data management information 39 is generated from the intermediate data (table) 36 and the table composition control information 37. Further, logical coordinate information (after synthesis) 38, which is position information after synthesis of each item included in each table, is generated. Next, cell definition information 41, which is a format definition that defines the cell width (column width) and cell height (row height) of the spreadsheet generated from the cell control information 40 and the logical coordinate information (after synthesis) 38, Generate. Then, from the intermediate data (table) 36, the intermediate data management information 39, and the cell definition information 41, these pieces of information are combined to generate cell information 42 corresponding to all items included in the intermediate data. Finally, cell information 13 for all cells on the spreadsheet is converted into a spreadsheet format to generate a spreadsheet.

Hereinafter, each information will be described by showing a data structure.
First, the data structure of the print data and the format definition information 35 will be described with reference to FIG.

The print data is a record in which character string data corresponding to each item in the table is serially stored.
The format definition information has a data structure including <1> item information and <2> ruled line information for each partition. <1> FIG. 7 shows a detailed data structure of item information, and FIG. 9 shows a detailed data structure of <2> ruled line information.

  As shown in FIG. 7, <1> item information includes (1) item name, (2) item position information, (3) item area length, (4) data length, (5) data format, (6) It includes information on font information, (7) arrangement information, (8) editing format, and (9) position in record. Detailed descriptions of (1) to (9) are as follows.

(1) Item name: Name for identifying an item (unique within the format definition).
(2) Item position information: Coordinate position indicating the item position (the leftmost bottom coordinate of the item).
(3) Item area length: A value indicating the range of an item.
(4) Data length: A value indicating the length of data (unit: number of bytes).
(5) Data format: A value indicating the type of data (text data, numerical data, etc.).
(6) Font information: Information indicating the font name and font size.
(7) Arrangement information: Information relating to the arrangement of characters such as center alignment.

(8) Edit format: Information indicating an edit format when data is edited and output (see FIG. 8).
The edit format is information for designating a display format in the finally generated spreadsheet. (8) FIG. 8 shows the correspondence between the editing format and the spreadsheet format (display format). In FIG. 8, for example, when (5) data format of <1> item information is “numerical value” and (8) edit format is “9999999”, the format in the spreadsheet is “000000; 000000”. Others are the same.

  (9) In-record position: information indicating the number of bytes from the beginning of the print data that is data in the record format (for example, in FIG. 6, (9) in-record position of item A is “Aiueo” in print data Information indicating the number of bytes from the beginning of the print data is stored.)

  As shown in FIG. 9, the data structure of <2> ruled line information of the format definition information is a structure including information such as (1) type and (2) position information. Detailed description of each information of (1) and (2) is as follows.

(1) Type: Information for identifying ruled lines, frames, and shading.
(2) Position information: Information indicating the positions and ranges of ruled lines, frames, and shading, and includes a start position (X1, Y1) and an end position (X2, Y2). In the case of a frame or shaded area, the start position indicates the uppermost leftmost coordinate, and the end position indicates the lowermost rightmost coordinate.

The data structure of the print data and the format definition information 35 has been described above with reference to FIGS.
Next, the data structure of the intermediate data (table) 36 generated from the print data and the format definition information 35 by the intermediate data generation unit 30 will be described.

  FIG. 10 shows the data structure of the intermediate data (table) 36. The character string or numerical value indicating the heading of each column in the table before synthesis is referred to as “item” as described above, but the intermediate data (table) 36 includes information for outputting this item to a spreadsheet. Is generated as follows. That is, as shown in FIG. 10, the intermediate data (table) 36 includes <1> item information, <2> ruled line information, <3> logical coordinate information (before synthesis), and <4> vertical and horizontal size information. The configuration of each piece of information <1> to <4> is shown in FIGS.

  First, the <1> item information shown in FIG. 11 will be described. The <1> item information in the intermediate data (table) 36 exists for all items in the table before composition. <1> item information includes (1) item position, (2) data format, (3) data length, (4) character string range, (5) arrangement information, (6) font information, and (7) edit format. , (8) including character string data. Detailed description of each information of (1) to (8) is as follows.

(1) Item position: coordinate information indicating the position of the item (character string) (the lowest leftmost coordinate of the item). A copy of the position information of the item (2) of the item information <1> of the format definition information is stored.
(2) Data format: A value indicating the type of data (text data, numerical data, etc.). Stores a copy of (5) data format of <1> item information of format definition information.

(3) Data length: A value indicating the length of a character string (unit: number of bytes). A (4) data length copy of the <1> item information of the format definition information is stored.
(4) Item range: A value indicating an item range (x-axis direction, y-axis direction). This is information calculated from (3) item area length of <1> item information of format definition information.

(5) Arrangement information: Information relating to the arrangement of characters such as center alignment. Stores a copy of (7) arrangement information of <1> item information of format definition information.
(6) Font information: Information indicating the font name and font size. Stores a copy of (6) font information of <1> item information of format definition information.

(7) Edit format: Information indicating an edit format when data is edited and output. A copy of (8) edit format of <1> item information of format definition information is stored.
(8) Character string data: Character string data is stored. Based on the (9) information indicated by the position in the record of the <1> item information of the format definition information and (4) the data length, the print data record is read and the acquired character string data is stored.

  Next, the data structure of <2> ruled line information in the intermediate data (table) 36 is a structure including (1) type and (2) position information as shown in FIG. Detailed description of each information of (1) and (2) is as follows.

(1) Type: Information for identifying ruled lines, frames, and shading. A copy of (1) type of <2> ruled line information of the format definition information is stored.
(2) Position information: Information indicating the positions and ranges of ruled lines, frames, and shading, and includes a start position (X1, Y1) and an end position (X2, Y2). In the case of a frame or shaded area, the start position indicates the uppermost leftmost coordinate, and the end position indicates the lowermost rightmost coordinate. Stores a copy of (2) position information of <2> ruled line information of format definition information.

  Next, as shown in FIG. 13, the data structure of <3> logical coordinate information (before synthesis) of the intermediate data (table) 36 is as follows: (1) number of registrations, (2) x-coordinate of item position, (3) item The structure includes the y coordinate of the position. Detailed description of each information of (1) to (3) is as follows.

(1) Number of registrations: <1> Number of item information.
(2) x-coordinate of item position: x-coordinate of the coordinate (the leftmost uppermost coordinate of the item) indicating the position of the item (character string). That is, the x coordinate of the coordinate information of the position information of the item (2) of the <1> item information of the format definition information is stored for the number of registrations corresponding to the <1> item information of the intermediate data (table) 36. ing.

  (3) y-coordinate of item position: y-coordinate of coordinate information (the leftmost uppermost coordinate of the item) indicating the position of the item (character string). That is, the font size is calculated from (6) font information of <1> item information of the format definition information, and from the y coordinate of the coordinates of the position information of (2) item information of <1> item information of the format definition information, A value obtained by subtracting the font size. The number of registrations corresponding to the <1> item information of the intermediate data (table) 36 is stored.

  Next, the data structure of <4> vertical and horizontal sizes of the intermediate data (table) 36 is a structure including (1) vertical size and (2) horizontal size as shown in FIG. Detailed description of each information of (1) and (2) is as follows.

(1) Vertical size: A value indicating the vertical size of the table corresponding to the intermediate data.
(2) Horizontal size: A value indicating the horizontal size of the table corresponding to the intermediate data.
As described above, the data structure of the intermediate data (table) 36 has been described with reference to FIGS. Next, the data structure of the table composition control information 37 used in the intermediate data management information generation unit 31 will be described.

  The table composition control information 37 is information relating to table composition preset by a user or the like. FIG. 15 shows the data structure of the table composition control information 27. The table composition control information 27 includes (1) paper size type, (2) paper direction, (3) placement attribute, and (4) placement direction. Detailed description of each information of (1) to (4) is as follows.

(1) Paper size type: Information for specifying the paper size to be used when printing the combined table. If omitted, “A4”.
(2) Paper orientation: Information that specifies the paper orientation to be used when printing the combined table. If omitted, "Portrait (vertical display)".

(3) Arrangement attribute: Information for designating an arrangement attribute (2UP or 4UP) for synthesizing tables. If it is omitted, “Do not compose”.
(4) Arrangement direction: Information for designating the arrangement direction (downward or rightward) when combining the tables. “Down” if omitted. This designation is valid only when “4UP” is designated in “(3) Placement attribute”. In the case of “2UP”, according to the designation of “(2) paper direction”, the portrait is downward, and the landscape (horizontal display) is right.

FIG. 16 shows an example of the table composition control information 37. (1) The paper size is A4, (2) the paper direction is portrait, (3) the placement attribute is 4UP, and (4) the placement direction is rightward.
Next, the intermediate data management information 39 generated by the intermediate data management information generation unit 31 will be described. FIG. 17 shows the data structure of the intermediate data management information 39. The intermediate data management information 39 includes (1) paper size type, (2) paper orientation, (3) placement attribute, (4) placement direction, (5) vertical and horizontal sizes after the synthesis of intermediate data, and (6) intermediate data. Reference information. Detailed description of each information of (1) to (6) is as follows.

(1) Paper size type: Information for specifying the paper size to be used when printing the combined table. A copy of (1) paper size type of the table composition control information 37 is stored.
(2) Paper orientation: Information that specifies the paper orientation to be used when printing the combined table. A (2) sheet direction copy of the table composition control information 37 is stored.

(3) Arrangement attribute: Information for designating an arrangement attribute (2UP or 4UP) for synthesizing tables. A copy of (3) arrangement attribute of the table composition control information 37 is stored.
(4) Arrangement direction: Information for designating the arrangement direction (downward or rightward) when combining the tables. A copy of (4) arrangement direction of the table composition control information 37 is stored.

(5) Vertical and horizontal size after intermediate data composition: Information on vertical and horizontal sizes after 2UP / 4UP. The calculation method will be described with reference to FIGS.
(6) Reference information to intermediate data: Reference information (link) to each intermediate data (table) is stored.

  When the four tables of Table 1, Table 2, Table 3, and Table 4 are combined into 4UP in A4 length, FIG. 18 to FIG. 22 show a method for obtaining the vertical and horizontal sizes after the intermediate data combining in the above (5). The description will be given with reference. Each table before synthesis is assumed to be A4, portrait, Table 2, A4, landscape, Table 3, A4, landscape, and Table 4, A4 portrait, respectively.

  The intermediate data management information 39 first copies (1) paper size type, (2) paper orientation, (3) placement attribute, and (4) placement direction of the table composition control information 37, and ( 1) paper size type, (2) paper orientation, (3) placement attribute, and (4) placement orientation. Further, reference information to each intermediate data (table) 36 is stored in (6) reference information to intermediate data in the intermediate data management information 39. Thereby, it becomes as shown in FIG.

  Next, (6) based on the reference information to the intermediate data, each intermediate data (table) 36 is referred to, and from the <4> vertical and horizontal sizes of the intermediate data (table) 36, the size of the table corresponding to the intermediate data ( (Vertical, horizontal). An example of the extracted sizes of Tables 1 to 4 is shown in FIG. Table 1 shows the vertical size: 16258 (unit: 1/1440 inch) and the horizontal size: 11333 (unit: 1/1440 inch). Table 2 shows the vertical size: 11333 (unit: 1/1440 inch) and the horizontal size: 16258 (unit: 1/1440 inch). Table 3 shows the vertical size 11333 (unit: 1/1440 inch) and the horizontal size 16258 (unit: 1/1440 inch). Table 4 shows the vertical size: 16258 (unit: 1/1440 inch) and the horizontal size: 11333 (unit: 1/1440 inch). These vertical and horizontal sizes are obtained by converting A4 size to 210 mm × 297 mm, providing a margin of 5 mm, A4 size of 200 mm × 287 mm, and converting these lengths to 1/1440 inches.

  The procedure 1 is to extract the size of the table corresponding to the intermediate data, and the procedure 2 and subsequent steps will be described with reference to FIG. From the size of each table obtained in the procedure 1, one section that can be arranged in either A4 length or width is obtained (FIG. 20, procedure 2). In the example of synthesizing Table 1 to Table 4, the longest vertical and horizontal sizes are 16258 (unit: 1/1440 inch), so 16258 (unit: 1/1440 inch) × 16258 (unit: 1/1440 inch). ) Square.

  Next, one section is set to the same ratio as the paper to be printed. In the example in which Table 1 to Table 4 are combined, the paper to be printed is A4 and the paper direction is portrait (vertical), so the vertical direction is enlarged by putting on clogs in the vertical direction (FIG. 20, procedure 3). . That is, one section is 21145 in the vertical direction (unit: 1/1440 inch) × 16258 in the horizontal direction (unit: 1/1440 inch). One block obtained in the procedure 3 is synthesized to generate 4UP (FIG. 20, procedure 4). As a result, the vertical 42270 (unit: 1/1440 inch) × 32516 (unit: 1/1440 inch) is the combined vertical and horizontal size. The combined vertical and horizontal sizes are larger than the actual size of A4 size paper (A4 size paper size is 16258 (unit: 1/1440 inch) × 11333 (unit: 1/1440 inch). )). However, since the ratio between the vertical and horizontal sizes of the paper and the combined vertical and horizontal sizes is the same, the combined vertical and horizontal sizes may be reduced as they are when printing. In this manner, an appropriate combined vertical and horizontal size is obtained and stored in the intermediate data management information 39 in (5) vertical and horizontal size after intermediate data combination.

  As described above, (5) the vertical / horizontal size value after the intermediate data composition is calculated as 42270 (unit: 1/1440 inch) × 32516 (unit: 1/1440 inch) (see FIG. 21). It is as follows when only the value calculated | required along each procedure is enumerated.

-Paper size ratio: 16258: 11333 (1.3: 1)
-Required 1 section: 16258: 16258 (1: 1) (Procedure 2)
Match ratio: 21125: 16258 (1.3: 1) (Procedure 3)
After synthesis (4UP): 42270: 32516 (1.3: 1) (Procedure 4)
As described above, the data structure of the intermediate data management information 39 has been described with reference to FIGS.

Next, the data structure of logical coordinate information (after synthesis) 38 that is also generated by the intermediate data management information generation unit 31 will be described.
The data structure of the logical coordinate information (after synthesis) 38 is shown in FIG. The logical coordinate information (after synthesis) 38 has a structure including (1) the number of registrations, (2) the x coordinate of the item position, and (3) the y coordinate of the item position. Detailed description of each information of (1) to (3) is as follows.

(1) Number of registrations: Number of <1> item information in the intermediate data (table) 36. A copy of (1) the registered number of <3> logical coordinate information (before synthesis) of the intermediate data (table) 36 is stored.
(2) x-coordinate of item position: x-coordinate of the coordinate (the leftmost uppermost coordinate of the item) indicating the position of the item (character string) after synthesis. The number of registrations corresponding to the <1> item information of the intermediate data (table) 36 is stored.

  (3) y-coordinate of item position: y-coordinate of the coordinate (the leftmost uppermost coordinate of the item) indicating the position of the item (character string) after synthesis. The number of registrations corresponding to the <1> item information of the intermediate data (table) 36 is stored.

  The (2) x-coordinate of the item position and (3) y-coordinate of the item position are set in information indicating the item position in the <3> logical coordinate information (before composition) in the intermediate data (table) 36, respectively. It is generated by adding correction information of corresponding coordinates. The correction information is obtained for each of the sections 2, 3, and 4 based on (3) layout attribute, (4) layout direction, and (5) vertical and horizontal sizes after the intermediate data composition in the intermediate data management information 39. Assuming that the horizontal size of one section is a and the vertical size is b, the correction information of sections 2, 3, and 4 is (a, 0), (4) as shown in FIG. 0, b), (a, b). This correction information is added to (1) the x-coordinate of the item position and (2) the y-coordinate of the item position in <3> logical coordinate information (before composition), and logical coordinate information (after composition) 38 is generated. The

With reference to FIG. 23, a method of calculating logical coordinate information (after synthesis) 38 will be described.
As shown in the upper part of FIG. 23, it is assumed that Table 1, Table 2, Table 3, and Table 4 are arranged in section 1, section 2, section 3, and section 4, respectively, and 4UP is synthesized. Table 1 includes items A and B, Table 2 includes items E and F, Table 3 includes items P and Q, and Table 4 includes items X and Y. It is. In addition, the x coordinate of the logical coordinate information of each item before the table is combined into 4UP is shown in the lower part of FIG. That is, the x-coordinates before composition are 8640 for item A, 15840 for item B, 8640 for item E, 1440 for item F, 7200 for item P, 2880 for item Q, 2880 for item X, 12960 for item Y ( The unit is 1/1440 inch.

  Assuming that the widths of the sections 1 and 3 are 27360 (unit: 1/1440 inch), the correction information for the x coordinate of the logical coordinate information in Tables 2 and 4 arranged in the sections 2 and 4 is 27360. This correction information is added to the x coordinate of the logical coordinate information before synthesis of the items included in Table 2 and Table 4, respectively, to obtain logical coordinate information after synthesis. That is, the x-coordinates of the logical coordinate information after synthesis are item A for 8640, item B for 15840, item E for 36000, item F for 28800, item P for 7200, item Q for 2880, item X for 30240, item, respectively. Y is 40320 (above, unit: 1/1440 inch).

  For the y coordinate of the logical coordinate information (after synthesis) 38 (y coordinate of the item position (3) of the logical coordinate information (after synthesis) 38), the x coordinate ((2) item position of the logical coordinate information (after synthesis) 38) X-coordinate).

As described above, the data structure of the logical coordinate information (after synthesis) 38 generated by the intermediate data management information generation unit 31 has been described with reference to FIGS. 22 and 23.
Next, the data structure of the cell control information 40 used in the cell definition information generation unit 32 will be described.

  The cell control information 40 is information set in advance by a user or the like in order to determine the format definition of the spreadsheet to be generated. FIG. 24 shows the data structure of the cell control information 40. The cell control information 40 includes (1) basic cell width, (2) basic cell height, (3) rounding width, and (4) rounding height. Detailed description of each information of (1) to (4) is as follows.

  (1) Basic cell width: A value of the basic cell width when determining the cell width (column width) of the spreadsheet to be generated. It can be customized with forms so that unnecessary cells are not generated as long as the layout is guaranteed. When omitted, “960 (unit: 1/1440 inch)” is set.

  (2) Basic cell height: A basic value for determining the cell height (row height) of the generated spreadsheet. It can be customized with forms so that unnecessary cells are not generated as long as the layout is guaranteed. If omitted, “240 (unit: 1/1440 inch)” is set.

  (3) Rounding width: A value for preventing useless cells from being generated due to subtle differences in x-coordinates of items when determining the cell width of a spreadsheet to be generated. Customizable by form so that useless cells are not generated due to subtle differences in x-coordinates of items. If omitted, “144 (unit: 1/1440 inch)” is set.

  (4) Rounding height: A value for preventing useless cells from being generated due to subtle differences in the y-coordinates of items when determining the cell height of a generated spreadsheet. Customizable by form so that unnecessary cells are not generated due to subtle differences in y-coordinates of items. If omitted, “144 (unit: 1/1440 inch)” is set.

  The data structure of the cell control information 40 has been described above with reference to FIG. By the way, the cell definition information generation unit 32 generates cell definition information 41 from the logical coordinate information (after synthesis) 38 described in FIG. 22 and the cell control information 40 illustrated in FIG. The cell definition information 41 is a basic format definition that defines the cell width (column width) and cell height (row height) of the spreadsheet to be generated. Next, the cell definition information 41 will be described with reference to FIG.

  The data structure of the cell definition information 41 includes (1) basic cell width, (2) basic cell height, (3) cell width, and (4) cell height. Detailed description of each information of (1) to (4) is as follows.

(1) Basic cell width: A value of the basic cell width when determining the cell width (column width) of the spreadsheet to be generated. A copy of (1) basic cell width of the cell control information 40 is stored.
(2) Basic cell height: A cell height value that is the basis for determining the cell height (row height) of the generated spreadsheet. A copy of (2) basic cell height of the cell control information 40 is stored.

  (3) Cell width: The cell width (column width) value of the generated spreadsheet calculated from the logical coordinate information (after synthesis) 38 and the cell control information 40 is stored for the number of columns in a comma-separated format. Is done.

  (4) Cell height: The cell height (row height) value of the spreadsheet to be generated calculated from the logical coordinate information (after synthesis) 38 and the cell control information 40 is the number of rows in a comma-delimited format. Minutes, stored.

  (3) Calculation of the cell width will be described with reference to FIGS. First, as shown in FIG. 26, the logical coordinate information (after synthesis) 38 is sorted in ascending order. FIG. 26 shows the logical coordinate information (after synthesis) 38 shown in FIG. 25 sorted in ascending order. After sorting, the logical coordinate information is arranged in the order of item Q, item P, item A, item B, item F, item X, item E, and item Y. The cell width of the generated spreadsheet is calculated using the sorted information. The calculation of the cell width of the generated spreadsheet after sorting the logical coordinate information (after synthesis) 38 is basically performed by the following (a) to (c).

(A) Of the logical coordinate information after sorting (after synthesis) 38, the distance between items is calculated by obtaining the difference between the logical coordinate information before and after.
(B) If the distance between the items calculated in (a) is smaller than (3) the rounding width of the cell control information 40, the cell width (column width) is not set, and the processing returns to (a) between the next items The distance is calculated.

  (C) When the distance between items calculated in (a) is larger than (3) the rounding width of the cell control information 40 and (1) more than twice the basic cell width of the cell control information 40 Sets the cell width (column width) as the basic cell width. When the distance between items is larger than (3) the rounding width of the cell control information 40 and the distance between items is (1) less than twice the basic cell width of the cell control information 40, the item Set the cell width (column width) by the distance between them. Then, returning to (a), the distance between the next items is calculated.

The determination of the format definition of the spreadsheet to be generated by (a) to (c) will be specifically described with reference to FIG.
The basic concept is as follows.

・ If (basic cell width × 2) or more, set the cell width (column width) as the basic cell width.
・ If less than (basic cell width x), set the distance between items as the cell width (column width).
In FIG. 27, when item A, item B, item C, and item D are first sorted according to the x coordinate of logical coordinate information (after synthesis) 38, items A, item B, item C, and item D are in this order.

  For the first item A, the x-coordinate value of item A is the distance between items. Since the distance between items is equal to or greater than the rounding width and less than twice the basic cell width, the distance between items is set as the cell width (column width) according to (c). That is, the cell width of column A is determined as the distance from the left end of the spreadsheet to the left end of item A.

  Next, the distance between the items A and B is calculated from the difference between the logical coordinate information (after synthesis) 38. Since the distance between the item A and the item B is not less than the rounding width and less than twice the basic cell width, the cell width of the column B is the same as that of the column A according to the above (c). It is determined by the distance between items A and B.

  Next, the distance between the items B and C is calculated from the difference between the logical coordinate information (after synthesis) 38. Since the distance between the item B and the item C is not less than the rounding width and not less than twice the basic cell width, the cell width of the column C is determined as the basic cell width. Further, since the distance from the right end of column C to the left end of item C is equal to or greater than the rounding width and less than twice the basic cell width, the cell width of column D is set to the left end of item C from the right end of column C. Determine the distance to.

  Next, the distance between the items C and D is calculated from the difference between the logical coordinate information (after synthesis) 38. Since the distance between the item C and the item D is less than the rounding width, the cell (column) is not set, and the process proceeds to the calculation of the distance between the next items. Thereby, a column corresponding to a short distance such as the distance between the item C and the item D is not set, and it is possible to prevent fine cells from being set in the format definition of the generated spreadsheet.

  Similarly, by calculating the distance between items, the cell widths (column widths) of the columns E and F are determined. Similarly to the calculation of the cell width, the cell height (row height) can be determined for the row. As described above, the format definition of the spreadsheet to be generated is determined. In (3) cell width of the cell definition information 41, the width values of column A, column B, column C, column D, column E, and column F are stored separated by commas. Similarly, (4) cell height of the cell definition information 41 stores the height values of row 1, row 2, row 3, row 4, and row 5 separated by commas.

As described above, the data structure of the cell definition information 41 and the method of calculating the cell width and cell height of the format definition of the spreadsheet to be generated have been described with reference to FIGS.
Next, the cell information 42 will be described. As described above, the cell information 42 is information corresponding to each cell of the spreadsheet, and is information generated by the intermediate data synthesis unit 33.

  First, the intermediate data synthesis unit 33 secures a storage area for sequentially storing the cell information of each row for each piece of information indicating the number of rows as shown in FIG. In this area, for example, information indicating the first row is stored in “row information” in FIG. 29, and cell information in the first row, first column, and cell information in the first row, second column below the “row information”. ,... Are arranged in order. Then, in the intermediate data composition unit 33, for each item information of the intermediate data (table) 36, the cell in which the corresponding item is arranged is specified, and the cell information 42 is stored in the cell information storage area shown in FIG. 28 corresponding to the cell. Process to store. Hereinafter, the structure of the cell information 42 will be described in detail.

  First, the data structure of the cell information 42 is shown in FIG. The cell information includes (1) data, (2) format, (3) font, (4) placement attribute, (5) cell combination, (6) ruled line, and (7) shaded data. Detailed description of each information of (1) to (7) is as follows.

  (1) Data: Cell data itself. Data obtained by converting (8) character string data of <1> item information of intermediate data (table) 36 as necessary based on (2) data format of <1> item information of intermediate data (table) 36 Is stored.

  (2) Format: Information specifying the format of the corresponding cell. Stored is information on the format of the corresponding cell in the generated spreadsheet, which is generated based on the (7) edit format of the item information <1> in the intermediate data (table) 36.

(3) Font: Information indicating the font name and font size. A copy of (6) font information of <1> item information of the intermediate data (table) 36 is stored.
(4) Arrangement attribute: Information related to character arrangement such as center alignment. A copy of (5) arrangement information of <1> item information of the intermediate data (table) 36 is stored.

(5) Cell combination: Information indicating a cell combination range. A method of combining cells will be described later with reference to FIG.
(6) Ruled line: Information indicating the ruled line of the cell. When the range of the start position and the end position of the ruled line is calculated based on (1) type and (2) position information of the <2> ruled line information of the intermediate data (table) 36, and the corresponding cell is included in the range , Information about ruled lines is stored

  (7) Shading: Information indicating shading of the corresponding cell. When the range of the start position and end position of shading is calculated based on (1) type and (2) position information of <2> ruled line information in the intermediate data (table) 36, and the corresponding cell is included in the range In addition, information about shading is stored.

Now, the cell combination (5) will be described with reference to FIG.
It is assumed that Table 1 and Table 2 shown in (i) of FIG. 29 are combined by 2UP (A4 vertical direction, section 2 is disposed below section 1).

  In this case, after the intermediate data generation unit 30, the intermediate data management information generation unit 31, and the cell definition information generation unit 32, the combined format definition of Table 1 and Table 2, that is, the cell width and cell height of the generated spreadsheet Is determined as (ii).

  Then, in the intermediate data composition unit 33, <1> item information from the (1) item position of the <1> item information of the intermediate data (table) 36 on the basic format definition of the spreadsheet to be generated. (8) Character string data is arranged. Then, it becomes like (iii). Here, for example, for the item “Spouse” next to “Family Information” and “Principal” in the top row, the character string of “Spouse” extends over two columns. This is determined from the (1) item position of the <1> item information of the intermediate data (table) 36, the (4) item range of the <1> item information of the intermediate data (table) 36, and the cell definition information 41. can do. In this way, in the format definition of the spreadsheet to be generated defined by the cell definition information 41, when the character string is displayed across a plurality of cells, the corresponding cells are combined based on the item range. . In (iv) of FIG. 29, “spouse”, “Δ □ Hanako”, “1955/10/10”, “medical record”, “date”, “hospital name”, “payment amount”, “1988” The cells corresponding to the character strings of “/ 08/08”, “Ox Hospital”, and “¥ 10,000” are specified as the combined range. Then, cell combination is performed as shown in FIG.

  In “<2> Cell information (5) Cell combination of cell information 42” in FIG. 28, information on the cell ranges combined as described above is stored. For example, the character string of “spouse” in (iv) in FIG. 29 is called “(1, 3), (1, 4)” because the cell in the first row, the third column, and the first row, the fourth column are combined. Information is stored in “<2> Cell information (5) Cell combination of cell information 42”.

  As described above, in the spread generation system 1 of the present embodiment shown in FIG. 3, the print data is input, and the cell information 42 that is composite data is generated with reference to the data structure. Thereafter, in this embodiment, the cell information 42 for all cells on one spreadsheet is converted into an Extensible Markup Language (hereinafter abbreviated as XML) format, and the XML format data is further converted into a spreadsheet format. To output a spreadsheet. The XML format data and the spreadsheet format data will be described later.

The structure of each data in the spreadsheet generation system 1 of the present embodiment shown in FIG. 3 has been described in detail above with reference to FIGS.
As described above, the system structure of the spreadsheet generation system 1 of the present embodiment and the structure of data used or generated by the system have been clarified. Therefore, the operation flow of the system will be described in detail below.

FIG. 30 shows an overall system flow of the spreadsheet generation system 1 of the present embodiment.
First, in S301, the intermediate data generation unit 30 generates intermediate data (table) 36 for table composition from the format definition information and the print data 35. Next, in S <b> 302, the intermediate data management information generation unit 31 generates intermediate data management information 39 and logical coordinate information (after synthesis) 38 from the table synthesis control information 37 and the intermediate data (table) 36. In step S <b> 303, the cell definition information generation unit 32 generates cell definition information 41 from the logical coordinate information (after synthesis) 38 and the cell control information 40. Next, in S304, the intermediate data composition unit 33 obtains cell information 42 for all cells on one spreadsheet from the intermediate data (table) 36, the intermediate data management information 39, and the cell definition information 41. Generate composite data that contains. Finally, in S305, the spreadsheet output unit 34 converts each cell information 42 of the composite data into data in a spreadsheet format, and generates a spreadsheet.

  S301 will be described in detail with reference to FIG. S302 will be described in detail with reference to FIG. S303 will be described in detail with reference to FIGS. S304 will be described in detail with reference to FIGS. S305 will be described in detail with reference to FIG.

First, the intermediate data generation process of S301 will be described with reference to FIG.
First, in step S311, format definition information and print data 35 are read. In S312, intermediate data (table) 36 is generated. Specifically, <1> item information (FIG. 11), <2> ruled line information (FIG. 12), <3> logical coordinate information (before synthesis) (FIG. 13), <4> vertical and horizontal sizes of intermediate data (table) 36 (FIG. 14) is generated.

  Each information of <1> item information of the intermediate data (table) 36 is generated as follows. (1) Item position stores a copy of (2) item position information of <1> item information of format definition information. (2) Data format stores (5) data format copy of <1> item information of format definition information. (3) Data length stores a copy of (4) data length of <1> item information of format definition information. (4) The item range is calculated from (3) item area length of <1> item information of format definition information. (5) Arrangement information stores a copy of (7) arrangement information of <1> item information of format definition information. (6) Font information stores a copy of (6) font information of <1> item information of format definition information. (7) The edit format stores a copy of (8) edit format of <1> item information of format definition information. (8) The character string data is read from the print data record based on (9) information indicated by the position in the record of (1) item information of the format definition information and (4) the data length, and the acquired character string data is Stored.

  Each information of <2> ruled line information of the intermediate data (table) 36 is generated as follows. (1) Type stores a copy of (1) type of <2> ruled line information of format definition information. (2) Position information stores a copy of (2) position information of <2> ruled line information of format definition information.

  Each information of <3> logical coordinate information (before synthesis) of the intermediate data (table) 36 is generated as follows. (1) The number of registrations is the number of <1> item information. (2) The x-coordinate of the item position is stored by separating the x-coordinate of the coordinate information of the position information of the item (2) item information of the format definition information <1> by separating the number of registrations with a comma. . (2) The y-coordinate of the item position is stored by dividing the y-coordinate of the coordinate information of the position information of the item (2) item information of the <1> item information of the format definition information by separating the number by the number of registrations. .

  Further, each piece of information of <4> vertical and horizontal sizes of the intermediate data (table) 36 is generated as follows. The vertical size of the table corresponding to the intermediate data (table) 36 is calculated from the position information of the item at the lowest rightmost position in the table before composition, and (1) is stored in the vertical size. Similarly, the horizontal size is also calculated and (2) stored in the horizontal size.

Next, in S313, reference information (link) to the generated intermediate data is stored in the temporary storage.
In the above, S301 of FIG. 30 was demonstrated. Next, S302 in FIG. 30 will be described with reference to FIG.

  In S302, processing for generating the intermediate data management information 39 is performed. First, in S321, each information of the table composition control information 37 is copied and stored in the corresponding information storage column of the intermediate data management information 39. As shown in FIG. 15, the table composition control information 27 has a structure including (1) paper size type, (2) paper direction, (3) placement attribute, and (4) placement direction. These pieces of information are copied and stored in (1) paper size type, (2) paper orientation, (3) placement attribute, (4) placement orientation, and (see FIG. 17) in the intermediate data management information 39, respectively. In step S322, the longest vertical and horizontal sizes of each table are specified. From the <4> vertical and horizontal sizes of the intermediate data (table) 36, the longest vertical and horizontal sizes of each table can be specified. In step S323, the ratio between the vertical size and horizontal size of the generated spreadsheet is calculated from the paper size and the paper direction copied from the table composition control information 37 in S321.

  Next, in S324, the size of the smallest one section that fits the vertical and horizontal sizes is calculated. In step S325, (3) the layout attribute is copied from the table composition control information 37 in step S321, whether the layout is 2UP or 4UP is specified, and the vertical and horizontal sizes of the generated spreadsheet are calculated. When the tables are not synthesized, the vertical and horizontal sizes of one table are the vertical and horizontal sizes of the spreadsheet to be generated as they are. Then, the calculated information is stored in the intermediate data management information 39 in (5) vertical and horizontal sizes after the synthesis of the intermediate data. Note that the processing of S322 to S325 is a portion where the processing described in FIG. 20 is performed.

Next, in S326, the reference information (link) to the intermediate data temporarily stored in S313 of FIG. 31 is stored in (6) reference information to the intermediate data in the intermediate data management information 39.
Thereafter, in S327 to S329, processing for generating logical coordinate information (after synthesis) 38 is performed.

  In S327, the 2UP or 4UP is identified by the (3) placement attribute copied in S321, and the processing of S328 and S329 is performed for 2 partitions for 2UP and 4 partitions for 4UP. Judgment.

  In S328, the coordinate correction information is calculated. That is, the correction information for each of the sections 2 to 4 is calculated based on (3) the layout attribute, (4) the layout direction, and the vertical and horizontal size of the spreadsheet calculated in S325 copied in S321. In S329, the correction information of the section corresponding to <3> logical coordinate information (before synthesis) (FIG. 13) of the intermediate data (table) 36 is added to generate logical coordinate information (after synthesis) 38. The processing of S327 to S329 is as described with reference to FIG.

Next, S303 in FIG. 30 will be described with reference to FIGS.
S303 is processing for generating cell definition information 41, which is the format definition of the spreadsheet to be generated. First, in S331 and S332, a process of calculating a cell width (column width) in the format definition is performed. Next, in S333 and S334, processing for calculating the cell height (row height) in the format definition is performed. Since the process for calculating the cell width and the process for calculating the cell height are similar processes, S331 and S332 will be described in detail, and S333 and S334 will be described briefly.

  First, in S331, the x-coordinate value is stored for the logical coordinate information (after synthesis) 38, and in ascending order based on the x-coordinate value of the item position (2) of the logical coordinate information (after synthesis) 38. Sort. Next, in S332, a cell width (column width) calculation process is performed.

For S332, a more detailed flow is shown in FIG.
In S341, control information for executing the processing flow is initialized. Control information is temporary information for controlling a flow. This control information includes a column position counter for indicating which column width is calculated, information for storing the previous item position, and information registered in the logical coordinate information (after synthesis) 38. There are three processing number counters that count how many of these are processed. Hereinafter, the column position counter will be referred to as “system) column position counter”, the previous item position will be referred to as “system) previous item position”, and the processing number counter will be referred to as “control) processing number counter”. In step S341, “system) column position counter” and “system) previous item position” are initialized to 0, and “system) processing number counter” is initialized to 1.

  Next, in S342, it is determined whether or not the value of the “system) processing number counter is equal to or less than the value stored in (1) the registered number of the logical coordinate information (after synthesis) 38. If No in S342, the process proceeds to S345. If Yes in S342, the process proceeds to S343. In S343, the value of (2) item position x coordinate of logical coordinate information (after synthesis) 38 is extracted. Then, the process proceeds to S344.

In S344, a process of determining the cell width (column width) is performed, which will be described in more detail with reference to FIG.
First, in S351, the distance between items is calculated. That is, the difference between the value of the x coordinate extracted in S343 and the “previous item position” as control information is obtained. Next, in S352, it is determined whether the distance between the items obtained in S351 is larger than (3) the rounding width of the cell control information 40. If No in S352, the process proceeds to S359. If Yes in S352, the process proceeds to S353. In S353, it is determined whether or not the distance between the items obtained in S351 is at least twice the (1) basic cell width of the cell control information 40. In the case of No in S353, the process proceeds to S357. If Yes in S353, the process proceeds to S354.

  In S354, the cell width (column width) of the column indicated by the “control column position counter” is determined as the basic cell width. In step S355, the “control) column position counter” is updated. Next, it progresses to S356 and updates the distance between items. That is, the basic cell width is subtracted from the distance between items, and the obtained result is set as the distance between items. Then, the process returns to S353.

  If it is determined in S353 that the distance between items is less than twice the basic cell, the process proceeds to S357. In S357, the cell width (column width) of the column indicated by the “control” column position counter is determined as the distance between items. Then, the process proceeds to S358 to update the “system) previous item position (X)” and “system) column position counter”.

  If it is determined No in S352 or after S358, the process proceeds to S359. In S359, the “control” process number counter ”is incremented by 1, and the process returns to the called step (S344 or S346) in FIG.

Returning to the description of FIG. After the process of S344, the process returns to S342, and when the “system) process number counter is equal to or greater than the registration number of the logical coordinate information, the process proceeds from S342 to S345.
In S345, the right end of the size of the spreadsheet to be generated is used as the item position, and the value of the x coordinate is extracted. S345 and S346 are processes for determining the cell width (column width) of the last column. In S346, the same processing as S344 is performed. With the above processing, the cell widths (column widths) of all the columns of the generated spreadsheet are determined.

Note that the processing of S331 and S332 of FIG. 33 including the processing of FIGS. 34 and 35 described above corresponds to the processing described with reference to FIGS.
Similarly, the processing of S333 and S334 in FIG. 33 is performed, and the cell height (row height) is determined for all the rows of the generated spreadsheet. First, in S333, the logical coordinate information (after synthesis) is sorted in ascending order based on the y coordinate value of (2) item position of logical coordinate information (after synthesis) 38 in which the y coordinate value is stored. To do. In step S334, the cell height (row height) is calculated.

  FIG. 36 shows a detailed flow of S334. The flow shown in FIG. 36 is the same as the flow shown in FIG. 34. Steps S361, S362, S363, S364, S365, and S366 are the same as steps S341, S342, S343, S344, and S345 in FIG. The same processing is performed corresponding to each of S346. In particular, the detailed flow of S363 and S366 is shown in FIG. The flow shown in FIG. 37 is the same flow as the flow shown in FIG. Steps S371, S372, S373, S374, S375, S376, S377, S378, and S379 correspond to S351, S352, S353, S354, S355, S356, S357, S358, and S359, respectively, and perform the same processing.

As described above, the flow of the process of generating the cell definition information 41, which is the process of S303 of FIG. 30, has been described in detail with reference to FIGS.
Next, the intermediate data synthesis process, which is the process of S304 in FIG. 30, will be described in detail with reference to FIGS.

The intermediate data synthesis unit 33 performs a process of converting a plurality of intermediate data (table) 36 into data corresponding to one spreadsheet by the process of S304.
As shown in FIG. 38, the intermediate data composition unit 33 first initializes the counter to 0 in S380. Next, in S381, it is determined whether the counter is less than the number of data in the intermediate data (table) 36 or not. That is, for example, in the case of 2UP, it is determined whether or not the counter is less than 2. For example, in the case of 4UP, it is determined whether or not the counter is less than 4. In the case of No in S381, since all intermediate data (table) 36 has been processed, the processing ends. If Yes in S381, the process proceeds to S382.

  In S382, information for correcting (1) item position included in <1> item information of the intermediate data (table) 36 is calculated. That is, the correction information for correcting the position where the item information is arranged is calculated based on (3) the arrangement attribute, (4) the arrangement direction, and (5) the vertical and horizontal size of the intermediate data after the composition of the intermediate data management information 39. .

  In step S383, the item counter is initialized to zero. Next, in S384, if the item counter is equal to or greater than the number of registrations of item information in the intermediate data (table) 36 (the number of registrations of item information is <3> logical coordinate information (before composition) of the intermediate data (table) 36. (1) obtained from the number of registrations), the process proceeds to S391. In S391, the counter is incremented, and the process returns to S381. If the item counter is less than the registered number of item information (table) 36 of the intermediate data in S384, the process proceeds to S385. In S385, using the correction information calculated in S382, a process for converting the position of each item into which cell on the spreadsheet is performed. Then, in S386 to S390, various types of information of the cell information 42 are generated for the cell position specified in S385 and stored in the information storage area shown in FIG.

  That is, first in S386, the (1) data of the cell information 42 corresponding to the cell position calculated in S385 (see the data structure of the cell information in FIG. 28) and the <1> item information of the intermediate data (table) 36 are included. (8) Character string data is converted into numerical values and stored. Similarly, in S387, the (2) format of the cell information 42 corresponding to the cell position calculated in S385 is generated based on the (1) editing format of <1> item information of the intermediate data (table) 36. Generate and store a spreadsheet format. In S388, (6) font information of (1) item information of intermediate data (table) 36, respectively, in (3) font and (4) arrangement attribute of cell information 42 corresponding to the cell position calculated in S385, ( 5) Copy and store the placement information. In S389, the cell occupied by the item corresponding to the item information of the intermediate data (table) 36 from the (1) item position, (4) item range, and cell definition information 41 of the item information <1> of the intermediate data (table) 36 The range is specified and stored in (5) cell combination of the cell information 42. In S390, based on the <2> ruled line information of the intermediate data (table) 36, the ruled line and shaded start and end positions are specified and stored in (6) ruled line or (7) shaded in the cell information 42. .

  After S390, the process proceeds to S392, the item counter is incremented by 1, and the process returns to S384. The processing for synthesizing intermediate data performed by the intermediate data synthesizing unit 33 has been described above. Further, S385, S386, S387, S388, S389, and S390 will be described with a more detailed flow.

First, the process of converting the position of the item corresponding to the item information of the intermediate data (table) 36 to the cell position in S385 will be described with reference to FIG. 39 and FIG.
In S393 of FIG. 39, the following (i) indicates which column the item position is based on (1) item position of <1> item information of the intermediate data (table) 36 and the correction information calculated in S382. Calculated by ~ (iii).
(I) First, the variable tmp is initialized with zero.
(Ii) Compare the x-coordinate value of the position of the item corrected with tmp and the correction information.
(Iii) If tmp is smaller than the x coordinate value of the item position corrected by the correction information, the cell width (column width) of the cell definition information 41 is added, and the process returns to (ii).
(Iv) When tmp is larger than the x-coordinate value of the item position corrected by the correction information, that is, the column at the time when the x-coordinate value becomes smaller than tmp is set as the column in which the item is positioned.

  That is, in (i) to (iv), the item position is smaller than the cell boundary value while comparing the cell boundary (Δ mark in FIG. 40) and the item position in order to determine which cell the item position is included in. At that point, the process of specifying the column is performed.

  An example in which a column is specified by (i) to (iv) is shown in FIG. Assume that the column of item C is specified. In this case, the x-coordinate value at the left end of item C is larger than the cell width of column A, column B, and column C added in order. However, when the column A, the column B, the column C, and the column D are added to the x coordinate value at the left end of the item C, the x coordinate value is smaller. That is, the x coordinate value of item C is smaller than Δ4. Therefore, it is specified that column D is the cell position of item C.

Similarly, in S394, the number of the item position is calculated. That is, it calculates by following (I)-(IV).
(I) First, the variable tmp is initialized with zero.
(II) The y-coordinate value of the position of the item corrected by tmp and the correction information is compared.
(III) When tmp is smaller than the y coordinate value of the position of the item corrected by the correction information, the cell height (row height) of the cell definition information 41 is added, and the process returns to (II).
(IV) When tmp is larger than the y-coordinate value of the position of the item corrected by the correction information, that is, the line at the time when the y-coordinate value becomes smaller than tmp is taken as the line where the item is located.

After S393 and S394, the calculated cell position (row, column) is temporarily stored in S395.
The process of S385 has been described above with reference to FIGS. 39 and 40.

  Next, the process of S386, which is a process of setting data in the cell information 42, will be described with reference to FIG. First, in S411, character string data is extracted from (8) character string data of <1> item information of the intermediate data (table) 36. Next, in S412, it is determined whether the (2) data format of the <1> item information of the intermediate data (table) 36 is a date item or a time item. If YES in step S412, the process advances to step S413. If No in S412, the process proceeds to S414. In S413, the character string data is converted into a serial value. Then, the process proceeds to S416.

  In the case of No in S412, the process proceeds to S414, and it is determined whether the (2) data format of the <1> item information in the intermediate data (table) 36 is a numeric item. If Yes in S414, the process proceeds to S415. If No in S414, the process proceeds to S416. In S415, the character string data is converted into a numerical character string. At this time, the presence / absence of a code, the total number of digits, the number of decimal digits, etc. are considered. Then, the process proceeds to S416.

  In S416, the value converted in S413, the value converted in S416, or the character string data that has not been subjected to the conversion process is stored in the cell information 42 corresponding to the cell position calculated in S385 (S395) (1). Store in data.

  The process of S386 has been described above with reference to FIG. Next, the process of S387, which is a process of setting a format for the cell information 42, will be described with reference to FIG. First, in S421, it is determined whether or not (7) editing format of <1> item information of intermediate data (table) 36 is numeric editing. If Yes in S421, the process proceeds to S422. If No in S421, the process proceeds to S423. In S422, a spreadsheet format for numerical editing is generated. For example, in the table shown in FIG. 8, when the editing format in the item information is “9999999”, “000000; 000000” is generated as the spreadsheet format. After S422, the process proceeds to S428.

  In the case of No in S421, the process proceeds to S423, and it is determined whether or not (7) edit format of <1> item information of the intermediate data (table) 36 is date / time edit. If Yes in S423, the process proceeds to S424. If No in S423, the process proceeds to S425. In S424, a spreadsheet format for date and time editing is generated. Then, after S424, the process proceeds to S428.

  In the case of No in S423, the process proceeds to S425, and it is determined whether or not (7) edit format of <1> item information of the intermediate data (table) 36 is postal code editing. If Yes in S425, the process proceeds to S426. If No in S425, the process proceeds to S427. In S426, a spreadsheet format for postal code editing is generated. Then, after S426, the process proceeds to S428.

In the case of No in S425, the process proceeds to S427, and a format indicating character string data is generated. Then, the process proceeds to S428.
In S428, the format of the spreadsheet generated in S422, S424, S426, or S427 is stored in the (2) format of the cell information 42 corresponding to the cell position calculated in S385 (S395).

  The process of S387 has been described above with reference to FIG. Next, the process of S388, which is a process for setting the font and arrangement attribute in the cell information 42, will be described with reference to FIG. First, in S431, the (6) font information of <1> item information of the intermediate data (table) 36 is read and stored in the (3) font of the cell information 42 corresponding to the cell position calculated in S385 (S395). . Next, in S432, the (1) item information (5) arrangement information of the intermediate data (table) 36 is read, and the (4) arrangement attribute of the cell information 42 corresponding to the cell position calculated in S385 (S395) is read. Store.

The process of S388 has been described above with reference to FIG. Next, the process of S389, which is a process for setting cell combination, will be described with reference to FIG. First, in S441, the item position (1) of the item information <1> of the intermediate data (table) 36 is corrected with the correction information calculated in S382, and the item position (1) of the intermediate data (table) 36 is changed to (1). 4) From the item range, the cell definition information 41 is referred to, and the range of the cell corresponding to the range occupied by the item is specified. Next, in S442, the cell range specified in S441 is stored in (5) cell combination of the cell information 42 as a cell combination range.
The process of S389 has been described above with reference to FIG.

  Next, the processing of S390, which is processing for setting ruled lines and shading, will be described with reference to FIG. First, in S451, it is determined whether or not the (2) ruled line information (1) type of the intermediate data (table) 36 is a ruled line. If Yes in S451, the process proceeds to S452. If No in S451, the process proceeds to S453.

  In S452, the cell definition information 41 is referred to from the (2) position information of <2> ruled line information of the intermediate data (table) 36, the ruled line start position (X1, Y1) and the ruled line end position (X2, Y2). Which column and row are included. Then, the process proceeds to S455.

  In S453, it is determined whether the type of (1) in the <2> ruled line information of the intermediate data (table) 36 is shaded. If No in S453, the process ends. If Yes in S453, the process proceeds to S454. In S454, which column and row includes the coordinates of the four corners of the shaded range, upper left (X1, Y1), lower left (X1, Y2), upper right (X2, Y1), and lower right (X2, Y2). Identify. Then, the process proceeds to S455.

In S455, the cell range specified in S452 or S454 is stored as a ruled line or shaded range in (6) ruled line or (7) shaded in the cell information 42, respectively.
As described above, the process of combining the intermediate data (table) 36, which is the process of S304 of FIG. 30, has been described in detail with reference to FIGS.

Next, the spreadsheet generation process, which is the process of S305 in FIG. 30, will be described in detail with reference to FIG.
First, a pointer pointing to the cell information 42 is initialized in S460. As a result, the cell information 42 storing the information of the cell in the first row and the first column of the synthesized table is pointed.

Next, in S461, it is determined whether there is cell information where the pointer points. If there is no cell information, the process proceeds to S468. If there is cell information, the process proceeds to S462.
In S462 to S466, the cell information 42 includes (1) data, (2) format, (3) font, (4) layout attribute, (5) cell combination, (6) ruled line, and (7) shaded information. Each is converted to XML format. That is, in S462, (1) data of the cell information 42 is output in the XML format. In step S463, the (2) format of the cell information 42 is output in the XML format. Next, in S464, (3) font and (4) arrangement attribute of the cell information 42 are output in the XML format. In S465, (6) cell combination of the cell information 42 is output in the XML format. In S466, the (6) ruled line and (7) shaded portion of the cell information 42 are output in the XML format.

Then, after S466, the pointer is updated in S467, and the next cell information is pointed to and the process returns to S461.
Through the processes in S460 to S467, all cell information is converted to the XML format. Thereafter, in S468, the table data described in the XML format is converted into a spreadsheet. The process of converting the XML-format table data in S468 into a spreadsheet uses an existing tool or the like.

  Also, the XML format data generated in S460 to S467 is conceptually, for example, as shown in FIG. 47, although it depends on the tool used in S468. XML is a language called a structured language, and it is possible to distinguish the contents of document data using tags, so that each information of the cell information 42 is distinguished using tags.

  In the above, S305 has been described with reference to FIG. A spreadsheet is generated in S305 of FIG. 30, the spreadsheet is output from the spreadsheet generation system 1 of the present embodiment, and the processing is completed.

The present embodiment has been described in detail with reference to FIGS.
As described above, in this embodiment, first, print data corresponding to a plurality of tables is converted to generate a plurality of intermediate data. Then, the plurality of intermediate data are combined to generate combined data including cell information for all cells of one spreadsheet. Further, each cell information in the composite data is converted into a spreadsheet format to generate a spreadsheet. As described above, in the present embodiment, it is possible to output print data corresponding to a plurality of tables to one spreadsheet by using intermediate data. In addition, when synthesizing intermediate data, processing to prevent the layout of each table from being destroyed and processing to prevent unnecessary cells from being generated are performed. Is unnecessary. In other words, as shown in FIG. 48, when two tables, Table 1 and Table 2, are combined with 2UP, the spreadsheet is maintained so that the layout of each table is maintained and fine useless cells are not generated. Can be generated. Thereby, according to this embodiment, it can be said that the work efficiency of a user etc. can be raised and the secondary availability of print data can be improved.

  Needless to say, the present invention is not limited to the description in the above embodiment, and various modifications can be made without departing from the spirit of the present invention.

With respect to the embodiment described with reference to FIGS. 1 to 48, the following additional notes are disclosed.
(Appendix 1)
In the information processing device,
An intermediate data generation step of generating a plurality of intermediate data corresponding to each table, including all items of positional information in the table of a plurality of items included in each table, from print data corresponding to the plurality of tables When,
A post-combination position information generation step for correcting the position information of each item included in the intermediate data with respect to the plurality of intermediate data, respectively, based on the control information for table composition,
Determine the format definition of the spreadsheet that combines and outputs the plurality of tables based on the combined position information of each item included in the intermediate data and the cell control information that defines the basic cell size. A format definition determination step;
Based on the position information after the combination of the items, cell position information indicating which cells on the spreadsheet are arranged based on the format definition is calculated, and the cell position information is supported. Generating cell information storing information related to items arranged in the cells to be output, and outputting the cell information for all cells of the spreadsheet as combined data;
A spreadsheet output step of converting each cell information of the composite data into spreadsheet format data, outputting the spreadsheet as cell format cell information for all cells of the spreadsheet,
A spreadsheet generation program characterized in that the program is executed.
(Appendix 2)
The cell control information is information including a basic cell width, a basic cell height, a rounded cell width, and a rounded cell height,
The format definition determining step includes:
First, the respective items are sorted with respect to the x-coordinate in the position information after the combination of the respective items, and the distance between the items is obtained by obtaining the difference of the x-coordinate values in order for the sorted items. If the width is less than the rounded cell width, the column in the format definition is not set, and if the distance between the items is not less than the rounded cell width and not less than twice the basic cell width, the basic cell The column in the format definition is set by the width, and the column in the format definition is set by the distance between the items when the distance between the items is not less than the rounding width and less than twice the basic cell width. After processing all items sorted for the x coordinate,
The items are sorted with respect to the y-coordinate in the position information after the combination of the items, the distance between the items is obtained by sequentially obtaining the difference of the y-coordinate values for the sorted items, and the distance between the items is rounded. If it is less than the cell height, no line is set in the format definition, and if the distance between the items is not less than the rounding height and not less than twice the basic cell height, the basic cell height To set the row in the format definition, and if the distance between the items is not less than the rounding height and less than twice the basic cell height, the row in the format definition is set with the distance between the items. And processing all items sorted for the y coordinate,
The spreadsheet generation program according to appendix 1, wherein the format definition of the spreadsheet to be output is determined.
(Appendix 3)
The information on the item includes information indicating the range of the item,
In the combining step, the items are arranged across a plurality of cells on the spreadsheet based on the format definition based on the position information after combining the items and information indicating the range of the items. If it is determined that the cell information is stored, information indicating that the corresponding cell range is to be combined is recorded in an area for storing information related to cell combination further included in the cell information. Sheet generation program.
(Appendix 4)
The information on the item includes the data of the item, the data length of the data, the range of the item, the font information of the item, the arrangement information of the item, and the editing method of the item. The spreadsheet generation program according to any one of Supplementary Note 1 to Supplementary Note 3, characterized by:
(Appendix 5)
Intermediate data generation means for generating a plurality of intermediate data corresponding to each table from the print data corresponding to the plurality of tables, including all pieces of positional information in the table of a plurality of items included in each table. When,
Post-combination position information generating means for correcting the position information of each item included in the intermediate data with respect to the plurality of intermediate data, respectively, based on the control information for table composition,
Determine the format definition of the spreadsheet that combines and outputs the plurality of tables based on the combined position information of each item included in the intermediate data and the cell control information that defines the basic cell size. , Format definition determination means,
Based on the position information after the combination of the items, cell position information indicating which cells on the spreadsheet are arranged based on the format definition is calculated, and the cell position information is supported. Generating cell information storing information relating to items arranged in the cells to be output, and outputting the cell information for all cells of the spreadsheet as combined data;
Spreadsheet output means for converting each cell information of the composite data into a spreadsheet format, converting cell information for all cells of the spreadsheet into spreadsheet format data, and outputting the spreadsheet;
A spreadsheet generation apparatus comprising:
(Appendix 6)
Information processing device
From the print data corresponding to a plurality of tables, generate a plurality of intermediate data corresponding to each table, including all items of positional information in the table of a plurality of items included in each table,
For the plurality of intermediate data, the position information of each item included in the intermediate data is corrected to the combined position information based on the control information for table composition,
Determine the format definition of the spreadsheet that combines and outputs the plurality of tables based on the position information after combining the items included in the intermediate data and the cell control information that defines the basic cell size. ,
Based on the position information after the combination of the items, cell position information indicating which cells on the spreadsheet are arranged based on the format definition is calculated, and the cell position information is supported. Cell information that stores information related to items placed in the cells to be generated, and the cell information for all cells in the spreadsheet is output as composite data;
Each cell information of the composite data is converted into a spreadsheet format, and cell information for all cells of the spreadsheet is output as spreadsheet format data, and a spreadsheet is output.
A spreadsheet generation method characterized by the above.
(Appendix 7)
Information processing device
From the print data corresponding to a plurality of tables, generate a plurality of intermediate data corresponding to each table, including all items of positional information in each table included in each table,
For the plurality of intermediate data, the position information of each item included in the intermediate data is corrected to the combined position information based on the control information for table composition,
Determine the format definition of the spreadsheet that combines and outputs the plurality of tables based on the position information after combining the items included in the intermediate data and the cell control information that defines the basic cell size. ,
Based on the position information after the combination of the items, cell position information indicating which cells on the spreadsheet are arranged based on the format definition is calculated, and the cell position information is supported. Generating cell information storing information related to items arranged in the cells, outputting the cell information for all cells of the spreadsheet as composite data, and holding the composite data;
And a print data processing method.

1 Spreadsheet Generation System 2 Intermediate Data Generation Device 3 Intermediate Data Synthesis Device 4 Spreadsheet Output Device 5 Print Data 6 Format Definition Information 7 Spreadsheet 8 Business Application 9 Form Definition Tool 10 CPU
11 ROM
12 RAM
13 Communication Interface 14 Input Device 15 Output Device 16 Storage Device 17 Drive Device 18 Bus 19 Portable Storage Medium 20 Network 21 Program Provider 22 Information Processing Device 30 Intermediate Data Generation Unit 31 Intermediate Data Management Information Generation Unit 32 Cell Definition Information Generation Unit 33 Intermediate data composition unit 34 Spreadsheet output unit 35 Format definition information and print data 36 Intermediate data (table)
37 Table composition control information 38 Logical coordinate information (after composition)
39 Intermediate data management information 40 Cell control information 41 Cell definition information 42 Cell information 43 Spreadsheet

Claims (7)

In the information processing device,
Generating, for each of the plurality of tables, intermediate data including position information in the table of items included in the plurality of tables from print data corresponding to the plurality of tables;
For the plurality of intermediate data, based on control information including information indicating the number of tables to be combined when combining the plurality of tables , the position information of each item included in the intermediate data is stored in a storage unit. The position information in the table after synthesis is corrected according to the number of tables to be synthesized,
Based on the corrected position information of each item included in the intermediate data, calculate cell position information indicating which cell on which each item is arranged in a predetermined spreadsheet;
Outputting a spreadsheet generated based on the cell information about the spreadsheet , storing information about the values of items placed in the cells corresponding to the cell location information;
A spreadsheet generation program characterized by causing processing to be executed. The control information includes a size of a printing paper, a direction of the printing paper, and the number of the tables to be combined on one printing paper,
The storage means stores cell control information including information on basic cell width, basic cell height, rounded cell width, rounded cell height,
In the information processing apparatus,
For the plurality of intermediate data, based on the control information, determine a section by dividing the printing paper on which each of the plurality of tables is arranged, and based on the size, direction, and position of the table corresponding to the section, The position information of each item included in the intermediate data is converted and corrected to the position information in the combined table, respectively.
Based on the corrected position information of each item included in the intermediate data and the cell control information, a format definition of a spreadsheet for combining and outputting the table for each of the plurality of sections is determined.
The spreadsheet generation program according to claim 1, wherein the processing is executed. The storage means stores cell control information including information on basic cell width, basic cell height, rounded cell width, rounded cell height,
In the information processing apparatus,
The items are sorted with respect to the x coordinate in the corrected position information of each item, and the distance between the items is obtained by obtaining the difference of the x coordinate values in order for the sorted items. If it is less than the rounded cell width, the column in the format definition is not set, and if the distance between the items is not less than the rounded cell width and not less than twice the basic cell width, the basic cell width A column in the format definition is set, and if the distance between the items is greater than or equal to the rounding width and less than twice the basic cell width, the column in the format definition is set with the distance between the items, Process all items sorted for x coordinate,
The items are sorted with respect to the y-coordinate in the position information of the corrected items, and the distance between the items is obtained by sequentially obtaining the difference of the y-coordinate values for the sorted items. If it is less than the cell height, no line is set in the format definition, and if the distance between the items is not less than the rounding height and not less than twice the basic cell height, the basic cell height To set the row in the format definition, and if the distance between the items is not less than the rounding height and less than twice the basic cell height, the row in the format definition is set with the distance between the items. And processing for all items sorted with respect to the y coordinate,
Determining the format definition of the output spreadsheet;
The spreadsheet generation program according to claim 1, wherein the processing is executed. The information regarding the value of the item includes information indicating the range of the item,
In the information processing apparatus,
Based on the corrected position information of each item and the information indicating the range of the item, it is determined that the item is arranged across a plurality of cells on the spreadsheet based on the format definition. In the case, information indicating that the corresponding cell range is combined is recorded in an area for storing information on cell combination further provided in the cell information.
4. The spreadsheet generating program according to claim 2, wherein the processing is executed. Information on the value of the item includes the data of the item , the data length of the data, the range of the item , the font information of the item , the arrangement information of the item, and the editing method of the item. The spreadsheet generation program according to claim 4 , further comprising: Intermediate data generating means for generating, for each of the plurality of tables, intermediate data including position information in the table of items included in the plurality of tables from print data corresponding to the plurality of tables;
For the plurality of intermediate data, based on control information including information indicating the number of tables to be combined when combining the plurality of tables , the position information of each item included in the intermediate data is stored in a storage unit. A post-combination position information generation unit that corrects the position information in the post-combination table according to the number of tables to be combined;
Based on the corrected position information of each item included in the intermediate data, each calculated item is arranged in a cell corresponding to cell position information indicating in which cell on a predetermined spreadsheet. A spreadsheet output means for outputting a spreadsheet generated based on cell information about the spreadsheet , storing information about the value of the item to be
A spreadsheet generation apparatus comprising: Information processing device
Generating, for each of the plurality of tables, intermediate data including position information in the table of items included in the plurality of tables from print data corresponding to the plurality of tables;
For the plurality of intermediate data, based on control information including information indicating the number of tables to be combined when combining the plurality of tables , the position information of each item included in the intermediate data is stored in a storage unit. The position information in the table after synthesis is corrected according to the number of tables to be synthesized,
Based on the corrected position information of each item included in the intermediate data, calculate cell position information indicating which cell on which each item is arranged in a predetermined spreadsheet;
Outputting a spreadsheet generated based on the cell information about the spreadsheet , storing information about the values of items placed in the cells corresponding to the cell location information;
A spreadsheet generation method characterized by the above.

Images