JP2004208278A - Data input/output method, program and network system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data input/output method with which processing such as updating of data such as cells of a general spread sheet can be easily performed regardless of the form of a network. <P>SOLUTION: When performing data management using a general spread sheet application program 9 provided for each of a host 3 and an X terminal 6 between the host 3 and the X terminal 6 connected over a network 1, a mail server 4 is provided and a position of a cell in the general spread sheet application program 9, an instruction of data input/output and data are specified by a subject and mail text as a mail form of the mail server 4, and input/output processing of the data of the cell is performed between the host 3 and the X terminal 6 by the specified mail form. <P>COPYRIGHT: (C)2004,JPO&NCIPI

Description

  The present invention relates to a method and a program using a general-purpose spreadsheet application program when performing data management between a center side and a terminal side via a network, and a network system.

  Conventionally, data management has been performed between a center side and a terminal side via a network using a general-purpose spreadsheet application program such as Excel (registered trademark) as spreadsheet software.

  In such a general-purpose spreadsheet application program, there are units of cells, sheets, and books, and updating of these unit data is performed, for example, by inputting data on the terminal side based on an update request from the center side to the terminal side. Is

  If the network is an external network such as the Internet or a public telephone line, the center starts the mail application program at the same time, and then uses the mail transmission function provided in the general-purpose spreadsheet application program to switch from the center to the terminal. Then, the corresponding cell, sheet and book units are transmitted to the terminal in the form of an attached file. The terminal side displays the received cell, sheet and book units, and then performs necessary data writing and the like. When the data writing, etc., is completed, the unit of the cell, the sheet, and the book are simultaneously activated on the terminal side, and then the terminal side is transmitted to the terminal using the mail transmission function provided in the general-purpose spreadsheet application program on the terminal side. Transmits the unit of cell, sheet, and book to the center in the form of an attached file. This makes it possible for the center to manage data from a large number of terminals using a general-purpose spreadsheet.

  On the other hand, if the network is an internal network such as an intranet, the display of cells, sheets, and books in which data is to be written is linked between the center side and the terminal side. The unit is displayed, data is written, and the data is returned to the link source center by overwriting and saving.

In addition to the above-described method, there is a method in which a general-purpose spreadsheet application program is started on the center side and the terminal side without using dedicated software, and data is input / output between the center side and the terminal side ( Patent Document 1).
JP-A-11-167405

  However, in a system using a general-purpose spreadsheet application program when performing data management between the center side and the terminal side via the network described above, if the network is an external network, cells, sheets, and books in an attached file format are used. , And there are problems such as requiring many operations on both the transmitting side and the receiving side.

  Also, when the network is an internal network, the display of units of cells, sheets and books is linked between the center side and the terminal side, so when one terminal is linked to the center side However, other terminals cannot be linked, and in a system having many terminals, it takes a lot of time to update data required in a system having many terminals.

  An object of the present invention is to provide a data input / output method, a program, and a network system that can easily perform processing such as updating data of cells or the like of a general-purpose spreadsheet, regardless of the form of a network, in response to such a problem. To provide.

  In order to solve the above problems, the present invention comprises the following data input / output method, program, and network system.

First, one invention performs data management between one information device and another information device connected via a network using a general-purpose spreadsheet application program provided for each of the first and other information devices. On the occasion,
A mail server is provided and at least one of cells, sheets, and books in the general-purpose spreadsheet application program is specified by a mail form in the mail server, and at least one of the cells, sheets, and books is specified by the specified mail form. One data is input / output processed between the one and other information devices.

Further, in another invention, one information device holding a general-purpose spreadsheet application program and another information device are connected via a network, and data is exchanged between the one information device and the other information device. In the data input / output method for input / output processing,
The other information device provided with a mail transmission / reception function specifies at least one of the cell, sheet, and book in the general-purpose spreadsheet application program by a mail form in the mail transmission / reception function, and by the specified mail form, The cell, the sheet, and the book, at least one data is transmitted to the one information device, and the one information device receiving the data transmits the received data according to the specified mail form in the general-purpose spreadsheet application program. It is characterized by writing in cells, sheets and books.

