JP2005122575A - Information processing apparatus, information processing method and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a technology for flexibly and easily processing information through a communication network and electronic mail by using a spread sheet, that is, to provide an information processing apparatus, an information processing method and its program. <P>SOLUTION: Data to be processed are stored as a spread sheet 3. A mail-receiving part 5 receives electronic mail incoming to a predetermined electronic mail address. An interpretation executing part 6 interprets the processing contents described in a predetermined format in the received electronic mail and applies information processing on the spread sheet 3, according to the processing content. A reply-preparing part 9 and a mail-returning part 10 return reply mail which contains the processing result to the transmission origin of the electronic mail. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a technology for processing information flexibly and easily via a communication network and electronic mail by using a spreadsheet, that is, an information processing apparatus, method, and program.

  In recent years, information provision via a communication network typified by the Internet has been activated due to social and economic informatization and development of information processing technology (for example, see Patent Document 1). A typical example is that a user accesses a predetermined website provided by a web server through a web browser or a URL, and displays a GUI (graphical User interface) A program such as CGI is operated by operation of parts, hyperlinks, etc., and services such as search condition designation and output of information stored in a database or the like are used.

Also, as an example via e-mail, when a user writes a search keyword in the e-mail title or text column and sends it to a predetermined server e-mail address, the server program is stored in a database or the like based on that There is also known an example in which the retrieved information is retrieved, and the result is returned in an e-mail.
JP-A-11-015891

  However, in the conventional technology as described above, when the configuration of information to be distributed is changed, the format of data stored in a database or the like is reorganized, or a program such as a corresponding DBMS (database management system) is stored. There is a problem that changes are required, and the burden of labor and costs is large and the speed is not sufficient. In particular, the change in the case of providing information via a website has a problem that the load is larger because the man-hours are large and various settings of the web server such as CGI and the screen data need to be corrected, and the speed is not sufficient.

  In addition, even when other than changes are considered, the conventional technology as described above requires a large amount of burden because it requires database construction and program preparation for each type and set of information to be provided. There was also a profit.

  In addition, when providing information with a search on a website, there is an inconvenience that conditions for search and narrowing must be specified on the interface of the web screen each time. In addition, even in the example where the search conditions can be registered in advance on the website, since an interface such as a web screen for such registration is required, a web browser is required in the access source environment, and login for registration is also required. Including registration operation is essential, and it cannot be used easily regardless of the access source environment. Of course, in the conventional information retrieval via e-mail, the technique for registering the retrieval condition was not known, and thus there was a long-awaited improvement in convenience of retrieval.

  The present invention solves the problems of the prior art as described above, and its purpose is to use a spreadsheet to process information flexibly and easily via a communication network and electronic mail, that is, an information processing apparatus, It is to provide a method and program.

  In order to achieve the above object, the information processing apparatus according to claim 1 stores means for storing data to be processed as a spreadsheet, means for receiving an e-mail that arrives at a predetermined e-mail address, and Processing means for interpreting processing contents described in a predetermined format in the e-mail and processing information on the spreadsheet according to the processing contents, and a reply mail including the processing result as a sender of the e-mail And means for replying to the computer.

  The information processing method according to claim 6 captures the invention according to claim 1 from the viewpoint of a method, and the computer stores the data to be processed as a spreadsheet and receives the electronic mail that arrives at a predetermined e-mail address. A reply mail that receives the mail, interprets the processing content described in the predetermined format in the received e-mail, performs information processing on the spreadsheet according to the processing content, and includes the result of the information processing To the sender of the e-mail.

  An information processing program according to an eleventh aspect captures the inventions according to the first and sixth aspects from the viewpoint of a computer program. By controlling the computer, data to be processed is stored as a spreadsheet, Receiving the incoming e-mail at the e-mail address, causing the received e-mail to interpret the processing content described in a predetermined format, and executing information processing on the spreadsheet according to the processing content, A reply mail including a result of the information processing is returned to the transmission source of the electronic mail.

  In these aspects, it is not necessary to construct a database by a database system, use a web server with a CGI function, or the like, and it is possible to easily start information processing such as providing information accompanied by a search only by preparing data in a spreadsheet. In addition, it is possible to deal with changes in the data structure quickly and easily by simply replacing the spreadsheet without a heavy burden of changing the server program, screen data, etc. or reorganizing the database.

  According to a second aspect of the present invention, in the information processing apparatus according to the first aspect, the processing means includes a spreadsheet containing at least a part of the title and the name of the received e-mail, a range thereof, or a file including the spreadsheet As a target of the information processing.

  The invention of claim 7 captures the invention of claim 2 from the viewpoint of a method, and in the information processing method of claim 6, the information processing includes at least a part of a title and a name of the received mail. A target spreadsheet is a matching spreadsheet or a range thereof or a file including the spreadsheet.

  The invention of claim 12 captures the inventions of claims 2 and 7 from the viewpoint of a computer program. In the information processing program of claim 11, the program stores the title of the received email and the title of the received mail. The information processing is executed on a spreadsheet, a range thereof, or a file including the spreadsheet having at least a part of the name.

  In these aspects, even if there are multiple sets of target information, it is not necessary to prepare as many email addresses, systems, programs, settings, etc. on the server side as there are spreadsheets and files for each set. Information processing can be started just by doing. The client (user) can easily access a desired information set by changing the mail title for one mail address designated as the access destination.

  According to a third aspect of the present invention, in the information processing apparatus according to the first or second aspect, the interpretation execution unit is placed in any column of a predetermined label row included in a target spreadsheet in the body of the e-mail. When the included value is described, the value of each row of the column is set as the processing result, and the value included in any row of the predetermined label column included in the target spreadsheet is included in the body of the email. When it is described, the value of each column in the row is used as the processing result.

  The invention of claim 8 captures the invention of claim 3 from the viewpoint of a method, and in the information processing method according to claim 6 or 7, the information processing is performed on a target spread in the body of the e-mail. When a value included in any column of a predetermined label row included in the sheet is described, the value of each row in the column is set as a processing result, and is included in the target spreadsheet in the body of the e-mail. When a value included in any row of a predetermined label column is described, the value of each column in that row is used as a processing result.

  The invention of claim 13 captures the invention of claims 3 and 8 from the viewpoint of a computer program. In the information processing program of claim 11 or 12, the information processing is performed in the body of the e-mail. When a value included in any column of a predetermined label row included in the target spreadsheet is described, the value of each row in that column is used as a processing result, and the target spread is included in the body of the e-mail. When a value included in any row of a predetermined label column included in the sheet is described, a value of each column in the row is used as a processing result.

  In these aspects, even if the location etc. is not specified correctly by the column name or row number, if the row or column value that is the label in the spreadsheet is specified, the corresponding group of values can be easily obtained. Can be obtained.

  According to a fourth aspect of the present invention, in the information processing apparatus according to any one of the first to third aspects, the interpretation execution unit includes a predetermined label row included in a target spreadsheet in the body of the electronic mail. When the first value included in any of the columns and the second value included in any row of the predetermined label column included in the target spreadsheet are described, the first value A value is referred to or updated to a value specified in a predetermined format for a column value where a column having the second row and a row having the second value intersect.

  The invention of claim 9 captures the invention of claim 4 from the viewpoint of a method, and the information processing method according to any one of claims 6 to 8, wherein the information processing is the text of the electronic mail. The first value included in any column of the predetermined label row included in the target spreadsheet and the second value included in any row of the predetermined label column included in the target spreadsheet When the value of is described, refer to the value of the column where the column having the first value and the row having the second value intersect, or update to the value specified in a predetermined format The process is performed.

  The invention of claim 14 is the information processing program according to any one of claims 11 to 13, wherein the invention of claims 4 and 9 is grasped from the viewpoint of a computer program. In the body of the e-mail, the first value included in any column of the predetermined label row included in the target spreadsheet and any row of the predetermined label column included in the target spreadsheet When the second value to be included is described, the value of the column where the column having the first value and the row having the second value intersect is specified as a target or specified in a predetermined format. A process of updating to a value is performed.

  In these modes, even if you do not specify the target location correctly by column name or row number, you can simply specify the row and column values that are labels in the spreadsheet and refer to the value of that intersection. And updating of values can be performed easily.

  A fifth aspect of the present invention is the information processing apparatus according to any one of the first to fourth aspects, wherein the command includes a command described in a predetermined format and a processing content corresponding to the command from the electronic mail. Detecting a registration request, means for registering the command and processing contents in a predetermined command storage area based on the request, and detecting a command described in a predetermined format in an e-mail received at the e-mail address In addition, the computer realizes means for taking out the processing contents corresponding to the detected command from the storage area and passing the processing contents to the processing means.

  The invention of claim 10 captures the invention of claim 5 from the viewpoint of a method, and the information processing method according to any one of claims 6 to 9 is described in a predetermined format from the electronic mail. A command registration request including the received command and processing contents corresponding to the command, and registering the command and processing contents in a predetermined command storage area based on the request, and receiving an electronic mail that arrives at the electronic mail address A command described in a predetermined format in the mail is detected, and processing content corresponding to the detected command is extracted from the storage area and the information processing is performed.

  The fifteenth aspect of the invention is an information processing program according to any one of the eleventh to fourteenth aspects, wherein the inventions of the fifth and tenth aspects are grasped from the viewpoint of a computer program. , Detecting a command registration request including a command described in a predetermined format and a processing content corresponding to the command from the electronic mail, and storing the command and the processing content in a predetermined command storage area based on the request. Registering and detecting a command described in a predetermined format in an e-mail received at the e-mail address, and extracting the processing content corresponding to the detected command from the storage area to perform the information processing. And

  In these aspects, the information user can register the desired search condition on the server side in association with the desired command name only by mail operation, and then reuse it only by describing the command name. Increased efficiency.

  According to the present invention as described above, it is possible to provide a technique, that is, an information processing apparatus, a method, and a program that flexibly and easily process information via a communication network and electronic mail by using a spreadsheet.

  Next, the best mode for carrying out the present invention (hereinafter referred to as “embodiment”) will be specifically described with reference to the drawings. In addition, since this invention can be grasped | ascertained also as an apparatus, a method, and a computer program which implement | achieves these, the virtual circuit block corresponding to each function of this invention or this embodiment is also used in the following description.

