Information processing system, information processing method, and program

Abstract

The objective is to increase the processing speed required for printing a print target created using spreadsheet software. [Solution] A variable object setting information acquisition unit acquires variable object setting information including a plurality of print item data and input object data corresponding to each of the plurality of print item data; a first variable object in which a character string may be set and at least one of a second variable object in which a predetermined figure may be set, a plurality of fixed objects in which a character string and a predetermined figure are not set, and at least one of character string specifying tag information (character string tag information) indicating an association with the print item data, which is set in association with the first variable object, and figure tag information indicating an association with the print item data, which is set in association with the second variable object; and a target spreadsheet data acquisition unit acquires target spreadsheet data, which is spreadsheet data including at least one of character string specifying tag information (character string tag information) and figure tag information, which is set in association with the second variable object, and at least one of character string specifying tag information (character string tag information) and figure tag information, which is set in association with the print item data, and and a spreadsheet data processing unit that sets a character string or a specified figure for the fixed objects, executes processing related to either the character string or the specified figure, and generates variable object spreadsheet data, which is spreadsheet data for displaying a print screen that does not include at least one fixed object among the multiple fixed objects and is composed of at least either the character string or the specified figure.

Description

[Technical field]

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

[0002] 2. Description of the Related Art There is known a form output system that generates a customer form using general-purpose spreadsheet software (see, for example, Patent Document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2017-157124 A Summary of the Invention [Problem to be solved by the invention]

[0004] The form output system described in Patent Document 1 acquires customer form information composed of cells set as fixed items of a form and cells not set as fixed items. When acquiring customer form information, the form output system executes a color-coding process in which the background of cells set as fixed items (e.g., cells in which fixed wording such as item names are set) is colored green, and the background of cells not set as fixed items (e.g., cells in which variable wording such as personal names is set) is colored yellow. The form output system determines whether the wording is fixed or variable based on the coloring of the cells that have been subjected to the color-coding process, thereby making it possible to appropriately register the fixed wording and variable wording in a database.

[0005] Incidentally, in commercial printing for printing forms using spreadsheet software, it is required to print fixed parts (such as character strings and figures) whose cell input contents do not change, and variable parts whose cell input contents change according to input information, separately. This is because, for example, a printing object such as a form is usually configured such that the display area of ​​the fixed part is wider than the display area of ​​the variable part, and therefore, rather than printing the fixed part and the variable part as one data, it is possible to increase the printing processing speed by separating the fixed part and the variable part, printing the fixed part with a printer with a high printing speed, and printing the variable part on the mount on which the fixed part is printed. However, the form output system described in Patent Document 1 distinguishes between fixed wording and variable wording, and cannot separate the printing processing of the fixed wording and the variable wording, and therefore cannot increase the processing speed for printing the printing object.

[0006] SUMMARY OF THE PRESENT EMBODIMENTS It is therefore an object of the present invention to increase the processing speed required for printing a print object generated by spreadsheet software. [Means for solving the problem]

[0007] An information processing system according to an aspect of the present invention includes a variable object setting information acquisition unit that acquires variable object setting information including a plurality of print item data and input object data corresponding to each of the plurality of print item data, a target spreadsheet data acquisition unit that acquires target spreadsheet data, which is spreadsheet data including at least one of a first variable object to which a character string may be set and a second variable object to which a predetermined figure may be set, a plurality of fixed objects to which the character string and the predetermined figure are not set, and at least one of character string tag information that is set in association with the first variable object and indicates a relationship with the print item data, and figure tag information that is set in association with the second variable object and indicates a relationship with the print item data, and a target spreadsheet data acquisition unit that acquires the character string tag information and the figure tag information. and a spreadsheet data processing unit that sets the character string or the specified figure for at least one of the first variable target and the second variable target on a screen displayed based on the target spreadsheet data, or sets the character string or the specified figure for a setting position corresponding to a position of at least one of the first variable target and the second variable target on a screen displayed based on the target spreadsheet data, based on at least one of the information in the variable target setting information, the print item data in the variable target setting information, and the input target data corresponding to the print item data, to generate variable target spreadsheet data that does not include at least one fixed target among the multiple fixed targets and is configured with at least one of the character strings and the specified figure.

[0008] An information processing method according to one aspect of the present invention includes a computer acquiring variable object setting information including a plurality of print item data and input object data corresponding to each of the plurality of print item data, acquiring target spreadsheet data which is spreadsheet data including at least one of a first variable object to which a character string may be set and a second variable object to which a predetermined figure may be set, a plurality of fixed objects to which the character string and the predetermined figure are not set, and at least one of character string tag information indicating an association with the print item data, which is set in association with the first variable object, and figure tag information indicating an association with the print item data, which is set in association with the second variable object, and acquiring at least one of the character string tag information and the figure tag information. The method executes the steps of: setting the character string or the specified figure for at least one of the first and second variable targets on a screen displayed based on the target spreadsheet data based on at least one of the print item data in the variable target setting information and the input target data corresponding to the print item data, or setting the character string or the specified figure for a setting position corresponding to the position of at least one of the first and second variable targets on a screen displayed based on the target spreadsheet data, thereby generating variable target spreadsheet data that does not include at least one fixed target among the multiple fixed targets and is composed of at least one of the character strings and the specified figure.

[0009] A program according to one aspect of the present invention causes a computer to acquire variable object setting information including a plurality of print item data and input object data corresponding to each of the plurality of print item data, acquire target spreadsheet data which is spreadsheet data including at least one of a first variable object to which a character string may be set and a second variable object to which a predetermined figure may be set, a plurality of fixed objects to which the character string and the predetermined figure are not set, and at least one of character string tag information which is set in association with the first variable object and indicates an association with the print item data, and figure tag information which is set in association with the second variable object and indicates an association with the print item data, and acquire target spreadsheet data which is spreadsheet data including at least one of the character string tag information and the figure tag information, and based on at least one of the print item data in the variable object setting information and the input target data corresponding to the print item data, setting the character string or the specified figure for at least one of the first variable object and the second variable object on a screen displayed based on the target spreadsheet data, or setting the character string or the specified figure for a setting position corresponding to the position of at least one of the first variable object and the second variable object, thereby generating variable object spreadsheet data, which is spreadsheet data for displaying a print screen that does not include at least one fixed object among the multiple fixed objects and is composed of at least one of the character string and the specified figure. Effect of the Invention

[0010] According to the present invention, it is possible to increase the processing speed for printing a print target generated by spreadsheet software. [Brief description of the drawings]

[0011] [Figure 1] FIG. 1 illustrates an example of a configuration of a print output adjustment system. [Diagram 2] FIG. 13 is a diagram showing an example of spreadsheet information D111. [Diagram 3] FIG. 11 is a flowchart illustrating an example of a processing procedure of the print output adjustment system. [Figure 4] FIG. 13 is a diagram showing an example of a screen T10 displayed based on target spreadsheet data. [Diagram 5] FIG. 13 is a diagram showing an example of a screen T20 displayed based on fixed deleted target spreadsheet data. [Figure 6] FIG. 13 is a diagram showing an example of a screen T30 displayed based on variable target spreadsheet data. [Figure 7] FIG. 13 is a diagram showing an example of a screen T40 displayed based on variable target spreadsheet data reflecting input target data. [Figure 8] FIG. 13 is a diagram showing an example of a screen T50 displayed based on mount spreadsheet data. [Figure 9] FIG. 13 is a diagram illustrating an example of the configuration of a print output adjustment system according to a modified example. [Figure 10] 13 is a diagram showing an example of variation in the layout of a fixed target T12. FIG. [Figure 11] FIG. 2 illustrates an example of a hardware configuration of a computer. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] A preferred embodiment of the present invention (hereinafter, referred to as "the present embodiment") will be described with reference to the attached drawings. In each drawing, the same reference numerals are used to denote the same or similar configurations. In this embodiment, "part", "means", "apparatus", and "system" do not simply mean physical means, but also include cases where the functions of the "part", "means", "apparatus", and "system" are realized by software. In addition, the functions of one "part", "means", "apparatus", or "system" may be realized by two or more physical means or devices, and the functions of two or more "parts", "means", "apparatus", or "system" may be realized by one physical means or device.

