JPH10124600A - Data input/output system for portable information terminal equipment - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide the functions of input processing, data retrieval and arithmetic processing of portable information terminal equipment. SOLUTION: This system is provided with a P-CEL 3 for storing table data prepared by a tabulation software 1 to operate on a personal computer into a file, a P-NET 4 for transmitting this file to the portable information terminal equipment, a T-NET 6 for receiving this file through a communicating means 5, and a T-LAN 7 for performing the input/arithmetic processing of the portable information terminal equipment based on the information in this file. Thus, it is not necessary to develop a program for the portable information terminal equipment and the data input/output system is provided inexpensively in a short time from the portable information terminal equipment while effectively utilizing the features provided for the portable information terminal equipment.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data input / output system using a personal computer and a portable information terminal.

[0002]

2. Description of the Related Art A conventional data input / output system using a portable terminal is disclosed, for example, in Japanese Patent Laid-Open No. 7-73259.
As disclosed in Japanese Patent Application Laid-Open Publication No. H10-209, a system in which data input / output processing for a layout file of a form created on a host device is performed by a portable information terminal device is described.

[0003]

In the above prior art,
It is not limited to the layout display and key input processing of the screen of the portable information terminal device, but also the processing operation by the input of the portable information terminal device, the bar code input and serial input process peculiar to the portable information terminal device, the data search and the arithmetic processing, etc. Currently, it is not enough to realize the functions required for the portable information terminal device, and in order to perform the same operation, a business program in a predetermined programming language for the portable information terminal device is required. It must be created for each task to which the portable information terminal device is applied. When developing business programs, considerable costs and time are required, which is expensive compared to the effects of introducing portable information terminal devices, and there has been a problem that portable information terminal devices cannot be introduced. .

Further, when developing a program for creating a form layout on a personal computer, the operating procedure is fixed, and in order to cope with an operating environment that changes with the progress of the OS and software of the personal computer, a considerable amount of work is required. It is necessary to upgrade the version while refining the
There is a problem that the input / output system becomes expensive and a certain development period is required until the version is upgraded.

[0005]

The present invention is characterized in that a display screen of a portable information terminal device and a processing function are set by using a table creation function of spreadsheet software operating on a personal computer, and a display screen created. A portable information terminal, wherein means for storing information of the setting function as table data in a table data file and communication means for transferring the table data file to a portable information terminal device via a communication medium are provided on a personal computer; The device has a communication means for receiving a table data file from a personal computer, and a display unit and an input unit corresponding to a cell-separated table as with the spreadsheet software of a personal computer.
By providing the data processing means for calculating, the portable information terminal device operates based on the table data created on the personal computer.

[0006] Thus, as processing operations of the portable information terminal device, in addition to input processing such as barcode input, serial input, list selection input, screen transition and input check,
Functions such as search, change, and redisplay of input data can be realized on the portable information terminal device.

[0007] Further, the portable information terminal device is provided with means for storing data input by the portable information terminal device in a data file and communication means for transmitting the data to a personal computer via a communication medium. By providing communication means for receiving a data file from the type information terminal device, and means for loading the spreadsheet software together with the information of the table data, the data input by the portable information terminal device can be directly used on a personal computer. Since processing can be performed with spreadsheet software, processing such as data processing and editing is not required on a personal computer, and an efficient data input / output system can be realized.

[0008]

BEST MODE FOR CARRYING OUT THE INVENTION

Embodiment 1 An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 shows a program configuration on a personal computer side and a portable information terminal device (hereinafter, portable terminal) side in the present invention. 1 is a personal computer and 2 is a portable terminal. 4 is a spreadsheet software that runs on a personal computer such as Microsoft Excel, and 5 is a spreadsheet software 4
The input screen 6 operates on the spreadsheet software 4 to display guidance for creating a mobile terminal screen on the input screen 5 and to create a file to be transmitted to the mobile terminal (P).
-CEL) and 7 are communication programs (P-NET) on the personal computer side for transmitting and receiving files to and from the portable terminal side. Reference numeral 3 denotes a unit for transmitting and receiving an information file between the personal computer 1 and the portable terminal 2. As the portable terminal side program, 8 is a portable terminal side communication program (T-NET) for transmitting and receiving files to and from the personal computer side, and 9 is to interpret the information in the file created by P-CEL2 and operate the portable terminal. Controlling program (T-LAN), 10
Is a display screen of the mobile terminal 2, and the entire screen is touch panel input.

