JP5239807B2 - Spreadsheet generation program, spreadsheet generation apparatus, and spreadsheet generation method - Google Patents

Description

  The present invention relates to a spreadsheet generation program, a spreadsheet generation device, and a spreadsheet generation method for automatically generating spreadsheet data of a form to be subjected to overlay output processing.

  The output result of the form is the form data including the items configured based on the format definition information of the form and the input data input to each item, such as frames, ruled lines, marks, etc. configured based on the overlay definition information. Overlay elements are superimposed and output.

  When the input data for a form item is used for secondary calculation or graph creation from the form print result, only the input data must be extracted from the form print result.

  However, when the print result of a form is digitized, the digitized print result data cannot distinguish input data from overlay data, so that only the input data cannot be extracted from the print result data.

  Therefore, when reusing input data of a form, conventionally, a business application or the like that obtains input data of a form from a database is created without using the printed result of the form electronically. The input data was acquired through the application.

  In addition, if the form input data and the overlay data are superimposed as they are in the printing process, there may be a difference such as a positional deviation or mismatch between the two on the form. If the print result of a form with different input data and overlay data is digitized, the digitized print result data cannot be reused as a display display or data input format as it is. Therefore, some processing or correction was necessary for reuse.

If the input data to the form items is indeterminate, change the size of the rectangular area of the form input data defined in the form definition information, and the character pitch, line pitch, etc. There is a known process of printing a form with an appropriate appearance by changing the above.
JP 2004-355077 A

  In order to effectively use a form as an information resource, there has been a strong demand for a process for converting form information into spreadsheet data that can be used by existing business applications such as spreadsheet software. In particular, a process for automatically generating data that can easily be used for the secondary use of input data while maintaining an image of a print result as much as possible from a form subjected to overlay output processing has not been realized.

  SUMMARY OF THE INVENTION An object of the present invention is a processing technique for automatically generating spreadsheet data that can easily utilize secondary layouts of input data and print results while maintaining an image of a print result of a form for a form to be subjected to overlay output processing. That is, a program for causing a computer to function as processing means for generating the spreadsheet data, an apparatus for executing the automatic generation processing of the spreadsheet data, and a method for generating the spreadsheet executed by the computer are provided. That is.

  In order to achieve the above object, a spreadsheet generation program disclosed as one aspect of the present invention includes a computer, a format definition information acquisition processing unit, an overlay definition information acquisition processing unit, a cell definition information generation processing unit, and a spreadsheet. It functions as output processing means.

  In a computer in which the disclosed program is installed and executed, the format definition information acquisition processing means acquires format definition information related to the layout position in the form of the group of items constituting the form. Also, overlay definition information acquisition processing means acquires overlay definition information relating to the layout position in the form of the overlay group that is output superimposed on the form.

  Then, the cell definition information generation processing means determines the column width and the row height based on the distance between adjacent items from the position in the column direction and the layout position in the row direction of each item of the format definition information. Generate format cell definition information for column width and row height.

  Then, the spreadsheet output processing means determines the column width and row height corresponding to the layout position of the overlay based on the overlay definition information, and further, the column width and row height of the item group of the format cell definition information, Based on the column width and row height based on the determined layout position of the overlay, the column width and row height for output, and the cell to which each of the item group and overlay group in the cell array of the column width and row height correspond are displayed. Generate the identified spreadsheet.

  According to the disclosed program, it is possible to cause a computer to function as processing means for automatically generating a spreadsheet having a cell array that maintains layout positions of items in a form and items and components overlaid upon output. The output spreadsheet data can be used to reuse the layout of the output result of the form, reuse the input data of the form, and the like.

  Based on the format definition information and overlay definition information of the form that is output as overlay, the spreadsheet data that is disclosed can automatically generate spreadsheet data that includes information on the layout of items and overlays when the form is output. it can.

  In the generated spreadsheet data, a cell array is set based on information on items and overlay layout. Therefore, it becomes possible to extract only the input data in a format (for example, CSV format, XML format, etc.) that is easy to secondary use from the cells corresponding to the items of the spreadsheet data.

  In addition, it is possible to extract overlay definition information that defines the image of the printed result of the form as spreadsheet data that can be easily used for secondary use.

  Therefore, it is easier to reuse the information input to the form and the output format information of the form, and the reusability and distribution of the form are enhanced.

  Embodiments of the present invention will be described below.

  FIG. 1 is a diagram illustrating a configuration example of a spreadsheet generation apparatus 1 disclosed as an embodiment of the present invention.

  The spreadsheet generation apparatus 1 acquires format definition information 31 and overlay definition information 33 output from an existing form definition creation tool (GUI), and sets items constituting the form print result and overlay layout position in cell units. A spreadsheet 41 specified by a matrix is generated and output. Further, the spreadsheet generation apparatus 1 acquires the input data group 35 output from the business application, gives input data to the cell corresponding to the item of the form, and outputs the spreadsheet 41.

  FIG. 2 is a diagram showing an example of a form printing result in one embodiment of the present invention.

  The form print result in FIG. 2 is configured to include an item group (item A to item D) and an overlay (frame, ruled line). The attributes, output modes, layout positions, etc. of the items (item A to item D) are defined in the format definition information 31. The overlay frame, the output mode of the ruled lines, the layout position, and the like that are printed out in a superimposed manner are defined in the overlay definition information 33.

  The format definition information 31 is information relating to the layout position in the form of the item group constituting the form.

  FIG. 3 shows a data configuration example of the format definition information 31 in one embodiment of the present invention.

  The format definition information 31 includes item information and ruled line information regarding items in the partition for each partition constituting the form as form format information.

  FIG. 4 shows a data configuration example of item information of the format definition information 31.

  The item information is information defining item attributes, and includes information such as item name, item position information, item area length, data length, data format, font information, layout information, edit format, and record position.

  The item name is a unique character string in the format definition information 31 for identifying the item. The item position information is a coordinate value in the XY coordinate system with the origin at the lower left of the form shown in FIG. The coordinate value is given in units of 1/1440 inch. The item area length is the length of the item area in the X coordinate axis direction (for example, the horizontal direction).

  The data length is the length (in bytes) of the input data given to the item. Input data is a character string or a numeric value.

  The data format is the type (character string, numeric value) of the input data given to the item. The font information is information indicating the font name and font size when printing the input data.

  The arrangement information is information indicating the arrangement (right alignment, center, left alignment, etc.) when printing the input data. The edit format is a display format when the input data is printed. The display format (format) of the cell corresponding to the item of the spreadsheet 41 is set from the editing format according to the correspondence relationship set in advance. The position in the record is the position in the record of the input data group 35 of the input data given to the item. The position in the record is indicated by the number of bytes from the beginning of the record.

  FIG. 5 shows a definition example of the correspondence relationship between the item information editing format of the format definition information 31 and the format of the spreadsheet 41.

  Information relating to the definition of the correspondence relationship is provided in advance in the spreadsheet output unit 15 and is referred to when the spreadsheet 41 is generated.

  The correspondence relationship in FIG. 5 is an example of correspondence with the display format (cell format) when the spreadsheet 41 is data for spreadsheet software “EXCEL” of Microsoft Corporation. The cell format of the spreadsheet 41 is specified by the set values of “data format” and “edit format” of the item information of the format definition information 31.

  For example, when the “data format” of the item is “character string” and the “editing format” is “none”, the format of the cell associated with this item is “@”. Further, when the “data format” of the item is “numeric value” and the “editing format” is “9999999”, the “format” of the cell associated with this item is “000000; 000000”.

  FIG. 6 is a diagram for explaining the relationship between the position in the record of the item information of the format definition information 31 and the input data given to each item.

  Assume that the items of the form are arranged in the order of “item A, item AA,...” As shown in the upper part of FIG. In this case, if the input data to each item of “item A”, “item AA”,... Is “Aiueo”, “12345”,..., The input data given to each item is The printing is performed in the order of “Aiueo, 12345,...”.

  FIG. 7 shows a data configuration example of ruled line information of the format definition information 31.

  The ruled line information is information that defines the output mode (ruled line, frame, shaded, etc.) of the item, and includes type and position information.

  The type is information for identifying ruled lines / frames / shading. The position information is a coordinate value indicating a ruled line / frame / shaded position or range, and a start coordinate value (X1, Y1) and an end coordinate value (X2, Y2) are set. When the type of ruled line information is “frame” or “shaded”, the start coordinate value is the upper left coordinate of the rectangular area of the item, and the end position is the lower right coordinate of the rectangle.

  The overlay definition information 33 is information relating to the layout position in the form of the overlay group, which is an element such as a frame, ruled line, or mark that is output superimposed on the form.

  FIG. 8 shows a data configuration example of the overlay definition information 33 in one embodiment of the present invention.

  The overlay definition information 33 includes information such as character string information, ruled line information, frame information, and shaded information.

  FIG. 9 shows a data configuration example of the character string information of the overlay definition information 33.

  The character string information includes position information, character string range, data length, font information, arrangement information, and character string data.

  The position information is a coordinate value in the XY coordinate system with the origin at the lower left of the form shown in FIG. The coordinate value is given in units of 1/1440 inch. The character string range is a coordinate value indicating the range of the character string of the overlay, and the start coordinate value (X1, Y1) that is the upper left coordinate of the rectangle and the end coordinate value (X2, Y2) that is the lower right coordinate of the rectangle are set. Is done. The data length is a value (in bytes) indicating the length of the character string when the overlay is a character string.

  The font information is information indicating the font name and font size of the overlay character string. The arrangement information is information indicating the arrangement (right alignment, center, left alignment, etc.) of the character string within the character string range of the overlay. The character string data stores character string data that is an overlay.

  FIG. 10 shows a data configuration example of the ruled line information of the overlay definition information 33.

  The ruled line information includes line type and position information.

  The line type is information for identifying the type of ruled line (solid line, dotted line, thick line, etc.). The position information is a coordinate value (1/1440 inch unit) indicating the position of the ruled line. A start position (x1, y1) and an end position (x2, y2) are set.

  FIG. 11 shows a data configuration example of the frame information of the overlay definition information 33.

  The frame information includes line type and position information.

  The line type is information for identifying the type of ruled line (solid line, dotted line, thick line, etc.). The position information is a coordinate value indicating the position or range of the frame. A start position (X1, Y1) that is the upper left coordinate value of the frame rectangle and an end position (X2, Y2) that is the lower right coordinate value of the frame line rectangle are set.

  FIG. 12 shows a data configuration example of the shaded information of the overlay definition information 33.

  The shaded information includes a shaded pattern and position information.

  The shade pattern is information for identifying the type or density of the shade pattern. The position information is a coordinate value indicating a shaded position or range. A start position (X1, Y1) that is the upper left coordinate value of the frame rectangle and an end position (X2, Y2) that is the lower right coordinate value of the frame line rectangle are set.

  The input data group 35 is data corresponding to a set of data such as characters / character strings and numerical values given to the item group of the form.

  The spreadsheet generation apparatus 1 shown in FIG. 1 includes a cell definition information generation processing unit 11, a mode specification unit 13, and a spreadsheet output unit 15.

  The spreadsheet output unit 15 further includes a cell output unit 151 and an auto shape output unit 152.

  The cell definition information generation processing unit 11 acquires the format definition information 31 and, based on the cell control information 19 stored in advance, calculates the column width and row height corresponding to the layout position of the item group of the form from the format definition information 31. Format / cell definition information 21 relating to the setting of the cell is generated.

  Further, the cell definition information generation processing unit 11 acquires the overlay definition information 33, and based on the cell control information 19, from the overlay definition information 33, a cell having a column width and a row height corresponding to the layout position of the form overlay. Overlay cell definition information 23 relating to the setting of is generated.

  FIG. 13 shows a data configuration example of the cell control information 19.

  The cell control information 19 is information relating to control of processing for determining the column width / row height of the cell. The cell control information 19 has a basic cell width, a basic cell height, a rounding width, and a rounding height, and a value can be arbitrarily set for each form.

  The basic cell width is a value (1/1440 inch unit) indicating the cell width (column width) of the basic cell of the spreadsheet 41 to be output. The initial value of the basic cell width is 960/1440 inches. The basic cell height is a value (1/1440 inch unit) indicating the cell height (row height) of the basic cell of the spreadsheet 41. The initial basic cell height is 240/1440 inches.

  The rounding width is information for determining whether to adjust the position of the item in the column direction (coordinate value in the X-axis direction). The initial value of the rounding width (in units of 1/1440 inches) is 144/1440 inches. The rounding height is information for determining whether to adjust the item position (the coordinate value in the Y-axis direction). The initial value of the rounding height (in units of 1/1440 inches) is 144/1440 inches.

  The cell definition information generation processing unit 11 sorts the coordinate value (X1) in the column direction of the item group of the format definition information 31 in ascending order, and the column direction between the sorting result and the item whose ascending order is one order higher. The column width is determined based on the distance. Further, the cell definition information generation processing unit 11 sorts the coordinate values (Y1) in the row direction of the items of the format definition information 31 in ascending order, and from the sorting result, the items in the ascending order are ranked one item higher. The row height is determined based on the distance in the row direction.

  The cell definition information generation processing unit 11 sorts the column direction coordinate values (X1) and row directions (Y1) of the overlay group of the overlay definition information 33 in ascending order, and the ascending order is one higher from the sorting result. The column width is determined based on the distance in the column direction from the overlay. Further, the row height is determined based on the distance in the row direction between the overlay in the ascending order and the next higher overlay.

  Furthermore, the cell definition information generation processing unit 11 refers to the rounding width / rounding height of the cell control information 19, and if the distance between items is within the rounding width / rounding height, the cell definition information generation processing unit 11 is closer to the coordinate origin ( The X coordinate value / Y coordinate value of the other item is matched with the X coordinate value / Y coordinate value of the item in the ascending order of the sorting result (one above).

  By aligning the positions of items that have a slight positional deviation, it is possible to prevent generation of useless cells.

  FIG. 14 shows an example of determining the column width and row height based on the format definition information 31.

  In the case of the form print result shown in FIG. 2, the cell definition information generation processing unit 11 determines the column width and the row height from the layout positions of the items A to D of the format definition information 31.

  In this embodiment, based on the basic cell width and basic cell height of the cell control information 19, if the distance between two parts is not less than “basic cell width / row height × 2”, the basic cell width / basic The column height / line height is determined by dividing the cell height into two columns / rows.

  The cell definition information generation processing unit 11 converts the start position (X1, Y1) of each item of the format definition information 31 into a coordinate value in the XY coordinate system with the upper left as the origin. Items A to D are sorted in ascending order based on the converted positions (coordinate values).

The distance between the coordinate value X _f1 of the item A and the origin coordinate X ₀ is calculated, and the obtained distance is set as the column width W _a of the column A. Similarly, to calculate the distance between the coordinate value X _f1 and field coordinates X _f2 of B item A, the distance obtained for the column width W _b of the column B.

Next, determine the distance between the coordinate value _{X f4} coordinates _{X f2} and item C of item B. Since this distance is equal to or greater than “basic column width W _s × 2”, the basic column width W _s is defined as the column width W _c of the column C, and the basic column width W _{s s} is added to the coordinate value X _f2 of the item B The value X _f3 is obtained.

Furthermore, since the distance between the coordinate value X _f3 and the coordinate value X _f4 of the item C is less than “basic column width W _s × 2”, the distance is defined as the column width W _d of the column D.

It is assumed that the distance from the coordinate value X _f4 of the item C to the coordinate value X _e at the right end of the form is “basic column width Ws × 2” or more. The basic column width W _{s is set} to the column width W _e of the column E, and the basic column width W _s is added to the coordinate value X _f4 of the item C to obtain the coordinate value coordinate value X _f5 .

Here, it is assumed that the distance between the coordinate value X _f4 of the item C and the coordinate value X _fd of the item D is within the rounding width of the cell control information 19. The coordinate value X _fd of the item D is matched with the coordinate value X _f4 .

Item C, and distance to the coordinate values X _e at the right end coordinate values X _f5 and form the item D which is less than the "basic column width W _s × 2". The distance is defined as a column width W _f of the column F.

  The cell definition information generation processing unit 11 performs the same process as the column width determination process, and based on the distance in the row direction between the converted position (coordinate value) in the ascending order and the next higher item. Thus, the row height (row 1 to row 5) is determined.

  Furthermore, the cell definition information generation processing unit 11 uses the format definition information 31 in the cell matrix having the column width (column A to column F) and the row height (row 1 to row 5) determined based on the format definition information 31. The cell corresponding to the item is identified from the item position information, and the association is performed.

  Then, the cell definition information generation processing unit 11 generates the format / cell definition information 21 including the column width and row height information determined as shown in FIG. 14 and the correspondence between cells and items.

  FIG. 15 shows an example of determining the column width and row height based on the overlay definition information 33.

  In the case of the form printing result shown in FIG. 2, the cell definition information generation processing unit 11 coordinates the start position (X1, Y1) and end position (X2, Y2) of the overlay (frame, ruled line) of the overlay definition information 33. The value is converted into a coordinate value in the XY coordinate system with the upper left as the origin.

  The cell definition information generation processing unit 11 sorts the converted coordinate values in ascending order in the column direction and the row direction, obtains the distance from the coordinate value one rank higher in the sorting result, and obtains the obtained distance in the column direction Is determined as the column width and the distance in the row direction as the row height.

The cell definition information generation processing unit 11 calculates the distance between the coordinate value X _O1 of the start position of the overlay frame and the origin coordinate X ₀ and _sets it as the column width W _Oa of the column A. Similarly, the distance between the coordinate value X _O1 and the coordinate value X _O2 of the start position of the vertical ruled line in the frame is calculated and set as the column width W _Ob of the column B.

Similarly, the distance between the coordinate value X _O2 and the coordinate value X _O3 of the end position in the frame is calculated and set as the column width W _oc of the column C. Further, the distance between the coordinate value X _O3 and the coordinate value X _{e at} the right end of the form is calculated to _obtain the column width W _Od of the column D.

Further, the cell definition information generation processing unit 11 calculates the distance between the coordinate value Y _O1 of the start position of the frame and the origin coordinate Y ₀ and sets it as the row height H _O1 of the row 1. From the distance between the coordinate value Y _O1 and the coordinate value Y ₀₂ of the upper horizontal ruled line in the frame, the row height H _O2 of the line 2 is determined, and the distance between the coordinate value Y _O2 and the coordinate value Y ₀₃ of the lower horizontal ruled line in the frame. To the line height H _O3 of the line 3, the distance between the coordinate value Y _O3 and the coordinate value Y ₀₄ of the end position of the frame, the line height H _O4 of the line 4 and the coordinate value Y _O4 and the coordinate value of the lower end position of the form the line height _{H O5} line 5 from the distance between the Y _e, is calculated.

  In addition, the cell definition information generation processing unit 11 uses the overlay definition information 33 in the cell matrix having the column width (column A to column D) and the row height (row 1 to row 5) determined based on the overlay definition information 33. From the overlay position information, the cell corresponding to the overlay is identified and associated.

  Then, the cell definition information generation processing unit 11 generates the overlay cell definition information 23 including the column width and row height information determined as shown in FIG. 15 and the correspondence between the cells and the overlay.

  FIG. 16 is a diagram showing a data configuration example of information related to the layout positions of the format / cell definition information 21 and the overlay / cell definition information 23.

  The format cell definition information 21 and the overlay cell definition information 23 have a basic cell width, a basic cell height, a cell width (for the number of columns), and a cell height (for the number of rows), respectively.

  The basic cell width and basic cell height are set with the basic cell width and basic cell height of the cell control information 19 referred to when generating the cell definition information.

  In the cell width, the column width value for the number of columns determined by the cell definition information generation processing unit 11 is set in a comma-delimited format in ascending order from the coordinate origin. Similarly to the cell width, the cell height is set to the cell height by the number of rows determined by the cell definition information generation processing unit 11 in ascending order from the coordinate origin in a comma-delimited format.

  A detailed description of the processing for generating the cell definition information from the format definition information 31 and the overlay definition information 33 executed by the cell definition information generation processing unit 11 is given in the earlier patent application “Japanese Patent Application No. 2007- 863017 ".

  The mode designating unit 13 designates processing contents to be executed by the spreadsheet output unit 15. The mode designating unit 13 sets “layout emphasis mode, data emphasis mode, optimization mode, auto shape mode” in advance, and designates a mode input externally such as a mode setting operation by the user. Further, the mode designating unit 13 designates a predetermined mode, for example, “optimization mode” when there is no mode designation external input.

  The “layout-oriented mode” is a mode in which the column width and the row height are determined by using all the item group positions and overlay group positions in the form in order to maintain the same layout as the form output result. The “data emphasis mode” is a mode in which the column width and the row height are determined with priority given to the position of the column width / row height of the item in order to facilitate the reuse of input data.

  In the “optimization mode”, the column width and row height are adjusted by adjusting the position of the item group and the position of the overlay group in order to minimize the generation of cells while maintaining the same layout as the output result of the form. This is a mode for determining. “Auto shape mode” determines the column width and row height based on the position of the item group, and spreads the overlay group to facilitate reuse of the overlay while maintaining the layout of the output result of the form. In this mode, a graphic element drawn on the sheet 41 is generated.

  The cell output unit 151 of the spreadsheet output unit 15 has the column width and row height information determined based on the layout positions of the format definition information 31 and the overlay definition information 33 according to the mode specified by the mode specifying unit 13. Then, the spreadsheet 41 is generated and output. The cell output unit 151 acquires the input data group 35, and generates and outputs a spreadsheet 41 in which input data is given to the cell corresponding to the item.

  The spreadsheet 41 is data that can be processed by a spreadsheet application program called Excel (EXCEL) of Microsoft Corporation.

  Alternatively, as shown in FIG. 17, the spreadsheet 41 is OOXML (Office Open XML) format Excel data composed of a plurality of data file groups each including document data, input data, attribute data, and auto-shape data in XML format. It may be. In this case, the spreadsheet 41 in the OOXML format is compressed in the ZIP format.

  Hereinafter, processing of the cell output unit 151 in the designated mode will be described.

(1) Processing in layout emphasis mode When the “layout emphasis mode” is designated by the mode designation unit 13, the cell output unit 151 includes column width and row height information (item group layout) in the format / cell definition information 21. Position) and column width and row height information (layout position of the overlay group) of the overlay cell definition information 23, the column width and row height are determined and registered in the output cell definition information 25. The cell definition information for output 25 is information that holds the cell width (column width) and cell height (row height) determined by the processing in the designated mode.

  The spreadsheet 41 generated by the layout-oriented mode processing includes many fine cells because all coordinate values are cell separators, but there is no overlay overlapping items, so the layout of a normal print result of a form Is maintained as it is. Therefore, the spreadsheet 41 that maintains the layout of the form print result can be used as it is as a data input screen.

  FIG. 18 shows a cell arrangement example of the spreadsheet 41 in the layout-oriented mode processing.