[0013] ===Configuration of print output adjustment system 100=== <<Overview>> The print output adjustment system 100 is a system for achieving high speed and low cost printing in, for example, commercial printing. In general, commercial printing employs, for example, on-demand printing and offset printing.

[0014] On-demand printing is a high-speed printing method that is executed, for example, by a large printer and has a high printing cost. On-demand printing is a printing method that can print the print target, for example, Portable Document Format (PDF) data, and is a printing method that can print multiple print targets with different print contents in a single operation.

[0015] Offset printing is a type of lithographic printing that is faster than on-demand printing and has a lower unit price. Because offset printing is a lithographic printing method, it cannot be applied to printing multiple print objects with different print contents, but it is a printing method that can efficiently print a single print content in large quantities.

[0016] For example, in a commercial printing situation where application forms for each of a large number of applicants are printed, application forms that reflect the application contents of each applicant are printed. Application forms include printing objects that vary depending on the applicant (hereinafter referred to as "variable objects") and printing objects that do not vary depending on the applicant (hereinafter referred to as "fixed objects"). Variable objects are objects into which different character strings, etc. are set depending on the applicant, such as objects into which name, date of birth, and selected fields are input. Fixed objects are objects into which different character strings, etc. are not set depending on the applicant, such as the area that serves as the backing for the application form.

[0017] When printing such applications commercially, printing a single PDF file containing both variable and fixed objects on demand results in significantly higher printing costs (ink costs, etc.). In addition, in this case, printing a fixed object, which has a larger data volume than the variable object, on demand together with the variable object takes longer than offset printing.

[0018] Therefore, in commercial printing by printing businesses, there is a demand for offset printing of fixed objects and on-demand printing of variable objects to reduce printing costs and speed up printing. To achieve this, printing businesses acquire PDF data of only variable objects and PDF data of only fixed objects, and perform on-demand printing and offset printing of each PDF data. Specifically, the printing business offset prints the required number of copies of PDF data of only fixed objects, sets the printed product of only fixed objects in an on-demand printing machine, and then performs on-demand printing of only variable objects on the printed product of only fixed objects.

[0019] However, the spreadsheet data created with spreadsheet software that is the source of the print target (PDF data) is data that combines variable targets (such as name and address) and fixed targets (such as the area that becomes the backing paper) for each applicant. Therefore, in order to separate the variable targets from the fixed targets in the spreadsheet data, the user must manually extract the variable targets and create spreadsheet data that is composed of the variable targets (hereinafter referred to as "variable target spreadsheet data"). It is difficult and takes a huge amount of time for the user to manually set the positions of variable targets and cell sizes in spreadsheet data.

[0020] Therefore, the print output adjustment system 100 automatically separates and generates variable object spreadsheet data composed of variable objects and spreadsheet data composed of fixed objects (hereinafter referred to as "mount spreadsheet data").

[0021] At this time, the print output adjustment system 100 sets information (hereinafter referred to as "tag information") that can identify cells and figures that are subject to change and are included in the spreadsheet data that is subject to change, based on the user's operational input.

[0022] Then, the print output adjustment system 100 creates a variable target spreadsheet data in which the position of the variable target and the size of the cell are the same as those of the original spreadsheet data to be printed by setting character strings and figures for the variable target based on the tag information. Similarly, the print output adjustment system 100 creates mount spreadsheet data in which character strings and figures set as the variable target based on the tag information are deleted from the original spreadsheet data to be printed.

[0023] This makes it possible for the print output adjustment system 100 to convert each of the variable object spreadsheet data containing only variable objects and the mount spreadsheet data containing only fixed objects into PDF data and provide the PDF data to the printing business operator.

[0024] The spreadsheet software is software that generates spreadsheet data by arranging a large number of cells in a grid pattern to form multiple rows and columns. Specifically, the spreadsheet software is, for example, Microsoft Excel (hereinafter, referred to as "Excel").

[0025] In the following, the spreadsheet data including the fixed target and the tag information is referred to as "target spreadsheet data".

[0026] In the following, the variable object in which a character string is set (for example, a cell on an Excel sheet) is referred to as the "first variable object," and the variable object in which a specific shape is set is referred to as the "second variable object." Note that in the following, when simply referring to a "variable object," it refers to at least either the first variable object or the second variable object.

[0027] In the following, tag information associated with the first variable object is referred to as "character string tag information," and tag information associated with the second variable object is referred to as "graphic tag information." Note that when simply referring to "tag information," it refers to at least either character string tag information or graphic tag information.

[0028] The print output adjustment system 100 may be, for example, a cloud computer, a server computer, a personal computer (e.g., a desktop, a laptop, a tablet, etc.), a media computer platform (e.g., a cable or satellite set-top box, a digital video recorder), a handheld computer device (e.g., a PDA, an email client, etc.), or any other type of computer or communication platform. At least a portion of the processing in the print output adjustment system 100 may be implemented by one or more computers (for example, but not limited to, cloud computing configured by one or more computers).

[0029] <<Configuration>> The configuration of the print output adjustment system 100 will be described with reference to Fig. 1. Fig. 1 is a diagram showing an example of the configuration of the print output adjustment system 100. As shown in Fig. 1, the print output adjustment system 100 includes, for example, a storage unit 110, a variable target setting information acquisition unit 120, a target spreadsheet data acquisition unit 130, a spreadsheet data processing unit 140, and a display processing unit 150.