According to still another invention, one information device holding a general-purpose spreadsheet application program is connected to another information device via a network, and data is input between the one information device and the other information device. In the data input / output method for output processing,
The one information device is provided with a mail transmission / reception function, and the one information device creates a template mail including at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof, and generates the template mail. To the information equipment of
The other information device that has received the template mail creates data relating to at least one of the cells, sheets, and books in the general-purpose spreadsheet application program and the range thereof according to the template mail, and writes the created data to the Send it to the one information device using the mail sending and receiving function,
The one information device that has received the data writes the received data into at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof.

Still another invention is that a plurality of first information devices holding a general-purpose spreadsheet application program and a second information device not holding a general-purpose spreadsheet application program are connected via a network, and A data input / output method for inputting / outputting data between at least one of the information devices and the first and second information devices,
A mail sending / receiving function is provided, and at least one of cells, sheets, and books in the general-purpose spreadsheet application program is specified by the mail form in the mail sending / receiving function between the first information devices, and the specified mail form is specified. By the at least one of the cell, sheet and book data input and output between the first information device,
The first information device creates a template mail including at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof, and sends the template mail to the second information device. Send,
The second information device that has received the template mail creates data relating to at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof according to the template mail, and writes the created data. Sending to the first information device using the mail sending and receiving function,
The first information device that has received the data writes the received data into at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof.

  The present invention provides a data input / output method, a program, and a network system according to the above, regardless of the form of an external network such as the Internet or an internal network such as an intranet, the data of at least one of cells, sheets and books of a general-purpose spreadsheet. The input / output processing is realized by specifying at least one of a cell, a sheet, and a book by using a mail form and independently accessing the mail server from one and other information devices, as in the related art. It is simple and does not require the attachment processing of attached files, etc., and also processes input / output of at least one of general-purpose spreadsheet cells, sheets, and books at any time, even between linked information devices. There are many information devices that can Made to contribute to the time reduction in the case of the stem.

  According to the present invention, in a system using a general-purpose spreadsheet application program when performing data management between a center side and a terminal side via a network, regardless of the form of the network, out of the cells, sheets and books of the general-purpose spreadsheet It is possible to provide a data input / output method, a program, and a network system that can easily perform at least one process such as data update.

  Hereinafter, embodiments of a data input / output method, a program, and a network system according to the present invention will be described with reference to the drawings, with regard to a system applied when data is managed between a head office and a plurality of factories.