The cell output unit 151 calculates coordinate values indicating cell delimiters (cell boundaries in the column direction) from the cell width (W _a , W _b ,...) Information of the format / cell definition information 21. From the cell width of the format cell definition information 21, coordinate values “(X ₀ ), X _f1 , X _f2 , X _f3 , X _f4 , X _f5 , (X _e )” are obtained as cell delimiters.

Similarly, from the cell width information (W _oa , W _OB ,...) Of the overlay cell definition information 23, the cell output unit 151 calculates a coordinate value indicating a delimiter (cell boundary in the column direction) of each cell. From the cell width of the overlay cell definition information 23, coordinate values “(X ₀ ), X _o1 , X _o2 , X _o3 , (X _e )” are obtained as cell delimiters.

Next, the cell output unit 151 merges these coordinate values, and sorts the coordinate values after merging in ascending order. As shown in FIG. 18, “(X ₀ ), X _o1 , X _f1 , X _f2 , X _f3 , X _o2 , X _f4 , X _f5 , X _o3 , (X _e )”.

  The cell output unit 151 employs the coordinate values after merging as column width separators, and registers the column width of each column (column A to column I) in the output cell definition information 25.

Further, the cell output unit 151 performs the same processing as the column width for the row height. From the cell height (H ₁ , H ₂ ,...) Of the format / cell definition information 21, the cell output unit 151 uses the coordinate values “(Y ₀ ), Y _f1 , _{Y f2, Y f3, Y f4} , calculates the _{(Y e)} ". Further, coordinate values “(Y ₀ ), Y _o1 , Y _o2 , Y _o3 , Y _o4 , (Y _e ) indicating the delimitation of each cell from the cell height (H _o1 , H _o2 ,...) Of the overlay cell definition information 23. ) ”.