[0010] Here, a cell for each data input which is divided on the input screen of the spreadsheet software 4 by a matrix is called a cell.

In FIG. 1, an area divided by the number of matrices corresponding to the screen of the mobile terminal 2 is taken on the input screen 5 of the spreadsheet software 4, and the screen of the mobile terminal 2 is created within that area. In the information for each cell in the input screen 5, a character / ruled line to be displayed on the mobile terminal and a processing function of the mobile terminal are defined. When creating the mobile terminal screen on the screen 5, the P-CEL6
Operates to display guidance at the time of data input, etc., and facilitate creation of a mobile terminal screen. The information of the mobile terminal screen on the input screen 5 is converted by the P-CEL 6 and output to an information file to be sent to the mobile terminal. The P-NET 7 is activated by the spreadsheet software 4 and communicates with the T-NET 7 through the communication means 3.
The file is transferred to and from the NET8, and the information file on the personal computer is transmitted to the portable terminal. On the mobile terminal side, T
-The contents of the file received by NET8 are
The N9 analyzes and reconstructs the screen 5 created on the personal computer on the display screen 10 of the mobile terminal in cell units and displays it. When the touch panel on the display screen of the mobile device is touched,
Processing is performed according to the function and argument defined for the cell corresponding to the touched position.

Hereinafter, the details of each function will be described with reference to the drawings. FIG. 2 shows a data configuration on the personal computer side. The spreadsheet software 4 is software having a program execution environment created and operated on the software 4 and a function of starting an external execution program, for example, Microsoft Excel.
And so on. Reference numeral 11 denotes a document file of the spreadsheet software 1, which is a standard screen 13 indicating the size of the screen of the portable terminal by a frame.
Is a basic file that has in advance as data. The basic file 11 is accompanied by a program P-CEL6 that operates on the spreadsheet software 4. When the basic file 11 is opened on the spreadsheet software 4, the P-CEL6 is activated. P
-CEL6 is for creating / deleting a mobile terminal screen, creating / deleting an item table on the personal computer screen of the spreadsheet software 4,
Creation / deletion of a candidate table, definition of a processing function, generation of a file, transmission of a file, and the like are arranged as function buttons 12. Further, the basic file 11 includes an item table 14 for setting definition information of items to be input on the mobile terminal, a candidate table 15 for setting candidate information for selecting and inputting on the mobile terminal, and data input on the mobile terminal. An input data table 16 to be stored is included.

A procedure for creating a new screen / process of the portable terminal on the input screen 5 will be described below. Basic file 11 with spreadsheet software 4 running
Is opened, and the item table 14 is created first. FIG. 3 shows a procedure for creating the item table 14. When creation of an item table is selected with the function button 12, an input screen 17 for inputting the name of the item table itself is displayed. When the table name is input on the input screen 17, the item name of the input data,
An item information setting table 14 for sequentially inputting the number of digits, format, type (character string / numerical value, etc.), input conditions and processing based on the determination results is displayed. The input is performed according to the guidance displayed on the P-CEL6. Item table 1 created here
The addition, change, and deletion of the information of No. 4 can be performed at any time after the creation. In addition, different item names can be created as different item tables. The input data table 16 for storing data input by the portable terminal constitutes one record according to the definition contents of the item table 14, and the P-CEL 6 automatically corresponds to the item table 14 by creating the item table 14. 16 is generated. In the input data table 16 immediately after generation, only items are set, and no input data is stored. If the input data is stored in advance in the input data table 16, on the mobile terminal, the previously stored input data becomes initial data at the time of input. Further, by setting data in the input data table 16 by this function, the data can be used as a master file handled as reference data on the portable terminal. If there is no item to be input / referenced on the mobile terminal side, there is no need to create the item table 14.

Next, as a preparation for the process of selecting and inputting from specific candidates, a candidate table 15 is created. When creation of a candidate table is selected with the function button 12, an input screen for inputting a candidate table name and number of digits is displayed, and a candidate table 15 is displayed by inputting the table name and number of digits.
The candidate data is input to the displayed candidate table to create the candidate table 15. The data of the candidate table 15 and the input data table 16 can be created by copying from another file as a function of the spreadsheet software 4. If the selection input process is not required, there is no need to create the candidate table 15.

