JP2017157078A - Table information processor, table information processing method, and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To automatically determine layout of four or more pieces of data in a table in a page.SOLUTION: A table information processor 1 includes: a storage section 11 which stores page information to be information in which a determined page is constituted of a region where a table is arranged; a reception section 12 which receives four or more pieces of data arranged in the table; an inspection section 131 which inspects the data received by the reception section 12; a determination section 132 which determines layout of the four or more pieces of data in the table in the region on the basis of the inspection result in the inspection section 131; an arrangement section 133 which arranges the four or more pieces of data in the table according to the layout determined by the determination section 132; and an output section 14 which outputs the page including the table in which the arrangement section 133 arranges the four or more pieces of data using the page information. Four or more pieces of data is inspected in advance and the four or more pieces of data are arranged in the table according to the layout determined on the basis of the inspection result by the table information processor, the layout of the four or more pieces of data in the table in the page can be automatically determined.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a table information processing apparatus or the like that processes table data.

  Some conventional table information processing apparatuses arrange four or more data in a table according to a predetermined layout (for example, see Non-Patent Document 1).

Microsoft, “Excel”, [online], [Search February 29, 2016], Internet [URL: https://products.office.com/ja-jp/excel]

  However, the conventional table information processing apparatus cannot automatically determine the layout of four or more data in the table. Also, the layout of the table within the page could not be determined.

  Accordingly, an object of the present invention is to provide a table information processing apparatus and the like that can automatically determine the layout of four or more data in a table in a page.

  The table information processing apparatus according to the first aspect of the present invention includes a storage unit that stores page information that is information constituting a page in which an area in which a table having two or more rows and two or more columns is arranged; The layout of four or more data in the table is determined based on the reception unit that receives four or more data arranged in the table, the inspection unit that inspects the data received by the reception unit, and the inspection result of the inspection unit According to the determining unit, the layout determined by the determining unit, an arrangement unit that arranges four or more data in a table, and a page including a table in which the arrangement unit arranges four or more data using page information A table information processing apparatus comprising:

  With this configuration, four or more pieces of data in the table in the page are inspected in advance, and the four or more pieces of data are arranged in the table in the page according to the layout determined based on the inspection result. A table information processing apparatus that can automatically determine the layout of the data is realized.

  Moreover, the table | surface information processing apparatus of this 2nd invention is a 1st invention. WHEREIN: The test | inspection part acquires the property corresponding to each 1 or more data of 4 or more data, A table information processing for allocating four or more data in the table according to the ratio determined by the determining unit, determining a ratio regarding the size of the columns or rows constituting the table according to the properties acquired by the inspection unit. Device.

  With this configuration, it is possible to output a page including a table in which four or more pieces of data are appropriately arranged (for example, in a balanced manner). Also, by acquiring existing properties, the processing load for inspection can be reduced.

  The table information processing apparatus according to the third aspect of the invention is a table information processing apparatus in which the property is one or more kinds of information of data length and data type.

  With this configuration, since the ratio is determined based on at least one piece of information of the data length or data type, it is possible to output a page including a table in which four or more data having different lengths or data types are appropriately arranged.

  In the table information processing apparatus according to the fourth aspect of the invention, in contrast to the third aspect of the invention, the property includes a data type, and the inspection unit determines the data type from one or more characters included in the data. It is a processing device.

  With this configuration, even if the acquired property does not include a data type, the data type can be determined from one or more characters included in the data, and thus the ratio can be determined.

  Further, in the information processing apparatus according to the fifth aspect of the present invention, with respect to any one of the first to fourth aspects, the reception unit receives four or more pieces of data arranged in a table, and the four or more pieces of data are arbitrary Including two or more attribute name data that is data indicating the name of the attribute, and two or more attribute value data that is data paired with the two or more attribute name data and indicating the value of any attribute The determination unit is an information processing apparatus that performs determination based on the inspection result of at least one of two or more attribute name data and two or more attribute value data.

  With this configuration, by making a determination based on the inspection result of at least one of two or more attribute name data and two or more attribute value data, at least one of two or more attribute name data and two or more attribute value data You can output a page that contains a table with one of them properly arranged.

  In particular, when making a decision based on the inspection results of both two or more attribute name data and two or more attribute value data, both the two or more attribute name data and the two or more attribute value data are appropriately arranged. A page containing a table can be output. Further, when the determination is made based on the inspection result of one of the two or more attribute name data and the two or more attribute value data, the two or more attribute name data and 2 and 2 are reduced while reducing the processing load for the inspection. A page including a table in which any one of the attribute value data is appropriately arranged can be output.

  Further, in the information processing apparatus according to the sixth invention, in contrast to the fifth invention, the determination unit includes two or more attribute name data in one row of two or more rows or two or more columns. The information processing apparatus determines the layout of four or more data in a table so as to be arranged in one column.

  With this configuration, it is possible to output a page including a table in which two or more attribute name data are arranged in one row or one column.

  Further, in the table information processing apparatus according to the seventh aspect of the present invention, in any one of the first to sixth aspects, the determining unit determines whether each of the two or more columns constituting the table is based on the inspection result of the inspection unit. The table information processing apparatus determines one or more types of information among the widths of two or more of the heights of two or more rows constituting the table.

  With such a configuration, based on the inspection result of each data of 4 or more, the ratio of one or both of the width of each column constituting the table or the height of each row constituting the table is determined, and the table is determined according to the determined ratio. Since four or more data are arranged in the table, a table in which four or more data are appropriately arranged in each column, a table in which four or more data are appropriately arranged in each row, or four or more data in each row And a page containing a table appropriately arranged in each column.

  In the information processing device according to the eighth aspect of the present invention, for any one of the first to seventh aspects, the reception unit further receives an instruction for a table area, and the determination unit It is a table | surface information processing apparatus which determines arrangement | positioning of the table area | region in.

  With this configuration, the arrangement of the table areas in the page can be determined.

  According to the present invention, a table information processing apparatus or the like that can automatically determine the layout of four or more data in a table in a page is realized.

The block diagram which shows the structural example of the table | surface information processing apparatus 1 in embodiment Flow chart relating to overall operation of the table information processing apparatus 1 Flowchart relating to partial operation (decision process) of the table information processing apparatus 1 The figure which shows the example of composition of the same page Data structure diagram of page information corresponding to the page of FIG. The figure which shows the example of composition of the same table Data structure diagram of column information Data structure diagram of accompanying information Data structure diagram for data of 4 or more The figure which shows an example of the same column information The figure which shows the example of an output of the page containing the table | surface using the column information of FIG. The figure which shows another example of the same column information The figure which shows the output example of the page containing the table | surface using the column information of FIG. The figure which shows another example of the same line information The figure which shows the example of an output of the page containing the table | surface using the column information of FIG. The figure which shows another example of the same line information The figure which shows the example of an output of the page containing the table | surface using the column information of FIG. External view of the computer system 900 The figure which shows the internal structure of the computer system 900

  Hereinafter, embodiments of a table information processing apparatus and the like will be described with reference to the drawings. In addition, since the component and step which attached | subjected the same code | symbol in embodiment perform the same operation | movement, description may be abbreviate | omitted again.

  The table information processing apparatus according to the present embodiment accepts data of a table arranged in a designated area in a page, inspects the data in the table, and lays out the data in the table in the page according to the inspection result Is determined and arranged.

  FIG. 1 is a block diagram illustrating a configuration example of a table information processing apparatus 1 according to the present embodiment. The table information processing apparatus 1 includes a storage unit 11, a reception unit 12, a processing unit 13, and an output unit 14.

  The processing unit 13 includes an inspection unit 131, a determination unit 132, and an arrangement unit 133.

  As a premise, the storage unit 11 stores programs for the processing unit 13 to perform various processes. Various processes and programs will be described later.

  The storage unit 11 stores page information that is information constituting a page.

  A page is an electronic page. An electronic page refers to a page that can be displayed on a display, recorded on a recording medium, or transmitted via a communication line. For example, an electronic page such as an electronic catalog, an electronic magazine, and an electronic book. It is a page of a publication. However, the type of publication and the content of the page are not important.

  In the page, one or more areas (for example, an image area, a text area, etc. in addition to the table area) including an area (table area) where the table is arranged may be determined.

  The table is a format for arranging four or more data in the horizontal (horizontal) direction and the vertical (vertical) direction, and has two or more rows and two or more columns. A row means a horizontal arrangement of two or more data, and a column means a vertical arrangement of two or more data.

  Hereinafter, a table having m rows (where m is an integer equal to or greater than 2) and n columns (where n is an integer equal to or greater than 2) is described as “a table of m rows and n columns”. Normally, m × n pieces of data are arranged in a table of m rows and n columns, but it is sufficient that at least two pieces of data are arranged. For example, in a table of 2 rows and 2 columns, usually four data are arranged, but there may be a case where only three or two data are arranged.

  An area refers to a predetermined range within a page. In the page in this embodiment, a table area that is an area in which a table is arranged is determined. However, for example, an image area that is an area where images such as photographs and illustrations are arranged, a text area that is an area where sentences such as product names and descriptions are arranged, and the like are further determined on the page. In many cases, the number of areas arranged in one page, the type of content arranged in each area, etc. are not limited.

  A region such as a table region in a page is usually determined by receiving an instruction from a user, but may be determined in advance, and the determination method is not limited.

  The area is, for example, a rectangular area, and the rectangular area is usually uniquely determined according to the start point and end point instructions from the user.

  However, a region other than a rectangle, for example, a circular region or a polygonal region other than a rectangle may be used, and the shape and size of the region are not limited. Further, for example, when the receiving unit 12 receives a contour line from the user, the processing unit 13 can determine an arbitrary region, and the method of determining the region is not limited.

  The determined area is usually unchanged, but may be changed as appropriate when the determination unit 132 determines the layout, or the arrangement unit 133 arranges the data in the table. At this time, it may be appropriately changed.

  The page information includes one or more area information that is information related to the one or more areas.

  The area information includes, for example, an area ID for identifying an area, a set of coordinates corresponding to the start point and end point of the area, and content for identifying content (for example, an image, a sentence, a table, etc.) arranged in the area. ID. The coordinates may be relative coordinates within the page, or may be absolute coordinates of a display that displays the page.

  However, instead of the set of coordinates corresponding to the start point and the end point, the area information may include, for example, information indicating a contour line (such as a series of coordinates), a center point, and a radius, indicating the area. Any type of information is acceptable.

  The page information has a format such as HTML or XML, for example, but any format or data structure may be used as long as the information has one or more area information as described above.

  The storage unit 11 stores one or more pieces of page information as described above.

  The storage unit 11 stores, for example, one or more sets of column information and row information in pairs with one or more page information.

  The column information is information indicating the width of each of two or more columns constituting the table. For example, the column information includes a set of pairs of a column ID for identifying a column and a value indicating the width of the column. However, for example, when two or more columns have the same width, the column information may be information indicating only the width of one column.

  The row information is information that indicates the height of each of two or more rows that make up the table, and includes, for example, a set of pairs of a row ID that identifies a row and a value that indicates the height of the row. However, for example, when two or more rows have the same height, the row information may be information indicating only the height of one row.

  However, the storage unit 11 can also store information other than the above-described page information, region information, column information, and row information, for example, inspection results of the inspection unit 131 described later.

  The accepting unit 12 usually accepts an instruction for an area (table area or the like) arranged in a page. However, if the area is determined in advance, the reception of the area instruction may be omitted.

  Moreover, the reception part 12 receives four or more data normally arrange | positioned at the table | surface in a page. However, the number of data received by the receiving unit 12 may be less than four (for example, three or two), and in this case, a portion (empty cell) where no data is arranged is generated in the table.

  Four or more pieces of data are usually ordered data. The data having order is, for example, data in CSV format and arranged in order. However, the four or more data may be data having no order, and the format and data structure are not limited. In the CSV format, four or more pieces of data are listed by being separated by a delimiter (for example, a comma (“,”)). Further, four or more data consists of two or more records, each record consists of two or more data, and records are separated by a line feed code, and two or more data in a record are separated by a delimiter (for example, They may be separated by a comma (“,”)).

  Receiving means receiving information input from an input device such as a keyboard, mouse, touch panel, microphone, image sensor (scanner, camera, etc.), receiving information transmitted via a wired or wireless communication line, an optical disc, It is a concept including reception of information read from a recording medium such as a magnetic disk or a semiconductor memory.

  The four or more data received by the receiving unit 12 may be, for example, data input by a user using an input device such as a keyboard or a microphone, data read from a recording medium, or a storage unit 11 or data acquired from a database stored in an external storage unit. In addition, when performing voice input using a microphone, the reception unit 12 needs to have a voice recognition function for converting voice data from the microphone into character data.

  Each of the four or more data received by the receiving unit 12 is, for example, “product number”, “size”, “price”, “A-100-001”, “5 m”, “¥ 1,000”, “A-100-002” , “10m”, “¥ 1,500”. Such data type is usually character data, but may be image data or a combination of character data and image data.

  Further, each of the four or more pieces of data is associated with the property of the data, for example. However, each data may not be associated with the property from the beginning, and may be associated with the property by the processing unit 13, for example. The correspondence may be that each data has a property, or may be stored or transmitted in pairs with a data ID, a property, or the like.

  Data properties refer to characteristics (features, types, etc.) of the data itself, and may be referred to as data attribute values. However, the “attribute value” here is distinguished from the attribute value in the case of attribute name data and attribute value data described later, that is, the attribute value for the attribute name.

  The data property is, for example, the length of the data, the data type, or the like. The data length is, for example, the number of bytes, the number of characters, the number of pixels, and the like, but any type of data can be used as long as the information indicates the length of the data. The data type refers to classification based on the data format, data structure, and the like, for example, character data, image data, and the like. Further, the data type may be attribute name data and attribute value data described later, and the classification standard is not limited.

  Examples of properties other than the above include character type (font, font size, full-width, half-width, etc.), image aspect ratio, and the like.

  The font is a character font, for example, a Gothic font, a Mincho font, or the like. The font size is a font size, for example, 10 points, 10.5 points, and the like. Full-width and half-width are classifications based on the aspect ratio of characters. For example, the full-width aspect ratio is 1: 1, and the half-width aspect ratio is 2: 1 (in the case of horizontal writing). Therefore, the ratio between the full width and the half width is 1: 1, and the ratio between the full width and the half width is 2: 1. The aspect ratio of the image is a ratio of the length in the vertical direction and the length in the horizontal direction of the image, and is, for example, 3 to 4. However, these ratios are examples and may be changed as appropriate.

  Character data is, for example, a character code or a set of character codes for identifying individual characters, and is also referred to as text data. As long as the information identifies individual characters, the format and type of character data are not limited.

  Image data is, for example, a set of pixel data (pixels, etc.) that constitutes an image including photographs, illustrations, and characters (bitmaps, etc.). Any format is acceptable.

  The attribute name data is data indicating the attribute name of the table, and has contents such as “product number”, “size”, and “price”, for example. The content of the attribute name data may have, for example, a character data format or an image data format, and the data format is not limited.

  The attribute value data is data that is paired with the attribute name data and is data indicating the attribute value of the table. The attribute value data paired with the attribute name data “product number” is data having contents such as “A-100-001”, for example, and the attribute value data paired with the attribute name data “size” is, for example, “5 m” The attribute value data paired with the attribute name data “price” is data having a content of “¥ 1,000”, for example. The content of the attribute value data may have, for example, a character data format or an image data format, and the data format is not limited.

  For example, the data property may be included in the data itself, stored in a recording medium in association with the data, input from an input device, or corresponding to the data. It doesn't matter where it is attached.

  For the table of m rows and n columns, the reception unit 12 normally receives m × n pieces of data. However, m is an integer of 2 or more, and n is an integer of 2 or more (the same applies hereinafter). Note that m × n means only the number of data arranged in the table of m rows and n columns, and m × n data is arranged two-dimensionally, for example, It does not indicate that it is separated by a line feed coat as a requirement (the same applies hereinafter).

  On the other hand, the table area where the table of m rows and n columns is arranged has a total of m × n, for example, m in the vertical direction and n in the horizontal direction by m + 1 vertical lines and n + 1 horizontal lines. Divided into cells.

  Hereinafter, a cell belonging to the i-th row and j-th column among the m × n cells may be described as “cell C (i, j)”. However, 1 ≦ i ≦ m and 1 ≦ j ≦ n (the same applies hereinafter).

  The receiving unit 12 normally receives m × n pieces of data arranged in m × n cells C (1, 1) to C (m, n). However, the receiving unit 12 may receive data of two or more and less than m × n. In this case, the m × n cells are cells in which no data is arranged. The result is an empty cell. Further, the receiving unit 12 may receive a number of data larger than m × n. In that case, excess data is discarded, or the number of rows or columns that the processing unit 13 configures the table. May be increased.

  The accepting unit 12 usually accepts such m × n data as continuous serial data.

  The four or more data received by the receiving unit 12 are, for example, two or more attribute name data and data paired with the two or more attribute name data, and two or more attributes that are data indicating arbitrary attribute values. Value data. However, the type of data of 4 or more does not matter.

  For example, when the processing unit 13 determines the arrangement destination as described above, for example, two or more pieces of data are arranged in one row or one column and correspond to one attribute name data. Two or more attribute value data to be arranged are arranged in an order such that they are arranged in the same column as the column in which the one attribute name data is arranged.

  The processing unit 13 uses, for example, at least one of page information, column information paired with the page information, and row information, the position of the table area in the page, and the table that is arranged in the table area n Information such as the width of each column, the height of each of the m rows constituting the table, and the position of each of the m × n cells included in the table can be uniquely determined.

  The inspection unit 131 inspects the data received by the reception unit 12.

  The inspection is, for example, inspection of data contents, acquisition of data properties, or inspection, but any inspection may be used.

  The content of data is the contents of the data, for example, a character string such as “Part No.”, “A-100-001”, “¥”, a photograph or a character image, or a combination thereof. The image is usually a still image, but may be a moving image. The still image is, for example, a thumbnail, and the moving image is, for example, a representative image.

  The inspection of data content is an inspection of the contents of data, and is usually a determination of whether or not the data includes a specific character or character string. The specific character or character string may be a single character or a range of characters (for example, [0-9]). Or, the inspection of data contents means, for example, judgment of a combination of data characters (for example, whether an English character string indicating a unit (for example, cm, m, kg, g, Hz, etc.) appears after a number string) Determination of whether or not), “¥” appears first, and determination is made as to whether or not it is a character string in which a numerical string follows “¥”.

  Acquisition is a concept that includes, for example, extraction from data, reading from a recording medium, and reception from an external device.

  Acquisition of a property is, for example, extraction of a property from data when the data has a property. Property acquisition is acquisition of a data type (character string, still image, moving image, etc.), for example. Property acquisition refers to, for example, acquisition of the number of characters constituting the character string included in the data, determination of whether the character constituting the character string included in the data is full-width or half-width, 2 bytes if full-width, 1 if half-width Processing to add bytes and calculate the number of bytes in the character string, processing to determine the character type of the character string included in the data (Kanji string, Katanaka string, Hiragana string, English character string, numeric string, and combinations thereof) Etc. Property acquisition is, for example, reading of a property from a recording medium when the property is stored in a recording medium, and reception of an input property when the property is input from an input device. Of course, the acquisition destination of the property does not matter.

  The property inspection is, for example, determining whether the data is character data or image data, determining whether the attribute name data is attribute data, or the like based on the data format or data structure.

  The inspection unit 131 acquires a property corresponding to one or more pieces of data among the four or more pieces of data received by the receiving unit 12.

  The property acquired by the inspection unit 131 is usually one or more types of information among the various properties described above.

  For example, the inspection unit 131 acquires one or more types of information of data length (number of bytes, number of characters, number of pixels, etc.) and data type (image data / character data, attribute name data / attribute value data, etc.). To do.

  The inspection unit 131 may determine the data type from one or more characters included in the data. For example, when one or more characters included in the data are full-width characters, the inspection unit 131 determines that the data is attribute name data, and when one or more characters included in the data are half-width characters, The unit 131 can determine that the data is attribute value data. In addition, the inspection unit 131 uses, for example, data including a specific symbol (for example, “\”), a specific character (for example, “m”, “cm”, “kg”, “bps”, etc.), etc. It is also possible to determine that the data does not include such symbols and characters as attribute name data. Furthermore, for example, data including “\” is determined to be monetary type data that is attribute value data relating to monetary amounts, or units of length, weight, and speed such as “m”, “kg”, and “bps” are determined. The attribute value data including the character or character string to be indicated can be determined as size type data. Thus, the data type determined by the inspection unit 131 is not limited.

  When four or more pieces of data have a tag format, the inspection unit 131 determines that the data enclosed by the tag <> is attribute name data, and determines that the other data is attribute value data. Also good. For example, if the data received by the receiving unit 12 is “<product number> A-100-001 <size> 5m <price> \ 1,000 <product number> A-100-002 <size> 10m <price> \ 1,500” The inspection unit 131 determines “part number”, “size”, and “price” as attribute name data, and “A-100-001”, “5 m”, “¥ 1,000”, “A-100-002”, “ 10m ”and“ ¥ 1,500 ”are determined as attribute value data.

  The four or more data received by the receiving unit 12 usually includes two or more attribute name data and two or more attribute value data paired with the two or more attribute name data. The above inspection is performed on at least one of two or more attribute name data and two or more attribute value data.

  That is, the inspection object of the inspection unit 131 may be either one or both of two or more attribute name data and two or more attribute value data. When either one is inspected, it is possible to reduce both the processing load for the inspection and the complexity of the user's operation. When both are inspected, the complexity of the user's operation can be further reduced.

  The determination unit 132 determines the layout of four or more data items in the table. The layout determination may be generation of information constituting the layout.

  The layout refers to information on the arrangement of four or more data in the table or the configuration of the table that determines the arrangement. The layout may include information defining a region such as a table region in the page.

  The layout may include, for example, information about the number of columns in the table, the number of rows in the table, the position of the data in the cell, the data properties, and the like. Properties may include data length and font. In addition, the layout may include information such as which cell position among four or more cells in the table is arranged, for example.

  The layout includes, for example, 1 of information (column information) indicating the width of each of two or more columns constituting the table, or information (row information) indicating the height of each of two or more rows configuring the table. The above information may be included. In other words, the layout may include at least one information of the width of each of two or more cells constituting one row or the height of each of two or more cells constituting one column. Alternatively, the layout may include information on the size (width, height, diagonal length, area, etc.) of each cell.

  The determination includes changing the determined layout. The change is not limited to a one-time change, but includes a plurality of changes. Multiple changes include regular or irregular changes, intermittent changes, continuous changes (adjustments), and the like.

  For example, when the layout includes column information and row information, the determination may be an accumulation of at least one of the column information and the row information in the storage unit 11.

  The determination may be determination of a set (i, j) of row numbers and column numbers indicating cells in which each of four or more pieces of data should be arranged.

  In addition, the layout may include, for example, information regarding data arrangement in each cell constituting the table. Information on the arrangement of data in a cell includes, for example, information such as whether data that does not fit in a cell is to be folded or placed, or data that is placed left-justified or right-justified in a cell. Information about whether to place in the center or in the center

  The determination unit 132 determines the layout of four or more data in the table based on the inspection result of the inspection unit 131.

  The determination unit 132 determines which cell constituting the table to arrange the four or more data received by the reception unit 12.

  For example, the processing unit 13 arranges four or more data, for example, the first data in the cell C (1, 1), the second data in the cell C (1, 2), and so on. It may be determined in the order in which they are arranged.

  Alternatively, for example, the determination unit 132 arranges two or more data determined by the inspection unit 131 as attribute name data in one row of two or more rows or one column of two or more columns. As described above, a layout of four or more data in the table (for example, a cell to be arranged) may be determined.

  Specifically, the determination unit 132 arranges four or more pieces of data so that, for example, two or more pieces of attribute name data are arranged in the first row (the top row) of the two or more rows. To decide. Or the determination part 132 determines the arrangement | positioning destination of 4 or more data so that 2 or more attribute name data may be arrange | positioned in the 1st column (leftmost column) among 2 or more columns, for example. However, the arrangement destination of two or more attribute name data may be two or more cells constituting any row of two or more rows, or two or more cells constituting any column of two or more columns.

  In the following description, data determined to be arranged in the cell C (i, j) among the four or more data may be described as “data D (i, j)”.

  Further, the determination unit 132 may determine the size of the columns or rows constituting the table, or the ratio relating to the size, based on the inspection result of the inspection unit 131.

  The size of the column or row constituting the table is, for example, one or more types of information among the width of each of two or more columns constituting the table or the height of each of the two or more rows constituting the table. The ratio related to the size of the columns or rows constituting the table is, for example, the ratio of the widths of two or more columns constituting the table, or the ratio of the heights of two or more rows constituting the table. Information.

  For example, depending on the property acquired by the inspecting unit 131, the determination unit 132 determines the width or width ratio of each of two or more columns constituting the table, or the height or height ratio of each of two or more rows that constitute the table. Of these, one or more types of information are determined.

  For example, the inspection unit 131 extracts the length of data from the property of each data, and the determination unit 132 determines the width of each of two or more columns based on the length of each data extracted by the inspection unit 131, or 2 Determine the ratio for the height of each row above.

  Specifically, for example, the reception unit 12 receives four pieces of data arranged in a table of two columns in two, and the inspection unit 131 determines the data lengths “4” and “6” from the properties of each data. , “9”, “2” are extracted, the determination unit 132 can determine the ratio of the widths of the two columns as follows.

  First, the determination unit 132 determines the longest “9” among the lengths “4” and “9” of the two data belonging to the first column as the representative value of the first column. Next, the determination unit 132 determines the longest “6” among the lengths “6” and “2” of the two data belonging to the second column as the representative value of the second column. Next, the determination unit 132 determines the ratio of the width of the first column and the width of the second column to 9: 6 (that is, 3: 2) that is a ratio corresponding to the representative value.

  Further, for example, the reception unit 12 receives four pieces of data arranged in a table of two columns in two, and the inspection unit 131 determines the data lengths “3”, “2”, “4” from the properties of each data. When “,” “1” is extracted, the determination unit 132 can determine the ratio of the heights of the two rows as follows, for example.

  The determination unit 132 first determines the longest “3” among the lengths “3” and “2” of the two data belonging to the first row as the representative value of the first row. Next, the determination unit 132 determines the longest “4” among the lengths “4” and “1” of the two data belonging to the second row as the representative value of the second row. Next, the determination unit 132 determines the ratio of the height of the first row and the height of the second row to 3 to 4, which is a ratio according to the representative value.

  In addition, for example, the reception unit 12 receives four pieces of data arranged in a table with two columns in two, and the inspection unit 131 determines the horizontal and vertical lengths of data “4 × 3” from the properties of each data. ”,“ 6 × 2 ”,“ 9 × 4 ”,“ 2 × 1 ”are extracted, the determination unit 132 performs the horizontal lengths“ 4 ”,“ 6 ”,“ 9 ”in the same manner as described above. ”,“ 2 ”, the ratio of the widths of the two columns is determined to be 3 to 2, and the longitudinal lengths“ 3 ”,“ 2 ”,“ 4 ”,“ 1 ” The ratio of the heights of the two rows can be determined to be 3 to 4.

  The length of the data mentioned above is, for example, the number of characters, but may be the number of bytes, the number of pixels, or the like.

  When the data includes both character data and image data, for example, based on the number of pixels of the image data (for example, vertical 20 pixels × horizontal 100 pixels) and the font size of the character data (for example, 10 points). Alternatively, the length of the data may be obtained by calculating the number of characters corresponding to the number of pixels in the horizontal direction of the image data and adding the calculation result to the number of characters.

  The number of characters is preferably a numerical value that takes into consideration full-width, half-width, and space between characters. For example, the inspection unit 131 may count a full-width character as one character and a half-width character as 0.5 character, and may include spaces between characters as a full-width character and a half-width character as 0.5 characters.

  In the above example, the determination unit 132 determines the longest length among the two or more lengths as the representative value. For example, the determination unit 132 determines the average value of the two or more lengths as the representative value. May be.

  Alternatively, the determining unit 132 may determine an intermediate value having a length of 3 or more (or an average value of two intermediate values) as a representative value.

  When an outlier that is a value greatly deviating from other values is included in the length of 3 or more, the determination unit 132 excludes the outlier from the length of 3 or more. The representative value may be determined. The determination of whether or not an outlier is present can be performed using a known algorithm such as a test.

  The arrangement unit 133 arranges four or more pieces of data in the table according to the layout determined by the determination unit 132.

  The arrangement according to the layout may be, for example, arranging four or more pieces of data at the position of the cell determined by the determining unit 132 among the four or more cells in the table.

  Also, the arrangement according to the layout means that, for example, when the determining unit 132 determines a layout including at least one piece of column information or row information, four or more pieces of data are arranged in a table having a configuration corresponding to the layout. It may be to do.

  The output unit 14 uses the page information stored in the storage unit 11 to output a page including a table in which the arrangement unit 133 arranges four or more pieces of data.

  Output is a concept that includes, for example, display on a display, printing on a printer, transmission to an external device, storage in a recording medium, delivery of a processing result to another processing device or another program, and the like. .

  For example, the output unit 14 displays images such as product photos and illustrations in the image area, sentences including the product name and description of the product in the text area, and a table describing the product number, size, price, and the like in the table area. The arranged pages are output via an output device such as a display.

  The storage unit 11 is preferably a non-volatile recording medium such as a hard disk or a flash memory, but can also be realized by a volatile recording medium.

  The process in which information, such as a program and page information, is stored in the storage unit 11 does not matter. For example, information may be stored in the storage unit 11 via a removable recording medium such as a CD-ROM or a memory card, and information transmitted via a communication line or the like may be stored in the storage unit 11. The information may be stored, or the information input via the input device may be stored in the storage unit 11.

  The input device may be anything such as a keyboard, mouse, touch panel, or input connector.

  The receiving unit 12 may be considered as including or not including an input device. That is, the receiving unit 12 can be realized by a device driver of an input device or a device driver and an input device of the input device.

  The processing unit 13, the inspection unit 131, the determination unit 132, and the arrangement unit 133 are usually realized by the cooperation of hardware such as an MPU or a memory and software stored in the memory, but only the hardware (dedicated Circuit). Hereinafter, hardware such as an MPU and a memory may be referred to as a “computer”, and software that causes the computer to function as the processing unit 13 or the like may be referred to as a “program”.

  The output unit 14 may be considered as including or not including an output device such as a display, a speaker, or a connector. In other words, the output unit 14 can be realized by driver software for an output device or driver software for an output device and an output device.

  Next, the operation of the table information processing apparatus 1 will be described with reference to the flowcharts of FIGS. 2 and 3 and the data structures of FIGS. Note that the description regarding the matters already described may be omitted or simplified.

  FIG. 2 is a flowchart regarding the overall operation of the table information processing apparatus 1. FIG. 3 is a flowchart relating to details of a partial operation of the table information processing apparatus 1. Prior to the description of the operation by the flowchart, the data structure and the like will be described.

  The storage unit 11 stores one or more page information corresponding to one or more pages.

  FIG. 4 is a diagram illustrating a configuration example of a page, and FIG. 5 is a data structure diagram of page information corresponding to the page. The page includes one or more areas, for example, rectangular areas E1, E2, E3,. The page information includes one or more area information corresponding to the one or more areas.

  The area information corresponding to the area is information including, for example, an area ID for identifying the area, a start point and an end point for determining the area, a content ID for identifying content arranged in the area. The start point and the end point are coordinates such as (x, y), for example, but any format can be used as long as the information can uniquely determine the position in the page.

  For example, the area information corresponding to the area E1 includes an area ID “E1”, a start point P1 and an end point Q1, a content ID “K1”, and the like. The area information corresponding to the area E2 includes an area ID “E2”, a start point P2 and an end point Q2, a content ID “K2”, and the like. The area information corresponding to the area E3 includes an area ID “E3”, a start point P3 and an end point Q3, a content ID “K3”, and the like.

  Here, it is assumed that the content K1 is an image, the content K2 is a sentence, and the content K3 is a table. Therefore, the area E1 is an image area, the area E2 is a text area, and the area E3 is a table area.

  FIG. 6 is a diagram illustrating a configuration example of a table arranged in the table area. The table is composed of two or more rows (first row, second row, ..., i-th row, ...) and two or more columns (first column, second column, ..., j-th column, ...). Is done. Each of the four or more cells included in the table is identified by a set (i, j) of row numbers and column numbers to which the cells belong. Hereinafter, a cell belonging to the i-th row and j-th column may be described as “cell C (i, j)”.

  The storage unit 11 further stores one or more sets of row information and column information related to the rows and columns constituting the table in pairs with the one or more page information.

  FIG. 7 is a data structure diagram of column information. This column information is composed of, for example, a set of pairs of column IDs (R1, R2,...) For identifying columns and values (d1, d2,...) Indicating column widths, and column R1 (first column). ) Is d1, and the width of the column R2 (second column) is d2,. If the widths of the columns are the same, the column information may be a value indicating the width of one column.

  FIG. 8 is a data structure diagram of row information. This row information is composed of, for example, a set of pairs of row IDs (L1, L2,...) For identifying the rows and values (h1, h2,...) Indicating the heights of the rows. The height of the row) is h1, and the height of the row L2 (second row) is h2. When the width of each line is the same, the line information may be a value indicating the height of one line.

  FIG. 9 is a data structure diagram regarding four or more data arranged in a table. Each of the four or more data is associated with the property of the data.

  For example, the content of the first data is “article number”, and the property of the first data includes information such as “character, double-byte, two characters, attribute name data, etc.”. Similarly, the content of the second data is “size”, and the property of the second data includes information such as “character, double-byte, three characters, attribute name data, etc.”. The content of the third data is “price”, and the property of the third data includes information such as “character, double-byte, two characters, attribute name data, etc.”.

  The content of the (n + 1) th data is “A-100-001”, and the properties of the (n + 1) th data include information such as “character / half-width / 9 characters / attribute value data”. Similarly, the content of the (n + 2) th data is “5m”, and the properties of the (n + 2) th data include information such as “character / half-width / two characters / attribute value data”. The content of the (n + 3) th data is “¥ 1,000”, and the properties of the (n + 3) th data include information such as “character / half-width / six characters / attribute value data”.

  The content of the (2n + 1) th data is “A-100-002”, and the properties of the (2n + 1) th data include information such as “character / half-width / 9 characters / attribute value data”. Similarly, the content of the 2n + 2nd data is “10m”, and the property of the 2n + 2nd data includes information such as “character / half-width / three characters / attribute value data”. The content of the 2n + 3rd data is “¥ 1,500”, and the property of the 2n + 3rd data includes information such as “character, half-width, 6 characters, attribute value data”.

  The flowcharts of FIGS. 2 and 3 are started when the table information processing apparatus 1 is turned on or a program is started.

  (Step S201) The processing unit 13 determines whether there is unacquired page information in the storage unit 11.

  Each of the one or more pieces of page information stored in the storage unit 11 is associated with a flag indicating whether it has not been acquired or has been acquired, and the processing unit 13 acquires unacquired page information and acquisition based on the flag. Can be identified from the page information.

  If it is determined that there is unacquired page information in the storage unit 11, the process proceeds to step S202. If it is determined that there is no page information, the process ends.

  (Step S <b> 202) The processing unit 13 acquires one of the unacquired page information from the storage unit 11. Accordingly, the processing unit 13 changes the flag corresponding to the acquired page information from unacquired to acquired.

  (Step S203) The reception unit 12 receives four or more pieces of data arranged in a table in a page configured by the acquired page information. Note that the number of received data may be any number as long as it is four or more. The four or more data are, for example, CSV format data, but the data format is not limited.

  (Step S204) The inspection unit 131 inspects four or more data received by the processing unit 13. Since the inspection has been described in detail, it will not be repeated.

  (Step S205) The determination unit 132 executes determination processing that is processing for determining the arrangement of four or more data items in the table based on four or more inspection results that are the results of the inspection processing. The determination process will be described later.

  (Step S206) The arrangement unit 133 arranges four or more pieces of data in the table according to the layout determined by the determination unit 132.

  (Step S207) The output unit 14 uses the page information acquired by the processing unit 13 to output a page including a table in which the arrangement unit 133 arranges four or more pieces of data. Thereafter, the process returns to step S201.

  FIG. 3 is a flowchart illustrating an example of the determination process.

  (Step S301) Based on the inspection result, the determination unit 132 determines the number of rows constituting the table (m), the number of columns that constitute the table (n), and the cell C ( i, j).

  Specifically, first, regarding the number m of rows and the number n of columns, for example, when the number of inspection results is nine and three inspection results indicate attribute name data, m = 3 , N = 3.

  Next, regarding the arrangement destination, the determination unit 132 sets two or more pieces of data whose inspection result is attribute name data, for example, two or more pieces constituting one row (for example, the top row L1) among the two or more rows. Or two or more cells constituting one column of two or more columns. However, the first data may be determined in the order in which they are arranged, such as the cell C (1,1), the second data in the cell C (1,2), and so on. Hereinafter, data determined to be arranged in the cell C (i, j) may be described as data D (i, j).

  (Step S302) The determination unit 132 sets an initial value “1” to a variable j indicating a column number.

  (Step S303) The determination unit 132 sets an initial value “1” to a variable i indicating a row number.

  (Step S304) The determination unit 132 determines whether the variable i is equal to or less than the number m of rows. If it is determined that the variable i is equal to or less than the number m of rows (j ≦ m), the process proceeds to step S305, and if it is determined that the variable i is not equal to or less than the number m of columns (j> m), the process proceeds to step S308. .

  (Step S305) The determination unit 132 determines whether the variable j is equal to or less than the number n of columns. If it is determined that the variable j is less than or equal to the number of columns n (j ≦ n), the process proceeds to step S306. If it is determined that the variable j is not less than the number n of columns (j> n), the process proceeds to step S310. .

  (Step S306) The determination unit 132 acquires the inspection result T (i, j) from the storage unit 11.

  If the test result T (i, j) is not stored in the storage unit 11, the process may proceed to step S307 without being acquired.

  (Step S307) The determination unit 132 increments the variable i. Thereafter, the process returns to step S304.

  (Step S308) The determining unit 132 determines a representative value Sj of n test results T (1, j) to T (n, j) corresponding to the j-th column.

  For example, the determination unit 132 determines the average value of the inspection results T (1, j) to T (n, j) as the representative value Sj.

  Alternatively, the determination unit 132 may determine the median value of the inspection results T (1, j) to T (n, j) as the representative value Sj, and if there are two median values, the average value thereof is represented. The value may be determined, and the method of determining the representative value does not matter.

  Note that the determination unit 132 may determine the representative value Sj after excluding the inspection result including “attribute name data” from the inspection results T (1, j) to T (n, j).

  For example, the determination unit 132 may determine the representative value Sj after excluding outliers from the inspection results T (1, j) to T (n, j).

  When there is one inspection result, the inspection result is determined as a representative value. If there is no inspection result, for example, a default value may be used as a representative value.

  (Step S309) The determination unit 132 increments the variable j. Thereafter, the process returns to step S303.

  (Step S <b> 310) The determination unit 132 determines the width ratios between the first column to the n-th column and the width between the first column to the n-th column based on the n representative values S <b> 1 to Sn.

  The determination unit 132 may determine the ratio of the width between the first column to the n-th column so as to be proportional to, for example, n representative values S1 to Sn, or to n reference widths. On the other hand, it may be determined by adding an additional width proportional to the n representative values S1 to Sn, and the determination method is not limited.

  For example, when the number n of columns is 3, and the representative values of each column are S1 = 4, S2 = 6, and S3 = 2, the width ratio between the first column, the second column, and the third column is It may be determined to be 4 to 6 to 2, that is, 2 to 3 to 1, in proportion to the representative value. Alternatively, it may be determined as 4 to 4 by 3 by adding three additional values proportional to the representative value, for example, 2, 3, and 1, to the three reference values 2, 2, and 2. .

  When the ratio proportional to the representative value is, for example, 13: 4: 6, the value may be rounded to be determined, for example, 12: 4: 6, that is, 6: 2: 3.

  Thereafter, the process returns to the flowchart of FIG.

  According to the flowchart of FIG. 3, the ratio of the widths of the columns constituting the table can be determined.

  In addition, according to the flowchart of FIG. 3, the ratio of the widths of the columns constituting the table can be determined based on the inspection result regarding the attribute name data and / or the attribute value data.

  Further, if the rows and columns in the flowchart of FIG. 3 are exchanged, the ratio of the heights of the rows constituting the table can be determined.

  Further, by executing the flowchart of FIG. 3 and further executing by exchanging the rows and columns in the flowchart of FIG. 3, both the width ratio of each column constituting the table and the ratio of the height of each row are determined. Is also possible.

  In the flowcharts of FIGS. 2 and 3, after the reception of four or more data is completed in step S203, the processing from step S204 is executed. For example, each time one data is received, the step You may perform the process below S204.

  In the flowcharts of FIGS. 2 and 3, the process is terminated when there are no unacquired pages. However, the process may be terminated by, for example, powering off or interruption of process termination.

  Next, a specific operation example of the table information processing apparatus 1 in the present embodiment will be described. Note that description overlapping with the above description may be omitted or simplified.

  The operation example described below is an operation for creating a product catalog page, but is merely an example and does not limit the present invention. Also. Specific contents of data, the number and width of rows, the number and height of columns, and the like described below are also merely examples, and can be changed as appropriate.

  When the table information processing apparatus 1 is activated, an image of a page is displayed on the display. The user of the table information processing apparatus 1 operates an input device such as a mouse or a touch panel, and first designates areas E1, E2, and E3 as shown in FIG. 4 for this page. Next, the user instructs the contents K1, K2, and K3 to be arranged in the areas E1, E2, and E3 using the input device.

  For example, the content K1 is an image such as a photograph or illustration of a product, the content K2 is a sentence such as a product name or an explanation, and the content K3 is a table in which the product number, size, or price of the product is registered. For this reason, the area E1 in which the content K1 is arranged is “image area”, the area E2 in which the content K2 is arranged is “text area”, and the area E3 in which the content K3 is arranged is “table area”.

  In the table information processing apparatus 1, the receiving unit 12 receives the above instruction via the input device, and the processing unit 13 is based on the instruction received by the receiving unit 12, as shown in FIG. And is stored in the storage unit 11.

  For example, the content K3 is a table with 3 rows and 3 columns. The structure of the table is shown in FIG.

  Next, regarding the table, the processing unit 13 configures column information as shown in FIG. 7 and row information as shown in FIG. The initial values (default) of the widths d1 to d3 corresponding to the columns R1 to R3 are all “40”. The initial values of the heights h1 to h3 corresponding to the rows L1 to L3 are all “20”.

  Next, the reception unit 12 receives nine pieces of data arranged in the table. These nine data are read from the recording medium in this example, but may be those input by the user with an input device. The contents and properties of each data are shown in FIG. In this example, the property of each data is stored in the recording medium in a pair with the data. However, when the data is input, it may be created by the processing unit 13 based on the content of the data. .

  The inspection unit 131 inspects the nine data D (1, 1) to D (3, 3) received by the processing unit 13. In this example, the inspection unit 131 acquires the property of each data from the recording medium, but information similar to the property of FIG. 9 is obtained by inspection of the contents of each data (for example, identification of character codes, count of the number of characters, etc.). You may get

  The inspection unit 131 stores the nine inspection results T (1,1) to T (3,3) corresponding to the nine data D (1,1) to D (3,3) obtained in this way. 11 accumulates.

  The determination unit 132 determines the arrangement of nine data in the table based on the nine inspection results T (1,1) to T (3,3) stored in the storage unit 11.

  Specifically, first, the determination unit 132 determines three representative values S1 of the three inspection results T (1,1) to T (3,1) corresponding to the first column, and three corresponding to the second column. Representative values S2 of the inspection results T (1,2) to T (3,2) are determined, and the representative of the three inspection results T (1,3) to T (3,3) corresponding to the third column The value S3 is determined.

  In this example, the inspection unit 131 acquires properties as shown in FIG. 9, and the determination unit 132 is included in “full-width / 2 characters” and T (2, 1) included in the inspection result T (1, 1). Among “half-width / 9 characters” and “half-width / 9 characters” included in T (3, 1), the longest half-width / 9 characters is determined as the representative value S1.

  Further, the determination unit 132 includes “full-width / three characters” included in the test result T (1, 2), “half-width / two characters” included in T (2, 2), and T (3, 2). Among the “half-width / 3 characters”, the longest “full-width / 3 characters (corresponding to half-width / 6 characters)” is determined as the representative value S2.

  In addition, the determination unit 132 includes “full-width / three characters” included in the inspection result T (1, 3), “half-width / two characters” included in T (2, 3), and T (3, 3). Among the “half-width / 3 characters”, the longest “full-width / 3 characters (corresponding to half-width / 6 characters)” is determined as the representative value S3.

  Next, the determination unit 132 determines the ratio of the width between the first column to the third column based on the three representative values S1 to S3.

  In this example, since S1 is “half-width / 9 characters”, S2 is “half-width / six characters”, and S3 is “half-width / six characters”, the determination unit 132 determines the ratio of the width between the first column to the third column. Is determined to be 9 to 6 to 6, that is, 3 to 2 to 2.

  Accordingly, the determination unit 132 updates the column information (see FIG. 7) stored in the storage unit 11 as illustrated in FIG. In the updated column information, the width d1 of the column R1 is changed from 40 to 50, the width d2 of the column R2 is changed from 40 to 35, and the width d3 of the column R3 is changed from 40 to 35.

  The arrangement unit 133 arranges nine pieces of data in a table of 3 rows and 3 columns according to the layout determined by the determination unit 132 in this way.

  In this example, the arrangement unit 133 is composed of three rows and three columns each having three columns having a width according to the column information shown in FIG. 10 and three rows having a height according to the row information shown in FIG. Nine data D (1,1) to D (3,3) are arranged in nine cells C (1,1) to C (3,3) included in the table.

  The output unit 14 uses the page information stored in the storage unit 11 and includes a 3 × 3 table in which the arrangement unit 133 arranges nine pieces of data as described above, as shown in FIG. Print the page. In the table in this page, the widths of the three columns R1, R2, and R3 are 50, 35, and 35, respectively. This is a ratio according to the length of the longest data among the three data that belong to each column ( Since it is 3 to 2 to 2), 9 data are appropriately arranged.

  In addition, arranging appropriately means arranging four or more pieces of data in a balanced manner according to, for example, at least one of the length or data type of each data. It is possible to arrange two or more attribute name data included in the data so that they are arranged in one column or one row, which is widely understood.

  Note that the above example does not consider whether the data is attribute name data or attribute value data. Therefore, the width of each column is determined based on the inspection results for both the attribute name data and the attribute value data. However, the width of each column may be determined based only on the inspection result of the attribute value data.

  Specifically, the inspection unit 131 accumulates the inspection result in the storage unit 11 only when the inspection result obtained by performing the inspection includes the data type “attribute value data”. Therefore, when the determination unit 132 performs the determination, the storage unit 11 stores the inspection results T (2, 1) to T (T) for the attribute value data D (2, 1) to D (3, 3). 3, 3) only.

  Therefore, the determination unit 132 selects the longest “half-width / 9 characters” included in the test result T (2, 1) and “half-width / 9 characters” included in T (3, 1). “9 characters” is determined as the representative value S1. In addition, the determination unit 132 selects the longest “half-width / 3 characters” among the “half-width / 2 characters” included in the test result T (2, 2) and the “half-width / 3 characters” included in T (3, 2). The character “is determined to be the representative value S2. Further, the determination unit 132 selects the longest “half-width · 6 characters” from among “half-width · 6 characters” included in the test result T (2, 3) and “half-width · 6 characters” included in T (3, 3). “Character” is determined as the representative value S3.

  Based on the three representative values S1 to S3, the determination unit 132 determines the ratio of the width between the first column to the third column to 9: 3: 6, that is, 3: 1: 2, and the storage unit The column information (see FIG. 7) stored in 11 is updated as shown in FIG. In the updated column information, the width d1 of the column R1 is changed from 40 to 60, the width d2 of the column R2 is changed from 40 to 20, and the width d3 of the column R3 is maintained at 40.

  Arrangement unit 133 is included in a 3 × 3 table composed of three columns having a width according to the column information shown in FIG. 12 and three rows having a height according to the row information shown in FIG. 8. Nine data D (1,1) to D (3,3) are arranged in the nine cells C (1,1) to C (3,3).

  The output unit 14 outputs a page as shown in FIG. 13 including a 3 × 3 table in which the arrangement unit 133 arranges nine pieces of data as described above. In the table in this page, the widths of the three columns R1, R2, and R3 are 60, 20, and 40, respectively, and this corresponds to the length of the longest data among the two attribute value data belonging to each column. Since the ratio is (3: 1: 1), 6 attribute value data are appropriately arranged.

  However, as a result of not considering the length of the attribute name data, a part of “size” protrudes from the cell C (1, 2) or is hidden behind the adjacent cell C (1, 3) and cannot be seen.

  Therefore, in the example of FIG. 13, the determination unit 132 determines to wrap data in the cell so that “size” fits in the cell C (1, 2). This is also a kind of layout determination by the determination unit 132.

  Alternatively, the determination unit 132 once determines the widths of the three columns R1, R2, and R3 to 60, 20, and 40 as in the example of FIG. 12, and then, for example, as illustrated in FIG. Even if the width of the column R2 is increased from 20 to 35 while the width of R3 is maintained at 60, 40, as shown in FIG. 15, the “size” is accommodated in the cell C (1, 2). . This is also a kind of layout determination by the determination unit 132.

  However, in the examples of FIGS. 14 and 15, the width of the column R <b> 2 is expanded while maintaining the widths of the columns R <b> 1 and R <b> 3, resulting in part of the table protruding from the table area.

  Therefore, after determining the widths of the three columns R1, R2, and R3 to 60, 20, and 40 as shown in FIG. 16, the determining unit 132 sets the font size of “size” as shown in FIG. You may reduce and display. This is also a kind of layout determination by the determination unit 132.

  In the above specific example, the processing unit 13 determines in which cell in the table each data received by the receiving unit 12 is arranged, but the determining unit 132 determines each data determined by the processing unit 13. The correspondence with the cells in the table can be changed based on the inspection result of the inspection unit 132.

  For example, when the accepting unit 12 accepts, for example, nine pieces of data for a table of 3 rows and 3 columns, the processing unit 13 receives the nine pieces of data in order from the first one in the cells C (1, 1), The cells C (1, 2), C (1, 3), C (2, 1),..., C (3, 3) are determined. The inspection unit 131 inspects these nine pieces of data, and if the inspection result indicates that the last three of the nine pieces of data are attribute name data, the determination unit 132 For example, the data may be changed to be arranged in the three cells C (1,1) to C (1,3) constituting the row L1.

  As described above, according to the present embodiment, the storage unit 11 that stores page information that is information constituting a page in which an area in which a table having two or more rows and two or more columns is arranged is stored, and the table The receiving unit 12 that receives four or more data arranged in the table, the inspection unit 131 that inspects the data received by the receiving unit 12, and the layout of four or more data in the table based on the inspection result of the inspection unit 131 In accordance with the layout determined by the determination unit 132, the arrangement unit 133 that arranges four or more data in the table, and the arrangement unit 133 arranges four or more data using page information according to the layout determined by the determination unit 132 The table information processing apparatus 1 including the output unit 14 that outputs the page including the table is inspected four or more data in advance, and according to the layout determined based on the inspection result, the four or more data in the table De Since placing the data, post-layout change operation is unnecessary.

  In the table information processing apparatus 1, the inspection unit 131 acquires properties corresponding to one or more pieces of data among four or more pieces of data, and the determination unit 132 displays the properties according to the properties acquired by the inspection unit 131. The arrangement unit 133 arranges four or more data in the table according to the ratio determined by the determination unit 132, so that the four or more data can be appropriately obtained. A page including the arranged table can be output. Also, by acquiring existing properties, the processing load for inspection can be reduced.