Next, the cell output unit 151 merges the obtained coordinate values and sorts them in ascending order. As shown in FIG. 18, the coordinate values after merging are expressed as “(Y ₀ ), Y _o1 , Y _f1 , Y _o2 , Y _f2 , Y _o3 , Y _f3 , Y _f4 , Y _o4 , (Y _e ). "

  Then, the cell output unit 151 employs the coordinate value after merging as a row height break, determines the row height of each row (R1 to R9), and registers it in the output cell definition information 25.

  The cell output unit 151 generates a spreadsheet 41 in which the cell column width and row height are set based on the cell width (column width) and cell height (row height) of the output cell definition information 25. Based on the format / cell definition information 21, the range of cells of the spreadsheet 41 corresponding to each item of the form is specified. Further, the cell output unit 151 registers display format information (cell format) for the specified range of cells based on the item information of the corresponding item of the format definition information 31, ruled line information, and the like.

  Further, the cell output unit 151 specifies the cell range of the spreadsheet 41 corresponding to the overlay frame or ruled line based on the overlay cell definition information 23. Further, the cell format is registered for the specified range of cells based on the ruled line information of the corresponding overlay in the overlay definition information 33.

(2) Processing in data emphasis mode The cell output unit 151 uses the column width and row height information of the format / cell definition information 21 when the data emphasis mode is designated by the mode designation unit 13. The height is determined and registered in the output cell definition information 25.

  Then, the cell output unit 151 maps the overlay layout position to the cell array of the column width and the row height of the output cell definition information 25.

  In the spreadsheet 41 generated by the data emphasis mode processing, the layout position of the overlay is changed, so that the layout of the print result may not be maintained. However, since cells are generated based on the layout position of the item group, there are few useless cells. Therefore, when programming with the macro function of spreadsheet software, or when converting the spreadsheet 41 into CSV format data, it becomes easy to extract the input data given to the item of the form, and secondary use of the input data Becomes easier.

  FIG. 19 shows a cell arrangement example of the spreadsheet 41 in the data emphasis mode processing.

  The cell output unit 151 registers the cell width and cell height information of the format / cell definition information 21 in the output cell definition information 25. Then, a spreadsheet 41 in which the column width and row height of the output cell definition information 25 are set is generated.

  Next, the cell output unit 151 specifies the cell range of the spreadsheet 41 corresponding to each item of the form based on the format / cell definition information 21, and the format definition information 31 for the specified range of cells. Cell format) is registered based on the item information, ruled line information, etc. of the corresponding item.

  Next, the cell output unit 151 obtains the overlay definition information 33, and for each overlay, the coordinate value of the overlay start position (X1, Y1) / end position (X2, Y2) indicates which column width (what from the origin) (Th column) or row height (how many rows from the origin) is specified, and based on the specified column width / row height, the overlay start / end position is a coordinate value indicating the cell delimiter To map.

  For example, the cell output unit 151 maps to the position of the boundary with the cell close to the origin side (left side) if it is closer to the coordinate origin than the intermediate point with reference to the intermediate point of the cell column width / row height. If the side is farther from the coordinate origin than the middle point, it is mapped to the position separated from the next cell (right side).

In FIG. 19, if the coordinate value X1 of the start position (X1, Y1) of the overlay frame is greater than the coordinate X _Am (the midpoint of the distance between X _f1 and X ₀ ), the coordinate X1 is mapped to the coordinate Xf1. Furthermore, if the coordinate value Y1 <coordinates Y1m start position _(midpoint of the distance between the _{Y f1} and _{Y 0),} maps the coordinates Y1 to coordinate _{Y 0.} Therefore, the start position of the frame is the coordinates (X _f1 , Y ₀ ).