[0030] The storage unit 110 includes spreadsheet information D111. The configuration of the spreadsheet information D111 will be described with reference to Fig. 2. Fig. 2 is a diagram showing an example of the spreadsheet information D111. The spreadsheet information D111 is a database that the print output adjustment system 100 refers to when creating mount spreadsheet data and variable target spreadsheet data from target spreadsheet data. The spreadsheet information D111 also stores data created by each functional unit.

[0031] 2, the spreadsheet information D111 may include items such as [Spreadsheet Data ID], [Target Spreadsheet Data], [Tag Information], [Variable Target Setting Information], [Variable Target Spreadsheet Data], and [Paper Spreadsheet Data]. [Spreadsheet Data ID] is an item that stores identification information that can uniquely identify the target spreadsheet data. [Target Spreadsheet Data] is an item that stores, for example, the target spreadsheet data.

[0032] [Tag information] is an item that stores tag information included in the target spreadsheet data. The tag information is stored in association with cells and shapes (including text boxes) that are variable and are included in the target spreadsheet data. The tag information may include information that can identify a position on an Excel sheet, such as information that can identify the row and column of a cell (e.g., (column A, row 2)) or information that indicates the position of a shape on an Excel sheet.

[0033] Specifically, the tag information is, for example, information indicating a character string that is not normally used, such as "%{XX}" as character string tag information, and in this case, the information is "%{" or "%{}". In this case, for example, the column name of the variable target setting information described later (the name of the print item data described later) is entered in the "XX" of %{XX}. In addition, the tag information may be, for example, a comment set in a cell as graphic tag information, such as a comment such as "When the gender is female (2), make the dotted line a solid line". In addition, the tag information may be, for example, a formula set in a cell, or a conditional format set in a cell.

[0034] [Variation target setting information] is an item that stores information (hereinafter referred to as "variation target setting information") that is set as a variation target for the target spreadsheet data, and is acquired from the business operator by the variation target setting information acquisition unit 120 described later. The variation target setting information is information acquired from the business operator, and is, for example, a CSV (Comma-Separated Values) file, XML (Extensible Markup Language) data, JSON (JavaScript Object Notation) data, etc.

[0035] The variable target setting information is information including, for example, a plurality of item data (hereinafter referred to as "print item data") and a plurality of data indicating character strings corresponding to each of the plurality of print item data (hereinafter referred to as "input target data"). The print item data is the name of a column, for example, data items such as "Name" and "Age". The input target data is print data such as "Yamada Taro" and "20 years old". The input target data includes figure-related data related to the display mode of figures in the figure tag information. For example, when the figure tag information is "Make the dotted line a solid line when the gender is female (2)", the figure-related data is "2" indicating gender.

[0036] [Spreadsheet data subject to change] is an item for storing spreadsheet data subject to change created from the target spreadsheet data by the spreadsheet data processing unit 140 described later.

[0037] [Mount Spreadsheet Data] is an item for storing mount spreadsheet data created from the target spreadsheet data by the spreadsheet data processing unit 140, which will be described later.

[0038] The variation target setting information acquisition unit 120 acquires variation target setting information from the business operator.

[0039] The target spreadsheet data acquiring unit 130 acquires the target spreadsheet data from a predetermined system. Note that, in the case where the print output adjustment system 100 includes a target spreadsheet data generating unit that generates the target spreadsheet data as described below, the target spreadsheet data acquiring unit 130 may acquire the target spreadsheet data from the storage unit 110.

[0040] The spreadsheet data processing unit 140 executes a predetermined process for either the character string or the predetermined graphic on the basis of the variation object setting information and the tag information, thereby generating variation object spreadsheet data.

[0041] Specifically, the spreadsheet data processing unit 140 identifies the variable objects of a screen (for example, a screen T10 in FIG. 4 described later) displayed on the display unit based on the tag information of the target spreadsheet data. The spreadsheet data processing unit 140 generates spreadsheet data from which fixed objects other than the variable objects have been deleted based on the tag information (hereinafter referred to as "fixed and deleted spreadsheet data").

[0042] Then, the spreadsheet data processing unit 140 sets input target data of the variation target setting information based on the string tag information for the first variation target (for example, the cell of the variation target T11a in FIG. 5) on a screen (for example, screen T20 in FIG. 5) displayed based on the fixed deleted spreadsheet data.

[0043] Furthermore, the spreadsheet data processing unit 140 sets a figure (e.g., a solid line) indicated by the figure tag information based on the input target data of the variable target setting information for a second variable target (e.g., variable target T11c or variable target T11d shown by dashed lines in FIG. 5) on the screen displayed on the display unit based on the fixed deleted target spreadsheet data. Note that the process of "setting a figure" includes a process of deleting a figure. In other words, the spreadsheet data processing unit 140 may delete a specified figure based on the figure tag information.

[0044] This allows the print output adjustment system 100 to generate variable target spreadsheet data that is made up of variable targets that are set at the same positions on the Excel sheet as the positions of the variable targets on the mount (such as the positions of cells and figures). Therefore, the print output adjustment system 100 can limit the targets of on-demand printing to variable targets only, making it possible to significantly reduce the costs associated with on-demand printing. The spreadsheet data processing unit 140 may generate variable target spreadsheet data that includes a portion of a fixed target.

[0045] In the above, it has been described that the spreadsheet data processing unit 140 generates the fixed deleted spreadsheet data from the target spreadsheet data, and then generates the variable target spreadsheet data from the fixed deleted spreadsheet data, but this is not limited to the above.

[0046] For example, the spreadsheet data processing unit 140 may execute a process of setting input target data for the variable target of the target spreadsheet data based on tag information, and then may identify the variable target based on the tag information to delete the fixed target, thereby generating the variable target spreadsheet data. The specific process in this case will be described later.

[0047] Also, for example, the spreadsheet data processing unit 140 may execute a process of setting input target data for the variable target of the target spreadsheet data based on tag information, and then generate the variable target spreadsheet data by reflecting the variable target on a blank Excel sheet based on the tag information (information indicating the position of the variable target). Specific processing in this case will be described later.

[0048] Then, the spreadsheet data processing unit 140 identifies the variable objects in the target spreadsheet data based on the tag information, deletes the variable objects and tag information from the target spreadsheet data, and generates mount spreadsheet data (for example, screen T50 in Figure 8 described later) composed of fixed objects.

[0049] The display processing unit 150 generates information for displaying various screens on the display unit.

[0050] ===Processing Procedure=== The processing procedure of the print output adjustment system 100 will be described with reference to Figs. 3 to 7. Fig. 3 is a diagram showing an example of a flowchart showing the processing procedure of the print output adjustment system 100. Fig. 4 is a diagram showing an example of a screen T10 displayed based on the target spreadsheet data. Fig. 5 is a diagram showing an example of a screen T20 displayed based on the fixed deleted target spreadsheet data. Fig. 6 is a diagram showing an example of a screen T30 displayed based on the variable target spreadsheet data. Fig. 7 is a diagram showing an example of a screen T40 displayed based on the variable target spreadsheet data in which the input target data is reflected. Fig. 8 is a diagram showing an example of a screen T50 displayed based on the mount spreadsheet data.