(1st Embodiment)
The network system according to the present embodiment will be described with reference to FIG.

  In FIG. 1, a host 3 of a head office 2 is connected to an X terminal 6 of an X factory 5 and a Y terminal 8 of a Y factory 7 via the Internet 1 as a network.

  The head office 2 has at least a mail server 4 in addition to the host 3 described above.

  The host 3 has installed thereon a spreadsheet application program 9 such as Excel (registered trademark), a mail application program 10 corresponding to the mail server 4, and a cell link application program 11 of the present embodiment as spreadsheet software.

  Similarly, a general-purpose spreadsheet application program 9, a mail application program 10, and a cell link application program 11 are installed in the X terminal 6 and the Y terminal 8, respectively.

  Here, the cell link application program 11 of the present embodiment connects the host 3, the X terminal 6, and the Y terminal 8 with at least one of the cell, sheet, and book in the general-purpose spreadsheet application program 9 and the mail server 4. This is a program that specifies a mail form and describes a procedure for input / output processing of the cell, sheet, and book data between the host 3, the X terminal 6, and the Y terminal 8 using the specified mail form.

  In this case, the specification by the mail form of at least one of the sheet and the book is to automatically perform the specification processing when at least one of the cell, the sheet and the book of the spreadsheet has changed from the conventional one. To explain with a specific example, it is assumed that a book a, a sheet b, and a cell c are input with data, and the sheet is stored.

  At the time of this storage, the cell link application program 11 compares the stored sheet with a previous sheet. As a result of this comparison, since the data of the cell c has changed, the positions of the book a, the sheet b, and the cell c, the data input, and the input data can be automatically detected. The position of the detected book a, sheet b, and cell c, the fact that the data has been entered, and the entered data should be included in the body of the mail, and the subject of the header should include the fact that the data is a spreadsheet data entry. I do. In the above description, the data input may include not only numbers but also characters such as results requests.

  On the other hand, as a procedure for performing the input / output processing in the cell link application program 11, when one or a plurality of cells are selected with a mouse or the like, if the selected cell has not been input with the result data, the other party inputs the result data. A prompt may be added. This additional display can be made compatible with the above-described data input. In addition to the above, it is possible to use the subject in the header of the mail to include that the mail prompts the other party to input the result data.

  Further, the cell link application program 11 holds link information between spreadsheets to be managed. This link information can correspond to cells, sheets, and books between spreadsheets of different formats.

  Generally, this link information is held in the form of a table or the like in the host 3 and is created and held when the cell link application program 11 is installed or as needed.

  The mail address of the host 3 under the control of the mail server 4 is, for example, the host {＠} ×. co. jp, and the mail address of the X terminal 6 of the X factory 5 is, for example, X terminal {＠} ×. co. jp, and the mail address of the Y terminal 8 of the Y factory 7 is, for example, Y terminal {＠} ×. co. jp.

  Normal mail transmission / reception by the mail server 4 can be performed between the host 3, the X terminal 6, and the Y terminal 8, and the mail unique to the present embodiment can be identified by the subject via the cell link application program 11. Transmission and reception are performed.

  Hereinafter, mail transmission / reception specific to the present embodiment will be described with reference to FIGS.

  FIG. 1 to FIG. 3 show the procedure of inputting data of a book a, a sheet b, and cells c and d of a general-purpose spreadsheet in the host 3 of the head office 2.

  First, the general-purpose spreadsheet application program 9, the mail application program 10, and the cell link application program 11 are activated in the host 3, the X terminal 6, and the Y terminal 8, respectively, and are held by the cell link application program 11 of the host 3 described above. The book, sheet, and cell correspond to each other according to the link information.

  First, the operator of the head office 2 operates the mouse or the like of the host 3 to specify the positions of the book a, the sheet b, the cells c and d of the general-purpose spreadsheet, and uses character information as a data input to input a “result input request”. ”Respectively, and save the general-purpose spreadsheet. At this time, the cell link application program 11 detects that the cells c and d have changed between the conventional general-purpose spreadsheet and the stored general-purpose spreadsheet. An e-mail is transmitted to each of the terminals 8 of the Y factory 7 (step S1 in FIG. 2).

  As shown in FIG. 3, the mail is sent to the mail box of the mail server 4 or the like, and the terminal 6 of the X factory 5 has the address X terminal {＠} ×. co. jp, and the box includes a “cell link” indicating that the subject of the header part is the mail of the present embodiment, and the body of the mail includes “the position of book a, sheet b, and cell c”. The mail 200 including the “result input request” is held.

  Similarly, the address of the terminal 8 of the Y factory 7 is Y terminal {＠} ×. co. jp, and the box includes a “cell link” indicating that the subject of the header part is the mail of the present embodiment, and the body of the mail includes “the position of book a, sheet b, and cell d”. The mail 201 including the “result input request” and the like is stored. An e-mail 201 is stored in which the main body of the e-mail includes “Please input actual data of book a, sheet b, and cell d”.

  Next, the terminal 6 of the X factory 5 and the terminal 8 of the X factory 7 receive the mails 200 and 201 in the mailbox of the mail server 4 (step S2 in FIG. 2).

  Thereby, the operator of the X factory 5 can recognize that the host 3 of the head office 2 is requesting the data input of the cell c. It can be recognized that the data input of cell d is requested.

  After this recognition, the operator of the X factory 5 inputs data of the cell c and saves the general-purpose spreadsheet. At this time, the cell link application program 11 detects that the cell c has changed between the conventional general-purpose spreadsheet and the stored general-purpose spreadsheet, and sends an e-mail to the host 3 based on the detection (see FIG. Step S3 in FIG. 2). As shown in FIG. 3, this mail has an address of host {＠} ×. co. jp, and the box includes a “cell link” indicating that the subject of the header part is the mail of the present embodiment, and the body of the mail includes “the position of book a, sheet b, and cell c”. The mail 202 including the data “@” is held.

  Similarly, the operator of the Y factory 7 inputs data of the cell d and saves the general-purpose spreadsheet. At this time, the cell link application program 11 detects that the cell c has changed between the conventional general-purpose spreadsheet and the stored general-purpose spreadsheet, and sends an e-mail to the host 3 based on the detection (see FIG. Step S3 in FIG. 2). As shown in FIG. 3, this mail has an address of host {＠} ×. co. jp, and the box includes a “cell link” indicating that the subject of the header part is the mail of the present embodiment, and the body of the mail includes “the position of book a, sheet b, and cell d”. The mail 203 including the data “□□□” is stored.

  As a result, the mails 202 and 203 arrive at the host 3 of the head office 2, and the operator of the head office 2 can recognize that the data の of the cell c has been input from the X factory 5. It is possible to recognize that the data □□□ of the cell d has been input from the Y factory 7. After this recognition, the operator of the head office 2 inputs data of cells c and d (step S4 in FIG. 2).

  As described above, according to the present embodiment, data managed by the general-purpose spreadsheet application program 9 is transferred between the head office 2 and the factories 5 and 6 via the Internet 1 which is an external network. 11 enables input / output using a mail function. In this case, it is simple and does not require the attachment processing of the attached file as in the past, and the data such as the cells of the general-purpose spreadsheet can be input at any time to terminals other than the linked terminals such as the intranet. Output processing can be performed, which contributes to a reduction in time in a system having many terminals.

