JP2014074947A - Program generation system and program generation method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To effectively reduce a workload of a user when shifting work using a spread sheet to a Web application.SOLUTION: A program generation system 303 performs: first processing which searches spread sheet data for data items having non-blank cells, determines arrangement of the data items and data types of each of the data item values, and stores them to a table 308; second processing which, in making determination, outputs a confirmation screen of a determination result to an input/output part, receives a confirmation result of a user with respect to the determination result at the input/output part, and updates the table 308 with the confirmation result; and third processing which reads arrangement of the data items and information about the data types from the table 308, sets the data items and information about the data types in a program held in advance, displays an input screen receiving input of the data items in the data types to a Web browser, and generates a screen code generation program that transmits the input data in the Web browser to a server.

Description

  The present invention relates to a program generation system and a program generation method. Specifically, the present invention relates to a web application program that effectively suppresses the amount of user work when a job using a spreadsheet is transferred to a web application. The present invention relates to a technique for efficiently generating code.

  Conventionally, when configuring a web application for executing business processing, a request processing program for processing a request from a client browser, a database access program for processing access to a database storing business data, and a client browser screen It is necessary to prepare a plurality of programs such as a screen code generation program to be generated and an information processing program according to business logic. Therefore, as the system scale to which such a web application is applied increases, the burden on the user for development and maintenance work increases.

  Regarding such problems, for example, a program generation device and a program generation method that can easily develop a web application, reduce the burden on the design developer, and speed up the design development (see Patent Document 1). ) Etc. have been proposed.

Japanese Patent No. 4386243

  However, in the program generation method as described above, it is necessary to provide basic design information such as business specification information, physical specification information, and business pattern information related to a business to be processed by the web application as an input. When adopting the conventional program generation method, even if it is a web application used for simple and very small-scale business, the above basic design information preparation work is naturally necessary. In comparison with this, the complexity of development work tends to be relatively large. Therefore, there is a problem that the program generation work becomes inefficient because it does not meet the labor and cost.

  An example of the simple and small-scale business described above is an information aggregation business using a spreadsheet. In this information aggregation service, the aggregation entity presents a spreadsheet with data items to a plurality of users, collects the spreadsheets that the user has answered for each data item, collects them in a database, etc., and manages them collectively It is business. If such a business can be migrated to a web application, the processing efficiency will improve. However, as described above, it is necessary to prepare basic design information for each of a plurality of web applications. Development work is required.

  SUMMARY OF THE INVENTION An object of the present invention is to provide a technique for effectively suppressing the amount of user work and efficiently generating the code of a web application program when a job using a spreadsheet is transferred to a web application. .

  The program generation system of the present invention that solves the above problems includes an input / output unit that handles data input / output with an external device, a storage unit that stores spreadsheet data, and data that is a non-blank cell in the spreadsheet data Searching for an item, determining the arrangement of the data item and the data type of the value of each data item, and storing the information of the arrangement and data type of the data item in a table of a storage unit; A determination result confirmation screen is output to the input / output unit, a user confirmation result for the determination result is received via the input / output unit, and the table is updated with the confirmation result. Read the information of the item arrangement and data type, set the data item and the data type information in a program stored in advance in the storage unit, And a third processing unit for executing a third process for generating a screen code generation program for displaying an input screen for accepting input in the data type on a web browser and transmitting the input data on the web browser to the server. It is characterized by that.

  Further, according to the program generation method of the present invention, a computer including an input / output unit for inputting / outputting data to / from an external device and a storage unit for storing spreadsheet data is used for the non-blank cell in the spreadsheet data. A first process of searching for a data item, determining a data item arrangement and a data type of each data item value, and storing the data item arrangement and data type information in a table of a storage unit; and the determination At this time, a confirmation result confirmation screen is output to the input / output unit, a user confirmation result for the determination result is received by the input / output unit, and the table is updated with the confirmation result. Read the information of the item arrangement and data type, set the data item and the data type information in a program stored in advance in the storage unit, And executing a third process for generating a screen code generation program for displaying an input screen for accepting input in the data type on a web browser and transmitting the input data on the web browser to the server. .

  ADVANTAGE OF THE INVENTION According to this invention, the amount of user work at the time of shifting the operation | work using a spreadsheet to a web application can be suppressed effectively, and the code | cord | chord of a web application program can be produced | generated efficiently.

It is a conceptual diagram explaining the information collection business using a spreadsheet. It is a conceptual diagram explaining the information aggregation business using a web application. It is a block diagram showing the structure of the program generation system in 1st Embodiment. It is a figure which shows the structural example of the web application system which consists of a request processing program, a database access program, and a screen code generation program. It is a figure which shows an example of the hardware constitutions of the computer which implement | achieves the function of a program generation system. It is a flowchart which shows process sequence example 1 of the program generation method in 1st Embodiment. It is a flowchart which shows process sequence example 2 of the program generation method in 1st Embodiment. It is a conceptual diagram explaining the number counting method example 1 of a non-blank cell series. It is a conceptual diagram explaining the number counting method example 2 of a non-blank cell series. It is a flowchart which shows process sequence example 3 of the program generation method in 1st Embodiment. It is a figure which shows the conceptual example of a data item determination process. It is a figure which shows the example of a hierarchical structure determination table. It is a flowchart which shows process sequence example 4 of the program generation method in 1st Embodiment. It is a figure which shows the structural example of a label and type corresponding | compatible list. It is a figure which shows the structural example of a character and type corresponding | compatible list. It is a flowchart which shows process sequence example 5 of the program generation method in 1st Embodiment. It is a figure which shows the example 1 of a screen display in 1st Embodiment. It is a figure which shows the example 2 of a screen display in 1st Embodiment. It is a figure which shows the example 3 of a screen display in 1st Embodiment. It is a figure which shows the example 4 of a screen display in 1st Embodiment. It is a figure which shows the example 5 of a screen display in 1st Embodiment. It is a figure which shows the example 6 of a screen display in 1st Embodiment. It is a flowchart which shows process sequence example 6 of the program generation method in 1st Embodiment. It is a flowchart which shows process sequence example 7 of the program generation method in 1st Embodiment. It is a flowchart which shows process sequence example 1 of the program generation method in 2nd Embodiment. It is a figure which shows the conceptual example of the lowest label arrangement direction determination process. It is a figure which shows the example 1 of a screen display in 2nd Embodiment. It is a figure which shows the conceptual example of the specific direction lowest label determination process. It is a figure which shows the example 2 of a screen display in 2nd Embodiment. It is a figure which shows the example 3 of a screen display in 2nd Embodiment. It is a figure which shows the example 4 of a screen display in 2nd Embodiment. It is a figure which shows the example 1 of a concept of the specific direction lowest label determination in 3rd Embodiment. It is a figure which shows the example 2 of a concept of the specific direction lowest label determination in 3rd Embodiment. It is a flowchart which shows process sequence example 1 of the program generation method in 4th Embodiment. It is a figure which shows the example 1 of a screen display in 4th Embodiment.

  Embodiments of the present invention will be described below in detail with reference to the drawings. First, a specific concept of information aggregation work using a spreadsheet, which is an application target of a web application generated by the program generation system of the present embodiment, will be exemplified. The information aggregating task is a task in which an aggregation entity that leads data collection and aggregation presents data items corresponding to data to be collected to a plurality of users and obtains responses from the plurality of users. Become. In this case, each of the plurality of users inputs data related to the data items presented by the aggregation entity in a spreadsheet and presents the data to the aggregation entity. On the other hand, the aggregation entity registers each data presented by the users in the database.

  FIG. 1 shows a conceptual example of information aggregation work using a spreadsheet as described above. When the information aggregation work is performed using a spreadsheet, a data file 104 representing a spreadsheet 103 describing data items as illustrated in FIG. 1 is used. First, the aggregation entity 101 delivers the above-described data file 104 to a plurality of users 102 by e-mail or the like. The user 102 receiving the data file 104 edits it, inputs data regarding each data item, and returns the edited data file 104 to the aggregation entity. The aggregation entity extracts data input by the user from the data file 104 returned from the users and registers it in the database 105. For delivery and return of the data file 104, e-mail, a file server, or the like is used.

  In the information aggregation work using the spreadsheet 103 shown in FIG. 1, the user 102 inputs “applicant, surname”, “applicant, first name”, “product, product ID”, “product, number”, It is a total of six data items of “assistance, burden source” and “assistance, amount”.

  As shown in the relationship between “applicant” and “surname” that make up the data item “applicant, surname”, there is a structure in which cells with values, that is, non-blank cells, are linked in a hierarchy with respect to a data item. It exists in the spreadsheet 103. The data item “Applicant, Surname” includes a hierarchical structure in which a non-blank cell with the value “Applicant” is set as the upper hierarchy and a non-blank cell with the value “Last Name” is set as the lower hierarchy. It is out. A data item can be recognized only by a single non-blank cell in which values such as “applicant” and “last name” are set. Therefore, in a broad sense, the above-described data item “applicant, surname” can be regarded as a hierarchical structure of the data item “applicant” and the data item “surname”.

  In the following embodiments, the data items are thus divided into a hierarchical structure, and each element (eg, “applicant”, “last name”) forming the hierarchical structure is referred to as a label. That is, one data item is represented by one or more labels. Further, a label corresponding to the lowest level of the hierarchical structure of the data item is called a lowest level label, and is called a first higher level label, a second higher level label, etc. every time the hierarchy is raised. In the data item “applicant, surname”, the lowest label is “last name” and the first upper label is “applicant”.

  In the spreadsheet, the above-described label is written in a cell. The hierarchical structure in the data item is expressed by the size and arrangement of the cell in which the label is written. In the spreadsheet shown in FIG. 1, the cells in which the values of “applicant”, “product”, and “auxiliary” as labels are entered are “last name” and “first name”, and “product ID” and “number”, respectively. , And “payment source” and “forehead” cells are arranged with a width of 2 cells above each cell. With this arrangement, “Applicant” is the first upper label of “Last Name” and “First Name”, “Product” is “Product ID” and “Number”, and “Auxiliary” is the first upper label of “Billing Source” and “Forehead”. It is shown that there is.

  In addition, the spreadsheet used for the above-described information aggregation work has a feature that cells including the lowest label of data items are arranged in a row or column direction. Also in the spreadsheet 103 of FIG. 1, “last name”, “first name”, “product ID”, “number”, “burden source”, and “amount” are the lowest labels, and these are arranged in the row direction. Also, there is a feature that the direction in which the lowest labels are arranged and the direction of the hierarchical structure are orthogonal. In the spreadsheet 103 of FIG. 1, the lowest labels are arranged in the row direction, while the direction of the hierarchical structure is the column direction, and the label described in the adjacent cell above is described in the lower cell. It is a higher-order label.

  Also, in a spreadsheet used for information aggregation work, one upper label has the same width (when the lowest label is aligned in the row direction) or height (the lowest label is the column direction) If you line up with). Therefore, the width or height of one upper label is equal to or greater than the width or height of one lower label under it. Furthermore, since the sum of the widths or heights of the labels in one hierarchy is the same among the hierarchies in the same data item, the number of labels in one hierarchy is almost smaller in the upper label than in the lower label. (Except when upper and lower labels have the same number of cells). Also in the spreadsheet 103 of FIG. 1, there are three upper labels, while there are six lowest labels.

  Note that the spreadsheet used for information aggregation work has a feature that elements other than labels are entered, such as “XX tabulation”, “yen”, and “pieces” in the spreadsheet 103 in FIG. .

  FIG. 2 is a conceptual diagram for explaining the implementation of the information aggregation work using the web application. In this case, instead of delivering the data file 104 of the spreadsheet 103 shown in FIG. 1 to the user, the aggregation entity creates a web application that displays the screen 203 as shown in FIG. The user 202 accesses the server 201 using a web browser in the client terminal, and inputs the same six items of data as illustrated in FIG. 1 through this web application. The web application is configured to store input data from the user 202 in the server 201 or a database of another device connected to the server 201.

  Even if the same information aggregating operation is performed, registration in the database is automated and efficiency is higher when the web application is used than when the spreadsheet 103 is used. Nevertheless, the reason for carrying out the information aggregation work using the spreadsheet 103 as shown in FIG. 1 is that there is no method for easily creating a web application as shown in FIG. Therefore, it is highly convenient if the information aggregation work that has been conventionally performed using the spreadsheet 103 can be transferred to the web application with a simple procedure. Therefore, in the program generation system according to the present embodiment, the spreadsheet 103 used in the information aggregation work is input, and a web application for performing the same information aggregation work is generated.

