Program, information processing method, and information processing apparatus

Abstract

This provides programs and other tools that enhance the convenience of processing using tabular data and layouts that define the relationships between each cell in that tabular data. [Solution] The program, relating to one aspect, displays a file list which is a folder or file search result, accepts the selection of a tabular file from the file list which contains tabular data associated with a layout that defines the relationships between multiple cells, generates an integrated table by combining multiple layout-defined data which are included in the tabular data and are defined as being the target of the layout, and causes the computer to perform the process of saving the folder path of the folder or the search conditions of the file search result in association with the generated integrated table.

Description

Technical Field

[0001] The present invention relates to a program, an information processing method, and an information processing apparatus.

Background Art

[0002] Patent Document 1 discloses an apparatus for converting data in a spreadsheet format into data in a semi-structured data format.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] Data users such as data scientists often require data creators such as researchers who input experimental data and the like to input data in a predetermined tabular data format in order to efficiently use data such as experimental data. However, data creators may sometimes use a tabular data format with some modifications according to the type and number of experiments. In such cases, it has been difficult to efficiently use the data.

[0005] In one aspect, there is provided a program or the like that further enhances the convenience of a process using a layout that defines the relationship between tabular data and each cell of the tabular data.

Means for Solving the Problems

[0006] The program in the first aspect displays a file list which is a folder or file search result, accepts the selection of a tabular file from the file list which contains tabular data associated with a layout that defines the relationships between multiple cells, generates an integrated table by combining multiple layout-defined data which are included in the tabular data and defined as being subject to the layout, and causes the computer to perform the process of saving the folder path of the folder or the search conditions of the file search result in association with the generated integrated table. One aspect of this disclosure makes it possible to further enhance the convenience of processing that uses tabular data and a layout that defines the relationships between each cell of the tabular data.

[0007] The program from the second perspective is the program from the first perspective which generates the integrated table based on a header selected from a list of header candidates created from the multiple layout-defined data.

[0008] The program of the third perspective is a program of the first or second perspective that, on the integrated table display screen where the integrated table has been output, obtains the folder path associated with the integrated table and displays the output file list, which is a list of files in the folder indicated by the folder path.

[0009] The program of the fourth perspective is a program of any one of the first to third perspectives, which, on the integrated table display screen where the integrated table has been output, retrieves the search conditions associated with the integrated table and displays the output file list, which is a list of files resulting from the search conditions.

[0010] The program according to the fifth perspective is the program according to the third or fourth perspective, which displays a button on the integrated table display screen that displays the list of files after output.

[0011] The program of the sixth perspective is a program of the third or fourth perspective that displays a screen in which a previously created header candidate for the integrated table is selected from the list of header candidates for the integrated table, which is displayed based on the tabular file selected from the list of output files.

[0012] The program of the seventh perspective is a program of the third or fourth perspective that, when the integrated table is output based on the folder path associated with the integrated table or the tabular file selected from the list of files displayed based on the search criteria, saves the integrated table in a new version.

[0013] The program of the eighth aspect is an information processing method that displays a list of files which are folder or file search results, accepts the selection of a tabular file from the file list which contains tabular data associated with a layout that defines the relationships between multiple cells, generates an integrated table by combining multiple layout-defined data which are included in the tabular data and are defined as being the target of the layout, and saves the folder path of the folder or the search conditions of the file search results in association with the generated integrated table.

[0014] The program of the ninth aspect is an information processing device comprising a control unit, the control unit displays a file list which is a folder or file search result, accepts the selection of a tabular file from the file list which contains tabular data associated with a layout that defines the relationships between multiple cells, generates an integrated table by combining multiple layout-defined data which are included in the tabular data and are defined as being the target of the layout, and saves the folder path of the folder or the search conditions of the file search result in association with the generated integrated table. [Brief explanation of the drawing]

[0015] [Figure 1] This is an overview diagram of the system relating to one aspect of this disclosure. [Figure 2] It is a block diagram showing a configuration example of a server device. [Figure 3] It is a diagram showing a configuration example of a management file. [Figure 4] It is a block diagram showing a configuration example of a terminal device. [Figure 5] It is an explanatory diagram for explaining a layout. [Figure 6] It is a flowchart showing an example of the processing of a server device. [Figure 7] It is a flowchart showing an example of the processing of a server device. [Figure 8] It is a flowchart showing an example of the processing of a server device. [Figure 9] It is a diagram showing an example of the configuration of a tabular file. [Figure 10] It is a diagram showing an example of a list of header candidates. [Figure 11] It is a diagram showing an example of a list of files after output. [Figure 12] It is an explanatory diagram showing an example of a list of header candidates and an integrated table when the division unit is "sheet". [Figure 13] It is a diagram showing another example of the integrated table displayed when the division unit is "sheet". [Figure 14] It is an explanatory diagram showing an example of a list of header candidates and an integrated table when the division unit is "table". [Figure 15] It is a diagram showing an example of the configuration of a tabular file. [Figure 16] It is an explanatory diagram showing an example of a list of header candidates and an integrated table when the division unit is "file". [Figure 17] It is an explanatory diagram showing an example of a list of header candidates and an integrated table when the division unit is "sheet". [Figure 18] It is an explanatory diagram showing an example of a list of header candidates and an integrated table when the division unit is "table". [Figure 19]This diagram shows an example of the structure of a tabular file. [Figure 20] This is an explanatory diagram showing a list of header candidates and an example of an integrated table when the division unit is set to "file". [Figure 21] This is an explanatory diagram showing a list of header candidates and an example of an integrated table when the division unit is set to "sheet". [Figure 22] This is an explanatory diagram showing a list of header candidates and an example of an integrated table when the partitioning unit is set to "table". [Modes for carrying out the invention]

[0016] The following describes in detail, with reference to drawings, a system that is an example of a program, information processing method, and information processing apparatus relating to one aspect of this disclosure. In the description, similar elements are denoted by the same reference numerals, and redundant explanations are omitted as appropriate.

[0017] Figure 1 is an overview diagram of a system relating to one aspect of this disclosure. The system relating to this form of disclosure includes an information processing device 1 and an information processing terminal 2, which can send and receive information via a network 3 such as the Internet.

[0018] Information Processing Device 1 is an information processing device that processes, stores, and transmits various types of information. Information Processing Device 1 may be configured as, for example, a server, a personal computer, a tablet terminal, or a smartphone. Information Processing Device 1 may be composed of multiple information processing devices, or it may be configured as one of multiple virtual devices (virtual machines) within a single information processing device. In this embodiment of the disclosure, to avoid complexity in the explanation, Information Processing Device 1 will be described as Server Device 1. However, Information Processing Device 1 is not limited to a server device and may be configured as any of the above-described types of information processing devices.

[0019] The information processing terminal 2 can display, download, and edit tabular data files (hereinafter referred to as "tabular files") stored in the server device 1 via the network 3. Here, tabular data or files can be used synonymously with spreadsheet data or files. The information processing terminal 2 can be, for example, a personal computer, smartphone, mobile phone, wearable device, or tablet. In this disclosure, to avoid complexity in explanation, the information processing terminal 2 will be read and described as terminal device 2.

[0020] Figure 2 is a block diagram showing an example configuration of server device 1. Server device 1 can be an information processing device composed mainly of electronic circuits using semiconductor circuit elements. Server device 1 has a control unit 11, a communication unit 12, a reading unit 13, and a storage unit 14. The control unit 11, communication unit 12, reading unit 13, and storage unit 14 are connected to each other via a bus 19 or the like. Note that server device 1 may have other configurations, such as not having a reading unit 13.

[0021] The control unit 11 can be configured to have one or more processing units such as a CPU (Central Processing Unit), MPU (Micro-Processing Unit), GPU (Graphics Processing Unit), FPGA (Field Programmable Gate Array), DSP (Digital Signal Processor), and quantum processor. The control unit 11 reads and executes the program (or program product) 1P stored in the storage unit 14.

[0022] The communication unit 12 is a communication module for performing communication-related processing and can send and receive information with terminal devices 2, etc., via the network 3. The reading unit 13 can read portable storage media 15 such as CD (Compact Disc)-ROM (Read Only Memory), DVD (Digital Versatile Disc)-ROM, and USB (Universal Serial Bus) memory. The control unit 11 may read program 1P from the portable storage media 15 via the reading unit 13 and save it to the storage unit 14. Alternatively, the control unit 11 may download program 1P from another computer via the network 3, etc., and save it to the storage unit 14.

[0023] The storage unit 14 includes volatile storage units such as RAM (Random Access Memory), and non-volatile storage units such as ROM, HDD (Hard Disk Drive), and flash memory. As shown in Figure 2, the storage unit 14 stores, for example, program 1P and tabular linked data 60. Program 1P is a program executed by the control unit 11. In this embodiment, program 1P may also be referred to as program product 1P.

[0024] The tabular linked data 60 consists of a management file 61, a tabular file storage unit 62, a layout file storage unit 63, a table creation setting file storage unit 64, and a file extraction information file storage unit 65. The management file 61 stores which layout files stored in the layout file storage unit 63, which table creation setting files stored in the table creation setting file storage unit 64, and which file extraction information files stored in the file extraction information file storage unit 65 are associated with the tabular files stored in the tabular file storage unit 62.

[0025] The tabular file storage unit 62 stores tabular data files (hereinafter referred to as "tabular files"). The layout file storage unit 63 stores files containing layouts (hereinafter referred to as "layout files"). The table creation setting file storage unit 64 stores table creation setting files (hereinafter referred to as "setting files") containing settings for tabular data. The file extraction information file storage unit 65 stores file extraction information files containing search conditions for a file list (file search results) that includes one or more tabular files to be searched. The layout, settings, and search conditions will be described later.

[0026] Figure 3 shows an example of the structure of the management file 61. As shown in this figure, the management file 61 can be structured in a table format. The management file 61 may be saved as a database table, or as a spreadsheet or text file.

[0027] The management file 61 has columns for identifier, tabular file, layout file, configuration file, and file extraction information file. The identifier column stores a string that identifies the tabular file. The tabular file column stores the location (file path) where the tabular file is stored.

[0028] The "Layout File" column stores the location (file path) of the saved layout file. The "Configuration File" column stores the location (file path) of the saved configuration file. The "File Extraction Information File" column stores the location (file path) of the saved file extraction information file.