(2nd Embodiment)
Next, a network system according to a second embodiment of the present invention will be described with reference to FIG. 4 in which the same parts as those in FIGS.

  The network system according to the present embodiment installs a public Web server 12 in the head office 2 so that all or part of the general-purpose spreadsheet according to the first embodiment can be disclosed to an external terminal 13 connected to the Internet 1. It was done.

  Specifically, the public Web server 12 is connected to an internal network such as the intranet of the head office 2, and all or a part of the general-purpose spreadsheet by the host 3 is periodically copied to the public Web server 12, for example. The copy can be browsed by the browser 14 of the external terminal 13 via the Internet.

  According to the present embodiment having such a configuration, in-house data is created between the head office and the factory via the Internet 1 which is an external network, and those which can be disclosed outside the company are stored in the Internet 1 and the public Web server 12. Since it can be disclosed to the outside through, it can be used as a tool for information disclosure.

(Third embodiment)
Next, a network system according to a third embodiment of the present invention will be described with reference to FIG. 5 in which the same parts as those in FIGS.

  In the present embodiment, in-house data is created between the host 101, the internal terminals 102 and 103, and the mail server 104 in the intranet 100, which is an internal network, and those that can be made public outside the company are stored in the public Web server 105 and the external network. It is open to the outside via a certain Internet 1.

  Here, the host 101 and the internal terminals 102 and 103 correspond to the host 3 and the terminals 6 and 8 in the first embodiment, in which a general-purpose spreadsheet application program, a mail application program, and a cell link application program are installed. ing.

  According to the present embodiment having such a configuration, in-house data is created between the in-house host 101 and the internal terminals 102 and 103 via the intranet 100, which is an internal network. Since it can be made public to the outside via the public Web server 105, it can be used as a tool for information disclosure as in the second embodiment.

(Fourth embodiment)
Next, the data input / output method, the program and the embodiment of the network system according to the present invention are applied to a case where data is managed between a head office (server side) and a mobile information terminal (for example, a mobile phone) as a client. The system will be described with reference to FIG. 6 in which the same parts as those in FIGS.

