JPWO2014103024A1 - Table synthesis apparatus and table synthesis program - Google Patents

Abstract

It is an object to generate composite data in a form that is easy for the user to see. A storage unit for storing a plurality of table data including a plurality of data items corresponding to a plurality of data labels arranged in a row direction and created in a table format, and table data obtained by combining the plurality of data files, Data labels are arranged in rows set for each table data, and data labels common to the table data are arranged in an area where a plurality of rows are combined, and data items corresponding to the data labels are arranged in the column direction. A table synthesizing apparatus comprising: a generating unit that generates the table data.

Description

  The present invention relates to a table synthesis device and a table synthesis program.

  Conventionally, tabular data files have been created by general-purpose software such as word processing software, spreadsheet software, and presentation software that run on a computer.

  In relation to this, a spreadsheet generation program for outputting spreadsheet format data obtained by synthesizing tabular data files is known (for example, see Patent Document 1).

JP2011-198296A

  However, the above-described spreadsheet generation program is not intended to synthesize a plurality of forms that are likely to have common data items, which are used for personnel management, business management, manufacturing management, and the like. For this reason, when the same type of data item is included in each of the plurality of source files, it may be impossible to output composite data that is easy for the user to see.

  An object of one aspect is to generate composite data in a form that is easy for a user to view.

  A table composition apparatus according to one aspect combines a plurality of data files with a storage unit that stores a plurality of table data including a plurality of data items created in a table format and corresponding to a plurality of data labels arranged in a row direction. Table data, wherein the plurality of data labels are arranged in a row set for each table data, and a data label common to the table data is arranged in an area where a plurality of rows are combined, and corresponds to the data label A generation unit that generates table data in which data items are arranged in a column direction.

  According to one aspect, it is possible to generate composite data in an aspect that is easy for the user to see.

It is a hardware structural example of the table | surface synthetic | combination apparatus 1 which concerns on one Example. 2 is a functional configuration example of a table synthesis device 1; It is an example of the flowchart which shows the flow of the whole process which the table | surface synthetic | combination apparatus 1 performs. It is a figure which shows an example of the data structure of the format definition 12I and the print data 12H. <1> It is a figure which shows an example of the data structure of item information. <2> It is a figure which shows an example of the data structure of ruled line information. It is a figure which shows a response | compatibility with the edit format in the format definition 12I, an edit format, and the format (display format) of a spreadsheet. It is an example of the flowchart which shows the flow of the intermediate data generation process performed by 10 A of intermediate data generation parts. It is an example of the data structure of 12 A of intermediate data. <1> An example of a data structure of character string information. <3> An example of the data structure of logical coordinate information. <4> This is an example of a vertical and horizontal data structure. It is an example of the table composition control information 12J. It is an example of the data structure of the intermediate data management information 12B in which the table composition control information 12J is reflected. It is an example of the generated intermediate data management information 12B. It is an example of the flowchart which shows the flow of a detailed data extraction process. It is an example of a data structure of cell definition information 12D. It is an example of a data structure of the cell control information 12K. It is an example of the flowchart which shows the flow of a label mapping information generation process. It is an example of the data structure of label mapping information 12E. It is an example of the flowchart which shows the flow of a detailed data synthetic | combination process. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is a figure which shows a mode that a layout is synthesize | combined by the process of the detail data synthetic | combination part 10F. It is an example of a data structure of cell information 12G. It is a figure which shows typically the flow of a process by the table synthesis apparatus 1, and the change of a data structure.

  DESCRIPTION OF EMBODIMENTS Hereinafter, embodiments for carrying out the present invention will be described with reference to the accompanying drawings.

  Embodiments of a table synthesis apparatus and a table synthesis program will be described below with reference to the drawings.