After the table is created, display data and processing functions are set on the input screen 5. The standard screen 13 for the mobile terminal set in the basic file 11 in advance is configured with the number of rows and columns corresponding to the screen size of the mobile terminal. When screen creation is selected by the function button 12, a name input screen of a new screen is displayed. When a screen name is input, the standard screen 13 is copied and displayed on the screen as a new screen. Mobile terminal screen 13
Is created by inputting a character string in the cell information at the position to be displayed, and setting the presence / absence of up / down / left / right for each cell. The function of the spreadsheet software 4 is used for inputting the display character string and setting the ruled line. FIG. 4 shows a setting procedure of the screen transition function as an example. To set the processing function, select the cell at the position where the function is to be set, and then select the function button 12 cell function definition button.
Activate the function definition function of P-CEL6. The function definition function displays functions in a list, and selects a function to be set from the list. An input screen 18 for setting an argument is displayed corresponding to the selected function, and the setting is sequentially performed according to the guidance. When setting the screen, the item table, each item in the item table, and the candidate table as arguments of the function, each registered information is displayed in a list, and is selected from the list. If a new item table not in the list, an item in the item table, or a candidate table is required, a new creation / change can be performed from this screen. In the case of a screen transition, the screen of the transition destination is created first, and then the screen transition function is set.

A part of the processing contents of each function is shown below.

(1) Screen transition This function is set using the screen to be transitioned as an argument. When the set cell is selected on the mobile terminal, the screen shifts to the set screen.

(2) Data input This function is set with the data input method and the item storing the input data as arguments. When a set cell is selected on the mobile terminal, data input processing is performed by a specified input method, and the input data is stored in the input data file as specified item data. Key input, character recognition input, barcode input, magnetic card input, serial I / F (RS-232C, optical communication)
There is an input from and a candidate selection input. In the case of the candidate selection input, the candidate table is designated as an argument, and the information of the designated candidate table is displayed in a list on the portable terminal, and the information selected from the list becomes the input data. Further, at the time of data input, a judgment process of the input condition set in the item table is executed, and a process set according to the judgment result is executed.

(3) Movement of Record of Input Data A record of input data to be displayed on the screen of the portable terminal and a number of a record for storing the input data are set as functions for operating. Operations include moving to the next or previous record,
Move to the designated record number.

(4) Data Search This function is set using the search key input method, the item table to be searched, the item name, and the search method as arguments. On the mobile terminal, when a set cell is selected, data input processing is operated by a specified input method to input a search key. The input method is the same as the item (2). For a specified item of the input data file corresponding to the specified item table, a search process is executed using the input search key, and information of a record corresponding to the search key is displayed on the screen. The search process performs a data search using a specified search method.

Next, a procedure for creating a file to be transmitted to the portable terminal will be described.

When the file creation of the function button 12 is selected, the portable terminal screen 13 created by the above operation
Is stored in a file. FIG. 5 shows the file to be created. 19 is a management file storing related information of all files created by the basic file 11, 20 is display information for each cell set on the mobile terminal screen 5, screen definition file storing processing function information, 21 is an item table Item table file storing 14 setting information, 22
Is a candidate table file storing setting information of the candidate table 15, and 23 is an input data file. In the screen definition file 20, each item of information, which has been handled by a name on a personal computer, such as a set item table, items in the item table, candidate tables, and processing functions, is converted from a name to a number and stored in a file.

The cell definition information stored in the file is limited to the cell in which the information is set. Thereby, the file capacity of the screen definition file can be compressed, and the processing time on the mobile terminal can be reduced. The correspondence information between the name and the converted number is stored in the management file 19. The management file 19 and the screen definition file 20 are each one file, and the item table file 21, the candidate table file 22, and the input data file 23 are one table and one file to create a plurality of files. As a result, data can be shared with other tasks on the mobile terminal, and data access time on the mobile terminal can be reduced. The management file 19 includes, in addition to the file-related information, the creator name, title information, P-CEL version information, etc. of the basic file 11 held by the spreadsheet software 4 and the storage destination information of each file on the portable terminal. To define file management specifications on the mobile terminal. The names of the files 19 to 23 are unified with one file name specified at the time of file creation, and are distinguished by a file extension.