--- First Embodiment ---
Next, the configuration of the program generation system 303 in the first embodiment will be described. FIG. 3 is a block diagram illustrating a configuration example of the program generation system 303 according to the first embodiment. The program generation system 303 is a computer system for effectively suppressing the amount of user work and efficiently generating the code of the web application program when a job using the spreadsheet 103 is transferred to the web application.

  The program generation system 303 is connected to an input device 301 such as a keyboard and a mouse that receives instructions from the above-described aggregation entity and a display device 302 such as a display that presents processing results to a person in charge. These connections may be direct connections, or may be connections via communication lines or other information terminals.

  The program generation system 303 includes functional units such as a data item / type determination unit 304, a code generation unit 305, and a screen control unit 306, and a storage unit 307. Each functional unit can be said to be implemented by executing a program included in the program generation system 303, for example.

  Among them, the data item / type determination unit 304 reads the spreadsheet data from the data file 104 of the spreadsheet 103 described above, determines the arrangement and type of the data items to be subjected to information aggregation work, and the data item / type table A function of storing in the storage unit 307 as 308 is provided.

  Also, the code generation unit 305 reads out information on the data item and its type from the data item / type table 308 stored in the storage unit 307, requests processing program code 309, database access program code 310, screen code generation program code 311 is generated and stored in the storage unit 307, and a database 312 is constructed.

  In addition, the screen control unit 306 displays a screen for presenting information to the display device 302 in the process of the data item / type determination unit 304, and further accepts an input operation from the input device 301, and information generated by input. Is provided to the data item / type determination unit 304.

  The storage unit 307 may be configured to be included in the program generation system 303 as illustrated in FIG. 3 or may be configured to be externally connected to the program generation system 303.

  FIG. 4 is a diagram illustrating a configuration example of a web application system including a request processing program 405, a database access program 406, and a screen code generation program 407 generated by the program generation system 303.

  The request processing program code 309, the database access program code 310, and the screen code generation program code 311 generated by the above-described code generation unit 305 are arranged in the server 402 in an executable state, and are respectively request processing program 405 and database. An access program 406 and a screen code generation program 407 are configured. The database 408 is configured to be able to store input data corresponding to data items to be subjected to information aggregation work.

  The web application system is used from the web browser 403 of the client 401. When the web browser 403 accesses the web application (application for information aggregation) of the server 402, the screen code generation program 407 of the server 402 stores information on each data item (from the spreadsheet 103) described above in a predetermined manner. A screen code 404 is generated by being inserted into a screen data template and transmitted to the web browser 403. The web browser 403 displays the received screen code 404 on the screen.

  On the other hand, when a request including input data on a display screen corresponding to the above-described screen code 404 is transmitted from the web browser 403 of the client 401 to the server 402, the request processing program 405 is activated. The request processing program 405 receives input data from a request from the web browser 403. Further, the request processing program 405 activates the database access program 406, passes input data to it, and requests execution of processing.

  The database access program 406 receives input data from the request processing program 405, registers it in the database 408, and returns the execution result to the request processing program 405. The request processing program 405 returns the execution result of the database access program 406 as a response to the web browser 403.

  The program generation system 303 can be realized on a general computer. FIG. 5 is a diagram illustrating a hardware configuration example of a computer that realizes the functions of the program generation system 303.

  A computer serving as the program generation system 303 includes a CPU (Central Processing Unit) 502, a RAM (Random Access Memory) 503, a ROM (Read Only Memory) 504, an HDD (Hard Disk Drive) 505, a communication interface (I / F) 506, an input. An output interface (I / F) 507 and a media interface (I / F) 508 are provided.

  The CPU 502 operates based on a program stored in the ROM 504 or the HDD 505 and controls each unit. The ROM 504 stores a boot program executed by the CPU when the computer is started, a program depending on hardware, and the like.

  The HDD 505 stores a program executed by the CPU 502 and data used for the program. The communication interface 506 receives data from other devices via the communication medium 520 and sends the data to the CPU 502, and transmits the data generated by the CPU 502 to other devices via the communication medium 520.

  The CPU 502 controls a display device 302 such as a display and an input device 301 such as a keyboard and a mouse via an input / output interface 507. That is, the CPU 502 outputs the generated data to the display device 302 via the input / output interface 507 and acquires data from the input device 301 via the input / output interface 507.

  The media interface 508 reads a program or data stored in the recording medium 530 and provides it to the CPU 502 via the RAM 503. The CPU 502 loads the program from the recording medium 530 onto the RAM 503 via the media interface 508, and executes the loaded program. The recording medium 530 is, for example, an optical recording medium such as a DVD (Digital Versatile Disk) or PD (Phase change rewritable disk), a magneto-optical recording medium such as an MO (Magneto-Optical disk), a tape medium, a magnetic recording medium, or a semiconductor memory. Etc.

  When such a computer functions as the program generation system 303, the CPU 502 implements the functions of the data item / type determination unit 304, the code generation unit 305, and the screen control unit 306 by executing a program loaded on the RAM 503. To do. The ROM 504 or the HDD 505 stores data in the storage unit 307. The computer reads these programs from the recording medium 530 and executes them, but as another example, these programs may be acquired from other devices via the communication medium 520. The communication medium 520 refers to a communication line or a carrier wave or a digital signal that propagates through the communication line.

  FIG. 6 is a flowchart showing a processing procedure example 1 of the program generation method according to the first embodiment. Specifically, the flowchart shows an example of generation of a web application by the program generation system 303.

  In this case, the data item / type determination unit 304 of the program generation system 303 starts the web application generation process by reading the data file 104 of the spreadsheet 103 from the storage unit 307 or the input device 301 (S101). The trigger of such processing is, for example, when the program generation system 303 receives a user instruction from the input device 301, or when the arrival of a predetermined time is detected by a clock function (a computer generally has), Alternatively, it can be assumed that the data file 104 of the spreadsheet 103 is input from the input device 301.

  Subsequently, the data item / type determination unit 304 performs a data item determination process (S102). In the data item determination process S102, the data item / type determination unit 304 acquires spreadsheet data from the data file 104 of the spreadsheet 103 read in step S101 described above, analyzes the spreadsheet data, and determines the hierarchical structure. Determine the included data items. Details of this processing will be described later.

  In addition, the data item / type determination unit 304 performs a data type determination process (S103). In the data type determination process S103, the data item / type determination unit 304 includes the lowest label of the data item determined in the data item determination process S102 described above, a label / type correspondence list 313, and a character / type correspondence list 314, which will be described later. To determine the data type of the corresponding data item.

  Further, the data item / type determination unit 304 performs data item / type confirmation processing (S104). The data item / type determination unit 304 displays the data item and the type determined in the data item determination processing S102 and the data type determination processing S103 in the data item / type confirmation processing S104 via the screen control unit 306. It is displayed in 302 so that a user such as an aggregation subject can confirm. Further, the data item / type determination unit 304 receives the operation of the user such as the aggregation subject with respect to the input device 301 via the screen control unit 306, and deletes, modifies, and adds the data item and its type indicated by the user operation content. Various processes such as these are performed. By this processing, the data item and its type as the determination result are stored in the data item / type table 308.

  Next, the code generation unit 305 performs code generation processing (S105). In the code generation processing S105, the code generation unit 305 reads the data item and its type information from the data item / type table 308, constructs the database 312 using these information, and further generates request processing program code 309, Database access program code 310 and screen code generation program code 311 are generated. Each generated program code is stored in the storage unit 307.

  FIG. 7 is a flowchart showing a processing procedure example 2 of the program generation method in the first embodiment, and specifically, a flowchart showing an example of the data item determination processing S102 performed by the data item / type determination unit 304. It is.

  In this case, the data item / type determination unit 304 reads the spreadsheet data from the spreadsheet 103, and counts the number of non-blank cells in each row or column by a method described later based on FIG. 8A (S201).

  Next, the data item / type determination unit 304 identifies the most continuous non-blank cell, that is, the largest continuous non-blank cell included in the largest count among all the rows and columns, and sets the entry content to the maximum. The lower label is set (S202).

  Finally, the data item / type determination unit 304 performs a hierarchical structure determination process (S203). The hierarchical structure determination process S203 is a process for determining the upper label of each lowest label from the spreadsheet.

  FIG. 8A is a conceptual diagram for explaining a first example of number counting method for a series of non-blank cells, and FIG. 8B is a conceptual diagram for explaining a second example of number counting method for a series of non-blank cells.

  In the spreadsheet 103, a rectangular area surrounded by ruled lines is called a cell. In this embodiment, a cell in which no value is entered is called a “blank cell”, and a cell that is not a blank cell is called a “non-blank cell”. All cells are either blank cells or non-blank cells. A large cell formed by connecting a plurality of cells is either a blank cell or a non-blank cell.

  The count of the number of non-blank cells is divided into a row unit count and a column unit count. In any count, cells constituting the spreadsheet 103 are referred to in order from the end of the spreadsheet 103, and the maximum value of the number of continuous non-blank cells is taken as the count. Concatenated cells related to the row or column to be counted (a plurality of cells connected to form a large single cell) are subject to counting in units of rows or columns. Therefore, when the connected cell is a non-blank cell, the connected cell is a target for counting in a plurality of rows or a target for counting in a plurality of columns.

  A numerical value representing the count is shown at the end of the arrow at the end of the row and column of the spreadsheet 103 in FIG. 8A. In the present embodiment, the number n is used to represent the nth row as “Rn” and the nth column as “Cn”. In addition, a symbol representing a function for obtaining row and column counts is “N”.

  For example, in FIG. 8A, the row “R4” has the largest count in the row direction, and the count is N (R4) = 6. In addition, the columns “C1” and “C2” have the largest counts in the column direction, and the counts are N (C1) = N (C2) = 3.

  Note that in the column-by-column count of column “C5”, consecutive non-blank cells are divided into two locations. In this column “C5”, the continuous non-blank cells are “purchased product” and “money” (the number of non-blank cells is “2”), and the number of cells is 1 and the non-continuous “submission YY” "Is the part. Among these, the number of the former having a large number is set as the count of the column “C5”, and N (C5) = 2. Similarly for the column “C6”, N (C6) = 2.

  The count is similarly obtained in FIG. 8B. FIG. 8B is an example in which the count in the column direction tends to be larger than that in FIG. 8A. In FIG. 8B, the row direction counts are the largest in rows “R2”, “R3”, “R4”, and “R5”, and the counts are all “2”. In addition, the column “C3” has the largest count in the column direction, and the count is N (C3) = 5.

  FIG. 9 is a flowchart showing a processing procedure example 3 of the program generation method according to the first embodiment. Specifically, the flowchart shows an example of a hierarchical structure determination process S203 performed by the data item / type determination unit 304. is there. At the time of execution of the hierarchical structure determination process S203, the arrangement direction of the lowest label included in the spreadsheet data and the lowest label are specified by the previously executed process S202.

  The hierarchical structure determination processing S203 executed by the data item / type determination unit 304 creates a hierarchical structure determination table 315 as shown in FIG. 10B and determines the upper label from the spreadsheet data for each of the lowest labels. It is. The upper label is searched upward or leftward from the position of the lowest label. Here, the search direction is “D”, and the “upper” direction is defined when the arrangement direction of the lowest label is a row, and the “left” direction is determined when the arrangement direction of the lowest label is a column.

  The data item / type determining unit 304 provisionally adopts the first lowest label, and moves the search position to the position of the first lowest label (S301). Next, the data item / type determination unit 304 stores the lowest label, the item name, and the D end position in the hierarchical structure determination table 315 (S302).

  Here, the item name represents a character string obtained by concatenating labels temporarily adopted. The concatenation of labels starts from the highest label among tentatively adopted, and concatenates up to the lowest label in the hierarchical order, for example, with a comma (“,”) as a delimiter. However, the upper label is not temporarily adopted at S302, and the item name matches the lowest label. The D end position represents the row position (when D is “up”) or the column position (when D is “left”) of the search position.

  Next, the data item / type determining unit 304 determines whether or not a non-blank cell is adjacent in the D direction of the search position (S303). When a non-blank cell is adjacent in the D direction of the search position (S303: YES), the data item / type determination unit 304 moves the search position in the D direction, and further adds the contents entered in the non-blank cell to the upper level. Temporarily adopted as a label, the lowest label, item name, and D end position are stored in the hierarchical structure determination table 315 (S304).

  On the other hand, when a non-blank cell is not adjacent in the D direction of the search position (S303: NO), the data item / type determination unit 304 determines whether or not the lowest label that has not been subjected to the hierarchical structure determination remains. (S305). If the lowest label that has not been subjected to the determination of the hierarchical structure remains (S305: YES), the data item / type determination unit 304 deletes all provisional adoptions and provisionally adopts the next lowest label, Further, the search position is moved to the position of the lowest label (S306). Then, the process returns to S302.

  On the other hand, when there is no lowermost label that has not been subjected to the determination of the hierarchical structure (S305: NO), the data item / type determination unit 304 searches the hierarchical structure determination table 315 and is common to all the lowest labels. Among the D end positions, the memory at the most D position is adopted for each lowest label (S307), and the hierarchical structure determination process S203 is terminated.

  FIG. 10A is a diagram illustrating a conceptual example of the data item determination process, and FIG. 10B is a diagram illustrating an example of the hierarchical structure determination table 315. Here, FIG. 10A is the spreadsheet 103 read by the program generation system 303, and shows numerical values representing the count result of a series of non-blank cells at the end of the arrow at the end of the row and column of the spreadsheet 103. FIG. 10B is a hierarchical structure determination table 315 generated by the data item determination process for the spreadsheet 103.

  As shown in FIG. 10A, the data item / type determination unit 304 counts the number of consecutive non-blank cells for each row and column in the spreadsheet 103. In this example, since the fourth row “R4” is the row / column with the maximum count, “A”, “B”, “C”, and “D” included in the fourth row “R4” are the lowest labels. Judge that there is.

  In addition, the data item / type determination unit 304 performs a hierarchical structure determination process S203. First, “A”, one of the lowest labels, is temporarily adopted, and the search position is set to the position “A”. Since the row position of “A” is “R4”, “A”, “A”, and “R4” are stored in the hierarchical structure determination table 315 as the lowest label, item name, and upper end position.

  Next, the data item / type determination unit 304 confirms the upward adjacency of the search position “A” and refers to the non-blank cell “E”. Then, the search position is moved to the position of the “E” cell, and “E” is temporarily adopted as the upper label. Further, the data item / type determining unit 304 has “R” as the row position of “E”, and therefore, “A”, “E, A”, “R3” are used as the lowest label, item name, and upper end position. Is stored in the hierarchical structure determination table 315.

  Similarly, the data item / type determination unit 304 confirms the upward adjacency of the search position “E” and refers to the non-blank cell “H”. Then, the data item / type determination unit 304 stores “A”, “H, E, A”, and “R2” in the hierarchical structure determination table 315 as the lowest label, the item name, and the upper end position.

  In the example of the figure, the non-blank cell is not adjacent in the upward direction of the non-blank cell “H”. Therefore, the data item / type determining unit 304 finishes writing the information of the lowest label, the item name, and the upper end position in the hierarchical structure determination table 315 for the lowest label “A”, and deletes all provisional adoptions. The next lowest label, for example, “B” is provisionally adopted, the search position is set to the position “B”, and thereafter, the hierarchical structure determination table 315 for “B” is stored.

  As described above, information is written to the hierarchical structure determination table 315 in the same procedure as “A” for “B”, “C”, and “D”, and the data item / type determination unit 304 is written. Obtains the hierarchical structure determination table 315 shown in FIG. 10B.

  Then, the data item / type determination unit 304 searches the completed hierarchical structure determination table 315 to obtain the upper end position common to all the lowest labels. In this example, “R2”, “R3”, “R4” are stored for the lowest labels “A” and “B”, and the upper end position is stored for the lowest labels “C” and “D”. “R3” and “R4” are stored. That is, the upper end positions common to all the lowest labels are “R3” and “R4”, and among them, the uppermost position is “R3”. Therefore, the memory having the upper end position “R3” in the hierarchical structure determination table 315 is adopted for each lowest label. Therefore, the result of the data item determination processing S102 in this example is “E, A”, “F, B”, “G, C”, “G, D” as data items including the hierarchical structure.

  FIG. 11 is a flowchart showing a processing procedure example 4 of the program generation method in the first embodiment. Specifically, the flowchart shows an example of the data type determination processing S103 performed by the data item / type determination unit 304. is there. At the time of the execution of the data type determination process S103, the data items included in the spreadsheet data have been specified including the hierarchical structure by the data item determination process S102 performed previously. In this case, the data type determination process S103 is a process of determining the value type of the data item using the label / type correspondence list 313 shown in FIG. 12A or the character / type correspondence list 314 shown in FIG. 12B. When the type of the data item cannot be determined using the two lists 313 and 314, a predetermined type (default type, for example, text type) is set.

  In this case, the data item / type determination unit 304 sets, for example, the top record in the hierarchical structure determination table 315 as the first data item, and starts type determination processing on this (S401). The data item / type determining unit 304 compares the lowest label of the data item to be processed with the label / type correspondence list 313 and determines whether the value of the lowest label exists in the label / type correspondence list 313. (S402).

  When the lowest label of the target data item exists in the label / type correspondence list 313 (S402: YES), the data item / type determination unit 304 changes the type of the target data item to the label / type correspondence list 313. The type described in association with the value of the lowest label is determined (S403), and the process proceeds to S406. Note that the data item / type determination unit 304 stores the determined type information in association with the corresponding data item in the hierarchical structure determination table 315 (the same applies hereinafter).

  On the other hand, when the lowest label of the target data item does not exist in the label / type correspondence list 313 (S402: NO), the data item / type determination unit 304 sets the lowest label of the target data item to the character / type. The correspondence list 314 is checked to determine whether the type can be determined (S404). Specifically, the data item / type determination unit 304 determines whether any of the “characters” described in the character / type correspondence list 314 matches the end character of the lowest label.

  If any of the “characters” listed in the character / type correspondence list 314 matches the last character of the lowest label (S404: YES), the data item / type determination unit 304 displays the target data item. The type is determined as the “type” corresponding to the “character” matched in the character / type correspondence list 314 (S403), and the process proceeds to S406. On the other hand, if there is no match (S404: NO), the data item / type determination unit 304 determines the type of the target data item as the default type (S405), and advances the process to S406.

  In step S <b> 406, the data item / type determination unit 304 determines whether or not data items that have not been subjected to the type determination still remain in the hierarchical structure determination table 315. If there is still a data item for which type determination has not yet been performed (S406: YES), the data item / type determination unit 304 proceeds to type determination processing for the next data item (S407), and returns the processing to S401. When type determination is performed on all data items in the hierarchical structure determination table 315 (S406: NO), the data item / type determination unit 304 ends the type determination process S103.

  FIG. 13 is a flowchart showing a processing procedure example 5 of the program generation method in the first embodiment. Specifically, an example of the data item / type confirmation processing S104 performed by the data item / type determination unit 304 is shown. It is a flowchart to show.

  In this case, the data item / type determination unit 304 displays a confirmation screen including the list of data items / types determined by the data item determination processing S102 and the data type determination processing S103 described above via the screen control unit 306. The information is displayed on the device 302 (S501). The confirmation screen includes data included in, for example, the hierarchical structure determination table 315 determined by the data item / type determination unit 304 in the above-described processing S102 and processing S103 with respect to the screen format of the confirmation screen 1400 as illustrated in FIG. The item and its type information are set in a predetermined arrangement to generate screen data (the same applies to other screen data generation). This screen data is output to the display device 302 (or the display device of the client 401; the same applies hereinafter) and becomes a confirmation screen 1400. As a result, the data item / type currently determined by the user such as the aggregation entity can be confirmed.

  Subsequently, the data item / type determination unit 304 receives user operations such as an aggregation subject in the input device 301 on the confirmation screen 1400 described above via the screen control unit 306, deletes the data item (S502), and corrects the data item. (S504), each step is implemented according to the operation content which designates data item addition (S507).

  In this case, the data item / type determination unit 304 executes the data item deletion step according to an operation (S502: YES) in which the delete button 1401 on the confirmation screen 1400 in FIG. 14 is pressed, and is selected on the confirmation screen 1400. The data item, that is, the data item for which the delete button 1401 is pressed is deleted from the hierarchical structure determination table 315 (S503). Based on the hierarchical structure determination table 315, the data item / type determination unit 304 displays a confirmation screen 1410 on which the corresponding data item is reduced as shown in FIG. 15 on the display device 302 (S501).

  Further, the data item / type determination unit 304 executes the data item correction step according to an operation (S504: YES) in which the correction button 1402 on the confirmation screen 1400 in FIG. 14 is pressed, and the data selected on the confirmation screen 1400. The process of correcting the item, that is, the data item for which the correction button 1402 is pressed is started. In this case, the data item / type determination unit 304 displays a correction screen 1600 for the lowest label and type as shown in FIG. 16A on the display device 302 (S505).

  In the correction screen 1600, in the initial state, the lowest label and type of the data item selected by the user as the correction target on the confirmation screen 1400 are displayed, and they can be corrected by operating the input device 301. Yes. In this correction screen 1600, the data item / type determination unit 304 further displays an upper label correction screen 1610 as shown in FIG. 16B by accepting the correction operation of the lowest label and the type and the pressing operation of the determination button 1601. The information is displayed on the display device 302 (S506).

  On the upper label correction screen 1610, in the initial state, the upper label of the data item selected as the correction target on the above-described correction screen 1600 is displayed and can be corrected by the operation of the input device 301. In the upper label correction screen 1610, by accepting the correction operation of the upper label and the pressing operation of the determination button 1602, the data item / type determination unit 304 executes correction of the corresponding data item in the hierarchical structure determination table 315, A list of data items / types reflecting the corrected data items is displayed on the display device 302 via the screen control unit 306 (S501).

  Further, the data item / type determining unit 304 executes the data item addition step according to an operation (S507: YES) in which the add button 1403 on the confirmation screen 1400 in FIG. 14 is pressed, and the lowest order as shown in FIG. 17A. A label / type addition screen 1700 is displayed on the display device 302 (S508). In this lowest level label and type addition screen 1700, a new lowest level label and type can be input by operating the input device 301. In this lowest label / type addition screen 1700, by accepting the input operation of the lowest label and type and the pressing operation of the decision button 1701, the data item / type determination unit 304 further displays the upper label as shown in FIG. 17B. An additional screen 1710 is displayed on the display device 302 (S509). In the upper label addition screen 1700, a new upper label of the corresponding data item can be input by operating the input device 301. In this upper label addition screen 1710, the data item / type determination unit 304 executes the addition of the data item in the hierarchical structure determination table 315 by receiving the input operation of the upper label and the pressing operation of the determination button 1702. A list of data items / types reflecting the data items is displayed on the display device 302 via the screen control unit 306 (S501).

  Further, the data item / type determination unit 304 displays the data item associated with the hierarchical structure determination table 315 and the data type information in the data item / type table 308 in accordance with an operation of pressing the determination button 1404 in FIG. Store (S510) and end the data item / type confirmation processing S104.

  FIG. 18 is a flowchart illustrating a processing procedure example 6 of the program generation method according to the first embodiment, and specifically, a flowchart illustrating an example of the code generation processing S105 performed by the code generation unit 305.

  In this case, the code generation unit 305 first reads each data item stored in the above-described data item / type table 308 and information on its type, and stores a database for storing user input data for the corresponding data item as a storage unit 307. (S601). For example, the code generation unit 305 stores a table in which a column that represents a data item and a column that stores user input data related to the corresponding data item (a value in the column is a type of the corresponding data item) in the database. A command statement (such as an SQL statement) for creation is generated and executed by the database. In order to generate such a statement, the code generation unit 305 holds a template of a code corresponding to a creation instruction of a relational database having a predetermined structure, and the above-described data items and types are stored at predetermined positions in the template. Information is set and a statement is generated.

  Next, the code generation unit 305 generates a database access program for accessing the database constructed as described above based on the data item read from the data item / type table 308 and its type (S602). In this case, the code generation unit 305, for example, a code that receives input data corresponding to a data item from a request processing program (described later), a code that generates a command statement for registering the input data in the database, and a command statement in the database. A code that is executed and returns the execution result to the request processing program is generated as a database access program. In any case, in order to generate such a program, the code generation unit 305 holds a program template having a predetermined structure, and sets the above-described data item and type information at a predetermined location in the template. And generate a program.

  Next, the code generation unit 305 receives a request processing program for receiving input data from the web browser and returning a response to the web browser based on the data item read from the data item / type table 308 and its type. Generate (S603). For example, the code generation unit 305 receives a code for receiving input data from a web browser, a code for starting a database access program and delivering input data to execute processing, and a result of executing the database access program, and returns it to the web browser Is generated as a request processing program. Also in this case, the code generation unit 305 holds a code template having a predetermined structure in order to generate such a code, and sets the above-described data item and type information at a predetermined position in the template, Generate the above code.

  Then, the code generation unit 305 executes screen code generation program generation processing (S604). In the screen code generation program generation processing S604, a screen code generation program for controlling the display and operation of the web browser screen is generated based on the data items read from the data item / type table 308 and their types. For example, the code generation unit 305 generates a screen code generation program according to the flowchart shown in FIG. Details of this processing will be described later.

  Finally, the code generation unit 305 stores the code generated in the above steps in the storage unit 307 (S605), and ends the code generation processing S105.

  FIG. 19 is a flowchart showing a processing procedure example 7 of the program generation method according to the first embodiment. Specifically, the flowchart shows an example of the screen code generation program generation processing S604 performed by the code generation unit 305. is there. This process is, for example, a process for generating a code for generating the web browser screen 203 of FIG.

  First, the code generation unit 305 generates a file to be a screen code generation program (S701). In this state, the screen code generation program has only a function for generating a screen code representing a blank screen.

  Next, the code generation unit 305 generates a code for displaying on the screen the data item name of the data item that has been processed up to step S603 described above and the data input area corresponding to the data item. (S702). Further, the code generation unit 305 generates a code for displaying “Register” and “Cancel” buttons on the screen, and adds the code to the file (S703). Any screen display code can be generated by setting various information related to the above-described data items in a code template stored in advance by the code generation unit 305. By such processing, screen data having an appearance like the web browser screen 203 of FIG. 2 is generated.

  Then, the code generation unit 305 generates a code for transmitting the information input to the data input area when the “Register” button is pressed on the screen to the request processing program, and adds the code to the above-described file (S704). The code generation unit 305 further generates a code for closing the screen when the “stop” button is pressed, and adds the code to the above-described file (S705). Thereby, a function corresponding to each button (“Register” and “Cancel” buttons) on the web browser screen 203 of FIG. 2 is added. Thus, the above-described file, that is, the screen code generation program is generated.