[Hardware configuration]
FIG. 1 is a hardware configuration example of a table synthesizing apparatus 1 according to an embodiment. The table synthesizing apparatus 1 includes, for example, a CPU (Central Processing Unit) 10, a memory 12, an HDD (Hard Disk Drive) 14, a drive device 16, a display control unit 20, a display device 22, and an input device 24. The communication control unit 26 is provided.

  The CPU 10 is a processor having, for example, a program counter, an instruction decoder, various arithmetic units, an LSU (Load Store Unit), a general-purpose register, and the like. The memory 12 is, for example, a RAM (Random Access Memory). The HDD 14 stores programs executed by the CPU 10 and other data. The table synthesizing apparatus 1 may include another storage device such as an SSD (Solid State Drive) instead of the HDD 14. The drive device 16 is a device that can read programs and data from the storage medium 18. When the storage medium 18 on which the program is recorded is loaded into the drive device 16, the program is installed from the storage medium 18 to the HDD 14 via the drive device 16. The storage medium 18 is a portable storage medium such as a CD (Compact Disc), a DVD (Digital Versatile Disc), or a USB (Universal Serial Bus) memory. In addition to using the storage medium 18, the program can be installed by the communication control unit 26 being downloaded from another computer via the network and installed in the HDD 14. The program executed in the table synthesizing apparatus 1 may be stored in advance in the HDD 14, ROM, or the like when the table synthesizing apparatus 1 is shipped.

  The display control unit 20 is a logic circuit for generating a screen displayed by the display device 22, for example. The display device 22 is a display device such as an LCD (Liquid Crystal Display), a CRT (Cathode Ray Tube), or an organic EL (Electroluminescence). The input device 24 includes, for example, a mouse, a keyboard, a touch panel mechanism, a touch pad, and the like.

[Function configuration]
FIG. 2 is a functional configuration example of the table synthesizing apparatus 1. The table synthesizing apparatus 1 includes an intermediate data generation unit 10A, an intermediate data management information generation unit 10B, a detailed data extraction unit 10C, a cell, and a functional block that functions when the CPU 10 executes a program stored in the HDD 14 or the like. A definition information generation unit 10D, a label mapping information generation unit 10E, a detail data synthesis unit 10F, and a print data generation unit 10G are provided. Note that these functional blocks do not need to be realized by a clearly separated program, and may be called by other programs as subroutines or functions. Further, a part of the functional blocks may be hardware means such as an LSI (Large Scale Integrated circuit), an IC (Integrated Circuit), or an FPGA (Field Programmable Gate Array).

  The table synthesizing apparatus 1 includes intermediate data 12A, intermediate data management information 12B, detailed data 12C, cell definition information (for each sheet) 12D, label mapping information 12E, cell definition information (after synthesis) 12F, cell information 12G, and the like. Data is generated and stored in the memory 12. In addition to the above, the memory 12 stores print data 12H, a format definition 12I, table composition control information 12J, cell control information 12K, and the like. These data are, for example, input by the user or default data loaded from the HDD 14.