[0029] This allows the extraction of a layout file for the layout applied to the saved tabular file, a settings file containing the settings applied to the tabular file, and a file extraction information file containing the folder path of the tabular file or the search conditions used during the search, using an identifier or the storage location (file path) of the tabular file as the key.

[0030] Furthermore, the configuration for linking a tabular file to a corresponding layout or layout file, settings or settings file, or file extraction information file is not limited to this configuration. For example, information linking to a corresponding layout or layout file may be stored within the tabular file, or other configurations can be used, such as indicating that the tabular file and layout file are linked by storing them in the same folder.

[0031] The linking of settings, settings files, or file extraction information files is the same as that of the layout or layout file, so the explanation will be omitted.

[0032] Figure 4 is a block diagram showing an example configuration of terminal device 2. Here, terminal device 2 can be an information processing device composed mainly of electronic circuits using semiconductor circuit elements. Terminal device 2 may have a control unit 21, a communication unit 22, a reading unit 23, a storage unit 24, a display unit 26, and an input unit 27. The components of the control unit 21, communication unit 22, reading unit 23, storage unit 24, display unit 26, and input unit 27 are connected to each other so as to be able to communicate with one another by a bus 29 or the like.

[0033] The control unit 21 can be configured to include one or more processing units such as a CPU, MPU, GPU, FPGA, DSP, and quantum processor. The control unit 21 reads and executes the program stored in the storage unit 24.

[0034] The communication unit 22 is a communication module for performing communication-related processing and can send and receive information with the server device 1, etc., via the network 3. The reading unit 23 can read portable storage media 25 such as CD-ROMs, DVD-ROMs, and USB memory sticks. The control unit 21 can read programs and / or data from the portable storage media 25 via the reading unit 23 and save them to the storage unit 24. The control unit 21 can also download programs from other computers via the network 3, etc., and save them to the storage unit 24.

[0035] The storage unit 24 includes volatile storage devices such as RAM, and non-volatile storage devices such as ROM, HDD, and flash memory. The display unit 26 can be a liquid crystal display or an organic EL (Electro-Luminescence) display, etc. The input unit 27 can be an input device such as a keyboard, mouse, touch panel, and camera.

[0036] Figure 5 is an explanatory diagram illustrating the layout. In Figure 5, tabular data is displayed, along with the layout displayed on top of the tabular data. Tabular data can be stored in or stored in a tabular file. Tabular data consists of columns and rows, and data elements, or cells, are located at the intersections of rows and columns. Cells are identified by sequentially specifying the column, which is identified by an alphabet, and the row, which is identified by a number (for example, "cell A1"). In Figure 5, for example, the string "Experimental Equipment" is stored as the value of cell B3, and the string "Tammann Tube" is stored as the value of cell D3.

[0037] The layout is primarily depicted using thick lines and arrows in Figure 5. In this embodiment, the elements that constitute the layout are called parsing objects. In this embodiment, the parsing objects are the header parser 92, the sequence parser 93, and the table parser 95. However, other parsing objects may also be present. Furthermore, the layout may not include any or all of these parsing objects.

[0038] The heading parser 92 is an arrow extending from the cell indicating the heading to the cell or table parser 95 that contains the heading's content. The heading parser 92 connects two cells, or a cell and a table parser 95. In Figure 5, the heading parser 92 is represented, for example, by a triangular-tipped arrow extending from cell B3 to cell D3. The heading parser 92 may also indicate an inclusion relationship.

[0039] The table parser 95 is a parsing object that specifies a table whose data content is structured in rows and columns. The table parser 95 consists of a whole table section 951 that shows the entire table and a table data section 952 that shows the data portion. In this embodiment, the whole table section 951 that is not included in the table data section 952 is referred to as the header or header area.

[0040] In Figure 5, the entire table portion 951 of the table parser 95 is represented by a rectangle with cells B9 and D13 as its diagonal vertices, while the table data portion 952 is represented by a rectangle with cells C10 through D13 as its diagonal vertices. Here, the upper left and lower right corners of the table data portion 952 are shown as black-filled triangles to distinguish the entire table portion 951 from the table data portion 952.

[0041] The sequence parser 93 is a parsing object that connects cells and represents the order in the direction indicated by the arrows. In Figure 5, for example, the sequence parser 93 is shown for cells C16, C18, and C20 by arrows extending from cell C16 to cell C18 and from cell C18 to cell C20. To distinguish the sequence parser 93 from the header parser 92, in this embodiment, each arrow has a V-shaped tip.

[0042] These parsing objects are included in the layout corresponding to the tabular data and are stored as a layout file in the layout file storage unit 63. The management file 61 can also store the file path of the corresponding layout file in the record of the corresponding tabular file. The layout file may store the layout structure information by converting each parsing object placed in the tabular data into a string or the like. For example, the layout structure information can be stored in the layout file by describing the header parser 92 extending from cell B3 to cell D3 using a predetermined syntax such as "Header:B3:D3".

[0043] Server device 1 may convert tabular data into semi-structured data based on the parsing objects described above. Semi-structured data can be output by applying a layout to tabular data. For example, it can be data written in JSON (JavaScript® Object Notation) format and XML (eXtensible Markup Language) format. Semi-structured data is data that explicitly defines and describes combinations of data names and the content of data related to those names, and can also describe inclusion relationships in a nested format. Furthermore, semi-structured data cannot be managed as a single relational database or tabular data, but can be defined as data that is structured to a certain extent.

[0044] For example, the header parser 92, which extends from cell B3 to cell D3, can be written in JSON format as follows: {"key": "Laboratory equipment", "value": [{"key": "Tammann tube"}]} By performing this conversion to create semi-structured data, it becomes possible to search for and easily extract necessary information from tabular data with different layouts.

[0045] Furthermore, rules for converting parsing objects other than the header parser 92 into semi-structured data can be appropriately defined. The rules for converting to semi-structured data do not have to be rules for converting to JSON format; they may also be rules for converting to XML format or other semi-structured data formats. The parsing objects are not limited to the header parser 92, sequence parser 93, and table parser 95, and can be defined as appropriate, and the rules for converting each parsing object into semi-structured data can be appropriately defined. In this embodiment, even when the conversion of semi-structured data is not described, it is permissible to convert to semi-structured data using tabular data and layouts, or to convert to tabular data and layouts based on semi-structured data, as appropriate.

[0046] Figures 6, 7, and 8 are flowcharts illustrating an example of processing by the server device 1. As shown in these figures, the control unit 11 of the server device 1 outputs a file list (screen 82 or screen 83 in Figure 10), which is a folder or file search result, to the user's terminal device 2 via the communication unit 12 (step S11). The output file list is displayed on the display unit 26 of the terminal device 2. The file list includes one or more tabular files. A tabular file is a file that stores tabular data to which a layout defining the relationships between multiple cells is applied.

[0047] The control unit 11 accepts the user's selection from the output file list of tabular files in which tabular data with a layout defining the relationships between multiple cells is stored (step S12).

[0048] The selection of a tabular file can be done by displaying the folder hierarchy structure on the display unit 26 of the user's terminal device 2, displaying the tabular files within the selected folder, and allowing the user to select a displayed tabular file. Alternatively, tabular files related to keywords may be displayed through a search, and the user can select from among them. The control unit 21 of the terminal device 2 may accept the selection of one or more tabular files simultaneously.

[0049] The control unit 11 extracts the layout-defined data of the selected tabular file (step S13). Here, the layout-defined data refers to tabular data in which the header parser 92, table parser 95, and sequence parser 93 described above are arranged, with the layout file associated with the tabular file applied to the tabular file.

[0050] The control unit 11 outputs a list of header candidates for the integrated table (Figure 10) from the layout-defined data (step S14). The output list of header candidates is displayed on the display unit 26 of the terminal device 2. The list of integrated table header candidates that is displayed will be described later. The control unit 11 can also display the list of header candidates in predetermined division units, or in division units such as the division unit displayed last time. Here, the division unit is one of the following: a sheet containing tabular data, a file having one or more sheets, or a table which is layout-defined data defined as a table within the tabular data. Details of the division unit will be described later.

[0051] The control unit 11 receives requests from the terminal device 2 to edit and select from the displayed list of header candidates via the communication unit 12 (step S15). The control unit 11 receives requests from the terminal device 2 via the communication unit 12 for one of the following: change of division unit, preview, loading of settings, or confirmation of file extraction information (step S16).

[0052] Specifically, the control unit 11 receives a request to change the division unit through the user's selection operation in the data division unit selection area 811 (Figure 10). The control unit 11 receives a request for preview through the user's touch (click) operation of the preview button 815 (Figure 10). The control unit 11 receives a request to load settings through the user's touch operation of the load settings button 816 (Figure 10). The control unit 11 receives a request to confirm file extraction information through the user's touch operation of the file extraction information confirmation button 817 (Figure 10).

[0053] If the control unit 11 receives a request to change the division unit in the processing of step S16 (S16: Change of division unit), it changes the division unit from which the layout-defined data, which is tabular data, is extracted (step S21). Specifically, the control unit 21 of the user's terminal device 2 receives the user's selection of the target division unit via the input unit 27. The control unit 21 transmits the received division unit to the server device 1 via the communication unit 22.

[0054] The control unit 11 extracts layout-defined data for each selected division unit from the tabular file (step S22). The control unit 11 outputs a list of header candidates for the integrated table from the layout-defined data for each division unit (step S23). The output list of header candidates is displayed on the display unit 26 of the terminal device 2. The control unit 11 returns to the process of step S15.

[0055] If the control unit 11 receives a preview request in step S16 (S16: Preview), it generates an integrated table using the header candidates selected by the user (step S31). The control unit 11 displays the generated integrated table in the preview area 813 (Figure 10) on the terminal device 2 (step S32). Alternatively, the control unit 11 may directly display the integrated table after extracting the layout-defined data without displaying a list of header candidates on the terminal device 2.

[0056] The control unit 11 determines, via the terminal device 2, whether an instruction has been given to save the previewed integrated table (step S33). If the control unit 11 determines that saving has not been instructed (NO in step S33), it returns to step S15 and repeats the process.