--- Second Embodiment ---
Next, a second embodiment will be described. In this embodiment, in the above-described data item determination processing S102, an example in which the lowest label alignment direction determination for determining the alignment direction of the lowest label and the specific direction lowest label determination for determining the lowest label are performed. State. In these determinations, a predetermined condition is evaluated for the number of consecutive non-blank cells for each row and column of the spreadsheet 103, and the data item / type determination unit 304 determines the determination target according to the evaluation result. Whether to make a determination as it is, or to display a candidate for determination on the display device 302 via the screen control unit 306, accept the operation content of a user such as an aggregation entity for the input device 301, and determine whether to determine according to the operation decide.

  Here, a series of information about a certain determination is displayed on the display device 302 via the screen control unit 306, the operation content of the user such as the aggregation subject with respect to the input device 301 is received, and the determination is performed according to the operation. This process is called “dialog”.

  FIG. 20 is a flowchart illustrating a processing procedure example 1 of the program generation method according to the second embodiment. Specifically, the flowchart illustrates an example of the data item determination process S102 performed by the data item / type determination unit 304. It is.

  In this case, the data item / type determining unit 304 reads the spreadsheet 103 and counts the number of consecutive non-blank cells for each row or column as in the first embodiment (S801).

Next, the data item / type determination unit 304 performs the lowest label arrangement direction determination (S802). In the lowest label arrangement direction determination step S802, the data item / type determination unit 304 sets M to be the smallest count and m to the other of the maximum count row and the maximum count column (the maximum count row and the maximum count row and When there are a plurality of columns, either the row or the column with the maximum count may be M or m), and a parameter K is used to evaluate a condition represented by the following formula (hereinafter, condition K).
N (M) <N (m) × K −−− (Formula 1)

  Here, the parameter K is a predetermined real number greater than 1. When the condition K shown in Expression 1 is satisfied, the data item / type determination unit 304 determines that “conversation” with the user regarding the arrangement direction is “necessary” (S803: YES). On the other hand, when the above-mentioned condition K is not satisfied, the data item / type determination unit 304 makes the arrangement direction dialogue “unnecessary” (S803: NO).

  When the arrangement direction dialogue is “necessary” (S803: YES), the data item / type determination unit 304 passes information to the display device 302 and the input device 301 via the screen control unit 306, and displays the screen as shown in FIG. 21B. A dialog with the user for the alignment direction is performed by 2100 (S804).

  In the arrangement direction dialogue on the screen 2100, the data item / type determination unit 304 selects the arrangement direction (row or column) of the lowest label according to the operation content of the user such as the aggregation subject with respect to the input device 301, or the data Accepts selection of execution of item manual selection.

  Here, the data item / type determining unit 304 determines whether or not the manual selection of the data item is selected by the user in the arrangement direction dialogue via the screen 2100 (S805).

  On the other hand, when the arrangement direction dialogue is “unnecessary” (S803: NO), the data item / type determination unit 304 determines the lowest label arrangement direction to be the above-described “M” direction (S806). That is, when “M” is any row, the arrangement direction of the lowest label is the row direction, and when “M” is any column, the arrangement direction of the lowest label is the column direction. Then, the process proceeds to S807.