In the present embodiment, one information device holding a general-purpose spreadsheet application program and another information device are connected via a network, and data is input / output between the one information device and the other information device. In the data input / output method to be processed,
The other information device provided with a mail transmission / reception function specifies at least one of the cell, sheet, and book in the general-purpose spreadsheet application program by a mail form in the mail transmission / reception function, and by the specified mail form, The cell, the sheet, and the book, at least one data is transmitted to the one information device, and the one information device receiving the data transmits the received data according to the specified mail form in the general-purpose spreadsheet application program. It is characterized by writing in cells, sheets and books,
In another respect,
In addition to providing a mail transmission / reception function, the one information device creates a template mail in which at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof are set, and generates the template mail. Transmitting to the other information device,
The other information device that has received the template mail creates data relating to at least one of the cells, sheets, and books in the general-purpose spreadsheet application program and the range thereof according to the template mail, and writes the created data to the Send it to the one information device using the mail sending and receiving function,
The one information device receiving the data writes the received data into at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof.

  In FIG. 6, a host 3 of a head office 2 on the server side, a Z terminal (for example, a mobile phone) 16 and a PDA terminal 17 as mobile clients are connected via the Internet 1, a telephone network 15 and an antenna 15A as networks. I have. The Z terminal 16 and the PDA terminal 17 which are mobile clients can send and receive mail via the Internet 1.

  The head office 2 has at least a mail server 4 in addition to the host 3 described above. The mail server 4 sends and receives mails to and from the Z terminal 16 and the PDA terminal 17.

  A general-purpose spreadsheet application program 9 such as Excel (registered trademark), a mail application program 10 corresponding to the mail server 4, and a cell link application program 18 of the present embodiment are installed in the host 3 as spreadsheet software.

  The Z terminal 16 and the PDA terminal 17, which are mobile clients, can transmit and receive mail to and from the host 3 via the Internet 1.

  Here, the cell link application program 18 of the present embodiment includes at least a template mail creation function, an automatic transmission function of the mail, an automatic reception function of a reply mail, and writing of reply data to a cell or the like in the general-purpose spreadsheet application program 9. It has a link function to perform

  The headquarters 2 creates a template mail 200 specifying the cell range to be written by the cell link application program 18 of the present embodiment, transmits this to the Z terminal 16 which is a mobile client, receives a reply mail 201, The reply data by the reply mail 201 can be written to a cell in the general-purpose spreadsheet application program 9.

  Hereinafter, the operation of this embodiment will be described with reference to FIG. 7 and FIG.

  In FIG. 7, an operator at the head office 2 operates a mouse or the like of the host 3 to specify a cell range or the like of a general-purpose spreadsheet and creates a template mail 200. In this case, by executing the cell link application program 18, a template mail creation screen 300 shown in FIG. 8A is preferably displayed. The operator of the head office 2 inputs each item of the title section 301 in the template mail creation screen 300, inputs each item of the cell range setting section 302, and inputs each item of the condition section 303 as necessary. Here, the requirements for the mobile client are displayed by inputting the items in the title section 301, and the cells to be written to the mobile client are specified by inputting the items in the terminal cell range setting section 302. The template mail 200 thus created is transmitted to, for example, the Z terminal 16 (step T1).

  Next, in step T2, the Z-terminal 16 receives the template mail 200. By receiving the mail, a screen 400 shown in FIG. 8B is preferably displayed on the Z terminal 16. As a result, the operator of the Z terminal 16 can recognize the cell range for which data writing or the like is requested, create the corresponding data, and return it (step T3).

  In step T4, the host 3 of the head office 2 receives the reply mail 201 from the Z terminal 16 and writes the reply data by the reply mail 201 into, for example, a designated cell on the sheet 500A shown in FIG. 8C. I do.

  As described above, according to the present embodiment, unlike the first embodiment, the range of cells to be written to the mobile terminal such as a mobile phone on which the general-purpose spreadsheet application program 9 is not installed is set to the host of the head office 2. 3, the necessary information can be easily written from the mobile terminal into the general-purpose spreadsheet in the host 3 of the head office 2.

  In the above example, data is written from a mobile terminal to a corresponding cell on a seed such as a daily report or a weekly report. In this example, for example, the mail screen 400 is used as common transmission data. By creating, the date can be input, and the registered cell of the received data can be allocated from the date data.

  In the above description, the number of data requests from the host 3 of the head office 2 to the mobile terminals is not limited, and the contents of requests to the mobile terminals may be of various types. May be sent for the purpose.

(Fifth embodiment)
Next, the embodiment of the data input / output method, the program, and the network system according to the present invention is applied to a case where data is managed between the head office and the mobile information terminal, and between the head office and a plurality of factories shown in FIG. This system will be described with reference to FIG. 9 in which the same parts as those in FIGS.

