JP5526991B2 - Information processing apparatus, information processing method, program, information processing system - Google Patents

Description

  The present invention relates to a workflow system and program configured by connecting a workflow server and a client terminal to each other via a network, and more particularly to a technique for acquiring design information of spreadsheet software as a workflow screen design.

  Some general workflow systems have an editor for designing a screen of a form (slip). Administrators use this editor to design forms that are used in the workflow system.

  By the way, before introducing the workflow system, there are many companies that design forms using spreadsheet software such as Microsoft Excel.

  However, even if there is already a form created with spreadsheet software, the screen design is unique to the workflow system. When introducing the workflow system, the form screen must be designed from scratch. However, there is a problem that man-hours are required.

  Patent Document 1 discloses a technology related to an information management system that creates a form that can be handled by a workflow system based on a form that is created without considering the workflow.

JP 2009-265903 A

  However, the invention described in Patent Document 1 is not a technique for importing a form screen into a screen design editor of a workflow system using a spreadsheet file designed with spreadsheet software.

The present invention is to solve the above problem, by using the application file form design is intended to provide a technique that enables to capture the image of the document on the screen design editor .

The present invention is capable of communicating with a client terminal spreadsheet application that creates a spreadsheet application files are installed in the information processing apparatus capable of designing a form screen, activates the possible screen design editor design the form screen Screen design editor launching means, and application file fetch instruction accepting means for accepting an instruction to fetch a spreadsheet application file already created by the spreadsheet application to the screen design editor launched by the screen design editor launching means If, when receiving the instruction to capture the spreadsheet application file in the application file taking instruction receiving means, a portion included in the print range set in the spreadsheet application file, and the image data An image data request means for requesting to the spreadsheet the spreadsheet application that created the application file, the image of the obtained form the images data acquired in response to a request by the image data requesting unit, said image design Arrangement means for arranging on an editor screen is provided.

According to the present invention, using the application file form design is, it is possible to capture an image of the document on the screen design editor.