Also, if the coordinate value X2> coordinates _X Fm end position of the overlay of the frame _(the midpoint of the distance between the _{X f5} and _{X e),} to map the coordinates X2 to the coordinate _{X e.} When the coordinate value Y2> coordinate _Y 4m end position _(midpoint of the distance between the _{Y f4} and _{Y e),} to map the coordinates Y1 to coordinate _{Y e.} Therefore, the end position of the frame is the coordinates (X _e , Y _e ).

  Further, the cell output unit 151 specifies a range of cells corresponding to the overlay based on the position after mapping of the overlay, and for the specified range of cells, the cell definition unit 33 uses the overlay definition information 33 corresponding to the ruled line information of the overlay. Register cell format based on it.

(3) Optimization-oriented mode processing When the optimization mode is designated by the mode designating unit 13, the cell output unit 151 includes the column width information of the format cell definition information 21 and the overlay cell definition information 23. Based on the column width information, when the position of the item and the overlay is close, the optimum position is selected to optimize the column width, and the optimized column width is registered in the output cell definition information 25. The row height is also optimized by the same processing as the column width.

  The cell output unit 151 merges the column width and row height information of the format cell definition information 21 and the column width and row height information of the overlay cell definition information 23, and is adjacent in the column direction / row direction. For the item position (X1 / Y1) and overlay position (X1 / Y1), replace the position far from the coordinate origin with a position closer to the coordinate origin, determine the column width / row height based on the replaced position, and output Registered in the cell definition information 25.

  The cell output unit 151 sets two or more column widths / row heights using the cell width (column width) and cell height (row height) of the basic cell for one item in the format cell definition information 21. If the cell width (column width) and cell height (row height) are separated from each other, the column width / row height is determined and registered in the output cell definition information 25.

  Since the spreadsheet 41 generated by the optimization mode processing is laid out with the start position superimposed on the side close to the coordinate origin when the position of the form item and the overlay position are adjacent, the layout of the print result is The advantage of the layout emphasis mode and the data emphasis mode is that the generation of useless cells is suppressed while maintaining in general.

  Further, in this spreadsheet 41, the column width / row height is determined based on the position of the form item and the overlay, and the cells are generated. Therefore, the number of useless cells is small, and the compatibility with the processing by the spreadsheet software is reduced. Will be good.

  Further, since the column width / row height delimiters that do not correspond to the items in the spreadsheet 41 are eliminated, the number of cells is further reduced.

  FIG. 20 shows a cell arrangement example of the spreadsheet 41 in the optimization mode processing.

  The cell output unit 151 calculates a coordinate value indicating a delimiter (cell boundary in the column direction) of each cell from the cell width information of the format / cell definition information 21. Similarly, from the cell width information of the overlay cell definition information 23, a coordinate value indicating a break (cell boundary in the column direction) of each cell is calculated.

  The cell output unit 151 merges the calculated coordinate values and sorts the coordinate values in ascending order. In the sorting result, for the position in the column direction, a pair in which the item and overlay positions are adjacent is specified, and a position far from the coordinate origin is mapped to a position close to the coordinate origin.

Assume that the merged and sorted X coordinate values are “(X ₀ ), X _o1 , X _f1 , X _f2 , X _f3 , X _o2 , X _f4 , X _f5 , X _o3 , (X _e )”.

As shown in FIG. 20, since the coordinate value X _f1 of the start position of item A and the coordinate value X _o1 of the start position of the overlay (frame) are adjacent to each other and X _o1 <X _f1 , the coordinate value of the farther item A the X _f1, mapped to the coordinate values _{X o1} overlay (frame), to exclude the coordinate values _{X f1} item a. The cell output unit 151 also performs the same processing in the row direction, maps the coordinate value Y _f1 of the item A farther away to the coordinate value Y _o1 of the overlay (frame), and excludes the coordinate value Y _f1 of the item A To do. By this exclusion, the column width that _delimits the coordinate value X _o1 and the coordinate value X _f2 and the row height that _delimits the coordinate value Y _o1 and the coordinate value Y _o2 are determined.

In the cell output 151, the coordinate value _Xf1 and the coordinate value _Xf2 are column boundaries determined based on the items (item A and item B), and these coordinate values are employed as they are.

Further, the cell output unit 151 excludes the coordinate value _Xf3 because the coordinate value _Xf3 which is a delimiter between the column D and the column E is due to the setting of the basic cell.

Similarly, the cell output unit 151 also maps the positions (coordinate values X _f4 ) of the items C and D to the positions (coordinate values X _o2 ) of the overlay (vertical ruled line in the frame).

  The cell output unit 151 performs the same processing in the row direction.

  Next, the cell output unit 151 registers the column width and row height determined by the mapping in the output cell definition information 25. Then, a spreadsheet 41 in which the column width and matrix of the output cell definition information 25 are set is generated.

  Then, the cell output unit 151 specifies the cell range of the spreadsheet 41 corresponding to each item of the form based on the format / cell definition information 21, and stores the cell in the specified range in the format definition information 31. Register cell format based on it.

  Further, the cell output unit 151 specifies the cell range corresponding to the overlay based on the overlay cell definition information 23, and the ruled line information of the overlay corresponding to the overlay definition information 33 for the specified range of cells. Register cell format based on.

(4) Auto Shape Mode Processing The cell output unit 151 registers the cell width and cell height information of the format / cell definition information 21 in the output cell definition information 25 when the auto shape mode is designated by the mode designating unit 13. To do. Then, a spreadsheet 41 in which the column width and row height of the output cell definition information 25 are set is generated.

  Furthermore, the output unit 151 specifies the range of cells of the spreadsheet 41 corresponding to each item of the form based on the format / cell definition information 21, and based on the format definition information 31 for the specified range of cells. Register the cell format.

  The auto-shape output unit 152 obtains the overlay definition information 33 and converts the overlay into a graphic element drawn on the spreadsheet 41 based on the information of each overlay. The graphic element is graphic data called an auto shape of the spreadsheet software “EXCEL”.

  In the spreadsheet 41 generated by the processing in the auto shape mode, since the overlay does not depend on the cell definition information, the layout in the form print result is maintained as it is.

  Further, since the cell array of the spreadsheet 41 is set using only the format / cell definition information 21, there are few useless cells, the extraction of the input data group is facilitated, and the secondary utilization of the input data is facilitated. .

  FIG. 21 shows a cell array example of the spreadsheet 41 in the auto-shape mode processing.

  As shown in FIG. 21, the cell arrangement of the spreadsheet 41 is set using the column width and row height information of the format / cell definition information 21 as in the case of the data emphasis mode processing. As overlay elements, graphic data is generated based on the overlay definition information 33, and is superimposed on the spreadsheet 41 and output.

  In the processing of the four modes described above, the cell output unit 151 acquires the input data group 35, and outputs the spreadsheet 41 that gives the corresponding input data to the items of the generated spreadsheet 41. it can.

  As shown in FIG. 17, the cell output unit 151 is a set of a plurality of data files in the OOXML format, and document data, input data, attribute data, and auto shape (graphic data) are configured as separate files.

  Therefore, as shown in FIG. 22, only input data (XML data file) 43 can be extracted from a spreadsheet 41 composed of a plurality of data files.

  Further, when the overlay is generated as graphic data by the processing in the auto shape mode, only the auto shape (XML data file) 45 can be extracted. In the spreadsheet software, the overlay definition information 33 of the form can be used secondarily, and the distribution of the overlay can be improved.

  As an example, as shown in FIG. 23A, a certain form is defined in the overlay definition information 33 as an overlay element such as a form border, background color, item heading character string, and the like. As shown, it is assumed that the form item is defined in the format definition information 31 and the input data group 35 is given to the form, resulting in an output result as shown in FIG.

  In the spreadsheet 41 generated from the form having such a configuration, the process of extracting input data from the cells corresponding to the items of the spreadsheet becomes easier. Further, the spreadsheet 41 can be displayed as it is and used as a data input screen.

  Next, the flow of processing of the spreadsheet generation apparatus 1 in one embodiment will be described.

  FIG. 24 is a diagram illustrating a processing flow example of the outline processing of the spreadsheet generating apparatus 1.

  The cell definition information generation processing unit 11 of the spreadsheet generation device 1 performs cell definition information generation processing based on the format definition information 31 (step S1), and subsequently performs cell definition information generation processing based on the overlay definition information 33. Perform (step S2).

  The spreadsheet output unit 15 performs output cell definition information generation processing in the designated mode (step S3).

  Subsequently, the spreadsheet output unit 15 performs overlay output processing for reflecting the overlay definition on the spreadsheet 41 based on the output cell definition information 25 generated in step S3 (step S4), and further defines the items. Is output to the spreadsheet 41 (step S5).

  The overlay output process and the format output process are processes for outputting the generated spreadsheet 41 to the spreadsheet software “EXCEL” of Microsoft Corporation.

  FIG. 25 is a more detailed process flow diagram of the cell definition information generation process in step S1.

  The cell definition information generation processing unit 11 acquires the format definition information 31, and sorts the item information of each item in ascending order based on the item position (X coordinate value) in the column direction (X-axis direction) (step S10). ). Subsequently, the cell definition information generation processing unit 11 performs a column width calculation process from the item information sorted in ascending order (step S11).

  Next, the cell definition information generation processing unit 11 sorts the item information of the format definition information 31 in ascending order based on the item position (Y coordinate value) in the row direction (Y-axis direction) (step S12). The cell definition information generation processing unit 11 performs a row height calculation process from the item information sorted in ascending order (step S13).

  In the processing of step S10 and step S12, when the item position of the format definition information 31 is not the XY coordinate system having the upper left as the origin, the item position is set as the position in the XY coordinate system having the upper left as the origin (before sorting). Coordinate value). For example, in the case of the item position in the coordinate system of the lower left origin, in the process of step S12, the Y coordinate value of the item position is expressed by the equation “upper left item position Y1 = lower left item position Y1−item height H1”. To convert.

  FIG. 26 is a more detailed process flow diagram of the column width calculation process in step S11.

  The cell definition information generation processing unit 11 initializes the control information 50 (step S110). The control information 50 is temporary information generated and held on the memory during processing. The control information 50 has a “column position counter (ix)” for specifying the column position and an “item position (x)” indicating the item position processed last time.

  If there is unprocessed item information in the format definition information 31 (Y in step S111), the cell definition information generation processing unit 11 extracts an item position (X coordinate value) in the column direction from the item information (step S112). A column width calculation process based on the extracted X coordinate value is performed (step S113).

  After the process of step S113, the process returns to the process of step S111. If there is no unprocessed item information (N in step S111), the coordinate value of the right end of the form item is extracted from the format definition information 31 to be the end position (X coordinate value) of the last column (step S114). The column width calculation process is performed (step S115).

  FIG. 27 is a more detailed process flow diagram of the row height calculation process in step S13.

  The cell definition information generation processing unit 11 initializes the control information 51 (step S130). The control information 51 is temporary information generated and held on the memory during processing. The control information 51 has a “line position counter (iy)” for specifying the line position and an “item position (y1)” indicating the item position processed last time.

  If there is unprocessed item information in the format definition information 31 (Y in step S131), the cell definition information generation processing unit 11 extracts the item position (Y coordinate value) in the column direction from the item information, and coordinates the upper left origin. An item position (Y1 coordinate value) converted to a system value is obtained (step S132). A row height calculation process based on the converted Y1 is performed (step S133).

  Thereafter, the process returns to step S131, and if there is no unprocessed item information (N in step S131), the coordinate value of the lower end of the form item is obtained from the format definition information 31 and is taken out as the end position Y of the last line. (Step S134). Then, a line height calculation process for the last line is performed (step S135).

  FIG. 28 is a more detailed process flow diagram of the column width calculation process of S113 and S115.

  The cell definition information generation processing unit 11 calculates the column direction distance Dx between the items using the extracted X coordinate value and the item position x of the control information 50 (step S1130). When the extracted X coordinate value is the first column, 1 is set to the column position counter ix of the control information 50, and the extracted X coordinate value is set to the item position x. On the other hand, if the extracted X coordinate value is not the first column, the column position counter ix of the control information 50 is incremented, and the expression 1 “extracted X coordinate value−item position x of the control information 50 (the X coordinate value of the previous process). ) ”.

  As a result of the calculation of Expression 1, it is determined whether the distance Dx is larger than the rounding width of the cell control information 19 (step S1131). If the distance Dx exceeds the rounding width (Y in step S1131), the distance Dx is “ It is determined whether or not the basic cell width x 2 "or more (step S1132).