When the function button 12 is selected to transmit a file, the P-CEL 6 activates the P-NET 7 after designating a file storage destination in the portable terminal to which data is transmitted. P-NET7 is a communication program T-
By cooperating with NET8, a plurality of communication means can be supported. As the communication means 3, RS-2
32C, SCSI, optical connection, IC card, wireless, LA
N, modem communication, digital communication, and the like. Communication means is selected according to the hardware configuration and operation mode of the mobile terminal. In communication using a public line such as a modem or digital communication, data is transmitted and received between a personal computer and a mobile terminal.
There are methods such as personal computer communication and the Internet,
FIG. 6 illustrates a method of transmitting and receiving data by mail as an example using personal computer communication and the Internet. In FIG.
Is a personal computer, 2 is a portable terminal, 24 is a personal computer communication or a mail server on the Internet, 25 is a received mail storage area for the mobile terminal managed on the mail server 24, 26 is a received mail storage on the personal computer side Area. It is assumed that the personal computer side and the portable terminal side have unique IDs as mail addresses. The table data file created on the personal computer is transmitted from the personal computer 1 to the mail server 24 by the P-NET 7 as a mail addressed to the portable terminal. The mail addressed to the portable terminal is stored in 25 by the mail server 24. In the mobile terminal 2, the T-NET 8 operates and periodically accesses the mail server 24 to check whether or not the received mail exists in the mail server 25. It is stored in the terminal 23. The input data file input by the mobile terminal 2 is transmitted to the T-NET 8 as a mail addressed to a personal computer.
To the mail server 24. The mail addressed to the personal computer is stored in 26 by the mail server 24. In the personal computer 1, the P-NET 7 operates and periodically accesses the mail server 24 to check whether or not the received mail exists in the personal computer 26. To be stored. Mobile terminal 2
When there are a plurality of mails, the personal computer 1 can confirm from which terminal the mail is sent from the mail sender ID.

In the transmission from the P-NET 7 to the T-NET 8, since the number of transmission files increases, the P-NET
7, the plurality of files are converted into one file and transmitted. The received file is decomposed into each file on the T-NET 8 and each file is stored according to the information of the management file 19. FIG. 7 shows a data configuration of the management file 19. The management file stores the document information of the basic file 11 on the personal computer, the storage location of each file used on the mobile terminal, and the number and file name of each file type. The file storage destination is specified separately for a file in which writing occurs (input data file) and a read-only file (other than the input data file). This allows the user to specify the storage location according to the characteristics of the storage medium in the portable terminal from a personal computer. In the case of a storage medium having a large capacity but a low writing speed (such as a flash memory), a read-only file is used. Can be arranged according to the characteristics of the storage medium possessed by the portable terminal, such as storing a file in which reading and writing occur in a storage medium with a high writing speed.

Next, processing on the portable terminal side will be described. FIG. 8 shows a flowchart of a processing outline on the mobile terminal side. The portable terminal side program T-LAN 9 reads the file related information of the management file 19 at the time of startup. First, the version information of P-CEL6 is confirmed, and T-LA
A version check is performed on N9 to determine whether or not it can be used. In the case of NG, an error message is displayed and the process ends. O
In the case of K, each file name in the management file 19 is read, and the item table number, candidate table number, Bi
The tMap file number is stored in the memory of the portable terminal as a table in which the file name and the file name are associated with each other so that the table can always be referred to. FIG. 9 shows the data structure of the screen definition file 20. The screen definition file 20 stores information of all screens as 1
Stored in a file. The T-LAN 9 opens the screen definition file 20, obtains a screen number to be displayed first from the screen definition file information, and reads the screen information of the number. In the screen information, an item table that mainly inputs and outputs data,
Only one input data file is specified, and the item information of the item table is expanded from the item table file to the memory of the portable terminal. As a result, file access to the item table file 21 does not occur in normal data input / output processing, so that the processing speed of the portable terminal can be increased. Next, the cell definition information of the screen is read. FIG.
9 shows a flowchart of the screen display processing. The display position on the screen of the mobile terminal is calculated from the row and column of the read cell definition information, the ruled line is displayed by looking at the ruled line information at the top, bottom, left and right, and the display character string is displayed according to the display position and attribute information. The display position has designation information such as left-justified, right-justified, centered, and evenly divided. When the display character string extends beyond the cell, if there is no character string display specification in the cell on the right, the right cell is overwritten. If the character string display area is specified as a rectangle over multiple cells, the cells in the upper left corner and lower right corner are distinguished from other cells by flags to specify the display area, and the character string is displayed according to the display position information . In addition, looking at the function number, in the cell where the item number of the item table is specified as an argument, extract the data corresponding to the item number from the input data file, convert it according to the cell information format, and follow the display position information. indicate. The screen of the mobile terminal is displayed by performing the above processing for all cell information in the screen information.