When the arrangement direction of the lowest label is determined in S806 or is determined by selection by the arrangement direction dialogue (S805: NO), the data item / type determination unit 304 next performs the lowest label determination in a specific direction ( S807). In this specific direction lowest label determination S807, the data item / type determination unit 304 sorts rows or columns based on the count. When the determined lowest label arrangement direction is the row direction, the data item / type determination unit 304 sorts the rows in the descending order of counts, and the rows with the same count so that the lower row comes first. When the determined lowest label arrangement direction is the column direction, the data item / type determining unit 304 sorts the columns in the descending order of the counts, and the columns with the same count so that the right column comes first. The data item / type determining unit 304 sets the first and second elements (rows or columns) in the sort order described above as “S1” and “S2”, uses the parameter “L”, and expresses the following formula: To be evaluated (hereinafter, condition L).
N (S1) <N (S2) × L ---- (Formula 2)

  Here, the parameter L is a predetermined real number larger than 1. When the condition L indicated by Equation 2 is satisfied, the data item / type determination unit 304 determines that the data item dialogue is “necessary” (S808: YES). On the other hand, when the condition L shown in Expression 2 is not satisfied, the data item / type determination unit 304 determines that the data item dialogue is “unnecessary” (S808: NO).

  Next, when the data item dialogue is “necessary” (S808: YES), or when the data item manual selection is selected in the arrangement direction dialogue (S805: YES), the data item / type determination unit 304 displays the screen control unit. Information is exchanged with the display device 302 and the input device 301 via 306, and a dialog with respect to the data item is performed on the screen as shown in FIG. 22B, FIG. 22C, or FIG.

  In this data item dialogue, the data item / type determining unit 304 acquires the contents of all the non-blank cells included in the spreadsheet 103 and displays them on the display device 302 on a screen 2200 as shown in FIG. 22B. In this screen 2200, the data item / type determination unit 304 accepts the selection operation of the lowest label and the pressing operation of the decision button 2201 by the user, thereby selecting the first higher label for each of the selected lowest labels. A screen 2300 (FIG. 22C) is displayed on the display device 302.

  Then, the data item / type determination unit 304 receives the selection operation of the first upper label and the pressing operation of the determination button 2202 for each lowest label on the screen 2300 described above, and the first upper label is selected. A second upper label selection screen 2400 (FIG. 22D) for each data item is displayed on the display device 302.

  Thereafter, the data item / type determination unit 304 similarly performs screen display and accepting input operations until the upper label selection of all data items becomes “none”. When the selection of the upper label is completed for all data items, the data item / type determination unit 304 determines the data items including the hierarchical structure, and ends the data item determination processing S102.

  On the other hand, when the data item dialogue is “unnecessary” (S808: NO), the data item / type determination unit 304 refers to the maximum continuous non-blank cell included in the above-mentioned “S1”, and sets the entry content at the bottom. As a label (S810), a hierarchical structure determination process is performed (S811). The hierarchical structure determination process S811 in the present embodiment is the same process as the hierarchical structure determination process S203 in the first embodiment. Upon completion of the hierarchical structure determination process S811, the data item / type determination unit 304 determines data items including the hierarchical structure, and ends the data item determination process S102.

  FIG. 21A is a diagram showing a conceptual example of the lowest label alignment direction determination process, specifically, a conceptual diagram showing the data of the spreadsheet 103 read by the data item / type determination unit 304, It is a conceptual diagram explaining an example of label arrangement direction determination S802 and arrangement direction dialogue S804. In this example, the parameter K related to the lowest label arrangement direction determination S802 will be described as “2”. A numerical value representing the count is shown at the end of the arrow at the end of the row and column of the spreadsheet 103.

  In this case, in the lowest label arrangement direction determination S802, of the two rows of the maximum count and the maximum count column, M is the smaller count and the other is m. In this example, M is “R4”. , M becomes “C1” (m is the same as C2).

  If the parameter K is “2”, the left side of the condition K is N (M) = N (R4) = 6, and the right side is N (m) × K = N (C1) × K = 4 × 2 = 8 Therefore, since the condition K (left side) <(right side) is satisfied, the arrangement direction dialogue becomes “necessary”. As described above, the data item / type determination unit 304 performs the arrangement direction dialogue S804 on the screen 2100 as shown in FIG. 21B.

  FIG. 22A is a conceptual diagram illustrating an example of the specific direction lowest label determination S807 and the data item dialog S809 according to the second embodiment of this invention. In this example, the parameter L related to the specific direction lowest label determination S807 will be described as “2”.

  FIG. 22A is a conceptual diagram showing spreadsheet data read by the data item / type determining unit 304. A numerical value representing the count is shown at the end of the arrow at the end of the row and column of the spreadsheet 103. In the spreadsheet 103 of this example, in the lowest label alignment direction determination S802, if K ≦ 4/3, the alignment direction dialog becomes “unnecessary” in the determination of the condition L, and the alignment direction of the lowest label is determined to be the row direction. Also in the case of K> 4/3, it is assumed that the arrangement direction of the lowest label is set to the row direction as a result of the arrangement direction dialogue S804.

  In the specific direction lowest label determination S807, the rows are sorted in the descending order of the counts, and the rows with the same count are sorted so that the lower row comes first. In this example, the sorting result is {R3, R5, R2,. }. Since the first and second rows in the sort order are “S1” and “S2”, respectively, “S1” is “R3” and “S2” is “R5” in this example.

  When the parameter L is “2”, the left side of the condition L is N (S1) = N (R3) = 4, and the right side is N (S2) × L = N (R5) × L = 3 × 2 = 6. Become. Therefore, since the condition L (left side) <(right side) is satisfied, the data item dialogue becomes “necessary”. As described above, the data item / type determining unit 304 performs the data item interaction S809 using the screens as shown in FIGS. 22B, 22C, and 22D.