[0051] In step S100, the print output adjustment system 100 acquires the target spreadsheet data from a predetermined system. Alternatively, the print output adjustment system 100 may acquire the target spreadsheet data from the storage unit 110.

[0052] A screen T10 displayed on the display unit based on the target spreadsheet data will be described with reference to Fig. 4. Screen T10 includes a variable object T11, a fixed object T12, and tag information T13.

[0053] The variation target T11 is a target in which input target data, which is different for each row of the variation target setting information, is set. In Fig. 4, the variation target T11 includes, for example, a character string variation target T11a (e.g., corresponding to the first variation target), a calculation variation target T11b (e.g., corresponding to the first variation target), a graphic variation target T11c (e.g., corresponding to the second variation target), and a display variation target T11d (e.g., corresponding to the second variation target).

[0054] The character string variation object T11a is composed of at least one cell, and is a cell into which a character string is input. The calculation variation object T11b is a cell into which a calculation formula is set. The graphic variation object T11c is an object displayed in a predetermined graphic form, and in FIG. 4, as an example, is an object into which a solid line is set. The display variation object T11d is, for example, an object composed of a text box into which text is input, and in FIG. 4, as an example, is a text box into which "*" is input.

[0055] The fixed object T12 is, for example, a paper area such as an application form, and is an area whose contents and format do not change depending on the applicant. In Fig. 4, the fixed object T12 includes, for example, an explanation T12a explaining the application contents, an area T12b displaying the calculation result of the total amount, an area T12c for selecting the gender, and an area T12d for selecting the plan.

[0056] The tag information T13 is, for example, information for identifying a moving target. In Fig. 4, the tag information T13 includes, for example, a first character string tag information T13a, a second character string tag information T13b, a first figure tag information T13c, and a second figure tag information T13d.

[0057] The first character string tag information T13a is tag information that can identify that a character string to be changed is input, and is shown as "%{" in Fig. 4 as an example. That is, information indicating the association with the print item data of the change target setting information is input into the first character string tag information T13a. For example, if "%{XX}" is input, the column name, which is the print item data, is input into XX.

[0058] The second character string tag information T13b is tag information that can identify that a formula to be varied has been input, and is, for example, information indicating a formula. In FIG. 4, "=P30+P40" is shown as an example. That is, information indicating a relationship with the print item data of the variation target setting information is input into the second character string tag information T13b. For example, since numerical values ​​corresponding to the columns of the print item data are input into the cells indicated by P30 and P40, the formula "=P30+P40" of the second character string tag information T13b can be said to be indirectly related to the print item data of the variation target setting information, and therefore can be said to be information indicating a relationship with the print item data information.

[0059] The first graphic tag information T13c is tag information indicating the display mode of the graphic of the variable object, and in FIG. 4, as an example, there are comments such as "When the gender is female (2), change the dotted line to a solid line" and "When T11 is selected, change the dotted line to a solid line." That is, information indicating the association with the print item data of the variable object setting information is inputted into the first graphic tag information T13c. Note that in FIG. 4, the first graphic tag information T13c is shown as being displayed in a balloon on the screen T10, but this is not limiting, and the first graphic tag information T13c does not need to be displayed on the screen T10, and it is sufficient if it is set in association with the graphic variable object T11c (for example, it is sufficient if it can be displayed and confirmed on the management screen).

[0060] The second graphic tag information T13d is tag information indicating the display mode of the text box of the variable object, and in Fig. 4, an example is a comment "If T10 or T11 is selected, delete *". That is, information indicating the association with the print item data of the variable object setting information is input to the second graphic tag information T13d. Note that in Fig. 4, the second graphic tag information T13d is shown as being displayed in a balloon on the screen T10, but is not limited to this, and the second graphic tag information T13d does not need to be displayed on the screen T10, and may be set in association with the display variable object T11d.

[0061] In step S101, the print output adjustment system 100 acquires variable target setting information from the business operator. As an example, the variable target setting information includes a plurality of input target data, such as name, address, sex, and selected plan, with each input target data being one line of information. The print output adjustment system 100 stores the variable target setting information in the storage unit 110.

[0062] In step S102, the print output adjustment system 100 deletes the fixed target from the target spreadsheet data based on, for example, the variable target setting information and the tag information, to generate the fixed-deleted spreadsheet data.

[0063] The process of deleting fixed objects from target spreadsheet data to generate fixed deleted spreadsheet data will be described with reference to FIGS.

[0064] The spreadsheet data processing unit 140 identifies a variation target related to the character string tag information and the graphic tag information. Specifically, in Fig. 4, the spreadsheet data processing unit 140 identifies a character string variation target T11a related to the first character string tag information T13a, identifies a calculation variation target T11b related to the second character string tag information T13b, identifies a graphic variation target T11c related to the first graphic tag information T13c, and identifies a display variation target T11d related to the second graphic tag information T13d.

[0065] The spreadsheet data processing unit 140 specifies, as fixed objects, objects other than the variable object specified based on the tag information. The spreadsheet data processing unit 140 deletes the specified fixed object from the target spreadsheet data to generate the fixed-deleted target spreadsheet data shown in Fig. 5. Note that the spreadsheet data processing unit 140 also specifies, for example, the cell borders of the character string variable object T11a and the calculation variable object T11b as fixed objects.

[0066] In step S103, the print output adjustment system 100 generates variable target spreadsheet data by reflecting the input target data in the fixed deleted target spreadsheet data, for example, based on tag information, print item data of the variable target setting information, and input target data of a specified row of the variable target setting information.

[0067] The process of reflecting input target data of a predetermined row of the variable target setting information in the fixed deleted spreadsheet data will be described with reference to FIGS.

[0068] The spreadsheet data processing unit 140 identifies that the character string "%{", which is character string tag information that can identify a variation target, has been input into a cell (input area) of the character string variation target T11a shown in FIG. 5. When the spreadsheet data processing unit 140 identifies "%{", it identifies "XX" of "%{XX}". Then, the spreadsheet data processing unit 140 identifies print item data that is the same as "XX" (here, the "Name" item) among multiple print item data of the variation target setting information. The spreadsheet data processing unit 140 identifies input target data that corresponds to the identified print item data. As shown in FIG. 6, the spreadsheet data processing unit 140 inputs the input target data "Yamada Taro" into the character string variation target T11a.

[0069] More specifically, the spreadsheet data processing unit 140 identifies that a calculation formula that can be identified as a variation object has been input into a cell (input area) of the calculation variation object T11b shown in Fig. 5. When the spreadsheet data processing unit 140 identifies the calculation formula that is character string tag information, it identifies a number indicating the calculation result. Then, as shown in Fig. 6, the spreadsheet data processing unit 140 inputs the number "15,000" indicating the calculation result into the calculation variation object T11b.