After displaying the screen, the portable terminal waits for input from the portable terminal. When there is an input, the cell row / column is calculated from the input position information, and the cell information of the corresponding row / column is searched. The function argument corresponding to the function number set in the cell information is extracted from the cell information, and the function corresponding to the function number is activated. The processing operations of the main functions will be described below.

(1) Screen transition function The screen transition function is activated with the screen number to be transitioned as an argument. After confirming that the screen number is different from the current screen number, the screen transition function opens the screen definition file 20, extracts the screen information and cell information corresponding to the screen number, and carries the item table corresponding to the screen information. Extract to terminal memory. Thereafter, the screen display processing is performed by performing the processing shown in FIG.

(2) Data input function The data input function is started using the data input method and the item number corresponding to the input data as arguments. The data input function includes key input, character recognition input, bar code input, magnetic card input, serial I / F (RS-2
32C, optical communication) and candidate selection input, and the data input by the specified input method is stored in the input data file 23 according to the item information on the item table corresponding to the item number.

The selection input from the candidate table among the input methods will be described below. In the selection input, a candidate table number is added to the argument, and when the data input function is activated, the contents of the candidate file corresponding to the candidate table number are read and developed as a candidate table on the memory of the portable terminal. A rectangular frame for displaying the candidate table is displayed on the screen of the mobile terminal, and the candidate table information is displayed in a list in the frame. If the candidate table information cannot be displayed in the frame, scroll display is performed, and input data is selected from the candidate table information by touching the screen. The input data is stored in the input data file, and is displayed at the cell position according to the format, display position, and attribute information of the corresponding cell definition information.

(3) Movement of Record of Input Data One item of input data corresponding to all items set in the item table 14 is treated as one record, and input / output is performed in the input data file 21 on a record basis. Immediately after the screen transition, the current record position is set to the new data record next to the input data record. In this function,
The record position can be moved. The function of the function is to move the record position back and forth, move by specifying the record number, perform data search using the data entered in the specified item as a search key, and perform the process of moving to the matched record.

When the record position is moved, all the input data at the record position is displayed again on the screen, and the displayed data can be corrected.

The data input on the portable terminal in the above processing is stored in the input data file 23 on a record-by-record basis according to the information in the item table 14. The stored input data can be displayed and referenced on the terminal at any time by using the record movement function of the input data. The input data to be stored in the input data file is stored in a data format that can be processed by the spreadsheet software 4 on the personal computer.

When the data input operation on the portable terminal is completed, the input data file is uploaded to the personal computer. The input data file 23 is transferred from the portable terminal to the personal computer by activating the P-NET 7 in the receive mode on the personal computer and activating the T-NET 8 in the transmit mode on the portable terminal. The transmission from the portable terminal to the personal computer targets only the input data file 23. The transferred input data file 23 is stored as a file on a personal computer, and the input file can be opened and read and processed on the spreadsheet software 4 by the spreadsheet software 4.

<Second Embodiment> In the first embodiment, as the portable terminal screen 5, one data defined in the item table 14 is handled on one screen (single form), and a plurality of records are handled on one screen. (Table format). FIG. 11 shows a creation procedure and a screen example. Function button 12
When the screen creation is selected, an input screen 27 for the screen name is displayed. On the screen name input screen, the screen type is selected together with the screen name input. In the cut-sheet format 28, all input items set in one screen are handled as data of the same record. In the case of the table format 29, one input line on the portable terminal screen becomes data for one record of input data, and a plurality of records can be displayed and input in one screen. In the setting of the mobile terminal screen in the table format, the area of the mobile terminal screen to be input into the table is specified over a plurality of lines, and the definition of the input items is set only in the first line of the table input area.

In the portable terminal side program T-LEN9,
In the case of the table input screen, it is determined whether or not the specified cell is a table input area. When a cell in the table input area is specified, the cell information at the head of the table input area in the same column as the corresponding cell is searched, and Performs processing according to the definition information.