System configuration diagram showing the configuration of the workflow system Diagram showing hardware configuration of various terminals Flow chart showing the overall processing flow An example of a delimiter character Example of import item definition imported from a spreadsheet file Diagram showing a series of slips designed with spreadsheet software The flowchart which shows the flow of the processing which extracts the picture of the slip which is designed from the spreadsheet file Example of pre-configuration screen Example of image table and screen design table An example of an image file placed on the design screen Flow chart showing the flow of processing to extract import items from a spreadsheet file Some examples of cell information to be returned Flowchart showing the flow of processing to extract capture items from cell information An example drawn in the screen design editor

  Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a system configuration diagram showing a configuration of a workflow system according to the present invention.

  In FIG. 1, in a workflow system (information processing system), at least one workflow server 101 (information processing apparatus) and a workflow client 102 (client terminal) are connected via a network.

  The user makes a workflow progress request to the workflow server 101 from the workflow client 102 using, for example, a web browser or client software.

  The workflow server 101 performs processing and management according to the request, and transmits a result or the like to the workflow client terminal 102 if necessary. It also has a screen design editor function for designing screens according to workflow processing.

  In this embodiment, a system developer operates a workflow client 102 in which spreadsheet software (for example, Microsoft Excel) is installed, and uses a form (slip) designed with spreadsheet software. Predetermined information is extracted, and the extracted information is loaded into an editor function for designing a screen of a form provided in the workflow server. The spreadsheet software is also called a spreadsheet application.

  FIG. 2 is a diagram showing a hardware configuration of various terminals according to the embodiment of the present invention.

  In FIG. 2, the CPU 201 comprehensively controls each device connected to the system bus 204.

  The ROM 203 or the external memory 211 stores an operating system (OS) that is a control program of the CPU 201 and programs for realizing various functions described later of each server or each client.

  The RAM 202 functions as a main memory, work area, temporary save area, and the like for the CPU 201.

  The input controller 205 controls input from the input unit 209. Examples of the input unit 209 include a pointing device such as a keyboard and a mouse in a terminal such as a server or a client. Moreover, in a printing apparatus etc., a touch panel, a button, a switch, etc. are mentioned.

  The output controller 206 controls the display of the output unit 210. Examples of the output unit 210 include a CRT and a liquid crystal.

  The external memory controller 207 controls access to the external memory 211 that stores a boot program, various applications, font data, user files, edit files, printer drivers, and the like. In addition, various tables and parameters for realizing various functions of each server or each client are stored. Examples of the external memory 211 include a hard disk (HD), a floppy (registered trademark) disk (FD), a compact flash (registered trademark) connected to a PCMCIA card slot via an adapter, and smart media.

  The communication I / F controller 208 executes communication control processing with an external device via the network 214.

  A program 212 for realizing the present invention is recorded in the external memory 211 and is executed by the CPU 201 by being loaded into the RAM 202 as necessary.

  Next, the overall processing flow will be described with reference to the flowchart of FIG.

  FIG. 3 is a flowchart showing the overall processing flow.

  As a prior work, the system developer operates the client terminal to register the delimiter character in the setting file managed by the workflow server (S301). A delimiter character is a delimiter character. This delimiter character is a character used to extract a capture item when a character string is extracted from a spreadsheet file. The items to be imported are also defined in advance.

  A specific example will be described with reference to FIGS.

  FIG. 4 is an example showing an example of a delimiter character.

  In this embodiment, “(@)” is defined as the delimiter character, but the delimiter character may be any character.

  FIG. 5 is an example showing the definition of the import items fetched from the spreadsheet file.

  In the present embodiment, “Delimiter $ item ID $ display format $ value” is defined as a fetch item. This definition indicates that a character string is extracted by “$”. As a result, when “(@) $ kingaku $ 1 $ 1000” is read, the item ID “kingaku” and the display format “1” are separated by “$” except for the delimiter character “(@)”. The value “1000” can be extracted. The display format “1” indicates, for example, a number for identifying the display format as a numeric format or a character format.

  Next, the system developer operates the client terminal to access the workflow server and activate the screen design editor. In the present embodiment, the screen design editor is described as being installed in the workflow server, but may be an embodiment in which the screen design editor is installed in the client terminal.

  In the present embodiment, the spreadsheet software is described as being installed in the client terminal operated by the administrator. However, the spreadsheet software may be installed in the workflow server.

  First, the system developer activates the spreadsheet software and creates a slip (form) (S301). Specifically, the form of the slip is designed using a function provided in the spreadsheet software (S303). In addition, the acquisition item is set (S304). Finally, the created slip is stored as a spreadsheet file (S305).

  An example of the designed slip will be described with reference to FIG.

  FIG. 6 is a diagram showing a series of slips designed with spreadsheet software.

  A slip is designed on the worksheet 600.

  In the present embodiment, an example of a slip of the transportation expense application form 601 is shown. This slip is created by inputting a character string in a cell or drawing a ruled line around the cell. It is also possible to specify the type and size of characters and to add color to characters and cells.

  In the example of the slip, the items of the slip include an affiliation 602, a name 603, a use transportation facility 604, a section 605, a charge 606, and a remark 607.

  Moreover, the acquisition item is set with respect to each item.

  For example, the affiliation 602 is set as “(@) $ Shozoku $ 1 $”. As a result, the item ID “Shozoku” and the display format “1” are extracted from the definition of the setting file. Note that this setting is not extracted because no value is set.

  Further, “(@) KIkan $ 1 $ JR” is set in the use transportation facility 604. As a result, the item ID “KIkan”, the display format “1”, and the value “JR” are extracted from the definition of the setting file.

  Also, since “(@) $$$” is set in the remarks 607, nothing is extracted.

  The example of the designed slip has been described above with reference to FIG.

  Next, the system developer logs in to the workflow server (S306), and after logging in, activates the image design editor (S307).

  Then, the spreadsheet file created by the spreadsheet software is dragged and dropped onto the activated screen design editor window (not shown) (S308).

  The screen design editor of the workflow server requests the spreadsheet software design information from the spreadsheet software of the client terminal operated by the system developer by dropping the spreadsheet file (S309).

  The spreadsheet software returns design information to the screen design editor according to the request (S310).

  The screen design editor uses the received spreadsheet calculation design information and the dropped spreadsheet file to image the slip and register the imaged image file in the database (S311). Details of this processing will be described with reference to FIG.

  FIG. 7 is a flowchart showing a flow of processing for extracting a slip image designed from a spreadsheet file.

  In this process, a workflow program, a spreadsheet software component, a spreadsheet software, and a clipboard appear as the subject of the process.

  In the present embodiment, the workflow program and the spreadsheet software component are modules installed in the workflow server.

  In this embodiment, the spreadsheet software is installed in the workflow client, and the clipboard is the clipboard of the workflow client.

  Here, the spreadsheet software component is a program that provides an interface for operating the spreadsheet software (almost all operations related to spreadsheet files, such as opening a spreadsheet file and selecting a cell). Yes.

  The clipboard is a shared memory area where data can be temporarily stored on a computer. It can be accessed from a plurality of different programs and is used to exchange data between applications.

  In another embodiment, the workflow program, the spreadsheet software component, the spreadsheet software application, and the clipboard may be provided in any of the workflow server and the workflow client, respectively.

  First, the workflow program requests the spreadsheet software component to acquire design information in order to acquire the design information of the spreadsheet file dropped in S308 (S701).

  The spreadsheet software component requests acquisition of design information from the spreadsheet software installed in the client terminal operated by the system administrator in accordance with the request.

  The spreadsheet software returns design information to the spreadsheet software component (S702). Here, the design information includes information such as the number of worksheets in the spreadsheet file and other basic attributes of the entire book in the spreadsheet file.

  The spreadsheet software component returns the acquired design information to the workflow program.

  The workflow program acquires design information.

  The workflow program repeats the process for each worksheet using the attribute information related to the worksheet included in the acquired design information (S703 to S718). For example, if there are 3 worksheets in the dropped spreadsheet file, repeat 3 times, and if there are 10 worksheets, repeat 10 times.

  The workflow program makes a request for acquiring a worksheet (S704).

  The spreadsheet software component makes a worksheet request to the spreadsheet software in accordance with the request from the workflow program.

  The spreadsheet software returns the requested worksheet (S705). Here, the actual information of the worksheet is returned. Specifically, all cell information arranged on the worksheet is included.

  The spreadsheet software component transmits the worksheet returned from the spreadsheet software to the workflow program. Then, the workflow program acquires a worksheet.

  Based on the acquired worksheet, the workflow program requests a print range set for the worksheet (S706).

  The spreadsheet software component makes a request for the print range of the worksheet to the spreadsheet software in accordance with a request from the workflow program. For example, the print range can be acquired from a function for acquiring the print range.

  The spreadsheet software returns the requested print range of the worksheet (S707). For example, the print range is returned in a format such as “$ A $ 2: $ I $ 17”. If there is no print range setting, information indicating that there is no print range is returned.

  The spreadsheet software component transmits the print range of the worksheet returned from the spreadsheet software to the workflow program. Then, the workflow program acquires the print range of the worksheet.

  The workflow program determines whether a print range is set (S708). If not, the process proceeds to S709, and if so, the process proceeds to S710.

  The workflow program sets a default value (S709). This default value is registered in advance.

  The workflow program repeats the processing for the print range using the acquired print range information (S710 to S717). Specifically, when the print range extends over a plurality of pages, the processing for the pages is repeated.

  The workflow program requests a copy of the print range (S711).

  The spreadsheet software component requests the spreadsheet software to copy an image in the print range in accordance with a request from the workflow program.

  The spreadsheet software places the copy information of the image in the print range on the clipboard in accordance with the request for the print range (S712).

  The workflow program requests acquisition of image data of the print range copied to the clipboard (S713). The requested image data differs depending on the prior image acquisition designation. If it is designated for printing, an enhancement metafile is requested. If it is designated for screen, image data in bitmap format is requested.

  In the present embodiment, this designation can be set from, for example, a setting screen shown in FIG. For image (low resolution), check 801. For printing (high resolution), check 802. In addition, it is assumed that this designation is performed before the drop in S308 of FIG.

  In this way, the image data required for the screen and the print is made different because the image data used for the image is not noticeable even if the image is somewhat rough, so the image data copied to the clipboard There is no problem even if it is acquired, but in the case of image data used for printing, the image becomes rough if it is printed as it is using the image data copied to the clipboard, so more to faithfully reproduce the original image This is because it is necessary to use an enhanced metafile having the following information.

  In addition, the addition destination 804 can select either to capture as an image or to capture as a background.

  After acquiring the image data from the clipboard, the workflow program converts the enhanced metafile into bitmap format image data for printing (S714). At that time, the enhanced metafile is enlarged / reduced in order to match the resolution set by default determined in advance by the system, and then converted into bitmap format image data.

  The workflow program converts the bitmap format image data to PNG format image data (S715).

  The workflow program converts the PNG format image data into binary format data and registers it in the image table (S716). Specifically, “image ID”, “image name”, and “image data” are recorded in the image table shown in FIG.

  The workflow program terminates the process by exiting the repeat loop for the print range (S717) and exiting the repeat loop for the worksheet (S718).

  The flow of processing for extracting a slip image designed from a spreadsheet file has been described above with reference to FIG.

  Returning to the description of FIG.

  The screen design editor places the imaged image file on the design screen created on the image design editor (S312). When the image is arranged for printing and the “match to image resolution” 803 shown in FIG. 8 is checked, the image to be displayed on the screen is arranged after adjusting the size in consideration of the resolution of the image. This is done to take into account the physical size intended by the image at the time of output. FIG. 10 shows an example in which image files are arranged on the design screen. An image file 1001 is arranged on the image design editor 1000.

  In this embodiment, the character string of each item (for example, “(@) $ Shokoku $ 1 $”, etc.) is not reflected, but this includes a delimiter character when copying the print range. This is because the character string in the existing cell is deleted and copied. Therefore, when the character string is not deleted, the character string of each item is also copied.

  In addition, the screen design editor uses the received spreadsheet software design information and the dropped spreadsheet file to extract the items to be imported from the spreadsheet file according to the settings file definition. Items are arranged on the design screen created on the image design editor (S313). Details of this processing will be described with reference to FIG.

  FIG. 11 is a flowchart showing the flow of processing for extracting a capture item from a spreadsheet file.

  In this process, a workflow program, a spreadsheet software component, and a spreadsheet software appear as subjects of the process. The workflow program, the spreadsheet software component, and the spreadsheet software application may be provided in any of the workflow server and the workflow client, respectively.

  Note that S701 to S710, S717, and S718 are the same as the processing shown in FIG.

  The workflow program repeats the process for the number of cells in the print range using the acquired print range information (S1101 to S1106). For example, the worksheet is repeated from the upper left to the lower right.

  The workflow program makes a request for acquiring cell information (S1102).

  The spreadsheet component requests cell information from the spreadsheet software in accordance with the request from the workflow program.

  The spreadsheet software returns the requested cell information (S1103). An example of part of the cell information to be returned is shown in FIG. Cell information includes "cell height", "cell width", "cell font", "cell font style", "cell font size", "cell font color", "cell value" , “Cell background color” and the like.

  The spreadsheet software component transmits the cell information returned from the spreadsheet software to the workflow program. The workflow program acquires cell information.

  The workflow program determines whether there is a delimiter character in the cell information (S1104). If there is, the process of S1105 is performed, and if not, the process of S1105 is not performed.

  If there is a delimiter character, the workflow program creates and arranges an item of the screen design editor (S1105). Details of this processing will be described with reference to FIG.

  FIG. 13 is a flowchart showing a flow of processing for extracting a capture item from cell information.

  The workflow program acquires the item ID of the item from the input character of the cell (S1301). When the input character of the cell is “(@) $ Kukan $ 1 $” as in the example shown in FIG. 12, “Kukan” is acquired according to the definition shown in FIG.

  The workflow program acquires the display format of the item from the input character of the cell (S1302). When the input character of the cell is “(@) $ Kukan $ 1 $” as in the example shown in FIG. 12, “1” is acquired according to the definition shown in FIG. In the present embodiment, “1” is a number indicating a text format.

  The workflow program acquires the item value from the input character of the cell (S1303). When the input character of the cell is “(@) $ Kukan $ 1 $” as in the example shown in FIG. 12, nothing is acquired according to the definition shown in FIG.

  The workflow program acquires the color of the item from the cell information (S1304). In the example shown in FIG. 12, “255” is acquired.

  The workflow program acquires the height and width of the item from the cell information (S1305). In the example shown in FIG. 12, “55” is acquired as the height of the item, and “5” is acquired as the horizontal width.

  The workflow program determines whether image data has been captured as print data in the flowchart shown in FIG. 7 (S1306). In the case of Yes, it progresses to S1307, and in No, it progresses to S1309.

  The workflow program corrects the ratio of the width to match the “item height” and the “width” with the “print range height” and the “width and background image height” (S1307). The reason for correcting the width ratio in this way is that the image data taken in as print data is generated by being reduced from the enhanced metafile, so that there is a shift in size. Therefore, for the purpose of correcting the shift, correction is performed to match the “item height” and “horizontal width” with the “print range height” and “horizontal width and background image height”. On the other hand, when image data is captured as image data, this correction is unnecessary because there is no deviation.

  The workflow program sets the item arrangement position according to the ratio of the height and width of the print range to the height and width of the background image (S1308). The value corrected in S1307 is specifically set here.

  The workflow program draws the value set in the item on the screen design editor (S1309). FIG. 14 shows an example drawn in the screen design editor. The items taken into the image file 1001 arranged on the image design editor 1000 are reflected. More specifically, “Text” is assigned to the affiliation 1401, “Text” is assigned to the name 1402, “JR” is assigned to the use transportation facility 1403, and “Text” is assigned to the charge 1405 for the section 1404. “Text” is set in the remarks 1406, and a blank is set. In addition, the color of characters is also reflected.

  Each of these items obtains an item from a plurality of cell information, and draws the cell at a position on image data corresponding to a position where the cell is arranged in a form designed by a spreadsheet file. The arrangement position can be determined based on the relative arrangement position from the origin of each cell.

  In the embodiment in which the character string in the cell containing the delimiter character is not deleted when the print range is copied, the character string of each item is also copied, so that the character string is not displayed. There is a need. That is, when arranging items, control is performed to delete unnecessary character strings.

  Conventionally, the attribute for each item had to be defined by the administrator on the screen design editor, but by defining the import items in the spreadsheet file in advance, as in this embodiment, Attribute information (design information) can be input.

  Heretofore, the flow of processing for extracting the capture item from the cell information has been described.

  Returning to the description of FIG.

  The workflow program exits the repeat loop for the cell information (S1106), exits the repeat loop for the print range (S717), and exits the repeat loop for the worksheet (S718).

  In the foregoing, the flow of processing for extracting a capture item from a spreadsheet file has been described.

  Returning to the description of FIG.

  Finally, the screen design editor stores the designed screen (S314). For example, it is stored in the screen design table shown in FIG. In this example, “business ID”, “screen ID”, “screen name”, and “screen data” are stored in association with each other.

  The overall processing flow has been described above.

  As described above, according to the present invention, it is possible to import a form screen into the screen design editor of the workflow system using a spreadsheet file in which the form is designed.

  Specifically, a form image designed with a spreadsheet file can be directly imported into the screen design editor as an image file.

  In addition, by defining import items in a spreadsheet file, not only image files but also items can be imported.

  Accordingly, there is no need to design a form screen from scratch, so that the burden of man-hours can be reduced.

  Although the embodiments have been described in detail above, the present invention can take embodiments as, for example, a system, an apparatus, a method, a program, or a storage medium (recording medium). The present invention may be applied to a system composed of a single device or an apparatus composed of a single device.

  In the present invention, a software program (in the embodiment, a program corresponding to the flowchart shown in the figure) that realizes the functions of the above-described embodiment is directly or remotely supplied to the system or apparatus, and the computer of the system or apparatus Is also achieved by reading and executing the supplied program code.

  Accordingly, since the functions of the present invention are implemented by computer, the program code installed in the computer also implements the present invention. In other words, the present invention includes a computer program itself for realizing the functional processing of the present invention.

  In that case, as long as it has the function of a program, it may be in the form of object code, a program executed by an interpreter, script data supplied to the OS, or the like.

  As a recording medium for supplying the program, for example, floppy (registered trademark) disk, hard disk, optical disk, magneto-optical disk, MO, CD-ROM, CD-R, CD-RW, magnetic tape, nonvolatile memory card ROM, DVD (DVD-ROM, DVD-R) and the like.

  As another program supply method, a client computer browser is used to connect to an Internet homepage, and the computer program of the present invention itself or a compressed file including an automatic installation function is downloaded from the homepage to a recording medium such as a hard disk. Can also be supplied. It can also be realized by dividing the program code constituting the program of the present invention into a plurality of files and downloading each file from a different homepage. That is, a WWW server that allows a plurality of users to download a program file for realizing the functional processing of the present invention on a computer is also included in the present invention.

  In addition, the program of the present invention is encrypted, stored in a storage medium such as a CD-ROM, distributed to users, and key information for decryption is downloaded from a homepage via the Internet to users who have cleared predetermined conditions. It is also possible to execute the encrypted program by using the key information and install the program on a computer.

  In addition to the functions of the above-described embodiments being realized by the computer executing the read program, the OS running on the computer based on the instruction of the program is a part of the actual processing. Alternatively, the functions of the above-described embodiment can be realized by performing all of them and performing the processing.

  Furthermore, after the program read from the recording medium is written in a memory provided in a function expansion board inserted into the computer or a function expansion unit connected to the computer, the function expansion board or The CPU or the like provided in the function expansion unit performs part or all of the actual processing, and the functions of the above-described embodiments are realized by the processing.