[0070] More specifically, the spreadsheet data processing unit 140 identifies the comment, which is the graphic tag information shown in Fig. 5, and the object to which the comment is associated. The spreadsheet data processing unit 140 identifies the object to which the comment, which is the graphic tag information, is associated as the second variable object. For example, as shown in Fig. 6, when the spreadsheet data processing unit 140 identifies that the input target data of the print item data of "gender" in the variable object setting information is "2", it makes the graphic of the graphic variable object T11c to which the first graphic tag information T13c (see Fig. 4) is associated a solid line.

[0071] More specifically, when the spreadsheet data processing unit 140 specifies that the data item of the basic plan of the input data is "1" for the individual and "T11" for the plan, it deletes the text box that is the display change target T11d associated with the second graphic tag information T13d (see FIG. 4) as shown in FIG 6. In this case, the spreadsheet data processing unit 140 does not delete the text box that is the display change target T11d associated with "Family" in FIG 4.

[0072] In this way, the print output adjustment system 100 can generate variation target spreadsheet data in which the variation target is placed at the same position as the position of the variation target in the target spreadsheet data.

[0073] Here, other processing for generating the variable target spreadsheet data will be described with reference to Fig. 6 and Fig. 7. The spreadsheet data processing unit 140 may generate the variable target spreadsheet data by, for example, specifying the variable target after reflecting the input target data in the target spreadsheet data. Hereinafter, the first processing method and the second processing method, which are other processing methods, will be described.

[0074] The first processing method will be described. The spreadsheet data processing unit 140 specifies the variable object of the target spreadsheet data shown in FIG. 7 in which the input target data of a predetermined row is reflected, based on the tag information. That is, the spreadsheet data processing unit 140 specifies the object (for example, an input area that is a cell or a figure) with which the tag information is associated as the variable object. The spreadsheet data processing unit 140 executes a process of deleting the fixed object, which is an object other than the specified variable object, to generate the variable object spreadsheet data shown in FIG. 6. In this way, the print output adjustment system 100 can generate variable object spreadsheet data in which the variable object is placed at the same position as the variable object in the target spreadsheet data.

[0075] The second processing method will be described. The spreadsheet data processing unit 140, for example, identifies the positions (hereinafter referred to as "character string positions") indicating the row and column of the cell on the Excel sheet to which the first character string tag information T13a and the second character string tag information T13b shown in FIG. 4 were set. Specifically, the spreadsheet data processing unit 140 identifies the character string positions (hereinafter referred to as "character string positions") indicating the row and column of the cell of the variable object T11a and the variable object T11b shown in FIG. 7. In addition, the spreadsheet data processing unit 140 identifies the positions (hereinafter referred to as "character string positions") of the figures or text boxes to which the first figure tag information T13c and the second figure tag information T13d shown in FIG. 4 are associated. Specifically, the spreadsheet data processing unit 140 identifies the character string positions (hereinafter referred to as "character string positions") of the figures of the variable object T11c and the text boxes of the variable object T11d shown in FIG. 7.

[0076] Then, the spreadsheet data processing unit 140 prepares a blank Excel sheet in advance, and sets the character strings and the calculation results corresponding to the first character string tag information T13a and the second character string tag information T13b at the set positions on the sheet that correspond to the character string positions. Specifically, the spreadsheet data processing unit 140 sets the character strings and the calculation results shown in the cells of the variable objects T11a and T11b shown in FIG. 6. Also, the spreadsheet data processing unit 140 sets the above-mentioned figure or text box at the set positions that correspond to the figure positions of the figure or text box on the sheet. Specifically, the spreadsheet data processing unit 140 sets, for example, the variable objects T11c and T11d shown in FIG. 6. This allows the print output adjustment system 100 to generate variable object spreadsheet data in which the variable object is placed at the same position as the position of the variable object in the target spreadsheet data.

[0077] In step S104, the print output adjustment system 100 creates mount spreadsheet data composed of fixed targets shown in FIG. 8 from the target spreadsheet data shown in FIG.

[0078] Specifically, the spreadsheet data processing unit 140 deletes the character string tag information and the second variable object set based on the graphic tag information from the target spreadsheet data shown in Fig. 4, and generates mount spreadsheet data consisting of fixed objects (for example, screen T50 in Fig. 8). In other words, the spreadsheet data processing unit 140 identifies information not associated with tag information as a fixed object, and creates mount spreadsheet data consisting of fixed objects. In this case, the spreadsheet data processing unit 140 may prepare a blank Excel sheet in advance, and create mount spreadsheet data by reflecting the fixed object on the sheet.

[0079] In step S105, the print output adjustment system 100 converts each of the variable spreadsheet data and the mount spreadsheet data into PDF data.

[0080] In step S106, the print output adjustment system 100 judges whether or not the variation spreadsheet calculation data has been created for the input target data of all rows of the variation target setting information (individual data for which variation spreadsheet calculation data is to be created) (for example, the spreadsheet data processing unit 140 judges). For example, if the print output adjustment system 100 has not created the variation spreadsheet calculation data for the input target data of all rows (step S106: NO), the print output adjustment system 100 increments the row of the variation target setting information and repeats the process from step S102.

[0081] More specifically, in this case, the variation target setting information acquisition unit 120 acquires variation target setting information (e.g., CSV) including multiple input target data corresponding to each of the multiple print item data, with each input target data among the multiple input target data being described on one line. The spreadsheet data processing unit 140 judges whether or not variation target spreadsheet data has been generated for all rows of input target data included in the variation target setting information. Then, when the spreadsheet data processing unit 140 judges that variation target spreadsheet data has not been generated for all of the multiple input target data, it repeats the process from step S102 for the input target data corresponding to the row incremented by the row of the input target data in the variation target setting information.

[0082] In this way, the print output adjustment system 100 can generate variation target spreadsheet data for each of the input target data in the variation target setting information.

[0083] === Variations === A print output adjustment system 100a according to a modified example will be described with reference to Fig. 9 and Fig. 10. Fig. 9 is a diagram showing an example of the configuration of the print output adjustment system 100a according to the modified example. Fig. 10 is a diagram showing an example of variation in the layout of a fixed target T12.

[0084] 9, the print output adjustment system 100a according to the modified example further includes a spreadsheet data generating unit 160 in addition to the print output adjustment system 100. The function of the spreadsheet data generating unit 160 will be described below.

[0085] <<First Modification>> The spreadsheet data generating unit 160 generates target spreadsheet data based on a user's operation input. Specifically, the spreadsheet data generating unit 160 generates target spreadsheet data by adding tag information (for example, "%{}" or "comment" in FIG. 4) to a variable object (cell or object) by accepting a user's operation input on a screen displayed based on spreadsheet data that does not include tag information. The spreadsheet data generating unit 160 stores the generated target spreadsheet data in the storage unit 110.