<Embodiment 3> In the first embodiment, the processing in the portable terminal in which the entire display screen is an input area has been described. However, in the case of a portable terminal having key input means separately from the display area,
As a mobile terminal screen prepared in advance in the basic file 11,
Assign keys that can be used on the mobile device to a cell different from the mobile device screen. In the cell allocated as a key, only the setting of the processing function is valid, and the setting of the display character string / ruled line is invalid. FIG. 11 shows a portable terminal 31 provided with keys in addition to the display screen, and an input screen 30 as an example of a portable terminal input screen on the personal computer side. For the key, a processing function of each key is set for each screen. If the display screen does not have an input function, only the setting of the display character string / ruled line is valid, and the setting of the processing function is invalid.

<Embodiment 4> An embodiment in which data input by the portable terminal 2 is processed on a personal computer will be described with reference to FIG. The input data file 23 input by the portable terminal 2 according to the first embodiment is transmitted to the portable terminal via the second communication means T-NET8 and the communication means 3 on the portable terminal side and the first communication means P-NET7 on the personal computer side. 2 to the personal computer 1. In the personal computer 1, the P-CEL 6 creates the input table 16 as a table of the spreadsheet software 4 based on the information of the item table 14 corresponding to the input data file 23,
For each item of the input table 16, the number of digits, type (character / numerical value, etc.), display format, and the like are set from the information in the item table 14. By taking the input data of the input data file 23 into the table of the input table 16, the data can be handled as processed data on the spreadsheet software 4 without processing the data. Also, input data file 2
Since 3 is in a data format that can be referred to by the spreadsheet software 4, it is also possible to directly develop the spreadsheet data as table data of the spreadsheet software 4 without performing this processing.

[0039]

As described above, according to the present invention, processes such as display screens, screen transitions, data input, retrieval, and calculations of portable information terminal equipment are converted into table data using spreadsheet software on a personal computer. By transmitting the table data created on the personal computer to the portable information terminal device from the personal computer using the communication means on the personal computer side and the portable information terminal side, keys and peripheral devices on the portable information terminal device can be created. It is possible to perform processing such as data input from the server, arithmetic processing, and data search. The data input on the portable information terminal device can be transmitted from the portable information terminal to the personal computer using the communication means, and the personal computer captures the input data received in the table including the table data. Thus, the data can be handled as data that can be processed on spreadsheet software. Thus, according to the conventional technology, even when functions such as data input / output and arithmetic processing that require creation of a program in a predetermined programming language for a portable information terminal device are realized, the program Eliminates the need to create Furthermore, since there is no need to develop a program for data transmission / reception processing between the personal computer and the portable information terminal device, a data input / output system using the portable information terminal device utilizing the features of the portable information terminal device is eliminated. It has the effect of being able to develop at a low price and in a short time.

[Brief description of the drawings]

FIG. 1 is a program configuration diagram showing an embodiment of the present invention.

FIG. 2 is a data configuration diagram on the personal computer side.

FIG. 3 is a diagram showing a procedure for creating an item table on the personal computer side.

FIG. 4 is a diagram showing a procedure for defining a function for a cell on the personal computer side.

FIG. 5 is a diagram showing each file created on the personal computer side.

FIG. 6 is a diagram showing an embodiment of a connection between a personal computer and a portable information terminal device.

FIG. 7 is a diagram showing a data structure of a management file 17;

FIG. 8 is a flowchart showing an outline of processing on the portable information terminal device side.

FIG. 9 is a diagram showing a data structure of a screen definition file 18.

FIG. 10 is a flowchart illustrating a screen display process on the portable information terminal device.

FIG. 11 is a diagram showing a procedure for creating two different screen formats as processing screens of the portable information terminal device.

FIG. 12 is a diagram showing an example of a display screen on a portable information terminal device having a key in addition to the display screen.