[0057] If the control unit 11 determines that saving is instructed (YES in step S33), it performs the save process (step S34) and then terminates the process. During the save process, the control unit 11 saves the tabular file, layout file, configuration file, and file extraction information file, and saves the respective file paths in a new record in the management file 61.

[0058] The control unit 11 saves the division unit and header editing operations used when generating the integrated table in a configuration file. Details of the header editing operations will be described later. However, the header editing operations described later are examples and may include any operations on the header and its columns that affect the generation of the integrated table. The control unit 11 saves the folder path of the target folder shown in screen 82 of Figure 10, or the search conditions for the file search results shown in screen 83, in a file extraction information file.

[0059] When the control unit 11 receives a request to load settings in step S16 (S16: Load settings), it retrieves the target settings file that has been saved (step S41). Specifically, when the control unit 21 of the terminal device 2 receives a touch operation on the Load Settings button 816 on the header candidate list screen 81 (Figure 10), it displays a file selection dialog (not shown) for selecting a settings file. The control unit 21 accepts the user's selection of the target settings file through the file selection dialog. The control unit 21 sends information about the selected settings file (file path and file name, etc.) to the server device 1. Based on the information about the settings file sent from the terminal device 2, the control unit 11 of the server device 1 retrieves the corresponding settings file from the table creation settings file storage unit 64 of the storage unit 14.

[0060] The control unit 11 reads the division unit ("file", "sheet", or "table") and header editing operations from the acquired configuration file (step S42). The control unit 11 extracts the layout-defined data for each division unit read from the tabular file (step S43).

[0061] The control unit 11 generates a list screen 81 of header candidates (Figure 10) from the extracted layout-defined data, and then applies the header editing operations read from the configuration file to the generated list screen 81 of header candidates (Figure 10) (step S44). Specifically, as will be described later, in this embodiment, the header editing operations include the selection operation of header candidates and the movement operation of header candidates.

[0062] Based on the selection operation details included in the read header editing operation, the control unit 11 selects checkboxes indicating selected or unselected states in association with the corresponding header candidates and displays them in the header candidate list display area 812. Here, the selected and unselected states of the checkboxes represent the headers to be displayed and the headers not to be displayed in the generated integrated table, respectively (Figure 10). Furthermore, based on the move operation details included in the read header editing operation, the control unit 11 moves the header name and position (display order) of each header candidate and displays them in the header candidate list display area 812.

[0063] The control unit 11 outputs a list of header candidates for the integrated table from the layout-defined data for each division unit (step S45). The output list of header candidates is displayed on the display unit 26 of the terminal device 2. The control unit 11 returns to the process of step S15.

[0064] If the control unit 11 receives a request to confirm file extraction information in step S16 (S16: Confirmation of file extraction information), it retrieves the target file extraction information file from the file extraction information file storage unit 65 of the storage unit 14 (step S51). Specifically, the control unit 11 retrieves the file path and file name of the file extraction information file corresponding to the tabular file from the management file 61 based on the file path and file name of the tabular file. Based on the retrieved file path and file name of the file extraction information file, the control unit 11 retrieves the corresponding file extraction information file from the file extraction information file storage unit 65.

[0065] The control unit 11 reads the acquired file extraction information file (step S52). The file extraction information file stores the extraction type ("folder" or "file search"), the folder path if the extraction type is "folder", or the search conditions if the extraction type is "file search".

[0066] If the extracted type read by the control unit 11 is "folder" (S53: folder), the control unit 11 obtains the folder path associated with the integrated table from the file extraction information file (step S54). The control unit 11 outputs the post-output file list, which is a list of files in the folder indicated by the obtained folder path, to the terminal device 2 via the communication unit 12 (step S55). The display screen of the output post-output file list (first post-output file list area 824 in Figure 11A) is displayed on the display unit 26 of the terminal device 2.

[0067] The control unit 11 determines whether it has received a selection of the target tabular file via the terminal device 2 from the display screen of the output file list (first output file list area 824 in Figure 11A) (step S58). If the control unit 11 has not received a selection of the tabular file (NO in step S58), it returns to the process in step S15. If the control unit 11 has received a selection of the tabular file (YES in step S58), it returns to the process in step S13.

[0068] If the extraction type is "file search" (S53: file search), the control unit 11 obtains the search conditions associated with the integrated table from the file extraction information file (step S56). Details of the search conditions will be described later. The control unit 11 outputs the post-output file list, which is a list of files resulting from the search results based on the obtained search conditions, to the terminal device 2 via the communication unit 12 (step S57). The display screen of the output post-output file list (second post-output file list area 825 in Figure 11B) is displayed on the display unit 26 of the terminal device 2.

[0069] The control unit 11 proceeds to the process in step S58. In this case, the control unit 11 determines whether or not it has received a selection of the target tabular file from the output file list display screen (second output file list area 825 in Figure 11B) via the terminal device 2.

[0070] In this manner, server device 1 outputs a file list, which is a folder or file search result, to terminal device 2 and accepts the selection of a tabular file from the file list. Server device 1 outputs a list of header candidates for an integrated table, which is a combination of multiple layout-defined data extracted for each selected division unit, and accepts header editing operations for the output list of header candidates. When server device 1 generates an integrated table based on the list of header candidates for which header editing operations have been performed, it can save the layout file, configuration file, and file extraction information file in association with the integrated table.

[0071] [1. Example when the number of tabular files is 1] Figure 9 shows an example of the structure of a tabular file 71. The tabular file 71 can be a tabular file stored in the tabular linked data 60, which is selected in step S12 of Figure 6. The tabular file 71 has sheets 711, 712, and 713 that contain tabular data.

[0072] Sheets 711, 712, and 713 are named "Experimental Information," "Experimental Results 1," and "Experimental Results 2," respectively. Sheet 711 contains layout-defined data 7111 defined by a heading parser 92 with "Person in Charge" as the heading and "Tanaka" as the content, and another heading parser 92 with "Sample Name" as the heading and "LaFeAs" as the content. Sheets 712 and 713 contain layout-defined data 7121 and 7131 defined by a table parser 95 with "Sample ID," "Electrical Resistivity (300K)," and "Transition Point" as headers.

[0073] [1.1. Splitting unit: File] Figure 10 shows an example of a list of header candidates. Figure 10 includes screens 82, 83, and 81.

[0074] Screen 82 is a screen that displays a list of files in a folder. That is, Screen 82 is a screen that is displayed in a folder hierarchy structure on the display unit 26 of the user's terminal device 2 and displays a list of files within a folder. Screen 82 includes a folder path input field 821 that accepts input of the folder path.

[0075] Server device 1 outputs a file list, including multiple tabular files within a folder, to terminal device 2 based on the folder path entered (specified) by the user through the folder path input field 821. Terminal device 2 displays the file list output from server device 1 on screen 82.

[0076] Screen 83 is a screen that displays a list of files, which are the search results. In other words, Screen 83 is a screen that displays a list of files that have been searched based on the search conditions, etc., on the display unit 26 of the user's terminal device 2. Screen 83 includes a search condition input field 831 for accepting input of search conditions. The server device 1 searches for tabular files that match the conditions based on the search conditions entered (specified) by the user through the search condition input field 831, using the operating system or a file system provided by program 1P.

[0077] The search criteria include, for example, a search keyword (e.g., "LaFeAs"), file name, extension, modification date, search scope (e.g., entire system, drive, or within a specified folder), or a combination of these. Server device 1 outputs a list of files found using the search criteria to terminal device 2. Terminal device 2 displays the file list output from server device 1 on screen 83.

[0078] Server device 1 accepts the user's selection of a target tabular file from the file list displayed on screen 82 or screen 83. The folder path displayed in folder path input field 821, or the search criteria displayed in search criteria input field 831, are saved in the file extraction information file in association with the tabular file when the integrated table tabular file is saved.

[0079] Screen 81 is the screen displayed on the display unit 26 of the terminal device 2 as a result of the output of step S14 in Figure 6, and is the screen for the tabular file 71 selected from the file list displayed on screen 82 or screen 83. As shown in this figure, screen 81 has a data division unit selection area 811, a header candidate list display area 812, a preview area 813, a save button 814, a preview button 815, a settings load button 816, and a file extraction information confirmation button 817.

[0080] Server device 1 accepts one of the following as the unit for data partitioning via the data partitioning unit selection area 811: file, sheet, or table. When server device 1 receives a preview request, it arranges the layout-defined data 7111, 7121, and 7131 vertically or horizontally in the preview area 813 using the selected partitioning unit (Figures 12-14).

[0081] In the example in Figure 10, "File" is selected as the splitting unit. The header candidate list display area 812 has a header name field 8121, a count field 8122, a type field 8123, and an edit link 8124.

[0082] Server device 1 extracts the headings from the heading parser 92 as header candidates. Server device 1 also extracts the contents of each table header from the table parser 95 as header candidates. The header name column 8121 displays the header names of the extracted header candidates. Server device 1 also displays a checkbox adjacent to the header name to select whether to use that header candidate as the header of the integrated table.

[0083] In Figure 9, the table parser 95 of the tabular file 71 does not have a header parser 92 connected to it. Therefore, in the header candidate list display area 812 of Figure 10, the table name is displayed as "(blank)". However, if the header parser 92 is connected to the table parser 95, the header of the header parser 92 will be displayed as the table name in the header name column 8121.

[0084] As shown in Figure 10, when displaying headers included in the table (for example, "Sample ID", "Electrical Resistivity (300K)", "Transition Point") in the header name field 8121, the server device 1 displays them as header candidates included in the table heading by listing them with indentation immediately after the header candidate that will become the table heading (for example, "Table:Experimental Results 1.(blank)"). Here, the columns (or rows) of the integrated table are displayed in the order they were displayed in the header candidate list display area 812.

[0085] The Count column 8122 displays the number of times the header name of the header candidate appears in the layout-defined data extracted from the selected tabular file. The Type column 8123 primarily displays the type of layout from which the header candidate of the layout-defined data was extracted. Specifically, "Value" is displayed if the header candidate is based on a header from the Heading Parser 92, and "Table" is displayed if the header candidate is based on a header from the Table Parser 95. "metadata" is displayed in the Type column for metadata header candidates.