--- Third Embodiment ---
Next, a third embodiment will be described. In the present embodiment, as in the second embodiment, in the data item determination process S102, two determinations (lowest label arrangement direction determination S802, specific direction lowest label determination S807) and two according to the determination result are performed. Dialogues (alignment direction dialogue S804, data item dialogue S809) are performed. The difference from the second embodiment is the content of the condition L evaluated in the specific direction lowest label determination S807.

  FIG. 23A is a conceptual diagram illustrating an example of specific direction lowest label determination S807 according to the third embodiment of this invention. In the specific direction lowest label determination S807 in this embodiment, the data item / type determination unit 304 sorts the rows or columns based on the count, and the first and second elements in the sort order (lowest label arrangement direction) Is the same as in the second embodiment in that S1 and S2 are the rows when the row direction is the row and the columns when the lowest label arrangement direction is the column direction, respectively.

On the other hand, in the present embodiment, first, the parameter L1 is used to evaluate the condition L1 expressed by the following formula.
N (S1) <N (S2) × L1 --- (Formula 3)

  Here, the parameter L1 is a predetermined real number larger than 1. Further, in this embodiment, the data item / type determining unit 304 determines that the condition L2 is “S2 is not adjacent to S1 from the top” when the lowest label arrangement direction is the row direction, and the lowest label arrangement direction is the column direction. Evaluate that “S2 is not adjacent to S1 from the left”.

  The above-mentioned condition L is set as “condition L1 and condition L2,” and the data item / type determination unit 304 determines whether or not the data item dialogue is necessary. That is, according to whether the conditions L1 and L2 are satisfied or not, the data item / type determining unit 304 determines whether or not the data item interaction is necessary as shown in the table of FIG. 23A.

  FIG. 23B is a conceptual diagram illustrating data of the spreadsheet 103 read by the data item / type determining unit 304 according to the third embodiment of this invention. A numerical value representing the count is shown at the end of the arrow at the end of the row and column of the spreadsheet 103. In this example, the parameter L1 related to the specific direction lowest label determination S807 will be described as “2”.

  In the spreadsheet 103 of this example, in the lowest label arrangement direction determination S802, if K ≦ 5/2, the arrangement direction dialog becomes “unnecessary” in the determination of the condition K, and the arrangement direction of the lowest label is determined as the row direction. Also in the case of K> 5/2, it is assumed that the arrangement direction of the lowest label is set to the row direction as a result of the arrangement direction dialogue S804.

  In the specific direction lowest label determination S807, the rows are sorted in the descending order of counts, and the rows with the same count are sorted so that the lower row comes first. In this example, the sorting result is {R3, R2, R5,. }. Since the first and second rows in the sort order are S1 and S2, respectively, S1 is R3 and S2 is R2 in this example.

  When the parameter L1 is 2, the left side of the condition L1 is N (S1) = N (R3) = 5, and the right side is N (S2) × L1 = N (R2) × L1 = 3 × 2 = 6. Therefore, (left side) <(right side) of the condition L1 is satisfied.

  However, the condition L2 “S2 is not adjacent to S1 from above” is not satisfied because R2 that is S2 is adjacent to R3 that is S1. Accordingly, the data item dialog “unnecessary” is obtained from the table of FIG. 23A, and the entry contents of the maximum continuous non-blank cell included in R3, that is, “A”, “B”, “C”, “D”, “ Let “E” be the lowest label.

  This embodiment is characterized by the condition L2, which is set in view of the fact that the number of first upper labels may be as large as the number of the lowest labels in the condition of the specific direction lowest label determination S807. Have. By setting the condition L2, it is possible to suppress unnecessary occurrence of data item dialogue performed by a user such as an aggregation entity via the screen control unit 306.