101 Workflow server 102 Workflow client 103 DB server 104 Circulation history

Claims (7)

In an information processing apparatus that can communicate with a client terminal on which a spreadsheet application that creates a spreadsheet application file is installed and that can design a form screen,
And the screen design editor activation means for activating a possible screen design editor design the form screen,
Application file import instruction accepting means for accepting an instruction to import a spreadsheet application file already created by the spreadsheet application , for the screen design editor started by the screen design editor launching means;
When the application file import instruction accepting unit accepts the spreadsheet application file import instruction, the part included in the print range set in the spreadsheet application file is used as image data as the spreadsheet application file. Image data requesting means for requesting the spreadsheet application that created
Locating means for the image of the document obtained from the images data acquired in response to a request by the image data request means, arranged on the screen of the screen design editor
The information processing apparatus comprising: a. It further comprises setting accepting means for accepting setting of the format of image data to be acquired,
The information processing apparatus according to claim 1 , wherein the image data requesting unit makes a request for acquiring image data in a format according to the setting received by the setting receiving unit. The cell information included in the print range before Symbol spreadsheet application file, and the cell information requesting unit that makes a request for obtaining the spreadsheet application installed on the client terminal,
Cell information acquisition means for acquiring cell information returned from the spreadsheet application;
If the cell acquired by the cell information obtaining means comprises a definition information, according to claim 1 or 2, characterized in that arranged on the screen of the screen design editor as an item by a value obtained from the definition information Information processing device. The arrangement means converts the height and width of a cell included in the cell information acquired by the cell information acquisition means when the image data of a predetermined format acquired in response to the request from the image data request means is converted and arranged. The information processing apparatus according to claim 3 , further comprising: a correction unit that corrects the image data to a ratio between a height and a width of the image data that has been converted and arranged. In an information processing method in an information processing apparatus capable of communicating with a client terminal in which a spreadsheet application for creating a spreadsheet application file is installed and capable of designing a form screen,
Screen design editor activating means of the information processing apparatus, and the screen design editor activation step of activating the possible screen design editor design the form screen,
Application file taking instruction accepting means of the information processing apparatus, to said image design editor activated activated screen design editor by step, receiving an instruction to capture a spreadsheet application file already created by the spreadsheet application Application file import instruction reception step,
A portion included in the print range set in the spreadsheet application file when the image data requesting unit of the information processing apparatus accepts the spreadsheet application file import instruction in the application file import instruction reception step. Image data requesting step for requesting the spreadsheet application that created the spreadsheet application file as image data;
And characterized in that it comprises an arrangement step of arranging means of the information processing apparatus, an image of a form obtained from the images data acquired in response to a request by the image data request step, placing on the screen of the screen design editor Information processing method. A program that can be executed on an information processing apparatus that can communicate with a client terminal in which a spreadsheet application that creates a spreadsheet application file is installed and that can design a form screen,
The information processing apparatus;
And the screen design editor activation means for activating a possible screen design editor design the form screen,
Application file import instruction accepting means for accepting an instruction to import a spreadsheet application file already created by the spreadsheet application , for the screen design editor started by the screen design editor launching means;
When the application file import instruction accepting unit accepts the spreadsheet application file import instruction, the part included in the print range set in the spreadsheet application file is used as image data as the spreadsheet application file. Image data requesting means for requesting the spreadsheet application that created
Program, characterized in that the image of the obtained form the images data acquired in response to a request by the image data request means, to function the information processing apparatus as the arrangement means for arranging on the screen of the screen design editor. In an information processing system in which a client terminal in which a spreadsheet application for creating a spreadsheet application file is installed and an information processing apparatus capable of designing a form screen can communicate,
And the screen design editor activation means for activating a possible screen design editor design the form screen,
Application file import instruction accepting means for accepting an instruction to import a spreadsheet application file already created by the spreadsheet application , for the screen design editor started by the screen design editor launching means;
When the application file import instruction accepting unit accepts the spreadsheet application file import instruction, the part included in the print range set in the spreadsheet application file is used as image data as the spreadsheet application file. Image data requesting means for requesting the spreadsheet application that created
Locating means for the image of the document obtained from the images data acquired in response to a request by the image data request means, arranged on the screen of the screen design editor
The information processing system comprising: a.

Images