[0086] In Figure 10, when server device 1 uses "file" as the splitting unit, it displays header candidates for "Book," which displays the file name, and header candidates for "Folder Path," which displays the file path of the folder where the file is stored. The header candidates for "Book" and "Folder Path" are listed with an indent immediately after the header candidate for "Metadata" in header name column 8121. Edit link 8124 allows editing whether the display of the integrated table in tabular file is vertical or horizontal, etc.

[0087] Server device 1 accepts a header editing operation (hereinafter referred to as "selection operation") by a user of terminal device 2 from a list of header candidates, in which the user selects a header candidate to display in the integrated table from the list of header candidates. The selection operation is an operation to select a header candidate from the list of header candidates that will be displayed in the integrated table.

[0088] For example, Server Device 1 accepts the user's selection of a header candidate to be displayed in the integrated table from a list of header candidates via touch or click operations. For example, if the header candidate "Experiment Information.Person in Charge" is selected, Server Device 1 displays whether the selection is made in the corresponding checkbox. The selected header candidate is then displayed in the integrated table.

[0089] Furthermore, if a header candidate that includes other header candidates (for example, "Table:Experimental Results 1.(blank)") is checked, all header candidates included in that header candidate (for example, "Sample ID," "Electrical Resistivity," and "Transition Point") will be automatically selected. This allows users to select all header candidates included in a selected header candidate at once, without having to individually select them, significantly reducing the effort required.

[0090] The preview area 813 displays a table generated by the header candidate selected in the header candidate list display area 812. The preview button 815 is a button that sends an instruction to the server device 1 to output the integrated table using the header candidate selected in the header candidate list display area 812 to the preview area 813. When the terminal device 2 receives an operation such as clicking the preview button 815 from the user, it sends a preview instruction to the server device 1. Upon receiving the preview instruction, the server device 1 creates an integrated table using the header candidate selected in the header candidate list display area 812 and outputs it to the preview area 813.

[0091] In Figure 10, server device 1 accepts selection of "file" as the splitting unit. When a file (tabular file) is selected as the splitting unit, server device 1 includes the sheet name in the header name of the header candidate displayed in the header candidate list display area 812. Specifically, server device 1 displays a string in the header name of the header candidate that connects the sheet name and the header of the header parser 92 or the table parser 95 ("(blank)" in Figure 10) via a "." (period).

[0092] For example, in the display of the header name field 8121, the sheet name "Experiment Information" and the header name "Person in Charge" generated by the header parser 92 are connected by a "." (period), resulting in "Experiment Information.Person in Charge". By creating a header that combines the sheet name and the header from the header parser 92 in this way, even if there are header candidates with the same name on different sheets when "files" are used as the unit of division, the server device 1 can treat them as different headers and display them in the header candidate list display area 812.

[0093] The integrated table displayed in the preview area 813 is the same as the content displayed in the header candidate list display area 812. When all of the displayed header candidates are selected (checked in the checkboxes), the server device 1 displays the integrated table when the preview button 815 is operated.

[0094] As shown in the integrated table displayed in preview area 813, server device 1 adopts the sheet name displayed before the "." (period) in the header candidate list display area 812 as a header that encompasses other headers in the multi-level headers of the integrated table. In addition, server device 1 adopts the string displayed after the "." (period) in the header candidate list display area 812 as a header included in the said sheet name.

[0095] The header included in the sheet name header will be a header with the Type field 8123 set to "Value" or "Table". Furthermore, Server Device 1 will adopt the header candidate (table header) displayed indented immediately after the header candidate with the Type field 8123 set to "Table" in the header name field 8121 of Figure 10 as the header of the integrated table, as a header further included in the header with the Type field 8123 set to "Table". Note that although Figure 10 shows a horizontal integrated table with the header at the top, a vertical integrated table with the header on the left side may also be used.

[0096] As shown in this table, the partitioning unit is "file," and since the selected tabular file is a single tabular file 71, the server device 1 does not use a common header and outputs the data in a single row. Note that the integrated table may extend in the column direction by transposing rows and columns. In this way, the server device 1 arranges multiple tabular data with different headers sequentially in either the vertical or horizontal direction.

[0097] In this way, Server Device 1 edits the position in which the header candidates are displayed on the integrated table from the list of header candidates and generates an integrated table based on the selected header. As shown in the figure, Server Device 1 generates an integrated table in the following order: "Experimental Information ("Person in Charge" and "Sample Name")", "Table:Experimental Results 1.(blank) ("Sample ID", "Electrical Resistivity (300K)" and "Transition Point")", "Table:Experimental Results 2.(blank) ("Sample ID", "Electrical Resistivity (300K)" and "Transition Point"), and "Metadata ("Book" and "Folder Path")".

[0098] Here, the server device 1 displays the columns (or rows) of the integrated table in the order they are displayed in the header candidate list display area 812. Based on operations performed by the user of the terminal device 2, such as drag-and-drop using the input unit 27 of the terminal device 2 (e.g., a mouse), the server device 1 changes the order of the header candidates in the header candidate list display area 812. In this way, the server device 1 accepts edits to the position where header candidates are displayed on the integrated table from the list of header candidates, accepts selections of header candidates to display, and generates an integrated table based on the selected headers.

[0099] The save button 814 is a button for sending a save command to the server device 1. When the user clicks the save button 814 or performs other actions, it sends a save command to the server device 1. Upon receiving the save command, the server device 1 saves the tabular file containing the contents displayed in the preview area 813, the layout file corresponding to the tabular file, the configuration file, and the file extraction information file.

[0100] Specifically, server device 1 saves the tabular data of the integrated table as a tabular file in the tabular file storage unit 62 in a new version. That is, server device 1 saves the tabular file selected from the file list (screen 82 or screen 83) displayed based on the folder path or search criteria as a new version (second version) in the tabular file storage unit 62. For example, if the original tabular file "data_a.lod" is saved in the existing first version, the newly saved second version may have a filename such as "data_a_v2.lod".

[0101] Regarding the saving process for the new version, the server device 1 may, for example, arbitrarily name the new tabular file and save it in the tabular file storage unit 62, regardless of the version number. Alternatively, after presenting it to the user, the server device 1 may overwrite the existing first version of the integrated table's tabular data and save it in the tabular file storage unit 62.

[0102] In this way, when an integrated table is output based on a tabular file selected from a list of files displayed based on the folder path associated with the integrated table or the search criteria, the integrated table can be saved in a new version.

[0103] Server device 1 converts the parsed objects placed in the tabular data into strings or the like, and saves the layout structure information as a layout file in the layout file storage unit 63.

[0104] Server device 1 stores the division unit and header editing operations as a configuration file in the table creation configuration file storage unit 64. Header editing operations include move operations and selection operations for headers displayed in the integrated table. The contents of a header editing operation include, but are not limited to, the name of the header to be operated on, the destination position of the header (after modification), procedure information for the editing operation, and display and hide settings in the integrated table.

[0105] The configuration file is composed of XML or JSON format, among others. By loading the configuration file the next time the system is used, the previous edits (splitting units and header editing operations) will be applied to the header candidate list screen. This allows users to reuse the header editing operations they performed later. Saved configuration files are automatically loaded the next time an integrated table is created, allowing the previous settings to be carried over.

[0106] The configuration file can include information such as the header name, the destination (after modification) of the header, editing procedure information, and display and hide settings for the integrated table. The configuration file may also include only the destination (after modification) of the header, editing procedure information, or display and hide settings for the integrated table. Furthermore, the editing procedure information includes the type of editing operation (e.g., move) and the destination location (e.g., "next to: Experiment Information"). This allows editing operations to be applied even if there are changes in the number of header candidates included in the header candidates or in the header name.

[0107] When a tabular file is selected from the file list displayed on screen 82, server device 1 saves the folder path of the folder corresponding to the file list (for example, "C:\ssd\spreadsheet") as a file extraction information file in the file extraction information file storage unit 65. The file extraction information file consists of text, XML, or JSON format, etc.

[0108] When a tabular file is selected from the file list displayed on screen 83, server device 1 saves the search criteria for the file search results corresponding to the file list (for example, "Keyword (LaFeAs)") as a file extraction information file in the file extraction information file storage unit 65.

[0109] Server device 1 assigns identifiers to management files for managing tabular files, layout files, configuration files, and file extraction information files. Server device 1 stores the file paths of tabular files, layout files, configuration files, and file extraction information files in management file 61, associating them with the assigned identifiers.

[0110] The settings load button 816 is a button for applying saved division units and header editing operations. When the server device 1 receives a touch operation of the settings load button 816 by a user, it accepts the user's selection (specification) of a settings file in which the division units and header editing operations are saved for the tabular file 71.

[0111] Specifically, when terminal device 2 receives a touch operation on the setting load button 816, it displays a file selection dialog (not shown) for selecting a setting file. Terminal device 2 accepts the user's selection of the target setting file through the file selection dialog. Terminal device 2 transmits information about the selected setting file (file path and file name, etc.) to server device 1. Based on the information about the setting file transmitted from terminal device 2, server device 1 retrieves the corresponding setting file from the table creation setting file storage unit 64 of the storage unit 14.

[0112] Server device 1 reads the division unit ("file", "sheet", or "table") and header editing operations from the selected configuration file. Server device 1 extracts layout-defined data for each read division unit from the tabular file 71. Server device 1 generates a list of header candidates for the integrated table from the layout-defined data for each division unit.

[0113] Server device 1 applies the division unit and header editing operation to the header candidate list screen 81. Specifically, server device 1 sets the read division unit to the data division unit selection area 811. Based on the header name and position (display order) of each header candidate included in the read header editing operation, server device 1 sets the header name and position of each header candidate to the header candidate list display area 812. Server device 1 may also move the header candidates based on the header candidate move operation included in the read header editing operation.

[0114] Furthermore, the display order of header candidates that do not exist in the configuration file will be set to a predetermined position within the header candidates that contain them. In other words, even if the number or content of header candidates contained within other header candidates differs from the settings in the configuration file, the header candidate in question may be moved together with the header candidates that contain it.

[0115] Server device 1 displays checkboxes indicating selected or unselected status in the header candidate list display area 812, based on the selection operation details included in the read header editing operation. If there are header candidates not included in the configuration file, the settings (selected or unselected) for those header candidates may also be configured.

[0116] The File Extraction Information Confirmation button 817 is a button used in the preview area 813 where the integrated table has been output to display a list of files after output corresponding to the integrated table. The list of files after output is a list of files in the folder indicated by the folder path associated with the integrated table, or a list of files resulting from the search results based on the search conditions associated with the integrated table.