[Processing flow etc.]
FIG. 3 is an example of a flowchart showing the overall processing flow executed by the table synthesizing apparatus 1.

  First, the table synthesizing device 1 acquires the print data 12H and the format definition 12I from the HDD 14, the storage device 18 via the drive device 16, or the network via the communication control unit 26, and stores the print data 12H and the format definition 12I in the memory 12 ( S100).

  The print data 12H and the format definition 12I constitute table data as a set. The print data 12H is data indicating characters, numbers, symbols and the like embedded in an area (hereinafter referred to as a partition) within the ruled line of the table data. The format definition information 12H is data defining a format used when embedding data included in the print data 12I into table data. The print data 12I is extracted from data created by general-purpose software such as word processing software, spreadsheet software, or presentation software, and the format definition information 12H is acquired as a processing result of a form definition tool, for example.

  FIG. 4 is a diagram illustrating an example of the data structure of the format definition 12I and the print data 12H. The print data 12I is a record in which character string data corresponding to each item in the table is serially stored. The format definition information 12H has a data structure including <1> item information and <2> ruled line information for each partition. FIG. 5 is a diagram illustrating an example of a data structure of <1> item information. FIG. 6 is a diagram illustrating an example of the data structure of <2> ruled line information.

  As shown in FIG. 5, <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 such as font information, (7) arrangement information, (8) editing format, (9) position in record, (10) character string data, (11) partition type, and (12) item type.

  (1) The item name is a name for identifying the item, and is unique information in the format definition. (2) The item position information is a coordinate position indicating the position of the item (for example, the lower left coordinate of the item). (3) The item area length is a value indicating the range of items. (4) The data length is a value (unit: number of bytes) indicating the length of the data. (5) The data format is a value (text data, numerical data, etc.) indicating the type of data. (6) The font information is information indicating a font name and a font size. (7) Arrangement information is information relating to the arrangement of characters such as center alignment. (8) The edit format is information for designating a display format in the finally generated spreadsheet. FIG. 7 is a diagram showing the correspondence between the editing format in the format definition 12I, and the format (display format) of the editing format and spreadsheet (here Excel). (9) The position in the record is information indicating the number of bytes from the top of the print data that is data in the record format. For example, in FIG. 4, the position in the record of item A is information indicating the number of bytes from the top of the print data at which the “aiueo” is stored in the print data. (10) The character string data is stored in the character string data only when the item type is “literal”. (11) The partition type represents the type of the partition to which it belongs. The partition type includes, for example, “PH” indicating a page header, “DE” indicating details, and the like. (12) The item type is information representing the item type, such as “literal” when a character string is defined and “text” when referring to a record.

  Here, the invoice or delivery note, which is the table data to be synthesized, is composed of a slip title such as a slip title, an issue date, an order, a subtotal, a total, etc., and forms a single specification. “Detail” means one or more items arranged under a label.

  The data structure of <2> ruled line information in the format definition 12I includes information such as (1) type and (2) position information. The type (1) shown in FIG. 6 is information for identifying ruled lines, frames, and shading. Further, (2) position information is 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).

  When the print data 12H and the format definition 12I are stored in the memory 12, the intermediate data generation unit 10A performs an intermediate data generation process (S110). The intermediate data 12A is binary data obtained by analyzing information such as an item output position, character attribute information, and output data. FIG. 8 is an example of a flowchart showing the flow of intermediate data generation processing executed by the intermediate data generation unit 10A. FIG. 9 shows an example of the data structure of the intermediate data 12A.

  First, the intermediate data generation unit 10A reads a set of format definition 12I and print data 12H (S111). Next, the intermediate data generation unit 10A outputs character data (S112), sets the item position to logical coordinate information (S113), outputs ruled line data (S114), and outputs frame data (S115). The shaded data is output (S116). Next, the intermediate data generation unit 10A sets the intermediate data 12A as intermediate data management information (S117). The intermediate data generation unit 10A executes the above processing for all sets of format definitions 12I and print data 12H (S118).

  FIG. 10 shows an example of the data structure of <1> character string information. <1> The item position (1) in the character string information is a coordinate position indicating the position of the character string (for example, coordinates indicating the lower left). (2) The data format is a value indicating the type of data (text data, numerical data, etc.). (3) The data length is a value (unit: number of bytes) indicating the length of the character string. (4) The character string range is a value indicating each character string range in the X direction and the Y direction. (5) Arrangement information is information relating to the arrangement of characters, such as center alignment and right alignment. (6) The font information is information indicating a font name and a font size. (7) The edit format is information indicating an edit format when data is edited and output. (8) Character string data is information indicating a character string. (9) The partition type is information indicating the type of partition to which the partition belongs. (10) The item type is information representing the item type, such as “literal” when a character string is defined and “text” when referring to a record.

  <2> The ruled line information will be described with reference to FIG. FIG. 11 shows an example of the data structure of <3> logical coordinate information. <3> The number of registrations in the logical coordinate information (1) is the number of character string information. (2) The X coordinate of the item position is the X coordinate of each character string information. (3) The Y coordinate of the item position is the Y coordinate of each character string information. FIG. 12 shows an example of a data structure of <4> vertical and horizontal sizes. <4> Vertical and horizontal sizes store the vertical and horizontal sizes of the target table data.

  When the intermediate data 12A is generated, the intermediate data management information generation unit 10B performs an intermediate data management information generation process for setting the table composition control information 12J in the intermediate data management information 12B (S120). FIG. 13 is an example of the table composition control information 12J. The (1) paper size type in the table composition control information 12J is information for designating a paper size to be used when the synthesized table data is printed. (2) The paper direction is information for designating the paper direction used when printing the combined table data. (3) The number of synthesis is information that specifies the number of table data to be synthesized.

  FIG. 14 shows an example of the data structure of the intermediate data management information 12B in which the table composition control information 12J is reflected. The (1) paper size type, (2) paper direction, and (3) composition number in the intermediate data management information 12B are copied from the table composition control information 12J. The (4) page width in the intermediate data management information 12B is a page width derived by subtracting margins from the maximum width of (1) paper size type. (5) In the reference information to the intermediate data, reference information to each intermediate data 12A is registered. (6) In the reference information to the detail data, reference information to each detail data 12C is registered. (7) In the reference information to the cell definition information, reference information to each cell definition information 12F is registered. The intermediate data management information 12B is used for generating cell definition information (for each sheet) 12D. FIG. 15 is an example of the generated intermediate data management information 12B.

  When the intermediate data management information 12B is generated, the detail data extraction unit 10C performs detail data extraction processing (S130). FIG. 16 is an example of a flowchart showing the flow of detailed data extraction processing. The detailed data 12C has the same data structure as the intermediate data 12A, and the detailed data 12C is obtained by extracting only data whose partition type is “DE” indicating the details from the intermediate data 12A.

  The detail data extraction unit 10C extracts one piece of intermediate data 10C (S131), and determines whether the item type is “literal” and the partition type is “DE” (S132). When the item type is “literal” and the partition type is “DE”, the detail data extraction unit 10C outputs the intermediate data 10C as one of the detail data 12C (S133). The detail data extraction unit 10C performs such processing for all the intermediate data 10C (S134).

  When the detail data 12C is extracted, the cell definition information generation unit 10D performs a cell definition information generation process (S140). A row and a column are set for each table data by the cell definition information generation process.

  The cell definition information generation unit 10D generates cell definition information 12D as shown in FIG. 17, for example. FIG. 17 shows an example of the data structure of the cell definition information 12D. In (1) basic cell width in the cell definition information 12D, the basic cell width of the cell control information 12K is set. (2) The basic cell height is set to the basic cell height of the cell control information 12K. (3) In the cell width, the column width of each column in each table data is described, for example, arranged in a comma separated manner. (4) In the cell height, the row height of each row in each table data is described, for example, arranged in a comma separated manner. FIG. 18 is a data structure example of the cell control information 12K.

  When the cell definition information generation process is performed, the label mapping information generation unit 10E performs the label mapping information generation process (S150).

  FIG. 19 is an example of a flowchart showing the flow of label mapping information generation processing. FIG. 20 is a data structure example of the label mapping information 12E.

  First, the label mapping information generation unit 10E reads cell definition information corresponding to detailed data (S151, S152), and acquires one column position from the cell definition information (S153).

  Then, the label mapping information generation unit 10E registers the label name (S154), registers the column position before combining (S155), and registers the column width before combining (S156).

  The column number after (2) composition in the label mapping information 12E is blank in the label mapping information generation process, and the processing result of the detailed data composition process described later is written.

  When the label mapping information 12E is generated, the detail data composition unit 10F performs detail data composition processing (S160). FIG. 21 is an example of a flowchart showing the flow of detailed data composition processing.

  First, the detailed data composition unit 10F reads the label mapping information 12E (S161), and generates cell definition information for a plurality of rows corresponding to each table data based on the column width before the composition (S162).

  Next, the detail data composition unit 10F determines a key item and moves the key item in each row to the left end (S163). Here, the key item is a common label in each table data, and may be designated by the user, or the leftmost item in each table data may be automatically set as a key item.

  Next, the detail data composition unit 10F sets the layout of the table data having the largest overall width as the basic layout (S164), and aligns the left end position of each layout (S165).

  Next, the detail data composition unit 10F sets the parameter n to 2 (S166). Then, the detail data composition unit 10F moves the nth cell of the table data that is not the basic layout so that the left end matches the left end of the basic layout (S167). Here, the detailed data composition unit 10F moves the nth cell associated with the (n-1) th cell, and does not move it if it falls within the cell of the basic layout.

  Next, the detail data composition unit 10F matches the right end position of the nth cell of the table data that is not the basic layout to the nearest boundary position of the basic layout (S168). Here, when moving the right end position to the left, the detailed data composition unit 10F determines whether or not the column width of the cell does not become smaller than the minimum column width, and if so, changes to move to the right. .

  Then, the detailed data composition unit 10F determines whether or not the processes of S167 and S168 have been executed for all the columns (S169). If the processes of S167 and S168 have not been performed for all the columns, the parameter n Is increased by 1 (S170), and the process returns to S167.

  On the other hand, when the processing of S167 and S168 is executed for all the columns, the detailed data composition unit 10F determines whether or not the table data that is not the basic layout has a larger overall width, and the table data that is not the basic layout. If the overall width becomes larger, re-correction is performed (S171). The detail data composition unit 10F performs a process of moving the nearest boundary line of the table data that is the basic layout to the left instead of moving the right end position of the nth cell of the table data that is not the basic layout to the right.

  Then, the detail data composition unit 10F combines the upper and lower cells corresponding to the key items (S172), and reflects the processing result in the label mapping information 12E and the cell definition information (after composition) 12F (S173).

  Although not shown, the processes in S166 to S171 are performed for each table data that is not the basic layout.

  22 to 26 and FIGS. 27 to 33 are diagrams illustrating how layouts are combined by the processing of the detailed data combining unit 10F. 22 to 26 show a case where the overall width of the table data 1 is narrower than the overall width of the table data 2, and FIGS. 27 to 33 show a case where the overall width of the table data 1 is wider than the overall width of the table data 2. Show.

  FIG. 22 is an example of the layout of the table data 1 and 2. When the detail data composition unit 10F performs the processing of S161 to S165 of FIG. 21, the composition layout shown in FIG. 23 is generated. Next, when the detailed data composition unit 10F performs the processing of S166 to S171 in FIG. 21 for the composition layout, the composition layout is changed as shown in FIGS. Then, when the detail data composition unit 10F performs the process of S172 in FIG. 21, a composition layout shown in FIG. 26 is generated.

  FIG. 27 is another example of the layout of the table data 1 and 2. When the detail data composition unit 10F performs the processing of S161 to S165 of FIG. 21, a composition layout shown in FIG. 28 is generated. Next, when the detailed data composition unit 10F performs the processing of S166 to S171 in FIG. 21 for the composition layout, the composition layout changes as shown in FIGS. 29, 30, 31, and 32. Then, when the detail data composition unit 10F performs the process of S172 in FIG. 21, a composition layout shown in FIG. 33 is generated.

  When the detail data composition process is performed, the print data generation unit 10G performs the print data generation process (S180). The print data generation unit 10G generates and outputs a file of a format selected by the user, for example, based on the label mapping information 12E, the cell definition information (after synthesis) 12F, and the cell information 12G. FIG. 34 shows an example of the data structure of the cell information 12G. The cell information 12G is generated by extracting necessary information from the intermediate data 12A and the detailed data 12C.

  FIG. 35 is a diagram schematically showing a process flow and a data structure change by the table synthesizing apparatus 1. As shown in the figure, the table data 1 and 2 having different layouts are combined into a table that has undergone cell definition information generation processing, label mapping information generation processing, detailed data combination processing (combination and adjustment), and print data generation processing. Is output.

  By such processing, the table synthesizing apparatus 1 maintains the layout of the column width before synthesis as much as possible, aligns the column boundaries after synthesis as much as possible in the upper and lower tables, and further merges common items in different table data by combining cells. Can be displayed.

  As a result, the table synthesizing device 1 can generate and output synthesized data in an aspect that is easy for the user to see.

  The intermediate data generation unit 10A, the intermediate data management information generation unit 10B, the detailed data extraction unit 10C, the cell definition information generation unit 10D, the label mapping information generation unit 10E, the detailed data synthesis unit 10F, and the print data generation unit 10G It is an example of a “generation unit”. The memory 12 and the HDD (Hard Disk Drive) 14 are examples of the “storage unit”.

  As mentioned above, although the form for implementing a table | surface synthesis | combination apparatus and a table | surface synthesis | combination program was demonstrated using the Example, this invention is not limited to such an Example at all, and in the range which does not deviate from the summary of this invention. Various modifications and substitutions can be made.

  For example, the table synthesizing apparatus and the table synthesizing program may have a configuration in which “row” and “column” in the above-described embodiment are interchanged as they are.

  The present invention can be used in the computer software industry and the like.