[0086] <<Second Modification>> The spreadsheet data generating unit 160 may have a function capable of changing the display pattern of the mount spreadsheet data. That is, the spreadsheet data generating unit 160 has a function capable of changing the display pattern on the screen displayed based on the mount spreadsheet data. Specifically, the spreadsheet data generating unit 160 acquires display mode identification information indicating the display mode of the display format on the screen displayed based on the mount spreadsheet data. The spreadsheet data generating unit 160 changes the display format to a predetermined display mode based on the display mode identification information. For example, when the display mode identification information is information indicating the number of rows of a table, the spreadsheet data generating unit 160 changes a table with a display mode of multiple rows to the number of rows indicated by the display mode identification information. This allows the print output adjustment system 100 to easily generate mount spreadsheet data composed of fixed targets in multiple display modes in the process of generating target spreadsheet data, thereby improving user convenience.

[0087] <<Third Modification>> Furthermore, the spreadsheet data generating unit 160 may vary the layout of the fixed object T12 to which the variable object T11 may be input, based on the variable object setting information and the display mode identification information. An example of a process for varying the layout of the fixed object T12 will be described with reference to FIG.

[0088] Figure 10 (A) shows the display mode of area T12d (a partial excerpt of area T12d where a plan is selected in Figure 4) that can become a fixed target T12 when the variable target setting information includes "Individual plan: T10", "Individual plan: T11", "Family plan: T20" or "Family plan: T21".

[0089] Fig. 10(B) shows the display mode of the area T12d that can be the fixed object T12 when the variable object setting information includes ""individual plan":"T10"" or ""individual plan":"T11". In other words, Fig. 10(B) shows the display mode of the area T12d when the variable object setting information does not include ""family plan":"T20"" or ""family plan":"T21".

[0090] Fig. 10(C) shows the display mode of the area T12d that can be the fixed object T12 when the variable object setting information includes "Family Plan: T20" or "Family Plan: T21". In other words, Fig. 10(C) shows the display mode of the area T12d when the variable object setting information does not include "Individual Plan: T10" or "Individual Plan: T11".

[0091] The display mode identification information is identification information that can uniquely identify the layout of the fixed object T12. Specifically, the display mode identification information is, for example, "Basic plan #if(%{individual plan})-individual #end #if(%{family plan})-family #end."

[0092] Specifically, when the variable target setting information includes ""individual plan":"T10", "family plan":"T21", the spreadsheet data generating unit 160 determines, based on the display mode identification information, that there is input in the columns for the personal plan and the family plan in the area T12d. That is, the spreadsheet data generating unit 160 determines that the mount spreadsheet data includes an area T12d1 which is a display area when there is a personal plan, and an area T12d2 which is a display area when there is a family plan. In this case, for example, the spreadsheet data generating unit 160 specifies "basic plan-individual-family" as an identifier.

[0093] Then, based on the identifier specified by the spreadsheet data generating unit 160, the spreadsheet data processing unit 140 generates mount spreadsheet data (in this case, screen T50 in FIG. 8) including the area T12d1 and the area T12d2 shown in FIG.

[0094] Similarly, if the variation target setting information includes ""individual plan":"T10"" but does not include ""family plan":"T20"" and ""family plan":"T21"", the spreadsheet data generation unit 160 determines that there is an input in the column for the individual plan in the area T12d based on the display mode identification information. That is, the spreadsheet data generation unit 160 determines that the area includes area T12d1, which is the display area when there is an individual plan, but does not include area T12d2, which is the display area when there is a family plan. In this case, for example, the spreadsheet data generation unit 160 specifies "basic plan-individual included" as the identifier.

[0095] Then, based on the identifier specified by the spreadsheet data generating unit 160, the spreadsheet data processing unit 140 generates mount spreadsheet data that includes the area T12d1 but does not include the area T12d2, as shown in FIG. 10(B).

[0096] Similarly, if the variation target setting information includes "Family Plan: T21" but does not include "Individual Plan: T10" and "Individual Plan: T11", the spreadsheet data generation unit 160 determines that there is an input in the family plan column in the area T12d based on the display mode identification information. That is, the spreadsheet data generation unit 160 determines that the area includes area T12d2, which is the display area when there is a family plan, but does not include area T12d1, which is the display area when there is a personal plan. In this case, for example, the spreadsheet data generation unit 160 determines that "Basic Plan-With Family" is the identifier.

[0097] Then, based on the identifier specified by the spreadsheet data generating unit 160, the spreadsheet data processing unit 140 generates mount spreadsheet data that includes the area T12d2 but does not include the area T12d1, as shown in FIG. 10(C).

[0098] Similarly, if the variation target setting information does not include information indicating the "individual plan" and the "family plan", the spreadsheet data generating unit 160 determines that there is no input in the columns for the individual plan and the family plan in the area T12d based on the display mode identification information. That is, the spreadsheet data generating unit 160 determines that the area T12d is not included. In this case, for example, the spreadsheet data generating unit 160 determines that the "basic plan" is used as an identifier.

[0099] Then, based on the identifier specified by the spreadsheet data generating unit 160, the spreadsheet data processing unit 140 generates mount spreadsheet data that does not include the area T12d (area T12d has been deleted).

[0100] That is, the print output adjustment system 100a relating to the third modified example sets the layout of the fixed object T12 based on the variable object setting information and the display mode identification information, and generates base spreadsheet data by deleting the string tag information and the second variable object.

[0101] As a result, the print output adjustment system 100a can, for example, identify multiple identifiers that can identify the layout of the fixed object T12 based on one display mode identification information, and generate base spreadsheet data in which the layout is appropriately set by simple processing based on the identifiers.

[0102] <<Fourth Modification>> Furthermore, the spreadsheet data generating unit 160 may specify a predetermined page among a plurality of pages of target spreadsheet data created in advance and configured based on the variation target setting information. In this case, the spreadsheet data processing unit 140 generates mount spreadsheet data based on the spreadsheet data configured by the pages specified by the spreadsheet data generating unit 160.

[0103] The spreadsheet data generating unit 160 specifies the page configuration of the mount spreadsheet data for the variation target setting information based on the parameters and the identification information corresponding to the parameters (hereinafter referred to as "page identification information").

[0104] Specifically, the print output adjustment system 100a sets in advance page identification information by which an operator can identify each of a plurality of pages that are a template (target spreadsheet data). For example, the page identification information is an "A flag" or "presence or absence of B page." In addition, a numerical value such as "1" or "2" is associated with each piece of page identification information. Specifically, "1=%{A flag}" and "2={presence or absence of B page}" are set in advance in the print output adjustment system 100a.

[0105] In this case, when the spreadsheet data generation unit 160 determines that the variation target setting information includes an “A flag” and that there is a “B page”, it identifies, as an identifier, a string of numbers corresponding to each page identification information, for example, “12”.