[0117] When server device 1 receives a touch operation of the file extraction information confirmation button 817 by a user, it obtains the file path and file name of the file extraction information file corresponding to the tabular file 71 in which the integrated table is stored from management file 61, based on the file path and file name of the tabular file 71 in which the integrated table is stored. Based on the obtained file path and file name of the file extraction information file, server device 1 obtains the file extraction information file from file extraction information file storage unit 65.

[0118] Server device 1 reads the acquired file extraction information file. The file extraction information file stores the extraction type ("folder" or "file search"), the folder path if the extraction type is "folder", or the search conditions if the extraction type is "file search". Based on the extracted type read, Server device 1 outputs the post-output file list to terminal device 2 along with the preview area 813 where the integrated table is output.

[0119] Figure 11 shows an example of a post-output file list. Figure 11A shows an example of a post-output file list, which is a list of files in the folder indicated by the folder path. Figure 11A includes the first post-output file list area 824. The first post-output file list area 824 is an area for displaying the post-output file list, which is a folder.

[0120] Figure 11B shows an example of a post-output file list, which is a list of files resulting from search results based on the search criteria. Figure 11B includes a second post-output file list area 825. The second post-output file list area 825 is an area for displaying the post-output file list, which is the file search result.

[0121] If the extracted type read by server device 1 is "folder", it obtains the folder path associated with the integrated table from the file extraction information file. Server device 1 outputs the post-output file list, which is a list of files in the folder indicated by the obtained folder path, to terminal device 2. Terminal device 2 displays the post-output file list output from server device 1 in the first post-output file list area 824.