--- Fourth Embodiment ---
Next, a fourth embodiment will be described. In this embodiment, in the data type determination process S103, the type corresponding to the data item cannot be determined using the label / type correspondence list 313 shown in FIG. 12A or the character / type correspondence list 314 shown in FIG. 12B. In this case, as in the first embodiment, the data type is determined by performing a type dialogue instead of determining a predetermined default type.

  FIG. 24 is a flowchart showing a processing procedure example 1 of the program generation method in the fourth embodiment, and specifically, a flowchart showing an example of the data type determination processing S103 performed by the data item / type determination unit 304. It is. In this case, it is determined whether or not the lowest label is listed in the label / type correspondence list 313 (S902), and whether or not the type can be determined based on the lowest label and the character / type correspondence list 314 (S904). About this, this embodiment is the same as that of 1st Embodiment.

  In the present embodiment, the data item / type determination unit 304 performs S905 instead of S405 of the data type determination processing S103 of the first embodiment. S905 is a step executed when the type cannot be determined by the two lists, and the data item / type determination unit 304 registers the data item to be determined in the type indefinite data item list.

  The data item / type determination unit 304 determines the data type for all data items or registers the data item / type determination unit 304 in the undefined data item list (NO in S906). It is determined whether there is a data item registered in the data item list (S908).

  When there is a data item registered in the undefined type data item list (S908: YES), the data item / type determination unit 304 passes information to the display device 302 and the input device 301 via the screen control unit 306, and the data item / type determination unit 304 in FIG. A dialogue (type dialogue) is performed with respect to the type of the undefined data item by using the screen 2500 (S909). In the type dialogue, the data item / type determining unit 304 accepts the selection of the type of the data item registered in the type-indefinite data item list according to the operation content of the user such as the aggregation subject with respect to the input device 301. Then, the data item / type determination unit 304 adds the correspondence between the lowest label of the received data item and the type to the label / type correspondence list 313 (S910), and ends the type determination process S103. On the other hand, when there is no data item registered in the undefined data item list (S908: NO), the data item / type determination unit 304 ends the type determination process S103.

  Although the best mode for carrying out the present invention has been specifically described above, the present invention is not limited to this, and various modifications can be made without departing from the scope of the invention.

  According to the present embodiment, it is possible to effectively suppress the amount of user work and efficiently generate the code of the web application program when the work using the spreadsheet is transferred to the web application.

  At least the following will be clarified by the description of the present specification. That is, in the program generation system of the present embodiment, in the first process, the calculation unit is a data item determination process that determines the arrangement of the data items from the spreadsheet data, and data that determines the data type of the value of the data item The data item determination process is defined by the relationship between one or a plurality of data items and an upper data item adjacent to and including the data item determination process based on the arrangement of the data items. Hierarchical structure determination processing that identifies the hierarchical structure between data items, and the data item group positioned at the bottom of the hierarchical structure, assuming that the number of consecutive cells in the hierarchy and the position in the hierarchical structure satisfy a predetermined condition And a lowest label determination process for determining and identifying the corresponding data item group as the lowest label.

  In the program generation system of the present embodiment, in the lowest label determination process, the calculation unit counts the maximum number of consecutive non-blank cells in each row or each column of spreadsheet data. Identify the row or column with the highest count among all the rows and columns contained in the spreadsheet data, and fill in the most consecutive non-blank cell entry in the identified row or column It may be determined as a label.

  In the program generation system according to the present embodiment, in the hierarchical structure determination process, when the arrangement direction of the lowest label is the row direction, the arithmetic unit determines the corresponding lowest order on the spreadsheet data for each of the lowest labels. When a cell adjacent to the label cell is referred to in the upward direction and the adjacent cell is not a blank cell, the entry content of the adjacent cell is provisionally determined to be an upper layer label, and the lowest label and the temporary layer It repeats storing the item name generated by concatenating the label information in the hierarchical order and the row position of the adjacent cell in the hierarchical structure determination table of the storage unit, and all the lowest labels are stored in the hierarchical structure determination table. After storing the item name and line position, the item name corresponding to the top line position among the line positions common to all the lowest labels in the hierarchical structure judgment table is displayed. And the item name is stored in the storage unit as hierarchical structure information for each lowest label, and when the arrangement direction of the lowest label is the column direction, for each of the lowest labels on the spreadsheet data, Referring to a cell adjacent to the left from the cell of the lowest label, if the adjacent cell is not a blank cell, the entry content of the adjacent cell is provisionally determined to be a higher-level label, and the lowest label is temporarily determined Repeatedly stores the item names generated by concatenating the information of the higher-level labels in the hierarchical order and the column positions of adjacent cells in the hierarchical structure determination table of the storage unit, and determines the hierarchical structure for all the lowest labels. After storing the item names and column positions in the table, specify the item name corresponding to the leftmost column position among the column positions common to all the lowest labels in the hierarchical structure determination table. It is intended to be stored in the storage unit an item name for each minimum label as information of the hierarchical structure or a.

  In the program generation system of the present embodiment, the storage unit includes a label / type correspondence list describing the correspondence between the value of the lowest label and the data type, and the correspondence between the last character of the lowest label and the data type. In the data type determination process, the calculation unit sets the value of the lowest label in the hierarchical structure to which the data item belongs to the label / type in the data type determination process. If the data type corresponding to the value of the lowest label could be identified by checking the correspondence list, the data type was determined to be the data type of the data item, and the data type corresponding to the value of the lowest label could not be specified. If the data type corresponding to the last character of the lowest label can be identified by matching one or more characters at the end of the character string constituting the lowest label against the character / type correspondence list If the corresponding data type is determined as the data type of the data item and the data type corresponding to the last character of the lowest label cannot be specified, the default data type is determined as the data type of the data item. Good.

  In the program generation system of the present embodiment, in the lowest label determination process, the arithmetic unit uses the maximum value of the number of consecutive non-blank cells in each row or each column of the spreadsheet data as the count of that row or column. Identify and compare the count of the row with the highest count among all the rows in the spreadsheet data with the count of the column with the highest count among all the columns in the spreadsheet data, If the non-small count is smaller than the value obtained by multiplying the other count by the first real constant having a value greater than 1, a confirmation request regarding the arrangement direction of the lowest label is output to the input / output unit. User input in response to a request is accepted by the input / output unit, and the direction of the lowest label is specified according to the user input. Is not less than the other count multiplied by the first real constant with a value greater than 1, the count of the row with the largest count among all the rows in the spreadsheet data and the spread The lowest label arrangement direction determination process is executed for determining the direction in which the smallest count of all the columns included in the sheet data is counted as the lowest label arrangement direction. It is good.

  Further, in the program generation system of the present embodiment, the calculation unit executes the lowest label arrangement direction determination process and the specific direction lowest label determination process in the lowest label determination process, and the lowest direction in the specific direction. In the label determination process, regarding the lowest label arrangement direction determined in the lowest label arrangement direction determination process, when the direction is the row direction, all the rows included in the spreadsheet data are sorted in descending order of count or If the same row is sorted so that the lower row is first, and the direction is the column direction, all the columns included in the spreadsheet data are sorted in descending order of the count, or for the column with the same count, the right column Sorting so that the column is first, the count of the first element of the sort result is 1 to the count of the second element of the sort result If the value is smaller than the value multiplied by the second real constant with a larger value, the contents of all non-blank cells included in the spreadsheet data are input to the input / output section as candidates for the lowest label and the higher-order label. The input / output unit receives the information on the lowest label and the higher hierarchy label specified by the user from among the candidates, identifies the lowest label and the higher hierarchy label based on the received information, and outputs the first sort result If the count of the element of is not less than the count of the second element of the sort result multiplied by the second real constant having a value greater than 1, the most consecutive element included in the first element of the sort result The entry content of the non-blank cell may be determined as the lowest label.

  In the program generation system of the present embodiment, the storage unit includes a label / type correspondence list describing the correspondence between the value of the lowest label and the data type, and the correspondence between the last character of the lowest label and the data type. In the data type determination process, the calculation unit sets the value of the lowest label in the hierarchical structure to which the data item belongs to the label / type in the data type determination process. If the data type corresponding to the value of the lowest label could be identified by checking the correspondence list, the data type was determined to be the data type of the data item, and the data type corresponding to the value of the lowest label could not be specified. If the data type corresponding to the last character of the lowest label can be identified by matching one or more characters at the end of the character string constituting the lowest label against the character / type correspondence list If the data type is determined to be the data type of the data item and the data type corresponding to the last character of the lowest label cannot be specified, information on the data item and the data type candidate of the data item is output to the input / output unit. The information of the data type designated by the user from among the candidates may be received by the input / output unit, and the corresponding data type may be determined as the data type of the data item based on the received information.

  In the program generation system according to the present embodiment, in the specific direction lowest label determination process, the calculation unit sets the count of the first element of the sort result to a value greater than 1 for the count of the second element of the sort result. If the value is smaller than the value multiplied by the second real constant, and if the label direction is the row direction and the second row of the sorting result is adjacent to the first row of the sorting result from above In the case where the arrangement direction of the lowest label is the column direction, and the second column of the sorting result is adjacent to the first column of the sorting result from the left, it is the most consecutive in the first element of the sorting result. The entry content of the non-blank cell may be determined as the lowest label.