In the present embodiment, a plurality of first information devices holding a general-purpose spreadsheet application program and a second information device not holding a general-purpose spreadsheet application program are connected via a network, and the first information device is connected to the first information device. A data input / output method for inputting / outputting data between at least one of the first and second information devices.
A mail sending / receiving function is provided, and at least one of cells, sheets, and books in the general-purpose spreadsheet application program is specified by the mail form in the mail sending / receiving function between the first information devices, and the specified mail form is specified. By the at least one of the cell, sheet and book data input and output between the first information device,
The first information device creates a template mail including at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof, and sends the template mail to the second information device. Send,
The second information device that has received the template mail creates data relating to at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof according to the template mail, and writes the created data. Sending to the first information device using the mail sending and receiving function,
The first information device that has received the data writes the received data into at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof.

  Therefore, the present embodiment shown in FIG. 9 has an extended cell link application program 19 having both the operation shown in FIG. 1 and the operation shown in FIG. The extended cell link application program 19 is installed in the host 3 of the head office 2, the terminals of the X factory 5 and the Y factory 7. The Z terminal 16 and the PDA terminal 17 which are mobile clients do not need to install the extended cell link application program 19 as in FIG.

  In the above-described embodiment, the mail form describes the data input / output of the spreadsheet by the subject, and specifies the cell, sheet and book, and the data input / output instruction by the mail body. Instead of this method, at least cells, sheets, and books may be specified by e-mail addresses. In this case, cells, sheets, and books can be specified by character information indicating the item contents on the vertical axis and the item contents on the horizontal axis. For example, the position of the cell c is specified by a character “X factory, result”, and the position of the cell d is specified by a character “Y plant, result”.

  In addition, the mail form according to the present invention includes various forms of performing input / output display of spreadsheet data, specification of cells, sheets, and books, using a mail header portion and mail text.

  Further, by providing an independent mail server that operates according to the cell link application program, it is possible to omit a subject index indicating identification from other mails.

  Furthermore, the configuration of the host 3, the mail server 4, and the like according to the present invention can be configured by one or more computers or a part of functions of these computers. The data input / output method shown in FIGS. 1 to 3 may be configured as hardware in addition to the software executed by the computer.

  The invention of the present application is not limited to the above embodiments, and can be variously modified in an implementation stage without departing from the gist of the invention. In addition, the embodiments may be implemented in appropriate combinations as much as possible, in which case the combined effects can be obtained. Furthermore, the above embodiments include inventions at various stages, and various inventions can be extracted by appropriately combining a plurality of disclosed constituent elements. For example, when an invention is extracted by omitting some constituent elements from all the constituent elements described in the embodiment, when practicing the extracted invention, the omitted part is appropriately supplemented by well-known conventional techniques. It is something to be done.

FIG. 1 is a diagram showing a network system according to a first embodiment of the present invention. 4 is a flowchart illustrating a data input / output method according to the first embodiment. FIG. 4 is an exemplary view for explaining a data input / output method in the embodiment. FIG. 4 is a diagram illustrating a network system according to a second embodiment of the present invention. The figure which shows the network system of the 3rd Embodiment of this invention. The figure which shows the network system of the 4th Embodiment of this invention. 4 is a flowchart illustrating a data input / output method according to the first embodiment. FIG. 4 is an exemplary view for explaining a data input / output method in the embodiment. The figure which shows the network system of 5th Embodiment of this invention.

Explanation of reference numerals

  1,100 Internet, 2 headquarters, 3101 host, 4,104 mail server, 5 X factory, 6 X terminal, 7 Y factory, 8 Y terminal, 9 general purpose spreadsheet application program 10, a mail application program, 11 a cell link application program, 12, 105 a public Web server, 13 an external terminal, 14 a browser, 15 a telephone network, 16 a Z terminal (mobile client), 17 a mobile terminal, 18: Mobile cell link application program, 19: Extended cell link application program, 20: Z factory, 102, 103: Internal terminal.

Claims (17)