1 Table Synthesizer 10 CPU
10A Intermediate data generation unit 10B Intermediate data management information generation unit 10C Detailed data extraction unit 10D Cell definition information generation unit 10E Label mapping information generation unit 10F Detailed data composition unit 10G Print data generation unit 12 Memory 12A Intermediate data 12B Intermediate data management information 12C Detail data 12D Cell definition information (each sheet)
12E Label mapping information 12F Cell definition information (after composition)
12G Cell information 12H Print data 12I Format definition 12J Table composition control information 12K Cell control information 14 HDD
16 drive device 20 display control unit 22 display device 24 input device 26 communication control unit

Claims (8)

A storage unit for storing a plurality of table data including a plurality of data items corresponding to a plurality of data labels created in a table format and arranged in a row direction;
The table data obtained by combining the plurality of data files, wherein the plurality of data labels are arranged in rows set for each table data, and a common data label among the table data is arranged in an area where the plurality of rows are combined. A generation unit that generates table data in which data items corresponding to the data labels are arranged in a column direction;
A table synthesizing apparatus. The table synthesizing apparatus according to claim 1,
The generation unit performs processing for matching the boundary lines in the column direction of the rows in which the plurality of data labels are arranged corresponding to the respective table data in the upper and lower rows,
Table synthesizer. A table synthesizing apparatus according to claim 2,
The generation unit performs a process of matching the boundary lines in upper and lower rows so that an area for storing each data label does not become less than a predetermined minimum width.
Table synthesizer.   The table synthesizing apparatus according to claim 1, wherein “row direction” is replaced with “column direction”. On the computer,
A plurality of table data including a plurality of data items corresponding to a plurality of data labels created in a table format and arranged in the row direction are stored in the storage unit,
The table data obtained by combining the plurality of data files, wherein the plurality of data labels are arranged in rows set for each table data, and a common data label among the table data is arranged in an area where the plurality of rows are combined. Generating table data in which data items corresponding to the data labels are arranged in the column direction.
A table synthesis program comprising A table synthesis program according to claim 5,
Causing the computer to perform processing for matching the boundary lines in the column direction of the rows in which the plurality of data labels are arranged corresponding to the respective table data in the upper and lower rows;
Table synthesis program. A table synthesis program according to claim 6,
Causing the computer to perform processing for matching the boundary lines in the upper and lower rows so that an area for storing each data label is not less than a predetermined minimum width;
Table synthesis program.   8. The table composition program according to claim 5, wherein “row direction” is replaced with “column direction”.

Images