Distance Dx is equal to or "basic cell width × 2" or more (Y in step S1132), the column width to the basic cell width W _s of the cell control information 19, the cell of the column indicated by the cell location counter ix control information 50 Set to width (column width). (Step S1133). The cell position counter ix of the control information 50 is incremented and updated (step S1134). The distance Dx between items is updated with a value obtained by calculating Formula 2 “Distance Dx−Basic Cell Width W _s ” (step S1135).

  Subsequently, the process returns to the process of step S1132, and as the process of the next column, it is determined whether or not the updated distance Dx is “basic cell width × 2” or more. If the distance Dx is greater than or equal to “basic cell width × 2” (Y in step S1132), the processes in steps S1133 to S1135 are repeated. If the distance Dx is not “basic cell width × 2” or more (N in step S1132), the process proceeds to step S1136.

  In step S1136, the distance Dx between items is set as the column width, and is set to the cell width of the column indicated by the cell position counter ix of the control information 50.

  Then, the extracted item position X is set in the item position x of the control information 50 and updated (step S1137).

  If it is determined in step S1131 that the distance Dx does not exceed the rounding width (N in step S1131), the process ends.

  FIG. 29 is a more detailed processing flow diagram of the row height calculation processing in S133 and S135.

  The cell definition information generation processing unit 11 calculates the distance Dy in the row direction between items (step S1330). If the extracted item position (Y1) is in the first line, 1 is set in the line position counter iy of the control information 51, and the extracted Y1 coordinate value is set in the item position y1. If the extracted Y1 coordinate value is not for the first line, the line position counter iy of the control information 51 is incremented, and the expression 1 “extracted item position Y1—item position y1 of the control information 51 (item position Y1 of the previous process). ) ”.

  As a result of the calculation of Expression 1, it is determined whether the distance Dy is larger than the rounding height of the cell control information 19 (step S1331). If the distance Dy exceeds the rounding height (Y in step S1331), the distance Dy is “basic”. It is determined whether or not the cell height × 2 ”or more (step S1332).

  If the distance Dy is equal to or greater than “basic cell height × 2” (Y in step S1332), the cell height of the row indicated by the cell position counter iy of the control information 51 is set with the basic cell height of the cell control information 19 as the row height. Set to (Line height). (Step S1333). The cell position counter iy of the control information 51 is incremented and updated (step S1334). Further, the distance Dy between the items is updated with a value obtained by calculating Formula 2 “Distance Dy−Basic cell height” (step S1335).

  Subsequently, the process returns to the process of step S1332, and as the process of the next row, it is determined whether or not the updated distance Dy is “basic cell height × 2” or more. If the distance Dy is equal to or greater than “basic cell height × 2” (Y in step S1332), the processes in steps S1333 to S1335 are repeated. If the distance Dy is not “basic cell height × 2” or more (N in step S1332), the process proceeds to step S1336.

  In step S1336, the distance Dy between items is set as the row height, and is set to the cell height of the row indicated by the cell position counter iy of the control information 51.

  Then, the extracted Y1 coordinate value is set in the item position y1 of the control information 51 and updated (step S1337).

  If it is determined in step S1331 that the distance Dy does not exceed the rounding height (N in step S1331), the process ends.

  FIG. 30 is a more detailed process flow diagram of the output cell definition information generation process of step S3.

  When the mode designated by the mode designation unit 13 is mode A (= layout emphasis mode) (Y in step S30), the cell output unit 151 performs layout emphasis mode processing (step S31). Further, when the mode designated by the mode designating unit 13 is either mode B (= data emphasis mode) or mode D (= auto shape mode) (Y in step S32), the data emphasis mode processing is performed. (Step S33). If the mode specified by the mode specifying unit 13 is mode C (= optimization mode) or no mode is specified (Y in step S34), the optimization mode is processed (step S34). S35).

  The cell output unit 151 uses the control information 52, which is temporary information generated and held on the memory during the cell definition determination process.

  FIG. 31 shows an example data structure of the control information 52.

  The control information 52 includes an overlay cell boundary C1, an item cell boundary C2, a processed cell boundary C3, a previous cancel item cell position C4, and a cell registration flag F.

  The overlay cell boundary C <b> 1 is a coordinate value indicating a cell boundary based on the column width / row height of the overlay cell definition information 23. The item cell boundary C <b> 2 is a coordinate value indicating a cell boundary based on the column width / row height of the format / cell definition information 21.

  The processed cell boundary C3 is a coordinate value indicating a cell boundary based on the cell width / cell height after the cell definition determination process. The previous cancel item cell position C4 is a cell position (coordinate value based on cell width / cell height) of an item not processed in the previous process. The cell registration flag F is a flag indicating whether or not the cell is used for overlay processing.

  FIG. 32 is a more detailed process flow diagram of the layout-oriented process in step S31.

  The cell output unit 151 initializes the control information 52 as follows (step S310).

Overlay cell boundary C1 = 1st cell position (X coordinate value);
Item cell boundary C2 = position of the first cell (X coordinate value);
Processed cell boundary C3 = 0.

  The cell output unit 151 determines whether there is cell definition information to be processed (step S311). If there is cell definition information to be processed (Y in step S311), the cell boundary for overlay C1 of the control information 52 = the cell for item It is determined whether the boundary is C2 (step S312).

If C1 = C2 (the overlay and the item are at the same position) (Y in step S312), the column width W _a (distance C1-C3) of the first cell is registered in the output cell definition information 25. Furthermore, the processed cell boundary C3 of the control information 52 is updated with the value of C1, and the overlay cell boundary C1 and the item cell boundary C2 are updated with the next cell boundary (X coordinate value), respectively (step S313). .

  If C1 = C2 is not satisfied (N in step S312), it is determined whether C1 <C2 is satisfied (step S314).

If C1 <C2 (the overlay is a position on the left side of the item) (Y in Step S314), the column width W _a (distance C1-C3) of the first cell is registered in the output cell definition information 25. Further, the processed cell boundary C3 of the control information 52 is updated with C1, and only the overlay cell boundary C1 is updated with the next cell boundary (coordinate value) (step S315).