In the table information processing apparatus 1, the property is a table in which four or more data having different lengths or data types are appropriately arranged because the property is one or more kinds of information of the data length and data type. A page containing can be output.
Moreover, in the said table | surface information processing apparatus 1, a property contains a data type, and the test | inspection part 131 determines a data type from one or more characters contained in data, and a data type is contained in the acquired property. Without it, you can determine the data type and thus the ratio.

  In the table information processing apparatus 1, the receiving unit 12 receives four or more pieces of data arranged in the table, and the four or more pieces of data include two or more pieces of attribute name data that are data indicating names of arbitrary attributes. 2 or more attribute name data that is paired with two or more attribute name data and indicating data of an arbitrary attribute. The determination unit 132 includes two or more attribute name data and two or more attribute name data. By making a determination based on the inspection result of at least one of the attribute value data, a page including a table in which at least one of the two or more attribute name data and the two or more attribute value data is appropriately arranged can be output.

  In particular, when making a decision based on the inspection results of both two or more attribute name data and two or more attribute value data, both the two or more attribute name data and the two or more attribute value data are appropriately arranged. A page containing a table can be output. Further, when the determination is made based on the inspection result of either one of two or more attribute name data or two or more attribute value data, the two or more attribute name data or 2 or 2 is reduced while reducing the processing load for the inspection. A page including a table in which any one of the attribute value data is appropriately arranged can be output.

  Moreover, in the said table | surface information processing apparatus 1, the determination part 132 is arrange | positioned so that two or more attribute name data may be arrange | positioned at one row of two or more rows, or one column of two or more columns. By determining the layout of four or more data in the table, a page including a table in which two or more attribute name data are arranged in one row or one column can be output.

  Further, in the table information processing apparatus 1, the determining unit 132 determines the width of each of two or more columns constituting the table or the height of each of two or more rows constituting the table based on the inspection result of the inspection unit 131. Of these, by determining one or more types of information, a table in which four or more data are appropriately arranged in each column, a table in which four or more data are appropriately arranged in each row, or four or more data in each row And a page containing a table appropriately arranged in each column.

  In the table information processing apparatus 1, the receiving unit 12 further receives a table area instruction, and the determining unit 132 determines the arrangement of the table area in the page according to the instruction received by the receiving unit 12. Thus, a page in which the table area is arranged according to the instruction can be output.

  Note that the processing in the present embodiment may be realized by software. The software may be distributed, for example, by software download or may be recorded and distributed on a recording medium such as a CD-ROM. This also applies to other embodiments in this specification.

  The software that implements the information processing apparatus 1 in the present embodiment is, for example, the following program. In other words, this program causes the computer to store the page information, which is information that constitutes a page in which an area in which a table having two or more rows and two or more columns is arranged, and stores the page information. The receiving unit 12 that receives four or more data to be arranged, the inspection unit 131 that inspects the data received by the receiving unit 12, and the layout of four or more data in the table based on the inspection result of the inspection unit 131 In accordance with the determination unit 132 to be determined, the layout determined by the determination unit 132, the arrangement unit 133 that arranges four or more data in the table, and the arrangement unit 133 arranges four or more data using page information This is a program for causing the output unit 14 to output a page including a table.

  FIG. 18 is a schematic diagram showing an example of the external appearance of a computer system 900 that executes the program and realizes the table information processing apparatus 1 according to the embodiment. The above-described embodiment can be realized by computer hardware and a computer program executed on the computer hardware.

  In FIG. 18, the computer system 900 includes a computer 901 including a CD-ROM drive 905, a keyboard 902, a mouse 903, and a display 904.

  FIG. 19 is a diagram showing an internal configuration of the computer system 900. In FIG. 19, in addition to the CD-ROM drive 905, a computer 901 is connected to an MPU (Micro Processing Unit) 911, a ROM 912 for storing a program such as a bootup program, and the MPU 911, and receives instructions of an application program. A RAM 913 that temporarily stores and provides a temporary storage space, a hard disk 914 that stores application programs, system programs, and data, a bus 915 that interconnects the MPU 911, the ROM 912, and the like, and a network such as the Internet A network card 916 for providing connection.

  A program that causes the computer system 900 to execute the functions of the table information processing apparatus 1 according to the above embodiment may be stored in the CD-ROM 921, inserted into the CD-ROM drive 905, and transferred to the hard disk 914. Alternatively, the program may be transmitted to the computer 901 via a network such as the Internet and stored in the hard disk 914. The program is loaded into the RAM 913 when executed. The program may be loaded directly from the CD-ROM 921 or the network. Further, the program may be read into the computer system 900 via another recording medium (for example, a DVD or a memory card) instead of the CD-ROM 921.

  The table information processing apparatus 1 is not limited to the stationary computer system 900 as described above, and may be realized by a portable computer system such as a smartphone, a tablet terminal, or a notebook PC. In this case, among the hardware described in FIGS. 18 and 19, the hard disk 914, the CD-ROM drive 905, and the CD-ROM 921 may be replaced with, for example, a flash memory, a memory card slot, and a memory card, respectively. The keyboard 902 and the mouse 903 can be replaced with a touch panel, for example.

  The program does not necessarily include an operating system (OS) or a third-party program that executes the function of the table information processing apparatus 1 according to the above embodiment in 901 indicating the details of the computer. The program may include only a part of an instruction that calls an appropriate function or module in a controlled manner and obtains a desired result. How the computer system 900 operates is well known and will not be described in detail.

  In addition, the computer which performs the said program may be single, and plural may be sufficient as it. That is, centralized processing may be performed, or distributed processing may be performed.

  In the above embodiment, each processing (each function) may be realized by centralized processing by a single device (system), or may be realized by distributed processing by a plurality of devices. May be.

  The present invention is not limited to the above-described embodiments, and various modifications are possible, and it goes without saying that these are also included in the scope of the present invention.

  As described above, the table information processing apparatus according to the present invention determines a layout according to four or more data, and arranges the four or more data in the table in the page according to the determined layout. This has the effect of automatically determining the layout of four or more data in the table, and is useful as a table information processing apparatus.