103 Spreadsheet 104 Data file (Spreadsheet data)
150 Database 301 Input Device 302 Output Device 303 Program Generation System 304 Data Item / Type Determination Unit 305 Code Generation Unit 306 Screen Control Unit 307 Storage Unit 308 Data Item / Type Table (Table)
309 Request processing program code 310 Database access program code 311 Screen code generation program code 312 Database 313 Label / type correspondence list 314 Character / type correspondence list 315 Hierarchical structure determination table 401 Client 403 Web browser 402 Server 405 Request processing program 406 Database access program 407 Screen code generation program 408 Database 502 CPU (calculation unit)
503 RAM
504 ROM
505 HDD (storage unit)
506 Communication I / F
507 Input / output c (input / output unit)
508 Media communication I / F

Claims (10)

An input / output unit responsible for data input / output with external devices;
A storage unit storing spreadsheet data;
Search for data items that are non-blank cells in the spreadsheet data, determine the data item arrangement and the data type of each data item value, and store the data item arrangement and data type information in a table in the storage unit A first process to store;
In the determination, a second process for outputting a determination result confirmation screen to the input / output unit, receiving a user confirmation result for the determination result via the input / output unit, and updating the table with the confirmation result;
Read data item arrangement and data type information from the table, set the data item and its data type information in a program stored in advance in the storage unit, and accept input in the data type for the data item An arithmetic unit that executes a third process for generating a screen code generation program that displays an input screen on a web browser and transmits input data in the web browser to the server;
A program generation system comprising: The computing unit is
In the first process, a data item determination process for determining an arrangement of the data item from the spreadsheet data and a data type determination process for determining a data type of the value of the data item are executed.
The data item determination process includes:
A hierarchical structure determination process for specifying a hierarchical structure between data items defined by the relationship between one or more data items and an upper data item adjacent to and including the data items based on the arrangement of each data item;
The data item group positioned at the lowest position in the hierarchical structure is determined as the number of consecutive cells and the position in the hierarchical structure satisfying a predetermined condition, and the corresponding data item group is specified as the lowest label. Including the lowest label determination process,
The program generation system according to claim 1. The computing unit is
In the lowest label determination process,
In each row or column of the spreadsheet data, the maximum value of the number of consecutive non-blank cells is specified as a count of the row or column, and among all the rows and columns included in the spreadsheet data, The row or column having the maximum count is specified, and the entry content of the most continuous non-blank cell in the specified row or column is determined as the lowest label.
The program generation system according to claim 2. The computing unit is
In the hierarchical structure determination process,
When the arrangement direction of the lowest label is a row direction, for each of the lowest labels, on the spreadsheet data, refer to a cell adjacent upward from the cell of the lowest label, and the adjacent cell is If it is not a blank cell, the entry content of the adjacent cell is provisionally determined as an upper layer label, and the item name generated by concatenating the information of the lowermost label and the label of the upper layer determined at the temporary determination in hierarchical order, and the adjacent Repeatedly storing the row position of the cell in the hierarchical structure determination table of the storage unit;
For all of the lowest labels, after the storage of the item names and row positions in the hierarchical structure determination table is completed, in the hierarchical structure determination table, the highest of the row positions common to all the lowest labels. The item name corresponding to the line position of the item is identified, and the item name is stored in the storage unit as hierarchical structure information for each lowest label,
When the arrangement direction of the lowest label is a column direction, for each of the lowest labels, on the spreadsheet data, a cell adjacent to the left from the cell of the lowest label is referred to, and the adjacent cell Is not a blank cell, the entry content of the adjacent cell is tentatively determined as an upper layer label, and the item name generated by concatenating the lowest label and the information of the tentatively determined upper layer label in hierarchical order, and Repeatedly storing the column position of the adjacent cell in the hierarchical structure determination table of the storage unit;
After the storage of the item name and column position in the hierarchical structure determination table for all the lowest labels, the leftmost column position common to all the lowest labels in the hierarchical structure determination table The item name corresponding to the column position is specified, and the item name is stored in the storage unit as hierarchical structure information for each lowest label.
The program generation system according to claim 2. The storage unit
A label / type correspondence list describing the correspondence between the value of the lowest label and the data type;
Storing a character / type correspondence list describing the correspondence between the last character of the lowest label and the data type;
The computing unit is
In the data type determination process,
For each of the data items, when the value of the lowest label in the hierarchical structure to which the corresponding data item belongs is collated with the label / type correspondence list, and the data type corresponding to the value of the lowest label can be identified, If the data type is determined to be the data type of the data item and the data type corresponding to the value of the lowest label cannot be specified, one or more characters at the end of the character string constituting the lowest label Is matched with the character / type correspondence list, and if the data type corresponding to the last character of the lowest label is identified, the corresponding data type is determined as the data type of the data item, and the end of the lowest label is determined. When the data type corresponding to the character cannot be specified, the default data type is determined as the data type of the data item.
The program generation system according to claim 2. The computing unit is
In the lowest label determination process,
In each row or column of the spreadsheet data, the maximum value of the number of consecutive non-blank cells is specified as the count of the row or column, and the count is the largest among all the rows included in the spreadsheet data. First, the row count is compared with the count of the column having the maximum count among all the columns included in the spreadsheet data, and the count that is not less than the first count has a value greater than 1 in the other count. If the value is smaller than the value multiplied by the real constant, a confirmation request regarding the arrangement direction of the lowest label is output to the input / output unit, the user input corresponding to the confirmation request is received by the input / output unit, and the user input The direction of the lowest label is specified according to the above, and the non-small count is multiplied by a first real constant having a value greater than 1 for the other count. If not less than the value, the count of the row with the highest count among all the rows included in the spreadsheet data and the count of the column with the highest count among all the columns included in the spreadsheet data Among these, the direction which is not smaller is determined as the arrangement direction of the lowest label, and the lowest label arrangement direction determination process is executed.
The program generation system according to claim 2. The computing unit is
In the lowest label determination process, the lowest label arrangement direction determination process and the specific direction lowest label determination process are executed.
The specific direction lowest label determination process includes:
Regarding the lowest label arrangement direction determined in the lowest label arrangement direction determination process,
When the direction is a row direction, all the rows included in the spreadsheet data are sorted in descending order of counts, or for the rows with the same count, the lower row is sorted first, and the direction is the column direction. , Sort all the columns in the spreadsheet data in descending order of count, or for the columns with the same count so that the right column is first,
If the count of the first element of the sort result is smaller than the count of the second element of the sort result multiplied by a second real constant having a value greater than 1, it is included in the spreadsheet data The input contents of all non-blank cells are output to the input / output unit as candidates for the lowest label and the upper layer label, and information on the lowest label and the upper layer label specified by the user from among the candidates is input. Accept at the output unit, specify the lowest label and the upper layer label by the received information,
If the count of the first element of the sort result is not less than the count of the second element of the sort result multiplied by a second real constant having a value greater than 1, the first of the sort result The content of the most continuous non-blank cell included in the element is determined as the lowest label,
The program generation system according to claim 6. The storage unit
A label / type correspondence list describing the correspondence between the value of the lowest label and the data type;
Storing a character / type correspondence list describing the correspondence between the last character of the lowest label and the data type;
The computing unit is
In the data type determination process,
For each of the data items, when the value of the lowest label in the hierarchical structure to which the corresponding data item belongs is collated with the label / type correspondence list, and the data type corresponding to the value of the lowest label can be identified, If the data type is determined to be the data type of the data item and the data type corresponding to the value of the lowest label cannot be specified, one or more characters at the end of the character string constituting the lowest label Is matched with the character / type correspondence list, and if the data type corresponding to the last character of the lowest label is identified, the corresponding data type is determined as the data type of the data item, and the end of the lowest label is determined. When the data type corresponding to the character could not be specified, the information on the data item and the data type candidate of the data item is output to the input / output unit and specified by the user from among the candidates Received in data type information the input-output unit, by the received information is intended to determine the appropriate data types and data types of the data items,
The program generation system according to claim 2. The computing unit is
In the specific direction lowest label determination process,
When the count of the first element of the sorting result is smaller than a value obtained by multiplying the count of the second element of the sorting result by a second real constant having a value greater than 1.
When the arrangement direction of the lowest label is a row direction and the second row of the sorting result is adjacent to the first row of the sorting result from above, or the arrangement direction of the lowest label is a column direction In the case where the second column of the sort result is adjacent to the first column of the sort result from the left, the entry content of the most continuous non-blank cell included in the first element of the sort result is It is determined as the lowest label.
The program generation system according to claim 7. A computer including an input / output unit that handles data input / output with an external device, and a storage unit that stores spreadsheet data,
Search for data items that are non-blank cells in the spreadsheet data, determine the data item arrangement and the data type of each data item value, and store the data item arrangement and data type information in a table in the storage unit A first process to store;
In the determination, a second process for outputting a determination result confirmation screen to the input / output unit, receiving a user confirmation result for the determination result in the input / output unit, and updating the table with the confirmation result;
Read data item arrangement and data type information from the table, set the data item and its data type information in a program stored in advance in the storage unit, and accept input in the data type for the data item A third process for generating a screen code generation program for displaying an input screen on a web browser and transmitting input data in the web browser to a server;
The program generation method characterized by performing.

Images