If C1 <C2 is not satisfied (N in step S314), and C1> C2 (the item is a position on the left side of the overlay), the output cell definition information 25 includes the column width W _a (C2-C3 Register the distance. Further, the processed cell boundary C3 of the control information 52 is updated with C2, only the item cell boundary C2 is updated with the next cell boundary (X coordinate value), and the process returns to step S311 (step S316).

  If there is no cell definition information to be processed (N in step S311), the process ends.

  FIG. 33 is a more detailed process flow diagram of the data emphasizing process in step S33.

  The cell output unit 151 registers the column width of the format / cell definition information 21 in the output cell definition information 25 (step S330).

  FIG. 34 is a more detailed process flow diagram of the optimization process in step S35.

  The cell output unit 151 initializes the control information 52 as follows (step S350).

Overlay cell boundary C1 = 1st cell position (X coordinate value);
Item cell boundary C2 = position of the first cell (X coordinate value);
Processed cell boundary C3 = 0;
Last cancel item cell position C4 = 0,
Cell registration flag F = OFF.

  The cell output unit 151 determines whether there is cell definition information to be processed (step S351). If there is cell definition information to be processed (Y in step S351), the cell boundary for overlay C1 of the control information 52 = the cell for item It is determined whether the boundary is C2 (step S352).

  If C1 = C2 (the overlay and the item are at the same position) (Y in step S352), the cell definition registration process for the overlay / item is performed (step S353).

  If C1 = C2 is not satisfied (N in step S352), it is determined whether C1 <C2 is satisfied (step S354).

  If C1 <C2 (the overlay is on the left side of the item) (Y in step S354), overlay cell definition registration processing is performed (step S355).

  If C1 <C2 is not satisfied (N in step S354), an item cell definition registration process is performed assuming that C1> C2 (the item is on the left side of the overlay) (step S356).

  FIG. 35 is a more detailed process flow diagram of the overlay / item cell definition registration process in step S353.

  The cell output unit 151 updates the cell registration flag F of the control information 52 to ON (step S3530), and clears the previous cancel item cell position C4 (step S3531). Then, the distance calculated by the expression “overlay cell boundary C1−processed cell boundary C3” is registered in the cell width of the output cell definition information 25 (step S3532).

  The processed cell boundary C3 of the control information 52 is updated with the overlay cell boundary C1 (step S3533), and the overlay cell boundary C1 and the item cell boundary C2 are updated with the position (X coordinate value) of the next cell boundary. Then, the process ends (step S3534).

  FIG. 36 is a more detailed process flow diagram of the overlay cell definition registration process in step S355.

  The cell output unit 151 updates the cell registration flag F of the control information 52 to ON (step S3550), and clears the previous cancel item cell position C4 (step S3551). Then, the distance calculated by the expression “overlay cell boundary C1−processed cell boundary C3” is registered in the cell width of the output cell definition information 25 (step S3552).

  The processed cell boundary C3 of the control information 52 is updated with the overlay cell boundary C1 (step S3553), and only the overlay cell boundary C1 is updated with the position of the next cell boundary (X coordinate value), and the process is terminated. (Step S3554).

  FIG. 37 is a more detailed process flow diagram of the cell definition registration process for the item in step S356.

  The cell output unit 151 determines whether the cell registration flag F of the control information 52 is ON (step S3560). If the cell registration flag F of the control information 52 is ON (Y of step S3560), the previous cancel item The cell position C4 is updated at the item cell boundary C2, only the item cell boundary C2 is updated at the position (X coordinate value) of the next cell boundary, and the cell registration flag F is turned OFF (step S3561).

  If the cell registration flag F of the control information 52 is not ON (N in step S3560), the distance calculated by the formula “item cell boundary C2−processed cell boundary C3” is set to the cell width of the output cell definition information 25. sign up. The processed cell boundary C3 of the control information 52 is updated with the item cell boundary C2, and only the item cell boundary C2 is updated with the position (X coordinate value) of the next cell boundary (step S3562).

  In step S3561, if the length of the processing target cell is 0, only the process of updating only the item cell boundary C2 to the position of the next cell boundary is performed.

  The processing flow of FIGS. 32 to 37 has been described as the cell width (column width) processing, but the cell output unit 151 performs the same processing for the cell height (row height).

  FIG. 38 is a more detailed process flow diagram of the overlay output process in step S4.

  The cell output unit 151 determines whether there is unprocessed information in the overlay definition information 33 (step S40). If there is unprocessed information (Y in step S40), the cell output unit 151 performs overlay position / cell position conversion processing (step S40). Step S41). Further, the cell output unit 151 performs print data registration processing (step S42), format registration processing (step S43), font / placement attribute registration processing (step S44), cell combination registration processing (step S45), ruled line / shaded registration. Processing (step S46) is performed.

  While there is unprocessed information in the overlay definition information 33, the processes in steps S41 to S46 are repeated. If there is no unprocessed information (N in step S40), a spreadsheet output process is performed (step S47).

  FIG. 39 is a more detailed process flow diagram of the format output process in step S5.

  The cell output unit 151 determines whether there is unprocessed information in the format definition information 31 (step S50), and if there is unprocessed information (Y in step S50), performs the item position / cell position conversion process (step S50). Step S51). Further, the cell output unit 151 performs print data registration processing (step S52), format registration processing (step S53), font / placement attribute registration processing (step S54), cell combination registration processing (step S55), ruled line / shaded registration. Processing (step S56) is performed.

  While there is unprocessed information in the format definition information 31, the processes in steps S51 to S56 are repeated. If there is no unprocessed information (N in step S50), a spreadsheet output process is performed (step S57).

  In the process flow diagram of FIG. 38 and the process flow diagram of FIG. 39, steps S40 and S50, steps S41 and S51, steps S42 and S52, steps S43 and S53, steps S44 and S54, steps S45 and S55, steps S46 and S56. Steps S47 and S57 each perform the same processing.

  The following process flow diagrams of FIGS. 40 to 45 are detailed explanatory diagrams of the processing steps of FIGS. 38 and 39. In the process description, the process will be described according to the process flow diagram of FIG.

  FIG. 40 is a more detailed process flow diagram of the item position / cell position conversion process of step S41 (S51).

  The cell output unit 151 calculates what column the item position of the item to be processed is. With reference to the format cell definition information 21, the column width is added in order from the coordinate origin, and the column at the time when the added column width becomes the position (X coordinate value) of the item of the format definition information 31 is obtained (step S410). In addition, the line number of the item position of the item to be processed is calculated. With reference to the format cell definition information 21, the row heights are added in order from the coordinate origin, and the column at the time when the added row height becomes the position (Y coordinate value) of the item of the format definition information 31 is obtained ( Step S411). The calculated cell position (row, column) is held (step S412).

  FIG. 41 is a more detailed process flow diagram of the print data registration process in step S42 (S52).

  The cell output unit 151 acquires the input data group 35, and extracts input data (hereinafter referred to as print data) corresponding to the item from the position in the record of the item information of the format definition information 31 (step S420).

  The cell output unit 151 determines whether the item type of the item information of the format definition information 31 is date or time (step S421). If the item type of the print data is date or time (Y of step S421), the print data Is converted into a serial value (step S422). If the item type of the print data is neither date nor time (N in step S421), it is determined whether the item type is a numerical value (step S423). Further, if the item type of the print data is a numerical value (Y in step S423), the print data is converted into a numerical character string (step S424).

  Then, the cell output unit 151 registers the print data and the corresponding cell position in the output processing information 26 (step S425). The output processing information 26 is information for processing in step S47.

  FIG. 42 is a more detailed process flow diagram of the format registration process in step S43 (S53).

  The cell output unit 151 determines whether the item information editing format of the format definition information 31 is numeric editing (step S430). If the item information variant format is numeric editing (Y in step S430), the cell output unit 151 supports numeric editing. Generate a format for EXCEL. For example, setting the total number of digits, fractional digits, comma separation, currency symbol editing, sign position, negative symbol, display color when negative data, zero data control, currency symbol, currency symbol position, positive data "+" A format such as display and decimal part zero suppression is generated (step S431).

  Next, it is determined whether the item information editing format is date editing or time editing (step S432). If the editing format is date editing or time editing (Y in step S432), date editing or time editing is performed. A format for EXCEL corresponding to is generated (step S433). It is determined whether the item information editing format is zip code editing (step S434). If the editing format is zip code editing (Y in step S434), an EXCEL format corresponding to zip code editing is generated. For example, the setting of 5 digits / 7 digits, the presence or absence of insertion characters (hyphens, spaces), or the type is generated (step S435).

  The cell output unit 151 generates a format (@) indicating character string data if none of the determination processes in steps S430, S432, and S434 is applicable (step S436).

  The cell output unit 151 designates the format generated by the processes in steps S431 to S436 and the corresponding cell position, and registers them in the output processing information 26 (step S437).

  FIG. 43 is a more detailed processing flowchart of the font / arrangement attribute registration processing in step S44 (S54).

  The cell output unit 151 registers information related to the font attribute of the item information of the format definition information 31 in the output processing information (step S440). Further, information relating to the character string layout attribute of the item information of the format definition information 31 is registered in the output processing information 26 (step S441).

  FIG. 44 is a more detailed process flow diagram of the cell combination registration process in step S45 (S55).

  The cell output unit 151 calculates a corresponding cell range (step S450). The range of cells occupied by the item is calculated from the item position (X, Y1) of the format definition information 31, the item area length (X-axis direction width), and the item height (Y-axis direction width) of the item information. . Then, the cell range corresponding to the calculated range is specified from the format / cell definition information 21.

  Then, the specified cell range is set as a combined range, and the cell position of the combined range is registered in the output processing information 26 (step S451).

  FIG. 45 is a more detailed process flow diagram of the ruled line / shaded registration process in step S46 (S56).

  The cell output unit 151 determines whether the type of ruled line information in the format definition information 31 is a ruled line (step S460).

  If the type of ruled line information is a ruled line (Y in step S460), the corresponding cell range is calculated (step S461).

  From the format cell definition information 21, it is calculated which column and row the ruled line start position (X1, Y1) and end position (X2, Y2) are included.

  When the spreadsheet 41 is generated by processing in the data emphasis mode or the optimization mode, for the mapped item or overlay ruled line, the coordinate value of the ruled line start position / end position is determined by the cell column width / If the coordinate value of the start position / end position is smaller than the midpoint with respect to the midpoint of the line height, the cell delimiter of the previous (coordinate origin side) is used as the start / end position of the range. If the coordinate value of the start position / end position is large, the cell range is calculated by setting the next cell division (opposite the coordinate origin) as the start / end of the range.

  The cell output unit 151 determines whether the type of ruled line information in the format definition information 31 is shaded (step S462). If the ruled line information type is shaded (Y in step S462), the corresponding cell range is calculated. The calculation of the cell range is performed by the same processing as the processing in step S461. From the format / cell definition information 21, the shaded start position (X1, Y1) and end position (X2, Y2) indicate which column and row. (Step S463).

  The specified cell range as ruled line and shaded is designated and registered in the output processing information 26 (step S464).

  FIG. 46 is a more detailed process flow diagram of the spreadsheet output process in step S47 (S57).

  The cell output unit 151 determines whether the output cell definition information 25 includes cell information that has not been output (step S470), and determines whether to output the data of the input data group 35 to another sheet (step S470). S471).

  When another sheet output of data of the input data group 35 is designated (Y in step S471), a process of generating a spreadsheet 41 'of an XML data sheet and outputting print data to the spreadsheet 41' (Step S472), and a link to the print data in the spreadsheet 41 'of the data sheet is registered in the spreadsheet 41 (Step S473).

  When another sheet output of the data of the input data group 35 is not designated (N in step S471), a process of outputting print data to the XML spreadsheet 41 is performed (step S474).

  The cell output unit 151 outputs the format registered in the output processing information 26 to the attribute data in the XML format for the cell information (cell) of the spreadsheet 41 (step S475), and outputs it to the output processing information 26. The registered font and arrangement information are output to the attribute data (step S476), and the cell combination information registered in the output processing information 26 is output to the attribute data (step S477) and registered in the output processing information 26. The ruled line and shaded information is output to the attribute data (step S478).

  If there is no unprocessed cell information (N in step S470), the attribute data (XML format) is compressed and stored in the output destination spreadsheet 41 (step S479).

  As mentioned above, although this invention was demonstrated by embodiment, it cannot be overemphasized that a various deformation | transformation is possible for this invention in the range of the main point.

  Further, the spreadsheet generation device 1 disclosed as the embodiment of the present invention can be constructed by realizing each processing unit of the spreadsheet generation device 1 by reading and executing a program by a computer. it can. This program can be stored in an appropriate recording medium such as a portable medium memory, a semiconductor memory, or a hard disk, which can be read by a computer, and is provided by being recorded on these recording media. Alternatively, this program is provided by transmission and reception using various communication networks via a communication interface.

  The following supplementary notes are further disclosed with respect to the embodiment including the above examples.