[0122] As shown in Figure 11A, the first post-output file list area 824 displays the folder path associated with the integrated table (for example, "C:\ssd\spreadsheet\") and the file list of the folder indicated by that folder path. In this way, the integrated table display screen (preview area 813) where the integrated table is output can obtain the folder path associated with the integrated table and display the post-output file list (first post-output file list area 824), which is the file list of the folder indicated by that folder path. Note that even if the file list indicated by the folder path differs from the file list at the time of outputting the integrated table, that file list will still be displayed.

[0123] If the extraction type is "file search", Server device 1 retrieves the search conditions associated with the integrated table from the file extraction information file. Server device 1 outputs a post-output file list, which is a list of files found using the retrieved search conditions, to Terminal device 2. Terminal device 2 displays the post-output file list output from Server device 1 in the second post-output file list area 825.

[0124] As shown in Figure 11B, the second post-output file list area 825 displays the search conditions associated with the integrated table (for example, "Keyword (LaFeAs)") and a list of files resulting from the search conditions. In this way, the integrated table display screen (preview area 813) where the integrated table is output can retrieve the search conditions associated with the integrated table and display the post-output file list (second post-output file list area 825), which is a list of files resulting from the search conditions. Note that even if the file search results differ from those at the time of integrated table output, the file list representing those file search results will be displayed.

[0125] Furthermore, it is possible to display a screen where a previously created header candidate for the integrated table is selected from the list of header candidates for the integrated table, which is displayed based on the tabular file selected from the list of output files.

[0126] Specifically, Server Device 1 accepts the user's selection of a target tabular file from the list of output files. Based on the selected tabular file, Server Device 1 generates a list of header candidates for the integrated table to be displayed. The process for generating the list of header candidates is the same as the process shown in Figure 10, so the explanation is omitted. The generated list of header candidates is displayed in the header candidate list display area 812.

[0127] Server device 1 obtains the file path and file name of the configuration file corresponding to the tabular file from management file 61, based on the file path and file name of the tabular file. Server device 1 obtains the corresponding configuration file from table creation configuration file storage unit 64, based on the obtained file path and file name of the configuration file.

[0128] Server device 1 reads the header editing operations from the acquired configuration file. Based on the operation details of the selection operations included in the read header editing operations, Server device 1 associates checkboxes indicating selected or unselected states with the corresponding header candidates and displays them in the header candidate list display area 812.

[0129] In this way, it is possible to display a screen where a previously created integrated table header candidate is selected from the list of integrated table header candidates displayed based on the tabular file selected from the list of output files.

[0130] In addition, regardless of the selection state, for example, the server device 1 may display the header name and position (display order) of each header candidate in the header candidate list display area 812 based on the header name and position (display order) of each header candidate included in the read header editing operation.

[0131] Note that, as described later, if there are multiple tabular files, the conversion process for the division unit, acceptance of header editing operations, saving process, application of the division unit and header editing operations, and display of the output file list are performed in the same way as when there is one tabular file, so the explanation is omitted.

[0132] Next, we will explain the process for accepting changes to the division unit for the list of header candidates displayed in the header candidate list display area 812. The division unit can be a sheet, a file, or a table (layout-defined data defined as a table within tabular data). When the division unit is changed, a list of header candidates for an integrated table, which combines multiple layout-defined data extracted for each changed division unit, can be output.

[0133] Specifically, when server device 1 receives a user's selection of "sheet" via the data division unit selection area 811 in the header candidate list display area 812 of Figure 10, where "file" is selected as the data division unit, server device 1 accepts "sheet" as the data division unit. Server device 1 outputs a list of header candidates for the integrated table (Figure 12), which combines multiple layout-defined data extracted for each changed division unit ("sheet"), to terminal device 2.

[0134] Alternatively, if the server device 1 receives a selection of "table" from the user via the data partitioning unit selection area 811, it accepts "table" as the unit for data partitioning. The server device 1 outputs a list of header candidates for the integrated table (Figure 14), which combines multiple layout-defined data extracted for each changed partitioning unit ("table"), to the terminal device 2.

[0135] [1.2. Splitting unit: Sheet] Figure 12 is an explanatory diagram showing an example of a header candidate list and integrated table when the division unit is set to "sheet". In Figure 12, along with the header candidate list display area 812, the integrated table that will be displayed when all header candidates are selected in the header candidate list display area 812 and the preview button 815 is operated is shown in the preview area 813 below the arrow. As shown in the header candidate list display area 812 of this figure, when the division unit is set to "sheet", the sheet name is not appended to the header name, and header names with the same string in different sheets are treated as common header candidates across sheets.

[0136] In Figure 9, the layout-defined data 7121 for sheet 712 and the layout-defined data 7131 for sheet 713, related to the table parser 95, have the same string header. Therefore, in the example of the header candidate list display area 812 in Figure 12, where the division unit is set to "sheet," the server device 1 uses the common header names for the layout-defined data 7121 and the layout-defined data 7131 as common header candidates. As a result, the header candidates "Sample ID," "Electrical Resistivity (300K)," and "Transition Point" extracted by the table parser 95 appear in both the layout-defined data 7121 and 7131, becoming common header candidates, and the display in the count column 8122 for these header candidates is 2.

[0137] Furthermore, regarding the metadata header candidates when "sheets" are used as the splitting unit, the server device 1 displays header candidates with the same header names "Book" and "folder path" as when "files" are used as the splitting unit, as well as a header candidate with the header name "Sheet" that displays the sheet name, in the header candidate list display area 812.

[0138] Here, the target tabular file 71 has layout-defined data 7111, 7121, and 7131 in three sheets, respectively (Figure 9). Since the division unit is "sheet," as shown in the integrated table in the preview area 813 of Figure 12, the server device 1 generates a three-row integrated table in the preview area 813, in which the layout-defined data 7111, 7121, and 7131 placed in each sheet are arranged vertically in order. Note that the integrated table may extend in the column direction by transposing the rows and columns.

[0139] Here, in the metadata, the "Book" column, which displays the file name for each row, is the same, while the "Sheet" column, which displays the sheet name, is different for each row. The metadata indicates that the contents of the cells in each row are data extracted from different sheets within the same file. In this way, server device 1 generates an integrated table by arranging the layout-defined data vertically (or horizontally) within the selected division unit.

[0140] Furthermore, as described above, the server device 1 arranges multiple tabular data sets having a common header ("Sample ID", "Electrical Resistivity (300K)", and "Transition Point") for each division in order in a first direction, which is either vertical or horizontal (in this embodiment, the "vertical direction"). In addition, the server device 1 arranges multiple tabular data sets having different headers ("Person in Charge" and "Sample Name") for each division in order in a second direction, which is either vertical or horizontal and different from the first direction (in this embodiment, the "horizontal direction").

[0141] In the example shown in Figure 12, tabular data with different headers for each division is arranged horizontally while also being moved vertically. This allows for easy comparison of common header content by arranging it in one direction, while non-common headers are described as separate information, thereby creating a clear and comprehensive integrated table.

[0142] Figure 13 shows another example of an integrated table displayed when the division unit is set to "sheet". Server device 1 can determine that sheets 712 and 713 have the same attributes based on the fact that the sheet names "Experimental Results 1" and "Experimental Results 2" are strings consisting of the same term and the numbers associated with that term. It can also determine that sheet 711, "Experimental Information," has different attributes from sheets 712 and 713.

[0143] In this case, as shown in the integrated table in Figure 13, sheets 712 and 713, which have common attributes, can be arranged vertically (or horizontally), and sheet 711, which has different attributes, can be arranged horizontally (or vertically). In this way, tabular data with common attributes can be arranged sequentially in a first direction, either vertically or horizontally, for each partition, and tabular data with different attributes can be arranged sequentially in a second direction, either vertically or horizontally, that is different from the first direction, for each partition. Furthermore, the server device 1 can output a preview of the integrated table based on the accepted selection of partition units or header editing operation, along with a screen displaying a list of header candidates.

[0144] This allows for the creation of a user-friendly and comprehensive integrated table by arranging the division units of common attributes in one direction for easy comparison, and displaying the division units of different attributes separately in a different direction. In the example in Figure 13, metadata is not selected in the header candidate list display area 812, and therefore metadata is not displayed in the integrated table.

[0145] Furthermore, even when multiple tabular data sets with a common header are arranged sequentially in a first direction, either vertically or horizontally, and tabular data sets with different headers are arranged in a second direction, either vertically or horizontally, that is different from the first direction, the server device 1 can output an integrated table like the one shown in Figure 13. For example, if the header candidate list display area 812 is set not to display metadata, the server device 1 can output an integrated table like the one shown in Figure 13 by arranging tabular data sets with different headers (e.g., sheet name "Experiment Information") only in the second direction (horizontally) relative to other tabular data sets (sheet name "Experiment Results 1"), without moving them in the first direction (vertically).

[0146] [1.3. Unit of division: Table] Figure 14 is an explanatory diagram showing an example of a header candidate list and an integrated table when the division unit is set to "table". In Figure 14, along with the header candidate list display area 812, the integrated table that will be displayed when all header candidates are selected in the header candidate list display area 812 and the preview button 815 is operated is shown in the preview area 813 below the arrow. As shown in the header candidate list display area 812 of this figure, when the division unit is set to "table", the headings of the heading parser 92 are not extracted as header candidates, just as when the division unit is set to "sheet", and header names with the same string in different sheets are treated as common header candidates among the layout-defined data.

[0147] The target tabular file 71 has layout-defined data 7111, 7121, and 7131 in three sheets, respectively (Figure 9). However, since the division unit is "table," the server device 1 targets only the layout-defined data 7121 and 7131, including the table parser 95, as header candidates.

[0148] Similar to the case in Figure 12 where the division unit is "sheet," in the example of the header candidate list display area 812 in Figure 14, the server device 1 adopts the same string header names in the layout-defined data 7121 and 7131 in Figure 9 as common header candidates. Specifically, the header candidates "Sample ID," "Electrical Resistivity (300K)," and "Transition Point" extracted by the table parser 95 appear in both the layout-defined data 7121 and 7131, and therefore become common header candidates, resulting in a display of 2 in the count column 8122 for these header candidates.

[0149] Furthermore, when "tables" are used as the partitioning unit, Server Device 1 displays header candidates such as "Book," "Folder Path," and "Sheet" as metadata, similar to when "sheets" are used as the partitioning unit, and also displays header candidates for the header name "Key" to identify tables within a sheet.

[0150] As described above, the integrated table created targets the layout-defined data 7121 and 7131, which have a table parser 95. As shown in the integrated table in the preview area 813 of Figure 14, since the partitioning unit is a "table," the server device 1 arranges the layout-defined data 7121 and 7131 based on this table parser 95 vertically in order to generate a two-row integrated table. The integrated table may also have two columns in the column direction by transposing the rows and columns.

[0151] In the metadata section, the "Book" column, which contains the file name, is the same for each row, while the "Sheet" column, which contains the sheet name, is different for each row. This indicates that the contents of the cells in each row are data extracted from different sheets within the same file. Additionally, the "Key" column contains a string combination formed by connecting the file name and sheet name with a "." (period).

[0152] If a header parser 92 is further connected to the extracted table parser 95, the "Key" column may display the table header after the sheet name, separated by a period (."). This allows the "Key" column to be displayed as a string that identifies the table. Therefore, the convenience of processing using a layout that defines the relationship between tabular data and each cell of that tabular data can be further enhanced. Alternatively, the "Key" column may not display the file name or sheet name, and may only display the table header. Furthermore, if one or more header parsers 92 are hierarchically connected to the header parser 92 connected to the table parser 95, the "Key" column may display the headers of each header parser connected by a period (.") in hierarchical order.

[0153] [2. Example when there are 2 tabular files] Figure 15 shows an example of the configuration of tabular files 72 and 73. Tabular files 72 and 73 can be tabular files stored in the tabular linked data 60, which are selected in step S12 of Figure 6. Tabular file 72 has the file name "Super Z Inspection_1" and has sheets 721, 722, and 723 containing tabular data. Tabular file 73 has the file name "Super Z Inspection_2" and has sheets 731, 732, and 733 containing tabular data.

[0154] Sheets 721, 722, and 723 of the tabular file 72 are named "Experimental Information," "Process 1," and "Process 2," respectively. Sheet 721 contains layout-defined data 7211 defined by the heading parser 92, with headings "Person in Charge," "Sample Name," "Type," and "Overview," respectively. Sheet 722 contains layout-defined data 7221 defined by the heading parser 92, with headings "Process Name," "Contact Drying Time," and "Glass Transition Temperature," respectively.

[0155] Sheet 723 contains layout-defined data 7231A defined by the header parser 92 with "Process Name" as the header, and layout-defined data 7231B defined by the table parser 95 with "Shear Load Stress (MPa)" and "Breakage Time (hr)" as headers. Layout-defined data 7231A and 7231B are collectively referred to as layout-defined data 7231.

[0156] Sheets 731, 732, and 733 of tabular file 73 are named "Experimental Information," "Process 1," and "Process 2," respectively, similar to sheets 721, 722, and 723 of tabular file 72. Sheet 731 contains layout-defined data 7311, which has the same headings as layout-defined data 7211 of sheet 721. Sheet 732 contains layout-defined data 7321, which has the same headings as layout-defined data 7221 of sheet 722. Sheet 733 contains layout-defined data 7331A, which has the same headings as layout-defined data 7231 of sheet 723, and layout-defined data 7331B, which has the same headers as layout-defined data 7231B. Layout-defined data 7331A and 7331B are collectively referred to as layout-defined data 7331.

[0157] Even when there are two tabular files, the server device can accept changes to the partitioning unit and header editing operations on the output list of header candidates, just as it does when there is one tabular file. Furthermore, it can output a preview of the integrated table based on the accepted partitioning unit selection or header editing operation.

[0158] Furthermore, even when there are two tabular files, similar to the example when there is one tabular file, the system can accept the selection of a tabular file from a folder or file search result file list, and when an integrated table is generated from the tabular data contained in that tabular file, the folder path of the folder or the search conditions of the file search result can be associated with and saved in relation to the generated integrated table.

[0159] [2.1. Splitting unit: File] Figure 16 is an explanatory diagram showing an example of a header candidate list and integrated table when the division unit is set to "file". In Figure 16, along with the header candidate list display area 812, the integrated table that will be displayed when all header candidates are selected in the header candidate list display area 812 and the preview button 815 is operated is shown in the preview area 813 below the arrow. Below, we will explain an example in step S12 of Figure 6 where tabular files 72 and 73 of Figure 15 are selected and the division unit is set to "file". As shown in the header candidate list display area 812 of Figure 16, when the division unit is set to "file (tabular file)", the server device 1 includes the sheet name of the sheet in the header name of the header candidate, similar to Figure 10.

[0160] Specifically, the server device 1 displays a string in the header name of a header candidate that connects the sheet name and the heading of the heading parser 92 or the heading of the table parser 95 (shown as "(blank)" in Figure 16) via a "." (period). For example, in the display of the header name field 8121, the sheet name "Experiment Information" and the header name "Person in Charge" from the heading parser 92 are connected by a "." (period), resulting in "Experiment Information.Person in Charge". By creating a header that combines the sheet name and the heading of the heading parser 92 in this way, even if there are header candidates with the same name on different sheets when "files" are used as the unit of division, the server device 1 can treat them as different headers and display them in the header candidate list display area 812.

[0161] Furthermore, since tabular files 72 and 73 have the same sheet name, the same heading parser 92, and the same table parser 95 with the same header, the count of each header candidate, excluding metadata, is 1 per sheet, for a total of 2. The "Metadata" in the header name column 8121 has header candidates with the header names "Book" and "Folder Path," similar to Figure 10.

[0162] As shown in the integrated table in preview area 813 of Figure 16, the server device 1, similar to Figure 10, adopts the sheet name before the "." (period) in the header candidate list display area 812 as the header containing the sheet header among the multi-level headers in the integrated table. Furthermore, the server device 1 adopts the string displayed after the "." (period) in the header candidate list display area 812 as the header included in the header of the sheet name.

[0163] The headers in the lower rows will be headers where the Type field 8123 is set to "Value" or "Table". Furthermore, Server Device 1 adopts the header candidate (table header) displayed in indentation immediately after the header candidate where the Type field 8123 is set to "Table" in the Header Name field 8121 of Figure 16 as the header of the integrated table, as a header below the header where the Type field 8123 is set to "Table". In Figure 16, the integrated table is shown as a horizontal table with the header at the top, but it may also be a vertical integrated table with the header on the left.

[0164] As shown in the integrated table in preview area 813 of Figure 16, since the partitioning unit of server device 1 is "file," the data of tabular files 72 and 73 are arranged vertically on a file-by-file basis. On the other hand, the headers within each tabular file 72 and 73 are arranged horizontally. Specifically, server device 1 arranges the header candidates contained in the sheet names "Experiment Information," "Process 1," and "Process 2" horizontally. Meanwhile, headers with the same header name between each tabular file 72 and 73 are common, and the values ​​are displayed in the same header column. In the integrated table of Figure 16, since all headers except metadata are common, the data from header parser 92 and table parser 95 are displayed in the common header column, respectively.

[0165] Here, the layout-defined data 7231 and 7331 extracted by the table parser 95 each have three data entries per header. Therefore, the server device 1 displays the data using three rows for each of the tabular files 72 and 73. Also, since the selected tabular files are two files, tabular files 72 and 73, the contents of tabular files 72 and 73 are arranged vertically. In other words, it becomes a combined table with a total of six rows.

[0166] This allows for the creation of a user-friendly and comprehensive integrated table by arranging the contents of common headers in one direction for easy comparison, and listing non-common headers as separate information. The integrated table may also be created by transposing the rows and columns to form a single column.

[0167] In the metadata, Server Device 1 displays the file name in the "Book" column and the folder path where the tabular file is saved in the "Folder Path" column.

[0168] [2.2. Splitting unit: Sheet] Figure 17 is an explanatory diagram showing an example of a header candidate list and integrated table when the division unit is set to "sheet". In Figure 17, along with the header candidate list display area 812, the integrated table that is displayed when all header candidates are selected in the header candidate list display area 812 and the preview button 815 is operated is shown in the preview area 813 below the arrow. As shown in the header candidate list display area 812 of this figure, when the division unit is set to "sheet", the sheet name is not appended to the header name, and headers with the same string in different sheets are treated as common header candidates across sheets.

[0169] Aside from the absence of sheet names and metadata, the only difference between the header candidate list display area 812 in Figure 17 and the header candidate list display area 812 in Figure 16 is that the count for "Process Name" in the header name column 8121 is 4. In the header candidate list display area 812 in Figure 16, the sheet name was attached to the header name column 8121, so "Process Name" in the header name column 8121 was treated as different headers for the sheet names "Process 1" and "Process 2". However, when the division unit is set to "Sheet" in Figure 17, the server device 1 treats "Process Name," which has the same header name, as a common header candidate and displays it as a common header in the integrated table.

[0170] The explanation of the metadata in Figure 17 is the same as the explanation in Figure 12, so redundant explanations will be omitted.

[0171] Here, the tabular file 72 in question has layout-defined data 7211, 7221, and 7231 in three sheets, respectively (Figure 15). Similarly, the tabular file 73 has layout-defined data 7311, 7321, and 7331 in three sheets, respectively. Because the division unit is "sheet," as shown in the integrated table in the preview area 813 of Figure 17, the server device 1 arranges the layout-defined data 7211, 7221, 7231, 7311, 7321, and 7331 vertically in order to form an integrated table of 10 rows.

[0172] Here, the header name "Process Name" is used as a common header, so the number of headers (columns) is one less compared to the integrated table in preview area 813 of Figure 16. In this way, server device 1 generates the integrated table by arranging the layout-defined data vertically in the selected division unit. Note that the integrated table may also be one in which the rows and columns have been transposed and extended in the column direction.

[0173] This allows for the creation of a user-friendly and comprehensive integrated table by arranging common header contents in a unidirectional manner for easy comparison, while listing non-common headers as separate information.

[0174] [2.3. Division Unit: Table] Figure 18 is an explanatory diagram showing an example of a header candidate list and an integrated table when the division unit is set to "table". In Figure 18, along with the header candidate list display area 812, the integrated table that is displayed when all header candidates are selected in the header candidate list display area 812 and the preview button 815 is operated is shown in the preview area 813 below the arrow. As shown in the header candidate list display area 812 of this figure, when the division unit is set to "table", the headers of the header parser 92 are not extracted as header names, and headers with the same string on different sheets are treated as common header candidates among the layout-defined data.

[0175] Of the target tabular files 72 and 73, the layout-defined data 7231 contained in sheet 723 and the layout-defined data 7331 contained in sheet 733 are eligible to be considered as header candidates. Excluding metadata, the header candidate list display area 812 in Figure 18 is the same as the list in the header candidate list display area 812 in Figure 17, excluding the header names with type "Value" in the type column 8123, and redundant explanations are omitted.

[0176] The explanation of the metadata in Figure 18 is the same as that for Figure 14, so redundant explanations will be omitted.

[0177] Since the division unit is "table" and the target tables are the layout-defined data 7231B and 7331B in Figure 15, the integrated table will be a table in which the layout-defined data 7231B and 7331B are arranged vertically, as shown in the preview area 813 of Figure 18. Since the layout-defined data 7231B and 7331B have a common header, the values ​​will be displayed in the corresponding common headers. In this way, the server device 1 generates the integrated table by arranging the layout-defined data vertically in the selected division unit. The integrated table may also be arranged with the rows and columns transposed to extend in the column direction.

[0178] This improves the convenience of processing tabular data using a layout that defines the relationships between each cell in that tabular data. It also allows for the creation of integrated tables tailored to user needs.

[0179] Even when there are two tabular files, the server device 1 displays a file list, which is a folder or file search result, and accepts the selection of a tabular file from the file list, just as when there is one tabular file. The server device 1 outputs a list of header candidates for the integrated table, which is a combination of multiple layout-defined data extracted for each selected division unit, and accepts header editing operations for the output list of header candidates.

[0180] When server device 1 generates an integrated table based on a list of header candidates for which header editing operations have been performed, it can associate and save a layout file, a configuration file, and a file extraction information file with the integrated table. Furthermore, by reading the saved splitting units and header editing operations, the splitting units and header editing operations can be applied to the header candidate list screen.

[0181] Furthermore, similar to the case where there is one tabular file, the server device 1 can accept header editing operations such as moving a header candidate to a higher or lower position in the output list of header candidates, or selecting a header from the list of header candidates to display in the integrated table. In this case, by moving one header candidate to a higher or lower position than other header candidates, an integrated table can be generated in which one header candidate is displayed in a column to the left or right of the other header candidates, respectively.

[0182] Furthermore, similar to the case where there is only one tabular file, Server Device 1 obtains the folder path associated with the integrated table on the integrated table display screen where the integrated table has been output. Server Device 1 can then display the output file list, which is a list of files in the folder indicated by the obtained folder path.

[0183] Furthermore, similar to the case where there is one tabular file, Server Device 1 retrieves the search conditions associated with the integrated table on the integrated table display screen where the integrated table has been output. Server Device 1 can then display the output file list, which is a list of files resulting from the search results based on the retrieved search conditions.

[0184] Furthermore, similar to the case where there is one tabular file, the server device 1 can display a screen in which a previously created header candidate for the integrated table is selected from the list of header candidates for the integrated table displayed based on the tabular file selected from the list of output files.

[0185] [3. Example when there are 6 tabular files] Figure 19 shows an example of the structure of tabular files 74-79. Tabular files 74-79 can be tabular files stored in tabular linked data 60, which are selected in step S12 of Figure 6. Tabular file 74 has the file name "Super Z Inspection_1 Experiment Information" and has sheet 741. Sheet 741 has layout-defined data 7411 defined by a heading parser 92 with headings "Person in Charge", "Sample Name", "Type", and "Overview".

[0186] Tabular file 75 has the filename "Super Z Inspection_1 Process 1" and contains sheet 751. Sheet 751 contains layout-defined data 7511 defined by the header parser 92, with the headers "Process Name", "Contact Drying Time", and "Glass Transition Temperature". Tabular file 76 has the filename "Super Z Inspection_1 Process 2" and contains sheet 761. Sheet 761 contains layout-defined data 7611A defined by the header parser 92, with the header "Process Name". It also contains layout-defined data 7611B defined by the table parser 95, with the header names "Shear Load Stress (MPa)" and "Breakage Time (hr)". Layout-defined data 7611A and 7611B are referenced together with layout-defined data 7611.

[0187] Tabular file 77 has the filename "Super Z Inspection_2 Experiment Information" and contains sheet 771. Sheet 771, like sheet 741, contains predefined layout data 7711 defined by a heading parser 92 with headings "Person in Charge", "Sample Name", "Type", and "Overview". Tabular file 78 has the filename "Super Z Inspection_2 Process 1" and contains sheet 781. Sheet 781, like sheet 751, contains predefined layout data 7811 defined by a heading parser 92 with headings "Process Name", "Contact Drying Time", and "Glass Transition Temperature".

[0188] Tabular file 79 has the filename "Super Z Inspection_2nd Process 2" and contains sheet 791. Sheet 791, like sheet 761, contains layout-defined data 7911A defined by the header parser 92 with the header name "Process Name". It also contains layout-defined data 7911B defined by the table parser 95 with the header names "Shear Load Stress (MPa)" and "Breakage Time (hr)". Layout-defined data 7911A and 7911B are referenced together with layout-defined data 7911.

[0189] Even when there are six tabular files, the server device can accept changes to the partitioning unit and header editing operations on the output list of header candidates, just as it does when there is one tabular file. Furthermore, it can output a preview of the integrated table based on the accepted partitioning unit selection or header editing operation.

[0190] Furthermore, even when there are six tabular files, similar to the example when there is one tabular file, the system can accept the selection of tabular files from a folder or file search result file list, and when an integrated table is generated from the tabular data contained in those tabular files, the folder path of the folder or the search conditions of the file search result can be associated with and saved in the generated integrated table.

[0191] [3.1. Splitting unit: File] Figure 20 is an explanatory diagram showing an example of a list of header candidates and an integrated table when the division unit is set to "file". In Figure 20, along with the header candidate list display area 812, the integrated table that will be displayed when all header candidates are selected in the header candidate list display area 812 and the preview button 815 is operated is shown in the preview area 813 below the arrow. The following describes an example in step S12 of Figure 6 where tabular files 74 to 79 are selected and the division unit is set to "file". As shown in the header candidate list display area 812 of Figure 20, when the division unit is set to "file (tabular file)", the server device 1 includes the sheet name of the sheet in the header name of the header candidate, as in the case of Figure 10.

[0192] Specifically, the server device 1 displays a string in the header name of the header candidate that is formed by concatenating the sheet name "Sheet1" with the header of the header parser 92 or the header of the table parser 95 (shown as "(blank)" in Figure 20) via a "." (period). This allows the server device 1 to treat them as different headers and display them in the header candidate list display area 812 even if there are header candidates with the same name on different sheets when "files" are used as the splitting unit.

[0193] Furthermore, tabular files 74-76 have the same sheet names, the same header parser 92, and the same header parser 95 as tabular files 77-79, respectively. Therefore, the total count for each header candidate, excluding metadata, is 2. However, the header name "Sheet1.Process Name" appears a total of 4 times in tabular files 75-76 and 78-79, so the count for header name 8121 for "Sheet1.Process Name" is 4.

[0194] The explanation of the metadata in Figure 20 is the same as the explanation for Figure 10, so redundant explanations will be omitted.

[0195] As shown in the integrated table in preview area 813 of Figure 20, the server device 1, similar to Figure 10, adopts the sheet name before the "." (period) in the header candidate list display area 812 as the header that encompasses the headers within the sheet, among the multi-level headers in the integrated table. In the case of Figure 20, since all sheet names are the same "Sheet1", the header for Sheet1 is used across all headers except metadata.

[0196] Furthermore, Server Device 1 adopts the string displayed after the "." (period) in the header candidate list display area 812 as the header included in the header of the sheet name. The headers of the lower levels will be headers where the type field 8123 is "Value" or "Table". In addition, Server Device 1 adopts the header candidate (table header) displayed with an indent immediately after the header candidate where the type field 8123 is "Table" in the header name field 8121 of Figure 20 as the header of the integrated table, as a header further below the header where the type field 8123 is "Table". In Figure 20, a horizontal integrated table with the header at the top is shown, but a vertical integrated table with the header on the left side may also be used.

[0197] As shown in the integrated table in preview area 813 of Figure 20, the division unit is "file," so server device 1 arranges the tabular data of tabular files 74-79 vertically on a file-by-file basis. On the other hand, as shown in header candidate list display area 812, tabular files 74-76 and tabular files 77-79 have a common header, so server device 1 arranges the headers horizontally in the order shown in header candidate list display area 812. Server device 1 arranges a total of six tabular files 74-79 vertically, but two of the six tabular files, tabular files 76 and 79, are 3-row tables, and the remaining one is a header parser 92 that is displayed on one row, resulting in an integrated table of 10 rows in total.

[0198] This allows for the creation of a user-friendly and comprehensive integrated table by arranging the contents of common headers in one direction for easy comparison, and listing non-common headers as separate information. The integrated table may also be created by transposing the rows and columns to form a single column.

[0199] [3.2. Splitting unit: Sheet] Figure 21 is an explanatory diagram illustrating an example of a header candidate list and integrated table when the division unit is set to "sheet". In Figure 21, along with the header candidate list display area 812, the integrated table displayed when all header candidates are selected in the header candidate list display area 812 and the preview button 815 is operated is shown in the preview area 813 below the arrow. As shown in the header candidate list display area 812 of this figure, when the division unit is set to "sheet", the sheet name is not appended to the header name, and headers with the same string in different sheets are treated as common header candidates across sheets.

[0200] The header candidate list display area 812 and preview area 813 in Figure 21 are the same as the header candidate list display area 812 and preview area 813 in Figure 20, except that the sheet name is not displayed and metadata is not included; therefore, redundant explanations are omitted. Also, the explanation regarding the metadata in Figure 21 is the same as the explanation in Figure 12; therefore, redundant explanations are omitted.

[0201] In this way, the server device 1 generates an integrated table by arranging the layout-defined data vertically in the selected division unit. The integrated table may also be one in which the rows and columns have been transposed and extended in the column direction.

[0202] This allows for the creation of a user-friendly and comprehensive integrated table by arranging common header contents in a unidirectional manner for easy comparison, while listing non-common headers as separate information.

[0203] [3.3. Division Unit: Table] Figure 22 is an explanatory diagram showing an example of a header candidate list and an integrated table when the division unit is set to "table". In Figure 22, along with the header candidate list display area 812, the integrated table that will be displayed when all header candidates are selected in the header candidate list display area 812 and the preview button 815 is operated is shown in the preview area 813 below the arrow. As shown in the header candidate list display area 812 of this figure, when the division unit is set to "table", the headers of the header parser 92 are not extracted as header names, and headers with the same string on different sheets are treated as common header candidates among the layout-defined data.

[0204] Of the target tabular files 74-79, the layout-defined data 7611 contained in sheet 761 of tabular file 76, and the layout-defined data 7911 contained in sheet 791 of tabular file 79, are considered as header candidates. Excluding metadata, the header candidate list display area 812 in Figure 22 is the same as the header candidate list display area 812 in Figure 18, and redundant explanations are omitted.

[0205] The explanation of the metadata in Figure 22 is the same as the explanation in Figure 14, so redundant explanations will be omitted.

[0206] The preview area 813 in Figure 22 is the same as the preview area 813 in Figure 18, except for the metadata, so redundant explanations are omitted. The metadata differs in that, in the example of preview area 813 in Figure 18, the same sheet name is used in two files, while in the example of preview area 813 in Figure 22, the same sheet name is used in six files.

[0207] In this way, the server device 1 generates an integrated table by arranging the layout-defined data vertically in the selected division unit. The integrated table may also extend in the column direction by transposing the rows and columns.

[0208] This improves the convenience of processing tabular data using a layout that defines the relationships between each cell in that tabular data. It also allows for the creation of integrated tables tailored to user needs.

[0209] Even when there are 6 tabular files, the server device 1 displays a file list, which is a folder or file search result, and accepts the selection of a tabular file from the file list, just as when there is 1 tabular file. The server device 1 outputs a list of header candidates for the integrated table, which is a combination of multiple layout-defined data extracted for each selected division unit, and accepts header editing operations for the output list of header candidates.

[0210] When server device 1 generates an integrated table based on a list of header candidates for which header editing operations have been performed, it can associate and save a layout file, a configuration file, and a file extraction information file with the integrated table. Furthermore, by reading the saved splitting units and header editing operations, the splitting units and header editing operations can be applied to the header candidate list screen.

[0211] Furthermore, similar to the case where there is one tabular file, the server device 1 can accept header editing operations such as moving a header candidate to a higher or lower position in the output list of header candidates, or selecting a header from the list of header candidates to display in the integrated table. In this case, by moving one header candidate to a higher or lower position than other header candidates, an integrated table can be generated in which one header candidate is displayed in a column to the left or right of the other header candidates, respectively.

[0212] Furthermore, similar to the case where there is only one tabular file, Server Device 1 obtains the folder path associated with the integrated table on the integrated table display screen where the integrated table has been output. Server Device 1 can then display the output file list, which is a list of files in the folder indicated by the obtained folder path.

[0213] Furthermore, similar to the case where there is one tabular file, Server Device 1 retrieves the search conditions associated with the integrated table on the integrated table display screen where the integrated table has been output. Server Device 1 can then display the output file list, which is a list of files resulting from the search results based on the retrieved search conditions.

[0214] Furthermore, similar to the case where there is one tabular file, the server device 1 can display a screen in which a previously created header candidate for the integrated table is selected from the list of header candidates for the integrated table displayed based on the tabular file selected from the list of output files.

[0215] In the above configuration, program 1P and tabular linked data 60 are stored in the storage unit 14 of server device 1, and the control unit 11 of server device 1 executes the processing of program 1P. However, for example, program 1P and tabular linked data 60 may be stored in the storage unit 24 of terminal device 2, and the control unit 21 of terminal device 2 may execute the processing of program 1P in a standalone manner without using the network 3. Alternatively, part of program 1P may be executed in terminal device 2, and the other part of program 1P may be executed in server device 1, so that terminal device 2 and server device 1 operate in cooperation.

[0216] According to the program 1P, the information processing method related to program 1P, and the information processing device (server device) 1 in the form of this disclosure, the convenience of processing that uses tabular data and a layout that defines the relationships between each cell of that tabular data can be further enhanced.

[0217] Furthermore, the program of Program 1P may be referred to as a program product, software, or software product, which may be provided on a recording medium or provided in a form distributed via a communication network.

[0218] The forms of this disclosure are illustrative in all respects and not restrictive. The scope of the invention is not limited to those shown in the above disclosure but is shown by the claims, and all modifications within the meaning and scope equivalent to the claims are intended.

[0219] Furthermore, the sequences shown in each embodiment described above are not limited, and within a reasonable scope, the order of each processing step may be changed, and multiple processes may be executed in parallel. The processing entity for each process is not limited, and within a reasonable scope, the processing of each device may be executed by other devices.

[0220] The matters described in each embodiment can be combined with each other. Furthermore, the independent claims and dependent claims described in the claims can be combined with each other in any combination, regardless of the form of reference. In addition, although the claims do not use the form of a multi-claim that further references a multi-claim (multi-multi-claim), it may be a combination that uses the form of a multi-multi-claim that references all higher-level claims. [Explanation of Symbols]

[0221] 1. Information processing device (server device) 11 Control Unit 12 Communications Department 13 Reading Unit 14 Storage section 15 Portable storage media 19 bus 1P Program (Program Product) 2. Information processing terminal (terminal device) 21 Control Unit 22 Communications Department 23 Reading section 24 Memory section 25 Portable storage media 26 Display section 27 Input section 29 bus 3 Network 60 Tabular Linked Data 61 Management files 62 Tabular File Storage Section 63 Layout file storage section 81. Screen (List of header candidates) 82 screens 83 screens 811 Data partitioning unit selection area 812 Header candidate list display area 8121 Header Name Field 8122 Count column 8123 Type field 8124 Edit Link 813 Preview Area 814 Save button 815 Preview button 816 Load Settings Button 817 File Extraction Information Confirmation Button 821 Folder path input field 824 File list area after first output 825 Second output file list area 831 Search criteria input field 92 Headline Parser 93. Sequential Parser 95 Table Parlor 951 Entire Table 952 Table Data Section

Claims

1. Display a list of files, which are the search results for a folder or file. From the aforementioned file list, the system accepts the selection of a tabular file containing tabular data associated with a layout that defines the relationships between multiple cells. A combined table is generated by combining multiple layout-defined data that are included in the tabular data and are defined as being subject to the layout. The folder path of the aforementioned folder or the search criteria for the file search results are associated with and saved in the generated integrated table. A program that instructs a computer to perform a process.

2. The integrated table is generated based on the header selected from the list of header candidates created from the aforementioned multiple predefined layout data. The program according to claim 1.

3. In the integrated table display screen where the integrated table is output, the folder path associated with the integrated table is obtained, Display the list of files after output, which is a list of files in the folder indicated by the aforementioned folder path. The program according to claim 1.

4. In the integrated table display screen where the integrated table is output, the search conditions associated with the integrated table are obtained, Display the list of files after output, which is the list of files found using the aforementioned search criteria. The program according to claim 1.

5. A button to display the list of output files is displayed on the integrated table display screen. The program according to claim 3 or 4.

6. The screen displays a list of header candidates for the integrated table, which is based on the tabular file selected from the list of output files, and shows a screen in which the header candidate for the integrated table that was previously created has been selected. The program according to claim 3 or 4.

7. If the integrated table is output based on the folder path associated with the integrated table or the tabular file selected from the file list displayed based on the search criteria, the integrated table will be saved in a new version. The program according to claim 3 or 4.

8. Display a list of files, which are the search results for a folder or file. From the aforementioned file list, the system accepts the selection of a tabular file containing tabular data associated with a layout that defines the relationships between multiple cells. A combined table is generated by combining multiple layout-defined data that are included in the tabular data and are defined as being subject to the layout. The folder path of the aforementioned folder or the search criteria for the file search results are associated with and saved in the generated integrated table. Information processing methods.

9. It includes a control unit, and the control unit is Display a list of files, which are the search results for a folder or file. From the aforementioned file list, the system accepts the selection of a tabular file containing tabular data associated with a layout that defines the relationships between multiple cells. A combined table is generated by combining multiple layout-defined data that are included in the tabular data and are defined as being subject to the layout. The folder path of the aforementioned folder or the search criteria for the file search results are associated with and saved in the generated integrated table. Information processing device.

Images