DESCRIPTION OF SYMBOLS 1 Table information processing apparatus 11 Storage part 12 Reception part 13 Processing part 14 Output part 131 Inspection part 132 Determination part 133 Arrangement part

Claims (10)

A storage unit that stores page information that is information constituting a page in which a table area is determined, which is an area in which a table having two or more rows and two or more columns is arranged;
A reception unit that receives four or more pieces of data arranged in the table;
An inspection unit for inspecting data received by the reception unit;
A determination unit that determines a layout of the four or more data in the table based on the inspection result of the inspection unit;
According to the layout determined by the determination unit, an arrangement unit that arranges the four or more data in the table;
A table information processing apparatus comprising: an output unit that outputs a page including a table in which the arrangement unit arranges the four or more data using the page information. The inspection unit
Obtaining a property corresponding to each of one or more of the four or more data;
The determination unit
According to the property acquired by the inspection unit, determine a ratio regarding the size of the columns or rows constituting the table,
The placement section is
The table information processing apparatus according to claim 1, wherein the four or more pieces of data are arranged in the table according to a ratio determined by the determination unit. The property is
The table information processing apparatus according to claim 2, wherein the table information processing apparatus is one or more kinds of information of data length and data type. The property is
Including data types,
The inspection unit
The table information processing apparatus according to claim 3, wherein the data type is determined from one or more characters included in the data. The four or more data are
Two or more attribute name data indicating the attribute name of the table, and data paired with the two or more attribute name data, including two or more attribute value data indicating the attribute value of the table,
The determination unit
The information processing apparatus according to any one of claims 1 to 4, wherein the determination is made based on a test result of at least one of the two or more attribute name data and the two or more attribute value data. The determination unit
The layout of the four or more data in the table such that the two or more attribute name data are arranged in one row of the two or more rows or one column of the two or more columns. The information processing apparatus according to claim 5, which determines The determination unit
2. One or more types of information are determined based on the inspection result of the inspection unit, from the width of each of two or more columns constituting the table or the height of each of two or more rows constituting the table. The table information processing apparatus according to claim 6. The reception unit
Further accepting instructions for the table area,
The determination unit
The table information processing apparatus according to claim 1, wherein an arrangement of the table area in the page is determined according to the instruction. A table information processing method performed by a storage unit, a reception unit, an inspection unit, a determination unit, an arrangement unit, and an output unit,
A storage step in which page information that is information constituting a page in which an area in which a table having two or more rows and two or more columns is arranged is stored in the storage unit;
A receiving step in which the receiving unit receives four or more pieces of data arranged in the table;
An inspection step in which the inspection unit inspects data received by the reception unit;
A determination step in which the determination unit determines a layout of the four or more data in the table based on the inspection result of the inspection unit;
An arrangement step in which the arrangement unit arranges the four or more data in the table according to the layout determined by the determination unit;
A table information processing method comprising: an output step in which the output unit outputs a page including a table in which the arrangement unit arranges the four or more data using the page information. Computer
A storage unit that stores page information that is information constituting a page in which an area in which a table having two or more rows and two or more columns is arranged;
A reception unit that receives four or more pieces of data arranged in the table;
An inspection unit for inspecting data received by the reception unit;
A determination unit that determines a layout of the four or more data in the table based on the inspection result of the inspection unit;
According to the layout determined by the determination unit, an arrangement unit that arranges the four or more data in the table;
A program for causing the arrangement unit to function as an output unit that outputs a page including a table in which the four or more pieces of data are arranged, using the page information.

Images