(Appendix 1)
Computer
Format definition information acquisition processing means for acquiring format definition information related to a layout position in the form of the items constituting the form;
Overlay definition information acquisition processing means for acquiring overlay definition information related to a layout position in the form of the overlay group to be output superimposed on the form;
From the position in the column direction and the layout position in the row direction of each item of the format definition information, the column width and the row height are determined based on the distance between adjacent items, respectively. Cell definition information generation processing means for generating cell definition information;
Column width and row height corresponding to the layout position of the overlay are determined based on the overlay definition information, and based on the column width and row height of the item group of the format cell definition information, and the determined layout position of the overlay Based on the column width and row height, a spread for generating a spreadsheet specifying the cell corresponding to each of the item group and overlay group in the cell width and row height for output and the cell array of the column width and row height. A spreadsheet generation program that functions as a sheet output processing means.

(Appendix 2)
Said computer,
Functioning as a mode designating unit for designating a mode for identifying the process executed by the spreadsheet output processing unit;
The spreadsheet generation program according to appendix 1, wherein the spreadsheet output processing means determines the column width and row height for output based on a mode designated by the mode designation means.

(Appendix 3)
The mode designation means designates a data emphasis mode as the mode,
The spreadsheet output processing means determines the column width and row height for output based on the column width and row height of the format / cell definition information when the data importance mode is designated by the mode designating means. Then, a spreadsheet having the determined column width and row height for output is generated, and in the generated spreadsheet, the column width delimiter closest to the layout position of each overlay in the overlay definition information is specified, and the specified column The spreadsheet generation program according to appendix 2, wherein a column width corresponding to a width delimiter is determined as a column width corresponding to the overlay.

(Appendix 4)
The mode designation means designates a data emphasis mode as the mode,
The spreadsheet output processing means determines the column width and row height for output based on the column width and row height of the format / cell definition information when the data importance mode is designated by the mode designating means. Then, a spreadsheet having the determined column width and row height for output is generated, and in the generated spreadsheet, the row height delimiter closest to the layout position of each overlay in the overlay definition information is specified, and the specified row The spreadsheet generation program according to appendix 2, wherein a row height corresponding to a height break is determined as a column width corresponding to the overlay.

(Appendix 5)
The mode specifying means specifies an optimization mode as the mode,
When the optimization mode is designated by the mode designating means, the cell definition information generation processing means is arranged based on a distance between adjacent positions from a layout position in the column direction of each overlay of the overlay definition information. Determine the width, generate overlay cell definition information for the determined column width,
The spreadsheet output processing means sorts the column width delimiter positions of the format cell definition information and the overlay cell definition information in ascending order when the optimization mode is designated by the mode designating means. , For column width delimiters where items and overlays are adjacent, the lower delimiter position is replaced with the upper delimiter position in ascending order, and the column width corresponding to the replaced column width delimiter corresponds to the item or the overlay 3. The spreadsheet generation program according to appendix 2, wherein the column width is determined as a column width, and the sorted column width including the determined column width is used as the output column width.

(Appendix 6)
The mode specifying means specifies an optimization mode as the mode,
The cell definition information generation processing means executes a line based on a distance between adjacent positions from a layout position in a row direction of each overlay of the overlay definition information when the optimization mode is designated by the mode designation means. Determine the height, generate overlay cell definition information for the determined row height,
The spreadsheet output processing means, when the optimization mode is designated by the mode designating means, sorts the row height delimiter positions of the format cell definition information and the overlay cell definition information in ascending order; For the column width separation position where the item and overlay are adjacent, the lower separation position in ascending order is replaced with the upper separation position, and the column width corresponding to the replaced row height separation is the row corresponding to the item or the overlay. The spreadsheet generation program according to appendix 2, wherein the sorted row height including the determined row height is set as the output row height.

(Appendix 7)
The mode designation means designates an auto shape mode as the mode,
The spreadsheet output processing means outputs the column width and row height for output determined based on the column width and row height of the format / cell definition information when the auto-shape mode is designated by the mode designating means. And a process of generating graphic data for drawing a graphic corresponding to each overlay of the overlay definition information at a layout position of the overlay in the generated spreadsheet. The spreadsheet generation program according to Appendix 2.

(Appendix 8)
Said computer,
While functioning as input data acquisition means for acquiring an input data group for each item of the form,
The spreadsheet output processing means provides each input data of the input data group to a cell corresponding to each item of the generated spreadsheet, The appendix 1 to appendix 7, wherein Spreadsheet generator.

(Appendix 9)
The format cell definition information generating means sorts the column direction and row direction coordinate values of the format definition information item group in ascending order, and between the items in the ascending order one order higher than the sorting result. The column width is determined based on the distance in the column direction, the row height is determined based on the distance in the row direction from the sorting result to the item in the ascending order one level higher, and the format definition information 9. The spreadsheet generation program according to any one of the appendix 1 to the appendix 8, wherein the format cell definition information relating to the column width and the row height determined based on the column width and the row height is generated.

(Appendix 10)
Format definition information acquisition processing means for acquiring format definition information related to a layout position in the form of the items constituting the form;
Overlay definition information acquisition processing means for acquiring overlay definition information related to a layout position in the form of the overlay group to be output superimposed on the form;
From the position in the column direction and the layout position in the row direction of each item of the format definition information, the column width and the row height are determined based on the distance between adjacent items, respectively. Cell definition information generation processing means for generating cell definition information;
Column width and row height corresponding to the layout position of the overlay are determined based on the overlay definition information, and based on the column width and row height of the item group of the format cell definition information, and the determined layout position of the overlay Based on the column width and row height, a spread for generating a spreadsheet specifying the cell corresponding to each of the item group and overlay group in the cell width and row height for output and the cell array of the column width and row height. A spreadsheet generation apparatus comprising: a sheet output processing unit.

(Appendix 11)
A spreadsheet generation method executed by a computer,
A process of acquiring format definition information related to the layout position in the form of the group of items constituting the form;
A process of acquiring overlay definition information relating to a layout position in the form of the overlay group to be output superimposed on the form;
A process of determining a column width and a row height based on a distance between adjacent items from a column-direction position and a row-direction layout position of each item of the format definition information;
A process of generating format cell definition information relating to column width and row height determined from the format definition information;
A process of determining a column width and a row height corresponding to the layout position of the overlay based on the overlay definition information;
Based on the column width and row height of the item group of the format cell definition information and the column width and row height based on the layout position of the overlay, the output column width and row height and the cell of the column width and row height are output. A spreadsheet generating method comprising: generating a spreadsheet specifying a cell corresponding to each of the item group and the overlay group in the array.