Between one information device and another information device connected via a network, when performing data management using a general-purpose spreadsheet application program provided for each of the one and other information devices,
A mail server is provided and at least one of cells, sheets, and books in the general-purpose spreadsheet application program is specified by a mail form in the mail server, and at least one of the cells, sheets, and books is specified by the specified mail form. A data input / output method, wherein one data is input / output processed between the one and other information devices. One information device holding a general-purpose spreadsheet application program and another information device are connected via a network, and data input / output is performed to input / output data between the one information device and the other information device. In the method,
The other information device provided with a mail transmission / reception function specifies at least one of the cell, sheet, and book in the general-purpose spreadsheet application program by a mail form in the mail transmission / reception function, and by the specified mail form, The cell, the sheet, and the book, at least one data is transmitted to the one information device, and the one information device receiving the data transmits the received data according to the specified mail form in the general-purpose spreadsheet application program. A data input / output method characterized by writing in cells, sheets and books. One information device holding a general-purpose spreadsheet application program and another information device are connected via a network, and data input / output is performed to input / output data between the one information device and the other information device. In the method,
The one information device is provided with a mail transmission / reception function, and the one information device creates a template mail including at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof, and generates the template mail. To the information equipment of
The other information device that has received the template mail creates data relating to at least one of the cells, sheets, and books in the general-purpose spreadsheet application program and the range thereof according to the template mail, and writes the created data to the Send it to the one information device using the mail sending and receiving function,
The data input / output method, wherein the one information device receiving the data writes the received data into at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof. A plurality of first information devices that hold a general-purpose spreadsheet application program and a second information device that does not hold a general-purpose spreadsheet application program are connected via a network, and are connected between the first information devices and the first information device. , A data input / output method for inputting / outputting data between at least one of the second information devices,
A mail sending / receiving function is provided, and at least one of cells, sheets, and books in the general-purpose spreadsheet application program is specified by the mail form in the mail sending / receiving function between the first information devices, and the specified mail form is specified. By the at least one of the cell, sheet and book data input and output between the first information device,
The first information device creates a template mail including at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof, and sends the template mail to the second information device. Send,
The second information device that has received the template mail creates data relating to at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof according to the template mail, and writes the created data. Sending to the first information device using the mail sending and receiving function,
A data input / output method, wherein the first information device receiving the data writes the received data into at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof. The e-mail form describes the subject of data input / output of the spreadsheet by the subject, and describes the position of at least one of cells, sheets, and books, data input / output instructions, and data by the body of the e-mail. 5. The data input / output method according to claim 1, wherein: When at least one of the cells, sheets, and books of the spreadsheet has changed from the previous one, at least one of the cells, sheets, and books of the spreadsheet is specified by the mail form, and the specified mail form 6. The data input / output method according to claim 1, wherein data of at least one of the cell, the sheet, and the book is input / output between the one and other information devices. 5. The data input / output method according to claim 1, wherein the mail form specifies at least one of a cell, a sheet, and a book by character information. 5. The data input / output method according to claim 1, wherein the mail form specifies at least one of a cell, a sheet, and a book by a mail address. Between one information device and another information device connected via a network, in a program that performs data management using a general-purpose spreadsheet application program provided for each of the one and other information devices,
For each of the one and other information devices,
At least one of cells, sheets, and books in the general-purpose spreadsheet application program is specified by a mail form in a mail server, and at least one of the cells, sheets, and books is specified by the specified mail form. And a program for executing a procedure for performing input / output processing between other information devices. One information device holding a general-purpose spreadsheet application program, each having an e-mail transmitting / receiving function, and another information device are connected via a network, and data is exchanged between the one information device and the other information device. In a data input / output program that performs input / output processing,
In the one and other information devices,
At least one of cells, sheets, and books in the general-purpose spreadsheet application program is specified by a mail form in the mail transmission / reception function, and the specified mail form is used to specify data of at least one of the cells, sheets, and books. The one information device that has transmitted to the one information device and received the data executes the procedure of writing the received data into cells, sheets and books in the general-purpose spreadsheet application program according to the specified mail form. Program. One information device holding a general-purpose spreadsheet application program, each having an e-mail transmitting / receiving function, and another information device are connected via a network, and data is exchanged between the one information device and the other information device. In a data input / output program that performs input / output processing,
In the one and other information devices,
In the general-purpose spreadsheet application program, create a template mail including at least one of cells, sheets, and books and a range thereof, and transmit the template mail to the other information device.
The other information device that has received the template mail creates data relating to at least one of the cells, sheets, and books in the general-purpose spreadsheet application program and the range thereof according to the template mail, and writes the created data to the Send it to the one information device using the mail sending and receiving function,
A program for causing the one information device that has received the data to execute a procedure of writing the received data into at least one of a cell, a sheet, and a book and a range thereof in the general-purpose spreadsheet application program. A plurality of first information devices each having an e-mail transmission / reception function holding a general-purpose spreadsheet application program and a second information device having an e-mail transmission / reception function not holding a general-purpose spreadsheet application program are connected via a network; In a data input / output program that performs input / output processing of data between at least one of the first information device and at least one of the first and second information devices,
In the first and second information devices,
Between the first information devices, at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program is specified by a mail form in the mail transmission / reception function, and the specified cell form is used by the specified mail form. And input / output processing of at least one data of the book between the first information devices;
The first information device creates a template mail including at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof, and sends the template mail to the second information device. Send,
The second information device that has received the template mail creates data relating to at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof according to the template mail, and writes the created data. Sending to the first information device using the mail sending and receiving function,
A program for causing the first information device that has received the data to execute a procedure of writing the received data into at least one of a cell, a sheet, and a book and a range thereof in the general-purpose spreadsheet application program. In a network system using a general-purpose spreadsheet application program when performing data management between one information device and another information device via a network,
A mail server for sending mail to each of the one and other information devices,
Provided in each of the one and the other information equipment, the cell in the general-purpose spreadsheet application program, at least one of a sheet and a book is specified by the mail form in the mail server, by the specified mail form, Means for inputting and outputting at least one of the cell, sheet, and book data between the one and other information devices. In a system in which one information device holding a general-purpose spreadsheet application program and another information device are connected via a network, and input / output processing of data between the one information device and the other information device,
Mail sending and receiving means for sending mail to each of the one and other information devices,
The other information device specifies at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program by a mail form in the mail transmission / reception unit, and uses the specified mail form to specify the cell, sheet, and book. Means for transmitting at least one of the data to the one information device,
The network system according to claim 1, wherein the one information device includes means for writing the received data to a cell, a sheet, and a book in the general-purpose spreadsheet application program according to the specified mail form when the data is received. One information device holding a general-purpose spreadsheet application program and another information device are connected via a network, and data input / output is performed to input / output data between the one information device and the other information device. In the processing system,
Mail sending and receiving means for sending mail to each of the one and other information devices,
The one information device creates a template mail including at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof, and transmits the template mail to the other information device. Means,
The other information device, when receiving the template mail, creates data relating to at least one of the cells, sheets, and books in the general-purpose spreadsheet application program and the range thereof according to the template mail, and stores the created data. Means for transmitting to the one information device using the mail sending and receiving function,
The one information device, when receiving the data, includes means for writing the received data to at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof. Network system. A plurality of first information devices that hold a general-purpose spreadsheet application program and a second information device that does not hold a general-purpose spreadsheet application program are connected via a network, and are connected between the first information devices and the first information device. , A data input / output method for inputting / outputting data between at least one of the second information devices,
A mail transmission / reception unit for transmitting a mail between the first information device and between the first and second information devices,
The first information device specifies at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program by a mail form in the mail server, and uses the specified mail form to specify the cell, sheet, and book. Means for performing input / output processing of at least one data between the first information devices,
The first information device creates a template mail including at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof, and sends the template mail to the second information device. Means for transmitting,
The second information device, when receiving the template mail, creates data relating to at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof according to the template mail, and generates the created data. Means for transmitting to the first information device using the mail transmission / reception function,
The first information device includes means for, when receiving the data, writing the received data into at least one of a cell, a sheet, and a book in the general-purpose spreadsheet application program and a range thereof. Network system. If the network is an internal network, the information processing apparatus further comprises a public server that publishes the general-purpose spreadsheet, on which data is input / output processed by each of the one and other information devices, via an external network. 17. The network system according to any one of 13 to 16.

Images