[1. Constitution〕
That is, the present embodiment relates to an information processing apparatus configured as a server 2 connected to the Internet 1 as shown in FIG. 1, and can be grasped as an information processing method and a computer program that implements these apparatuses and methods. it can. In the server 2, the following elements shown in FIG. 1 are realized by such a program controlling the computer. That is, each element of the server 2 shown in FIG. 1 is comprised as a means which acts as follows with the said program.

[2. Preparation on the server)
Data to be processed for information processing such as retrieval and provision is described in advance as a spreadsheet (hereinafter also referred to as “table” or “table”) 3 and stored in a storage device such as a hard disk drive of the server 2. Keep it. In this data, for example, in a relational database table, each column label corresponds to “field” and each row corresponds to “record”. In addition, when a plurality of tables can be recorded in a single file or a file name corresponding to the type or set of information, a sheet name is assigned to each individual table.

[3. Outline of processing
In the present embodiment, the user can send desired information processing contents to a predetermined address by mail and receive the processing result by mail for the data prepared on the server side as described above. That is, a user who wants to receive information transmits an e-mail to a predetermined e-mail address assigned to the server 2 by using an e-mail terminal such as a personal computer, a mobile phone, or a PDA as a transmission source 4.

  In the server 2 to which such an e-mail is transmitted, first, the mail receiving unit 5 receives an e-mail that arrives at a predetermined e-mail address assigned to the server 2 and, for example, e-mail data of the entire e-mail The character string data of the sender mail address, mail title, and mail body are extracted for each part. The interpretation execution unit 6 interprets processing contents such as search described in a predetermined format in the electronic mail, and performs information processing on the spreadsheet 3 according to the processing contents. At this time, the name of the information set such as the file name to be processed can be specified by describing it in the mail title.

  When the command registration request or the command execution instruction is included in the mail, the command registration unit 7 or the command expansion unit 8 processes them, and the command execution instruction is expanded into the corresponding processing contents and the interpretation execution unit 6 Passed to. Although these points will be described later, a command name corresponding to a search expression or the like for specifying information processing contents can be described in the mail body or the like, and a new command can be created by describing a command name corresponding to a new search condition. Can also be registered.

  Then, the reply creation unit 9 creates a reply mail based on the result of the information processing by the interpretation execution unit 6, and the mail reply unit 10 returns the reply mail to the sender of the electronic mail. The reply mail has, for example, a text that is formed by characterizing each column (column) of the corresponding row of the search result into a character string in pairs with the label of each column.

  In the present embodiment as described above, it is not necessary to construct a database by a database system or to use a web server with a CGI function, and it is easy to perform information processing such as providing information accompanied by a search only by preparing data in a spreadsheet. Can start. In addition, it is possible to deal with changes in the data structure quickly and easily by simply replacing the spreadsheet without a heavy burden of changing the server program, screen data, etc. or reorganizing the database.

  Note that the description format of the information processing content in the mail may be freely determined at the time of implementation, but an example is shown below.

[4. (Specifying the target)
First, in the present embodiment, the user can designate a processing target by describing a target spreadsheet or the name of a file including the target spreadsheet in the title of a mail requesting information processing.

  In other words, the interpretation execution unit 6 sets a spreadsheet that has at least a part of the name as the character string of the received title of the mail or a file including the spreadsheet as a target of the information processing.

For example, it is a system called “book” that includes a plurality of tables in one file, and the name of this table is “inventory table 3” and exists in the book “sales department 2”. In this case, to specify this table by e-mail, in the order of book name> table name in the title, for example

Sales Section 2> Inventory Table 3

It describes as follows. Further, a defined cell range name may be specified. For example, if the above example is a part of a table and the cell range name is “for maintenance”, the title is in the order of book name> table name (cell range name), for example,

Sales Section 2> Inventory Table 3 (for maintenance)

It describes in the way.

  In this embodiment, even if there are a plurality of sets of target information, it is not necessary to prepare as many e-mail addresses, systems, programs, and settings as the number on the server side. Information processing can be started simply by preparing a file. The client (user) can easily access a desired information set by changing the mail title for one mail address designated as the access destination.

[5. (Specify conditions)
One of the formats for specifying the target in column units from the above targets is to specify the range by writing the label in the spreadsheet in the main text, To operate. For example, consider the following spreadsheet example with the left column and top row of the table as the label.

Product number Product name Unit price Stock quantity 001 A parts ¥ 800
005 B cover ¥ 4500 12
012 C screw ¥ 450 150
018 D sheet ¥ 680 6
022 E parts ¥ 1800 20
023 F parts…

[5-1. Example of single condition specification)
First, an example in which the range in the table is designated by a single condition in the mail body is shown. That is, when the value included in any column of the predetermined label row included in the target spreadsheet is described in the body of the e-mail, the interpretation execution unit 6 processes the value of each row in the column. As a result.

As an example of the pattern for designating the position in the table in the text as described above, first, if a vertical label (for example, “005”) is written in the text, the corresponding horizontal line is, for example,

005 B cover ¥ 4500 12

You can get like this.

In addition, when the value included in any row of the predetermined label column included in the target spreadsheet is described in the body of the e-mail, the interpretation execution unit 6 sets the value of each column in that row. Is the processing result. For example, if “product name” is written as a horizontal label in the text, the corresponding vertical line is

A part B cover C screw D sheet E part

You can get like this.

  In this embodiment, if a row or column value that is a label in the spreadsheet is specified, the location or the like is not accurately specified by the column name or the row number. Can be easily obtained.

[5-2. Example of compound condition specification)
The processing target may be specified by a combined condition of rows and columns. In this case, the interpretation execution unit 6 includes the first value included in any column of the predetermined label row included in the target spreadsheet and the predetermined value included in the target spreadsheet in the body of the e-mail. When the second value included in any row of the label column is described, the value reference is made for the value of the column where the column having the first value and the row having the second value intersect Alternatively, update processing to a value specified in a predetermined format is performed.

The order of description of the first and second values is arbitrary, but as an example, in the body of the email, in the order of vertical label / horizontal label, for example

018 / unit price

For example, the intersection value specified by

¥ 680

You can get like this.

Also, in the text, in the order of vertical label / horizontal label = value, for example

018 / Unit price = ¥ 650

Is written, the intersection value specified by it is updated to that value.

Also, in the text, in the order of vertical label / horizontal label == value, for example

023 / unit price == ¥ 310

Is written, the update including the addition is performed on the value of the intersection specified by the above. If a wild card such as “* label *” can be used for the vertical label, it is easy to search for more conditions and add a new line value to the line next to the current last value. become.

  In such an embodiment, even if the target location is not accurately specified by the column name or the row number, the value of the intersection point can be determined only by specifying the row and column values that are labels in the spreadsheet. It is possible to easily refer to or update the value of the target.

[6. Example of other condition specification)
Further, as an example of specifying a search pattern in the text, for example, the first line of the table may be regarded as a field name, the second and subsequent lines as records, and values may be acquired according to a relational database. For example, in the same way as above, the table name, etc. is specified in the subject line of the mail as Book name> Table name (cell range name). . . ] / Conditions may be specified.

As an example of condition description, for example,

Field 1 <10
Field 2 LIKE “Operating%”
Field 3 = “Aiueo”

Can be used, and a wild card such as “*” can be used in the field to be extracted.

@ * / Name = “Taro”

If a description like this is accepted, a record or line including the character string “Taro” is obtained in any column.

[7. Register command
In addition, the user can register processing contents such as desired search conditions as commands by e-mail, and can subsequently use commands registered by themselves or commands registered on the server side by information providers or other users. Registration may be performed at the same time when the processing contents are actually executed for the first time, or only registration without execution may be accepted by performing a predetermined writing method.

  That is, the command registration unit 7 detects a command registration request including a command described in a predetermined format and processing contents such as a search condition corresponding to the command from the e-mail, and based on the request, The command and processing content are associated with each other and registered in a predetermined command storage area such as the command file 11.

Specifically, at the end of the mail describing the processing contents such as the search conditions as described above, together with a predetermined symbol such as # command name, for example

#Check inventory

In this way, the contents of the information processing at that time are registered on the server side with the command name, and the search formula becomes unnecessary from the next time.

[8. Command interpretation execution)
In addition, the command expansion unit 8 detects and detects a command described in a predetermined format in an e-mail received at the e-mail address, for example, in a form following a predetermined symbol in the body of the mail. The processing content corresponding to the command is taken out from the storage area and passed to the interpretation execution unit 6.

  For example, in the above example, the next time the command is used, the title and text will be described as “# inventory check”, and the other text will not be written if there is no necessary parameter, and there will be a necessary parameter. Sometimes, describe as many parameters as necessary in the body, separating them with line breaks or commas. Then, the command expansion unit 8 detects a registered command such as “# inventory check” from the title or text of the mail, calls the search condition registered corresponding to the command from the command file 11, and responds accordingly. Parameters are acquired from the mail text, and the information is passed to the interpretation execution unit 6 for information processing.

  In such an embodiment, the information user can register a desired search condition in association with a desired command name on the server side only by a mail operation, and then reuse it only by describing the command name. Information processing is made efficient.

[9. (Table processing)
If the command is not used in the incoming mail, the interpretation execution unit 6 passes the title and body of the mail as they are, and if the command is used in the incoming mail, the processing expanded based on the command The contents are passed from the command expansion unit 8. The interpretation execution unit 6 searches and opens the spreadsheet 3 corresponding to the file name or sheet name specified by the title of the mail or specified by the expanded processing content, and opens the above described example Thus, for example, a predetermined column is searched using a character string of the text as a search keyword, and a predetermined column range of a matched row is selected as a result.

  Based on the information processing result thus obtained, the reply creating unit 9 creates a reply mail to the sender mail address. For example, a character string representing the data itself extracted from the table or range data representing the range of the table is passed from the interpretation execution unit 6 to the reply creating unit 9 as a processing result. For example, in the latter case, the reply creation unit 9 accesses the spreadsheet 3 having a file name that matches the email title, and for each row included in the range data, for each column included in the target tabular data, A character string is generated by arranging the label and its column data.

For example, a row value

005 B cover ¥ 4500 12

And the label corresponding to each column

Product number: 005
Product Name: B Cover Unit Price: ¥ 4500
In Stock: 12

A reply string such as is generated.

  Such processing is repeated while inserting line breaks for all elements included in the search result, and the resulting character string is passed to the mail reply unit 10 as the body of the reply mail. It is sent as an e-mail to the original sender 4. The title of the reply mail is free, but in accordance with normal manners, it is possible to add “Re:” to the beginning of the original mail title.

  For example, if the title of the email is a blank or a specific reserved word such as “LIST” or “DIR”, the interpretation execution unit 6 returns a list of spreadsheet file names existing in the storage device of the server 2 as a result. As described above, the reply creation unit 9 and the mail transmission unit 10 may be made to reply to the transmission source address.

  The sender e-mail address included in the original e-mail data is at least passed to the e-mail reply unit 10 to be used for specifying the e-mail reply destination. In addition, user authentication and user-specific tables and files are used based on the user authentication. It may be used as identification information for calling and processing, registering or using a user-specific command.

  In addition, a search language such as SQL is effective for data search such as a spreadsheet. In this embodiment, a mail character string in which a user describes processing contents such as search conditions is interpreted on the server side and converted into SQL syntax. It is desirable to convert and perform table processing. In this way, it is not necessary for the user to learn difficult SQL, and it is also possible to search for data with a simple command name corresponding to a search condition character string registered in advance by the information providing side.

[10. Other embodiments]
The present invention is not limited to the above-described embodiment, and includes other embodiments as exemplified below. For example, although processing of inventory information has been exemplified in the above embodiment, information to be processed is free, and for example, a target such as writing on a bulletin board (BBS) or a thread can be freely selected. Further, the division of each block shown in FIG. 1 is solely for convenience of explanation, and there is no particular meaning such as a unit of a program module in the implementation, so that the division range can be freely changed.

The functional block diagram which shows the structure of embodiment of this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Internet 2 ... Server 3 ... Spreadsheet 4 ... Transmission origin 5 ... Mail receiving part 6 ... Interpretation execution part 7 ... Command registration part 8 ... Command expansion part 9 ... Reply creation part 10 ... Mail reply part 11 ... Command file

Claims (15)

Means for storing the data to be processed as a spreadsheet;
Means for receiving an email incoming to a predetermined email address;
Processing means for interpreting the processing content described in a predetermined format in the received e-mail and performing information processing on the spreadsheet according to the processing content;
Means for returning a reply email containing the result of the processing to the sender of the email;
An information processing apparatus characterized by realizing a computer.   The processing means is configured to target a spreadsheet in which at least a part of the title and name of the received e-mail match, or a range thereof, or a file including the spreadsheet as a target of the information processing. The information processing apparatus according to claim 1. The processing means includes
When the value included in any column of the predetermined label row included in the target spreadsheet is described in the body of the email, the value of each row in the column is used as the processing result,
When a value included in any row of a predetermined label column included in the target spreadsheet is described in the body of the e-mail, the value of each column in the row is used as a processing result. The information processing apparatus according to claim 1 or 2. The processing means includes
A first value included in any column of a predetermined label row included in the target spreadsheet and any row of a predetermined label column included in the target spreadsheet are included in the body of the e-mail. When the second value included in the is described, it is specified by referring to the value of the column where the column having the first value and the row having the second value intersect, or specified in a predetermined format. The information processing apparatus according to claim 1, wherein the information is updated to a new value. A command registration request including a command described in a predetermined format and a processing content corresponding to the command is detected from the e-mail, and the command and the processing content are registered in a predetermined command storage area based on the request. Means to
Means for detecting a command described in a predetermined format in an e-mail received at the e-mail address, and taking out the processing content corresponding to the detected command from the storage area and passing it to the processing means;
The information processing apparatus according to any one of claims 1 to 4, wherein the computer realizes the above. Computer
Store the data to be processed as a spreadsheet,
Receive incoming emails at a given email address,
Interpreting the processing content described in a predetermined format in the received e-mail and performing information processing on the spreadsheet according to the processing content;
An information processing method, wherein a reply mail including a result of the information processing is returned to a transmission source of the electronic mail.   The information processing method according to claim 6, wherein the information processing is performed on a spreadsheet in which at least a part of a title and a name of the received mail match, a range thereof, or a file including the spreadsheet. The information processing
When the value included in any column of the predetermined label row included in the target spreadsheet is described in the body of the email, the value of each row in the column is used as the processing result,
When a value included in any row of a predetermined label column included in the target spreadsheet is described in the body of the e-mail, the value of each column in the row is used as a processing result. The information processing method according to claim 6 or 7. The information processing
A first value included in any column of a predetermined label row included in the target spreadsheet and any row of a predetermined label column included in the target spreadsheet are included in the body of the e-mail. When the second value included in the is described, it is specified by referring to the value of the column where the column having the first value and the row having the second value intersect, or specified in a predetermined format. The information processing method according to any one of claims 6 to 8, wherein an update process to a new value is performed. A command registration request including a command described in a predetermined format and a processing content corresponding to the command is detected from the e-mail, and the command and the processing content are registered in a predetermined command storage area based on the request. And
2. The method according to claim 1, wherein a command described in a predetermined format is detected in an e-mail received at the e-mail address, and processing information corresponding to the detected command is extracted from the storage area and the information processing is performed. The information processing method according to any one of 6 to 9. By controlling the computer
Store the data to be processed as a spreadsheet,
Receive incoming emails at a given email address,
The received e-mail is interpreted with processing content described in a predetermined format, and information processing is executed on the spreadsheet according to the processing content,
An information processing program for causing a reply mail including a result of the information processing to be returned to a transmission source of the electronic mail. The program is stored in the computer.
12. The information processing program according to claim 11, wherein the information processing is executed on a spreadsheet in which at least a part of the title and name of the received mail match, a range thereof, or a file including the spreadsheet. The information processing
When the value included in any column of the predetermined label row included in the target spreadsheet is described in the body of the email, the value of each row in the column is used as the processing result,
When a value included in any row of a predetermined label column included in the target spreadsheet is described in the body of the e-mail, the value of each column in the row is used as a processing result. The information processing program according to claim 11 or 12. The information processing
A first value included in any column of a predetermined label row included in the target spreadsheet and any row of a predetermined label column included in the target spreadsheet are included in the body of the e-mail. When the second value included in the is described, it is specified by referring to the value of the column where the column having the first value and the row having the second value intersect, or specified in a predetermined format. The information processing program according to any one of claims 11 to 13, wherein the information is updated to a new value. The program is stored in the computer.
A command registration request including a command described in a predetermined format and processing content corresponding to the command is detected from the e-mail, and the command and processing content are registered in a predetermined command storage area based on the request. Let
A command described in a predetermined format is detected in an e-mail received at the e-mail address, and a processing content corresponding to the detected command is extracted from the storage area to perform the information processing. Item 15. The information processing program according to any one of Items 11 to 14.