It is a figure which shows the structural example of the spreadsheet production | generation apparatus disclosed as one Example of this invention. It is a figure which shows the example of the printing result of the form in one Example of this invention. It is a figure which shows the data structural example of the format definition information in one Example of this invention. It is a figure which shows the data structural example of the item information of the format definition information in one Example of this invention. It is a figure which shows the example of a definition of the correspondence of the edit format of the item information of format definition information in one Example of this invention, and the format of a spreadsheet. It is a figure for demonstrating the relationship between the position in the record of the item information of the format definition information in one Example of this invention, and the input data given to each item. It is a figure which shows the data structural example of the ruled line information of the format definition information in one Example of this invention. It is a figure which shows the data structural example of the overlay definition information in one Example of this invention. It is a figure which shows the data structural example of the character string information of overlay definition information in one Example of this invention. It is a figure which shows the data structural example of the ruled line information of overlay definition information in one Example of this invention. It is a figure which shows the data structural example of the frame information of overlay definition information in one Example of this invention. It is a figure which shows the data structural example of the shading information of overlay definition information in one Example of this invention. It is a figure which shows the data structural example of the cell control information in one Example of this invention. It is a figure which shows the example of determination of the column width and row height based on the format definition information in one Example of this invention. It is a figure which shows the example of determination of the column width and row height based on the overlay definition information in one Example of this invention. It is a figure which shows the data structural example of the information regarding the layout position of format cell definition information and overlay cell definition information in one Example of this invention. It is a figure which shows the example of the spreadsheet of an OOXML (Office Open XML) format in one Example of this invention. It is a figure which shows the cell array example of the spreadsheet by the process of layout emphasis mode in one Example of this invention. It is a figure which shows the cell array example of the spreadsheet by the process of data emphasis mode in one Example of this invention. It is a figure which shows the cell array example of the spreadsheet by the process of the optimization mode in one Example of this invention. It is a figure which shows the cell array example of the spreadsheet by the process of the auto shape mode in one Example of this invention. It is a figure for demonstrating the case where only input data is extracted from the spreadsheet comprised by the some data file in one Example of this invention. It is a figure for demonstrating the secondary utilization of the information of input data and overlay in one Example of this invention. It is a figure which shows the example of a processing flow of the outline | summary process of the spreadsheet production | generation apparatus in one Example of this invention. It is a more detailed process flow figure of the production | generation process of the cell definition information of step S1 in one Example of this invention. It is a more detailed process flowchart of the column width calculation process of step S11 in one embodiment of the present invention. It is a more detailed process flow figure of the line height calculation process of step S13 in one Example of this invention. It is a more detailed process flow figure of the column width calculation process of step S113 and S115 in one Example of this invention. It is a more detailed process flow figure of the line height calculation process of step S133 and S135 in one Example of this invention. It is a more detailed process flow figure of the output cell definition information generation process of step S3 in one Example of this invention. It is a figure which shows the example of a data structure of the control information 52 in one Example of this invention. It is a more detailed process flow figure of the layout emphasis process of step S31 in one Example of this invention. It is a more detailed process flow figure of the data emphasis process of step S33 in one Example of this invention. It is a more detailed process flow figure of the process for optimization of step S35 in one Example of this invention. It is a more detailed process flow figure of the cell definition registration process of the overlay and item of step S353 in one Example of this invention. It is a more detailed process flow figure of the cell definition registration process of the overlay of step S355 in one Example of this invention. It is a more detailed process flow figure of the cell definition registration process of the item of step S356 in one Example of this invention. It is a more detailed process flow figure of the overlay output process of step S4 in one Example of this invention. It is a more detailed process flow figure of the format output process of step S5 in one Example of this invention. It is a more detailed process flow figure of the item position / cell position conversion process of step S41 (S51) in one Example of this invention. It is a more detailed process flow diagram of the print data registration process of step S42 (S52) in one embodiment of the present invention. It is a more detailed process flow figure of the format registration process of step S43 (S53) in one Example of this invention. It is a more detailed process flow figure of a font and arrangement | positioning attribute registration process of step S44 (S54) in one Example of this invention. It is a more detailed process flow figure of the cell combination registration process of step S45 (S55) in one Example of this invention. It is a more detailed process flow figure of the ruled line / shaded registration process of step S46 (S56) in one Example of this invention. It is a more detailed process flow figure of the spreadsheet output process of step S47 (S57) in one Example of this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Spreadsheet production | generation apparatus 11 Cell definition information generation process part 13 Mode designation part 15 Spreadsheet output part 151 Cell output part 152 Auto-shape output part 19 Cell control information 21 Format cell definition information 23 Overlay cell definition information 25 Cell definition for output Information 31 Format definition information 33 Overlay definition information 35 Input data group 41, 41 'Spreadsheet 51, 52, 53 Control information

Claims (9)

Computer
Format definition information acquisition processing means for acquiring format definition information related to a layout position in the form of the items constituting the form;
Overlay definition information acquisition processing means for acquiring overlay definition information related to a layout position in the form of the overlay group to be output superimposed on the form;
From the position in the column direction and the layout position in the row direction of each item of the format definition information, the column width and the row height are determined based on the distance between adjacent items, respectively. Cell definition information generation processing means for generating cell definition information;
Column width and row height corresponding to the layout position of the overlay are determined based on the overlay definition information, and based on the column width and row height of the item group of the format cell definition information, and the determined layout position of the overlay Based on the column width and row height, a spread for generating a spreadsheet specifying the cell corresponding to each of the item group and overlay group in the cell width and row height for output and the cell array of the column width and row height. A spreadsheet generation program that functions as a sheet output processing means. Said computer,
Functioning as a mode designating unit for designating a mode for identifying the process executed by the spreadsheet output processing unit;
The spreadsheet generation program according to claim 1, wherein the spreadsheet output processing means determines the column width and row height for output based on a mode specified by the mode specifying means. The mode designation means designates a data emphasis mode as the mode,
The spreadsheet output processing means determines the column width and row height for output based on the column width and row height of the format / cell definition information when the data importance mode is designated by the mode designating means. Then, a spreadsheet having the determined column width and row height for output is generated, and in the generated spreadsheet, the column width delimiter closest to the layout position of each overlay in the overlay definition information is specified, and the specified column The spreadsheet generation program according to claim 2, wherein the column width corresponding to the width delimiter is determined as the column width corresponding to the overlay. The mode designation means designates a data emphasis mode as the mode,
The spreadsheet output processing means determines the column width and row height for output based on the column width and row height of the format / cell definition information when the data importance mode is designated by the mode designating means. Then, a spreadsheet having the determined column width and row height for output is generated, and in the generated spreadsheet, the row height delimiter closest to the layout position of each overlay in the overlay definition information is specified, and the specified row The spreadsheet generation program according to claim 2, wherein a row height corresponding to a height break is determined as a column width corresponding to the overlay. The mode specifying means specifies an optimization mode as the mode,
When the optimization mode is designated by the mode designating means, the cell definition information generation processing means is arranged based on a distance between adjacent positions from a layout position in the column direction of each overlay of the overlay definition information. Determine the width, generate overlay cell definition information for the determined column width,
The spreadsheet output processing means sorts the column width delimiter positions of the format cell definition information and the overlay cell definition information in ascending order when the optimization mode is designated by the mode designating means. , For column width delimiters where items and overlays are adjacent, the lower delimiter position is replaced with the upper delimiter position in ascending order, and the column width corresponding to the replaced column width delimiter corresponds to the item or the overlay The spreadsheet generation program according to claim 2, wherein the spreadsheet width is determined as a column width, and the sorted column width including the determined column width is used as the output column width. The mode specifying means specifies an optimization mode as the mode,
The cell definition information generation processing means executes a line based on a distance between adjacent positions from a layout position in a row direction of each overlay of the overlay definition information when the optimization mode is designated by the mode designation means. Determine the height, generate overlay cell definition information for the determined row height,
The spreadsheet output processing means, when the optimization mode is designated by the mode designating means, sorts the row height delimiter positions of the format cell definition information and the overlay cell definition information in ascending order; For the column width separation position where the item and overlay are adjacent, the lower separation position in ascending order is replaced with the upper separation position, and the column width corresponding to the replaced row height separation is the row corresponding to the item or the overlay. The spreadsheet generation program according to appendix 2, wherein the sorted row height including the determined row height is set as the output row height. The mode designation means designates an auto shape mode as the mode,
The spreadsheet output processing means outputs the column width and row height for output determined based on the column width and row height of the format / cell definition information when the auto-shape mode is designated by the mode designating means. And a process of generating graphic data for drawing a graphic corresponding to each overlay of the overlay definition information at a layout position of the overlay in the generated spreadsheet. The spreadsheet generation program according to claim 2. Format definition information acquisition processing means for acquiring format definition information related to a layout position in the form of the items constituting the form;
Overlay definition information acquisition processing means for acquiring overlay definition information related to a layout position in the form of the overlay group to be output superimposed on the form;
From the position in the column direction and the layout position in the row direction of each item of the format definition information, the column width and the row height are determined based on the distance between adjacent items, respectively. Cell definition information generation processing means for generating cell definition information;
Column width and row height corresponding to the layout position of the overlay are determined based on the overlay definition information, and based on the column width and row height of the item group of the format cell definition information, and the determined layout position of the overlay Based on the column width and row height, a spread for generating a spreadsheet specifying the cell corresponding to each of the item group and overlay group in the cell width and row height for output and the cell array of the column width and row height. A spreadsheet generation apparatus comprising: a sheet output processing unit. A spreadsheet generation method executed by a computer,
A process of acquiring format definition information related to the layout position in the form of the group of items constituting the form;
A process of acquiring overlay definition information relating to a layout position in the form of the overlay group to be output superimposed on the form;
A process of determining a column width and a row height based on a distance between adjacent items from a column-direction position and a row-direction layout position of each item of the format definition information;
A process of generating format cell definition information relating to column width and row height determined from the format definition information;
A process of determining a column width and a row height corresponding to the layout position of the overlay based on the overlay definition information;
Based on the column width and row height of the item group of the format cell definition information and the column width and row height based on the layout position of the overlay, the output column width and row height and the cell of the column width and row height are output. A spreadsheet generating method comprising: generating a spreadsheet specifying a cell corresponding to each of the item group and the overlay group in the array.

Images