FIG. 13 is a diagram showing a process performed by a personal computer on data input by the portable information terminal device.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Personal computer, 2 ... Portable information terminal equipment, 3 ... Communication means between a personal computer and portable information terminal equipment, 4 ... Spreadsheet software operated on a personal computer, 5 ... Spreadsheet software 1 table input screen, 6… Program running on spreadsheet software 1 (PC
EL), 7: PC side program (P-NET) for communication with portable information terminal device, 8: Portable information terminal device side program (T-NET) for communication with personal computer, 9: Portable information Control program (TL for terminal equipment)
AN), 10: Display screen of portable information terminal equipment, 11: Document file of spreadsheet software 1 with P-CEL3, 12: Function buttons displayed by P-CEL3 on input screen 1, 13: Input screen 1 14: Item table, 15: Candidate table, 16: Input data table, 17: Input screen of item table name, 18: Argument setting screen of screen transition function, 19: Management file Reference numeral 20: Screen definition file 21: Item table file 22: Candidate table file 23: Input data file 24: Mail server 25: Mail storage area of the portable information terminal device 2, 26: Mail storage of the personal computer 1 Area, 27: Input screen for the name and format of the portable information terminal device screen, 28: Portable information terminal device display screen in single form 29, a portable information terminal device display screen in a tabular form, 30: a screen example of a portable information terminal device having a screen and keys separately displayed on the input screen 1, 31: portable information having a screen and keys separately Terminal equipment example.

 ──────────────────────────────────────────────────続 き Continuing on the front page (72) Inventor Toshihiro Sato 800, Tomita, Ohira-machi, Shimotsuga-gun, Tochigi Pref.Hitachi Co., Ltd.Cooling Division (72) Inventor Tomohiro Aoyama 2 Hitachi Tochigi Electronics Co., Ltd. (72) Inventor Mitsuru Tashiro 709, Tomita, Ohira-cho, Shimotsuga-gun, Tochigi 2 Hitachi-Tochigi Electronics Co., Ltd. 2 Inside Hitachi Tochigi Electronics Co., Ltd.

Claims (8)

[Claims] 1. A personal computer on which spreadsheet software capable of defining table data and a calculation process for each data entry (cell) in a table format, a portable information terminal device, the personal computer and the mobile phone In a data input / output system by a portable information terminal device configured with a communication connection unit that connects with a type information terminal device, a first data processing unit that stores information of the table data in a table data file, A first communication means for transmitting / receiving the table data file stored in the first data processing means to / from the portable information terminal device, the second communication means for transmitting / receiving the table data created by the personal computer, A portable information terminal device having second data processing means for calculating a cell-divided table on a display screen in cell units and creating the table in the same manner as the spreadsheet software. Data input and output system by the information terminal equipment. 2. A data input / output system according to claim 1, wherein said second communication means for transmitting / receiving table data created by a personal computer, and a display screen similar to said spreadsheet software. And a second data processing means for calculating a cell-divided table on a cell-by-cell basis to create the table. 3. A recording medium storing a program capable of executing first data processing means for storing information from the table data in a table data file in the data input / output system using the portable information terminal device according to claim 1. 4. A data input / output system using a portable information terminal device according to claim 1, wherein, similarly to said spreadsheet software, a table divided into cells on a display screen is calculated in units of cells to create a table. A recording medium storing a program capable of performing the second data processing means. 5. The spreadsheet software according to claim 3, wherein the first data processing means is application software operating on the spreadsheet software, and a display screen of a portable information terminal device is displayed on an input screen of the spreadsheet software. A function of displaying a table indicating an input unit, a function of setting a function of a portable information terminal device in each cell of the input screen of the spreadsheet software, and a function of displaying an operation guide of an input operation for setting the function information And a function of outputting table data created by the above operation to the first communication means. 6. A function according to claim 4, wherein the second data processing means displays characters and image data in cell units based on the table data received from the personal computer by the second communication means. Based on the table data, a function of inputting data, performing arithmetic processing, searching for and changing input data, and transmitting data input by a portable information terminal device to a personal computer by a second communication means based on the cell data. A second data processing means, comprising: 7. An input / output system according to claim 1, wherein the first data processing means on the personal computer has an initial display function of an input area corresponding to the screen size of the portable terminal, and spreadsheet software. Has a function setting function that can set a function dedicated to a portable information terminal device that is not prepared for each cell in each cell, and selects a cell on the display screen in the second data processing means on the portable information terminal device A data input / output system using a portable information terminal, having a function and a function of realizing the processing of the function. 8. The data input / output system using the portable information terminal device according to claim 1, wherein said second data processing means creates table data, said second communication means,
The table data is transmitted from the portable information terminal device to the personal computer by the communication connection unit that connects the personal computer and the portable information terminal device and the first communication unit, and the table data is converted into the input data. A data input / output system using a portable information terminal device, characterized in that the first data processing means has a function of taking in a table including attribute information.