[0106] The spreadsheet data processing unit 140 generates mount spreadsheet data based on a template of a page configuration corresponding to the identifier "12" (for example, a template consisting of the first and second pages).

[0107] That is, the print output adjustment system 100a identifies a specific template (a template that will become mount spreadsheet data) from among preset templates, and then the spreadsheet data processing unit 140 generates the mount spreadsheet data. This allows the print output adjustment system 100a to obtain the required mount spreadsheet data through simple processing. In addition, by storing the mount spreadsheet data generated according to the identifier, it is possible to reuse previously created mount spreadsheet data with a matching identifier from the next time onwards. This is a mechanism known as caching. This makes it possible to minimize the number of times mount spreadsheet data is created, and even faster processing speeds can be expected.

[0108] ===Hardware Configuration=== An example of a hardware configuration for implementing the print output adjustment system 100 on a computer will be described with reference to Fig. 11. Fig. 11 is a diagram showing an example of a hardware configuration of a computer.

[0109] As shown in FIG. 11, a computer 1000 includes a processor 1001, a memory 1002, a storage device 1003, an input I / F unit 1004, a data I / F unit 1005, a communication I / F unit 1006, and a display unit 1007.

[0110] The processor 1001 is a control unit that controls various processes in the computer 1000 by executing programs stored in the memory 1002 .

[0111] The memory 1002 is a storage medium such as a RAM (Random Access Memory), etc. The memory 1002 temporarily stores the program code of the program executed by the processor 1001 and data required when the program is executed.

[0112] The storage device 1003 is a non-volatile storage medium such as a hard disk drive (HDD), a flash memory, etc. The storage device 1003 stores an operating system and various programs for implementing the above-mentioned components.

[0113] The input I / F unit 1004 is a device for receiving input from a user. Specific examples of the input I / F unit 1004 include a keyboard, a mouse, a touch panel, various sensors, a wearable device, etc. The input I / F unit 1004 may be connected to the computer 1000 via an interface such as a USB (Universal Serial Bus).

[0114] The data I / F unit 1005 is a device for inputting data from outside the computer 1000. A specific example of the data I / F unit 1005 is a drive device for reading data stored in various storage media. The data I / F unit 1005 may be provided outside the computer 1000. In that case, the data I / F unit 1005 is connected to the computer 1000 via an interface such as a USB.

[0115] The communication I / F unit 1006 is a device for performing data communication via the Internet N, either wired or wirelessly, with an external device of the computer 1000. The communication I / F unit 1006 may be provided outside the computer 1000. In that case, the communication I / F unit 1006 is connected to the computer 1000 via an interface such as a USB.

[0116] The display unit 1007 is a device for displaying various types of information. Specific examples of the display unit 1007 include a liquid crystal display, an organic EL (Electro-Luminescence) display, a display of a wearable device, and the like. The display unit 1007 may be provided outside the computer 1000. In that case, the display unit 1007 is connected to the computer 1000 via, for example, a display cable. In addition, when a touch panel is adopted as the input I / F unit 1004, the display unit 1007 can be configured integrally with the input I / F unit 1004.

[0117] ===Summary=== <1> The print output adjustment system 100 in this embodiment includes a variation target setting information acquisition unit 120 that acquires variation target setting information including a plurality of print item data and input target data corresponding to each of the plurality of print item data, at least one of a first variation target to which a character string may be set (e.g., character string variation target T11a, calculation variation target T11b) and a second variation target to which a predetermined figure may be set (e.g., figure variation target T11c, display variation target T11d), a plurality of fixed targets to which a character string and a predetermined figure are not set (e.g., fixed target T12), and at least one of character string tag information (e.g., first character string tag information T13a, second character string tag information T13b) indicating an association with the print item data that is set in association with the first variation target, and figure tag information (e.g., first figure tag information T13c, second figure tag information T13d) indicating an association with the print item data that is set in association with the second variation target. The print output adjustment system 100 includes a target spreadsheet data acquisition unit 130 for acquiring target spreadsheet data, which is spreadsheet data, and a spreadsheet data processing unit 140 for setting a character string or a predetermined figure for at least one of the first and second variable targets on a screen displayed based on the target spreadsheet data, based on at least one of the character string tag information and the figure tag information, the print item data in the variable target setting information, and the input target data corresponding to the print item data, or for setting a character string or a predetermined figure for a setting position corresponding to at least one of the positions of the first and second variable targets (for example, a blank Excel sheet is prepared in advance, and a position on the sheet corresponding to the character string position or figure) to generate variable target spreadsheet data, which is spreadsheet data for displaying a print screen that does not include at least one fixed target among a plurality of fixed targets and is composed of at least one of the character strings and the predetermined figure. As a result, the print output adjustment system 100 can easily generate variable target spreadsheet data of only the variable targets, convert it into PDF data, and provide it to a printing company, thereby increasing the printing speed at the printing company and reducing costs.

[0118] <2> Furthermore, the spreadsheet data processing unit 140 in the print output adjustment system 100 in this embodiment generates fixed-deleted spreadsheet data, which is spreadsheet data in which multiple fixed objects have been deleted from the target spreadsheet data, based on the character string tag information and the graphic tag information, and sets character strings or a predetermined graphic for at least one of the first variable object and the second variable object on the screen displayed based on the fixed-deleted spreadsheet data, thereby generating variable object spreadsheet data. This allows the print output adjustment system 100 to easily generate variable object spreadsheet data containing only the variable objects, and to convert it into PDF data and provide it to the printing company, thereby increasing the printing speed at the printing company and reducing costs.

[0119] <3> Furthermore, the spreadsheet data processing unit 140 in the print output adjustment system 100 in this embodiment generates mount spreadsheet data, which is spreadsheet data obtained by deleting the character string tag information and the second variable object associated with the graphic tag information from the target spreadsheet data. This allows the print output adjustment system 100 to easily generate variable object spreadsheet data containing only variable objects and mount spreadsheet data containing only fixed objects, respectively, and convert them into PDF data to provide them to the printing company, thereby increasing the printing speed at the printing company and reducing costs.

[0120] <4> Furthermore, the input target data of the variable target setting information in the print output adjustment system 100 in this embodiment includes string data indicating a string, the target spreadsheet data includes a first variable target which is an input area consisting of at least one cell into which a string indicated by the string data can be input, and string tag information is input into each input area, and the spreadsheet data processing unit 140 inputs string data based on the string tag information into each input area into which the string tag information in the fixed deleted spreadsheet data has been input, and generates variable target spreadsheet data for displaying a print screen including the string data. This allows the print output adjustment system 100 to easily generate variable target spreadsheet data of only the variable targets, and to convert it into PDF data and provide it to the printing company, thereby increasing the printing speed at the printing company and reducing costs.

[0121] <5> In addition, the input target data of the variable target setting information in the print output adjustment system 100 in this embodiment includes figure-related data related to a predetermined figure, and the figure tag information includes conditions related to the display mode of the predetermined figure, and the spreadsheet data processing unit 140 executes processing related to the display mode of the predetermined figure according to the conditions for the second variable target in the fixed and deleted spreadsheet data based on the figure tag information and the figure-related data, and generates variable target spreadsheet data reflecting the results of the processing related to the display mode of the predetermined figure for the set position or the second variable target. This allows the print output adjustment system 100 to easily generate variable target spreadsheet data for only the variable targets, convert it into PDF data, and provide it to the printing company, thereby increasing the printing speed at the printing company and reducing costs.

[0122] <6> The print output adjustment system 100a further includes a spreadsheet data generating unit 160 that determines whether or not to delete a specific fixed target from the target spreadsheet data or the mount spreadsheet data based on display mode identification information that can identify a specific fixed target among multiple fixed targets included in the target spreadsheet data based on variable target setting information. This allows the print output adjustment system 100a to generate mount spreadsheet data whose layout is appropriately set by simple processing, for example.

[0123] It should be noted that the present embodiment is an example for explaining the present invention, and is not intended to limit the present invention to only this embodiment. The present invention can be modified in various ways without departing from the gist of the present invention. The components of the print output adjustment system 100 described in the above embodiment are realized in cooperation with other hardware by the processor 1001 executing a program stored in the storage device 1003. [Explanation of symbols]

[0124] 100... print output adjustment system, 110... storage unit, 120... variable target setting information acquisition unit, 130... target spreadsheet data acquisition unit, 140... spreadsheet data processing unit, 150... display processing unit, 160... spreadsheet data generation unit.

Claims

1. A variable object setting information acquisition unit that acquires variable object setting information including a plurality of print item data and input target data corresponding to each of the plurality of print item data; At least one of a first variable object to which a character string can be set and a second variable object to which a predetermined graphic can be set; a plurality of fixed objects on which the character string and the predetermined graphic are not set; At least one of character string tag information indicating a relationship with the print item data, which is set in association with the first variable object, and graphic tag information indicating a relationship with the print item data, which is set in association with the second variable object; a target spreadsheet data acquisition unit for acquiring target spreadsheet data, the target spreadsheet data being spreadsheet data including Based on at least one of the character string tag information and the graphic tag information, the print item data in the variable object setting information, and the input target data corresponding to the print item data, setting the character string or the specified graphic for at least one of the first variable object and the second variable object on a screen displayed based on the target spreadsheet data, or setting the character string or the specified graphic for a setting position corresponding to a position of at least one of the first variable object and the second variable object; a spreadsheet data processing unit that generates variable object spreadsheet data, which is spreadsheet data for displaying a print screen that does not include at least one of the plurality of fixed objects and is configured with at least one of the character string and the predetermined figure; An information processing system comprising:

2. The spreadsheet data processing unit includes: generating fixation-deleted spreadsheet data, which is spreadsheet data obtained by deleting the fixed objects from the target spreadsheet data, based on the character string tag information and the graphic tag information; setting the character string or the predetermined graphic for at least one of the first variable object and the second variable object on a screen displayed based on the fixed and deleted spreadsheet data; Generate the variable target spreadsheet data. The information processing system according to claim 1 .

3. the spreadsheet data processing unit generates mount spreadsheet data, which is spreadsheet data obtained by deleting the character string tag information and the second variable object associated with the graphic tag information from the target spreadsheet data.

3. The information processing system according to claim 1 or 2.

4. The input target data of the variation target setting information includes character string data indicating a character string, the target spreadsheet data includes the first variable object which is an input area configured with at least one cell into which a character string indicated by the character string data can be input, The character string tag information is input into each of the input areas, The spreadsheet data processing unit includes: inputting the character string data based on the character string tag information into each of the input fields into which the character string tag information has been input in the fixed and deleted spreadsheet data; generating the variable target spreadsheet data for displaying the print screen including the character string data; The information processing system according to claim 2 .

5. The input target data of the variation target setting information includes graphic related data related to the predetermined graphic, the graphic tag information includes conditions regarding a display mode of the predetermined graphic, The spreadsheet data processing unit includes: execute a process for the second variable object in the fixed and deleted spreadsheet data, based on the graphic tag information and the graphic related data, for a display mode of the predetermined graphic according to the condition; generating the variable object spreadsheet data reflecting the result of executing a process related to the display mode of the predetermined figure for the setting position or the second variable object; The information processing system according to claim 2 .

6. A spreadsheet data generating unit is further provided for determining whether or not a predetermined fixed object is to be deleted from the target spreadsheet data or the mount spreadsheet data based on display mode identification information that can identify a predetermined fixed object among the plurality of fixed objects included in the target spreadsheet data based on the variable object setting information. The information processing system according to claim 3 .

7. The computer Acquiring variable target setting information including a plurality of print item data and input target data corresponding to each of the plurality of print item data; At least one of a first variable object to which a character string can be set and a second variable object to which a predetermined graphic can be set; a plurality of fixed objects on which the character string and the predetermined graphic are not set; At least one of character string tag information indicating a relationship with the print item data, which is set in association with the first variable object, and graphic tag information indicating a relationship with the print item data, which is set in association with the second variable object; acquiring target spreadsheet data, the target spreadsheet data including Based on at least one of the character string tag information and the graphic tag information, the print item data in the variable object setting information, and the input target data corresponding to the print item data, setting the character string or the specified graphic for at least one of the first variable object and the second variable object on a screen displayed based on the target spreadsheet data, or setting the character string or the specified graphic for a setting position corresponding to a position of at least one of the first variable object and the second variable object, generating variable object spreadsheet data which is spreadsheet data for displaying a print screen that does not include at least one of the plurality of fixed objects and is configured with at least one of the character string and the predetermined figure; An information processing method for performing the above.

8. On the computer, Acquiring variable target setting information including a plurality of print item data and input target data corresponding to each of the plurality of print item data; At least one of a first variable object to which a character string can be set and a second variable object to which a predetermined graphic can be set; a plurality of fixed objects on which the character string and the predetermined graphic are not set; At least one of character string tag information indicating a relationship with the print item data, which is set in association with the first variable object, and graphic tag information indicating a relationship with the print item data, which is set in association with the second variable object; acquiring target spreadsheet data, the target spreadsheet data including Based on at least one of the character string tag information and the graphic tag information, the print item data in the variable object setting information, and the input target data corresponding to the print item data, setting the character string or the specified graphic for at least one of the first variable object and the second variable object on a screen displayed based on the target spreadsheet data, or setting the character string or the specified graphic for a setting position corresponding to a position of at least one of the first variable object and the second variable object, generating variable object spreadsheet data which is spreadsheet data for displaying a print screen that does not include at least one of the plurality of fixed objects and is configured with at least one of the character string and the predetermined figure; A program for executing the above.

Images