JP2007026348A - Table data processor and table data processing program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To certainly and easily convert table data into data for a business application. <P>SOLUTION: This table data processor has: a display part 14 displaying information; a display control means making a display means display the table data; a storage part 15 storing an inquiry item file including an item used in a layout of the business application; an input part 12 designating the position information of a cell of the table data correspondingly to each the item of the inquiry item file; and a conversion table creation means associating the designated position information of the cell and the item to create a conversion table. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a table data processing apparatus and a table data processing program.

  Conventionally, when a file such as a quotation (table data) created by a spreadsheet application program is used in another business application (program), the table data is converted into data for the business application.

  As one of the conversion methods, a configuration in which items of table data are automatically recognized and extracted, and business application data is created based on the extracted items is considered (see, for example, Patent Document 1). ).

  A conversion program for converting table data into business application data is also implemented. For example, the table data cells are combined and moved to perform processing, and conversion is performed by creating business application data in a fixed format.

In addition, without processing the table data itself, the user inputs information related to the association between the cell of the table data and the item of the business application data to create and register the association table, and the table is displayed using the association table. Data conversion was done.
JP 2002-287916 A

  However, in the conventional configuration in which items of table data are automatically recognized, extracted, and converted, the items may not be recognized or erroneous recognition may occur.

  Moreover, in the structure which processes and converts the conventional table | surface data, the user had to process as preparation for conversion by operation input, and there existed a problem that a user's work burden was large.

  In addition, in the configuration in which the association data of the conventional table data is created and converted, the user can visually recognize and record the cell column number and row number while referring to the table data, and manipulate the column and row number. There is a problem that it is necessary to input and register it as an association table, which places a heavy burden on the user.

  An object of the present invention is to reliably and easily convert table data into data for business applications.

In order to solve the above problems, the table data processing apparatus of the present invention is:
Display means for displaying information;
Display control means for displaying table data on the display means;
A query item file storage means for storing a query item file including items used in the layout of the business application;
Corresponding to each item of the inquiry item file, designating means for designating cell position information of the table data;
Conversion table creating means for creating a conversion table by associating the location information of the designated cell with the item.

Further, for example, provided with conversion table storage means for storing the conversion table created by the conversion table creation means,
The display control means may be configured to display by default the cell position of the table data corresponding to each item of the inquiry item file based on the conversion table stored in the conversion table storage means. .

  In addition, for example, based on the conversion table created by the conversion table creation means, it is configured to include a conversion means for creating a conversion result transaction file including data of the specified cell position in the table data. Also good.

  Further, for example, an editing unit that edits the conversion result transaction file created by the conversion unit to create business application data corresponding to the layout of the business application may be provided.

  Further, for example, the editing unit may be configured to create business application data including identification information for identifying a layout pattern of the business application.

  Further, for example, a voice output unit that outputs voice guidance related to designation of position information of cells of the table data may be provided.

  According to the present invention, a conversion table can be easily created, and table data can be reliably and easily converted into a conversion result transaction file for a business application using the created conversion table.

  DESCRIPTION OF EMBODIMENTS Hereinafter, preferred embodiments according to the present invention will be described in detail with reference to the accompanying drawings. The present invention is not limited to the illustrated example.

  First, the apparatus configuration of the present embodiment will be described with reference to FIG. FIG. 1 shows the configuration of the PC 10 according to the present embodiment.

  As shown in FIG. 1, a PC (Personal Computer) 10 as a table data processing apparatus according to the present embodiment includes a CPU (Central Processing Unit) 11, an input unit 12 as a specifying means, and a RAM (Random Access Memory). 13, a display unit 14 as a display unit, a query item file storage unit, a storage unit 15 as a conversion table storage unit, a communication unit 16, and a voice output unit 17 as a voice output unit. Each unit is connected via the bus 18.

  The CPU 11 centrally controls each part of the PC 10. The CPU 11 develops a program designated from the system program and various application programs stored in the ROM 14 in the RAM 13, and executes various processes in cooperation with the program expanded in the RAM 13. Display control means, conversion table creation means, conversion means, and editing means are configured by the cooperation of the CPU 11 and the program.

  The CPU 11 creates a conversion table 40 by extracting items from the conversion target estimate file 20 based on the query items in the query item file 30 in cooperation with a table data conversion program described later, and uses the conversion table 40. The conversion target estimate file 20 is converted to create a conversion result transaction file 50, and the conversion result transaction file 50 is edited to create business application data.

  The input unit 12 includes a keyboard including cursor keys, numeric input keys, various function keys, and the like, and outputs a pressing signal pressed by the operator using the keyboard to the CPU 11. Further, the input unit 12 may include a pointing device such as a mouse.

  The RAM 13 is a volatile memory, has a work area for storing various programs to be executed, data related to these various programs, and the like, and temporarily stores information.

  The display unit 14 includes an LCD (Liquid Crystal Display), a CRT (Cathode Ray Tube), and the like, and performs screen display according to a display signal from the CPU 11.

  The storage unit 15 includes a recording medium (not shown) in which various programs, various data, and the like are stored or writable in advance, and a storage such as an HDD (Hard Disk Drive) that stores various information in the recording medium in a readable manner Part. The storage unit 15 is not limited to a fixed one such as an HDD, but is a CD-R (Recordable) / RW (Rewritable), DVD (Digital Versatile Disk) -R / RW, memory card, portable hard disk, blue A portable storage unit to which a recording medium such as a large-capacity information recording medium using a laser is detachably mounted may be used.

  The storage unit 15 stores a table data conversion program. The storage unit 15 also stores an inquiry item file 30, a conversion table 40, a conversion result transaction file 50, and a business application DB (Data Base) 60.

  The communication unit 16 includes a modem, a TA (Terminal Adapter), a router, a network card, and the like, and transmits / receives information to / from an external device such as a device on a connected communication network.

  The audio output unit 17 includes an amplifier, a speaker, and the like. The audio output unit 17 amplifies an audio signal input from the CPU 11 with an amplifier and outputs audio from the speaker.

  Next, information stored in the storage unit 15 will be described with reference to FIGS. FIG. 2 shows the operation of the PC 10 and the data flow. FIG. 3A shows an example of the inquiry item file 30. FIG. 3B shows an example of the conversion table 40. FIG. 4A shows an example of the estimate ledger file 51. FIG. 4B shows an example of the estimate detail file 52.

  As shown in FIG. 2, the storage unit 15 includes an inquiry item file 30, a conversion table 40 created by a conversion table creation process described later, a conversion result transaction file 50 created by a conversion execution process described later, A business application DB 60 that stores business application data created by input processing to be described later is stored.

  The business application data is data as a final purpose created by a table data conversion process to be described later, and is data in the same format as the estimate file 81 created by the predetermined business application 71. The business applications 71 and 72 are the same business application but have different layout patterns (input patterns) such as items of the estimate file to be created. For this reason, the estimate file 81 created by the business application 71 and the estimate file 82 created by the business application 72 have different layout patterns. As an identification number for identifying this layout pattern, an identification number “101” is assigned to the estimate file 81, and an identification number “102” is assigned to the estimate file 82. The business application data created by the input process will be described as corresponding to the identification number “101”.

  The inquiry item file 30 is a CSV (Comma Separated Value) file having items to be extracted from the conversion target estimate file 20. The conversion target estimate file 20 is an estimate file as table data created by execution of a predetermined spreadsheet application program, and is converted into business application data. The conversion target estimate file 20 is created by the PC 10 or created by an external device and recorded on a recording medium such as a flexible disk, CD, or DVD, and is read via the recording medium drive of the storage unit 15 or externally. The data is input by receiving the data created by the device via the communication unit 16 or the like. It is assumed that the input conversion target estimate file 20 is stored in the HDD of the storage unit 15 in advance.

  As shown in FIG. 3A, in the inquiry item file 30, for example, a number for identifying an item and an item name such as an estimate number are stored in association with each other. FIG. 3A shows the inquiry item file 30 in the CSV format in a table format, and illustrates some items of the inquiry item file 30.

  The conversion table 40 is a CSV file having information for associating the conversion target estimate file 20 with the business application data to be finally created for each item. The conversion table 40 has a ledger part 41 and a detail part 42.

  As shown in FIG. 3B, the ledger part 41 of the conversion table 40 includes, for example, a conversion number for identifying the type of conversion, and a row number and a column number (estimate number line, And an estimate number string) are stored in association with each other. These row numbers and column numbers are row numbers and column numbers in the spreadsheet application program. The row numbers are represented by 1, 2,... In sequence, and the column numbers are represented by A, B,. .

  As shown in FIG. 3B, the detailed portion 42 of the conversion table 40 includes, for example, a conversion number for identifying the type of conversion and a column number (product code string or the like) of each item corresponding to the conversion number. Stored in association. FIG. 3B shows the conversion table 40 in CSV format in a table format, and illustrates some items of the conversion table 40.

  The conversion result transaction file 50 is a CSV file having information on the conversion result of the conversion target estimate file 20. The conversion result transaction file 50 includes an estimate ledger file 51 and an estimate details file 52.

  The estimate ledger file 51 is a CSV file having information on the ledger part extracted for each item from the conversion target estimate file 20. As shown in FIG. 4A, the estimate ledger file 51 stores, for example, a fetched estimate number for identifying the fetched conversion target estimate file 20 and an item name such as a quote date in association with each other. The FIG. 4A shows an estimate ledger file 51 in CSV format in a table format, and illustrates some items of the estimate ledger file 51.

  The estimate detail file 52 is a CSV file having information of the detail portion extracted for each item from the conversion target estimate file 20. As shown in FIG. 4B, the estimate detail file 52 stores, for example, a fetched estimate number, each line number, and an item name such as a product code associated with the line number. The FIG. 4B shows a CSV-format estimate detail file 52 in a table format, and illustrates some items of the estimate ledger file 51.

  Next, the operation of the PC 10 will be described with reference to FIGS. FIG. 5 shows the flow of the table data conversion process. FIG. 6 shows the flow of the conversion table creation process of the table data conversion process. FIG. 7 shows an overview of the conversion table creation process. FIG. 8 shows a table data display area 101a in which cells are displayed by default. FIG. 9 shows the flow of the conversion execution process of the table data conversion process. FIG. 10 shows an outline of the conversion execution process. FIG. 11 shows the flow of input processing. FIG. 12 shows an outline of the input process. FIG. 13 shows the flow of the product code acquisition process.

  The table data conversion process will be described with reference to FIGS. The table data conversion process is a process for creating business application data in the same format as the output data of a predetermined business application 71 from the conversion target estimate file 20 and storing it in the business application DB 60. For example, when the execution instruction of the table data conversion process is input as a trigger, the table data conversion process is performed in cooperation with the table data conversion program read from the storage unit 15 and appropriately expanded in the RAM 13 and the CPU 11. Executed.

  First, the conversion target estimate file 20 stored in advance in the storage unit 15 is opened (step S1). Then, based on the inquiry item in the inquiry item file 30, a conversion table creation process is executed for extracting the items from the conversion target estimate file 20 and creating the conversion table 40 (step S2).

  Then, the conversion execution process for converting the conversion target estimate file 20 using the conversion table 40 and creating the conversion result transaction file 50 (the estimate ledger file 51 and the estimate detail file 52) is executed (step S3). Then, input processing for creating business application data by editing the conversion result transaction file 50 with various input data is executed (step S4), and the table data conversion processing is completed.

  Next, the conversion table creation process in step S2 of the table data conversion process will be described with reference to FIGS.

  The table data conversion process is mainly a process for creating a conversion table 40 for converting the conversion target estimate file 20, but when there is a conversion table that has already been created and stored in the storage unit 15, The conversion table may be a copy source conversion table, and a new conversion table may be created based on the copy source conversion table. Further, when there is a conversion table already registered in the storage unit 15 and the conversion table is corrected, the conversion table may be used as a correction conversion table and a new conversion table may be created based on the correction conversion table. Good. A number for identifying the conversion table is a conversion number. Further, a number for identifying the copy source conversion table is set as a copy source conversion number. It is preferable that the copy source conversion table and the correction conversion table have a layout similar to that of the conversion table to be created, because a user's operation input can be facilitated.

  In the conversion table creation process, as shown in FIG. 6, first, the conversion table creation screen 100 is displayed on the display unit 14 (step S11). Specifically, the conversion table creation screen 100 includes a table data display area 101, a copy source conversion number input area 102, a conversion number input area 103, a current item display area 104, a cell, as shown in FIG. It has a number display area 105, an execution key 106, an end key 107, a previous item key 108, and a next item key 109. When the end key 107 is pressed during execution of the conversion table creation process, the conversion table creation process (table data conversion process) ends.

  Here, when the copy source conversion table is used, a desired copy source conversion number is input from the user via the input unit 12. For example, the copy source conversion number is input to the copy source conversion number input area 102 of the conversion table creation screen 100. Then, it is determined whether or not a copy source conversion number has been input (step S12). When the copy source conversion number is input (step S12; YES), the copy source conversion table of the input copy source conversion number is read from the storage unit 15 and the record is stored in the RAM 13 (step S13).

  And the input of the desired new conversion number from a user is received via the input part 12 (step S14). For example, the conversion number is input to the conversion number input area 103 of the conversion table creation screen 100. If the copy source conversion number has not been input (step S12; NO), the process proceeds to step S14. In step S14, it is determined whether or not a registered conversion number corresponding to the conversion table already stored (registered) in the storage unit 15 is input (step S15). When the registered conversion number is input (step S15; YES), the input conversion table of the registered conversion number is read from the storage unit 15 as a correction conversion table and the record is stored in the RAM 13 (step S16). ).

  Then, the inquiry item file 30 is read from the storage unit 15, and one item is selected from all items of the inquiry item file 30 and displayed on the display unit 14 (step S17). For example, the selected item is displayed in the current item display area 104 of the conversion table creation screen 100. In step S17, one unselected item is basically selected in the order of records. However, when the previous item key 108 or the next item key 109 is pressed in step S27, the items in the record order are selected. The previous or next item is selected by. When the registered conversion number is not input (step S15; NO), the process proceeds to step S17.

  Then, the line number corresponding to the item selected in step S17 is acquired from the copy source conversion table or the correction conversion table (step S18). Then, the column number corresponding to the item selected in step S17 is acquired from the copy source conversion table or the correction conversion table (step S19). Then, the row numbers and column numbers acquired in steps S18 and S19 are combined as cell numbers, and the row numbers and column numbers are displayed on the display unit 14 (step S20). For example, when the row number is 10 and the column number is B, the cell number is B10. The cell number (row number and column number) is displayed in the cell number display area 105 of the conversion table creation screen 100.

  In steps S18 to S20, when the copy source conversion table or the correction conversion table is not stored in the RAM 13 (when a new conversion table is created), the cell number is set to be empty, and the cell number display area 105 is also numbered. Is not displayed.

  Then, it is determined whether or not the cell number acquired in step S20 is empty (step S21). When the cell number is not empty (step S21; NO), the cell with the cell number is displayed by default on the display screen of the display unit 14 by selection display, highlight display, or the like (step S22). For example, as shown in FIG. 8, when the acquired cell number is B20, the corresponding cell 110 is displayed by default.

  Then, the designation input of the cell corresponding to the item selected in step S17 from the user is accepted via the input unit 12, and the row number and column number of the designated cell are acquired (step S23). For example, as shown in FIG. 7, a voice guidance prompting the designation of a cell is outputted from the voice output unit 17, and a cell in the table data display area 101 of the conversion table creation screen 100 is designated by a click input by the user. When the cell number is empty (step S21; YES), the process proceeds to step S23.

  Here, the user presses the execution key 106 (when the specified cell is acceptable), the previous item key 108 (when selecting the item of the previous record) or the next item key 109 (when selecting the item of the next record). An input is received via the input unit 12. Then, it is determined whether or not the execution key 106 has been pressed (step S24). When the execution key 106 is pressed (step S24; YES), the row number and column number acquired in step S23 are stored in the RAM 13 as a record array in association with the item being selected (step S25).

  Then, it is determined whether or not the item currently selected in step S17 is the last item in the inquiry item file 30 (step S26). If it is not the last item (step S26; NO), the process proceeds to step S17. If the execution key 106 has not been pressed (step S24; NO), it is determined whether the previous item key 108 or the next item key 109 has been pressed (step S27). If the previous item key 108 or the next item key 109 has not been pressed (step S27; NO), the process proceeds to step S24.

  When the previous item key 108 or the next item key 109 is pressed (step S27; YES), the process proceeds to step S17. If it is the last item (step S26; YES), the conversion table 40 is created by associating the record array item, row number and column number stored in the RAM 13 in step S25 with the conversion number input in step S14. It is created and stored in the storage unit 15 (step S28), and the conversion table creation process ends.

  Next, the conversion execution process in step S3 of the table data conversion process will be described with reference to FIGS.

  As shown in FIG. 9, first, a conversion execution screen is displayed on the display unit 14 (step S31). Specifically, the conversion execution screen includes the conversion number of the conversion table to be used, the conversion target estimate file name (including the sheet name), the storage location of the conversion result transaction file, and the line of the detail portion 42 of the conversion table 40. The number range and the input area are included. The line number range in the detail portion of the conversion table 40 is all line numbers that are not less than the first line number in the range that is the smallest line number in the range and less than or equal to the last line number that is the largest line number in the range. And

  Then, the input of the conversion number, the conversion target estimate file name, the conversion result transaction file storage destination, and the line number range from the user is accepted via the input unit 12 (step S32). Then, the conversion target estimate file 20 corresponding to the conversion target estimate file name input in step S32 is opened from the storage unit 15 (step S33). For example, the change execution screen 200 shown in FIG. 10 is displayed on the display unit 14. The change execution screen 200 has a table data display area 201 for displaying the conversion target estimate file 20 opened in step S33, and an execution key 202. Here, when the execution key 202 is pressed and input, the following steps are executed.

  Then, the conversion table 40 corresponding to the conversion number input in step S32 is read from the storage unit 15, and the record array of the conversion table 40 is stored in the RAM 13 (step S34). Then, the item of the ledger part 41 is expanded on the RAM 13 from the record array of the conversion table 40 stored in the RAM 13 (step S35).

  Then, among all the items of the ledger part 41 stored in the RAM 13, one unselected item is selected in the order of records, and the column number and row number corresponding to the item are acquired (step S36). Then, it is determined whether or not the column number and the row number acquired in step S36 are empty (step S37). If the column number and row number are not empty (step S37; NO), the acquired column number and row number are combined to obtain the cell number (step S38).

  Then, in correspondence with the cell number acquired in step S38, the character string of the cell of the conversion target estimate file 20 acquired in step S33 is acquired (step S39). The acquired character string is stored in the RAM 13 in association with the item being selected (step S40). And it is discriminate | determined whether the last item of the ledger part 41 was selected in step S36 (step S41). When the column number and the row number are empty (step S37; YES), the process proceeds to step S41.

  When the last item of the ledger part 41 is not selected (step S41; NO), the process proceeds to step S36. When the last item of the ledger portion 41 is selected (step S41; YES), the estimated ledger file 51 is created from the items and character strings stored in the RAM 13, and the conversion result obtained by inputting the estimated ledger file 51 in step S32 Based on the storage location of the transaction file 50, it is stored in the storage unit 15 (step S42).

  Then, the item of the detail portion 42 is expanded on the RAM 13 from the record array of the conversion table 40 stored in the RAM 13 (step S43). Then, 001 is substituted for the update row number (step S44). The update line number is a line number used in the estimate detail file 52. Then, the range start line number input in step S32 is substituted for the item line number (step S45). The item line number is the line number of each item in the conversion target estimate file 20.

  Then, among all items in the detail portion 42 stored in the RAM 13, one unselected item is selected in the record order, and the column number corresponding to that item is acquired (step S46). And it is discriminate | determined whether the column number acquired in step S46 is empty (step S47). If the column number is not empty (step S47; NO), the cell number is acquired by combining the column number acquired in step S46 and the item row number set in step S45 or S53 (step S48). .

  Then, in correspondence with the cell number acquired in step S48, the character string of the cell of the conversion target estimate file 20 acquired in step S33 is acquired (step S49). The acquired character string is stored in the RAM 13 in association with the selected item and the update line number (step S50). Then, it is determined whether or not the last item of the item row number has been selected in step S46 (step S51). If the column number is empty (step S47; YES), the process proceeds to step S51.

  When the last item of the item row number has not been selected (step S51; NO), the process proceeds to step S46. When the last item of the item line number is selected (step S51; YES), it is determined whether or not the item line number is the range last line number input in step S32 (step S52). If the item line number is not equal to the last line number in the range (step S52; NO), the update line number and the item line number are each incremented by +1 (step S53), and the process proceeds to step S46.

  When the item line number = the last line number in the range (step S52; YES), the estimate detail file 52 is created from the update items and character strings stored in the RAM 13, and the estimate detail file 52 is input in step S32. Based on the storage destination of the result transaction file 50, it is stored in the storage unit 15 (step S54), and the conversion result transaction file 50 including the estimate ledger file 51 and the estimate detail file 52 is stored in the storage unit 15, and the conversion is executed. The process ends.

  Next, the input process in step S4 of the table data conversion process will be described with reference to FIGS.

  As shown in FIG. 11, first, an input processing screen is displayed on the display unit 14 (step S61). Specifically, the input processing screen includes a selection input area for data to be acquired from the conversion result transaction file 50.

  Then, the input of the selection of data to be imported from the conversion result transaction file 50 and the identification number (the identification number of the layout pattern of the business application) associated with the business application data to be generated is input from the user via the input unit 12. (Step S62). For example, the identification number “101” corresponding to the business application 71 of FIG. 2 is input.

  Then, the import target data selected in step S62 is read from the conversion result transaction file 50 stored in the storage unit 15 (step S63).

  Then, the capture target data read in step S63 is shaped, and the capture target data is displayed on the display unit 14 in a layout pattern corresponding to the identification number input in step S62 (step S64). The shaping of the data to be captured includes deleting unnecessary spaces and characters in the data to be captured and converting various numerical values to appropriate digits. In step S64, for example, an input processing screen 300 including the import target data as shown in FIG.

  Then, various edits are performed on the displayed capture target data (step S65). The editing of the capture target data includes, for example, adding appropriate data to the blank of the capture target data, changing various data, and the like.

  Then, it is determined whether or not there is an error in the import target data edited in step S65 (step S66). For example, when there is no data required as business application data, the data format is inappropriate, or data that is not allowed to be duplicated such as an estimate number is stored in the business application DB 60. Is also present.

  If there is an error (step S66; YES), the process proceeds to step S65. At this time, the type and location of the error are preferably displayed on the display unit 14. If there is no error (step S66; NO), business application data is created by associating the import target data edited in step S65 with the identification number acquired in step S62, and the business application data is stored in the storage unit 15. Are stored in the business application DB 60 (step S67), and the input process is terminated.

  Here, with reference to FIG. 13, the flow of acquiring the item “product code” (referred to as product code acquisition processing) will be described as an example of editing the import target data in step S <b> 65. First, it is determined whether or not a product code has been acquired based on whether or not a product code is included in the import target data (step S71).

  If the product code has not been acquired (step S71; NO), the product in the product name search table (not shown) stored in advance in the storage unit 15 using the product name and the product name 2 as items in the import target data as keys. The code is indexed (step S72). In the product name search table, it is assumed that a product code is associated with the product name and the product name 2 and stored.

  Then, it is determined whether or not the product code is indexed and acquired in step S72 (step S73). If the product code has not been acquired (step S73; NO), it is determined whether or not an operation input of the product code from the user is accepted (step S74). When the operation input of the product code is not performed (step S74; NO), the product code column of the import target data is set to be empty (step S75), and the product code acquisition process is completed.

  When the product code is acquired (step S71; YES) or (step S73; YES), the acquired product code is displayed on the display unit 14, and the acquired product code is set in the product code column of the import target data. (Step S76), the product code acquisition process ends.

  When the operation input of the product code is performed (step S74; YES), the input of the product code from the user is accepted through the input unit 12, and the input product code is set in the product code column of the import target data ( Step S77), the product code acquisition process ends.

  As described above, according to the present embodiment, the conversion table 40 can be easily created simply by designating the cells of the conversion target estimate file 20 on the screen according to the inquiry items of the inquiry item file 30. Further, by using the created conversion table 40, the conversion target estimate file 20 can be reliably and easily converted into the conversion result transaction file 50 for business applications.

  When the copy source conversion table or the correction conversion table stored in the storage unit 15 is used, the copy source conversion table or the cell of the correction conversion table corresponding to the inquiry item is displayed by default in the table data display area 101a. The cell corresponding to the inquiry item can be specified and input easily, and the conversion table 40 can be created more easily. Further, since voice guidance regarding the designation of the cell corresponding to the inquiry item is output from the voice output unit 17, the cell corresponding to the inquiry item can be designated and input more easily.

  Further, business application data having a layout pattern of a target business application can be created by editing the conversion result transaction file 50. Since the created business application data has an identification number for identifying the layout pattern of the target business application, the business application data of each layout pattern can be stored and managed in the business application DB 60 using the identification number as a key.

  The description in the above embodiment is an example of a table data processing apparatus and a table data processing program according to the present invention, and the present invention is not limited to this.

  For example, in the above embodiment, the conversion target estimate file 20 is used as the table data to be converted. However, the present invention is not limited to this, and the table data other than the estimate is used as the conversion target. Also good.

  In the above embodiment, the voice guidance related to the cell designation input corresponding to the inquiry item in the conversion table creation process is output from the voice output unit 17, but the present invention is not limited to this. It is good also as a structure which carries out the audio | voice output of the voice guidance regarding screen operation.

  In the above embodiment, in the table data conversion process, the conversion table creation process, the conversion execution process, and the input process are sequentially performed. However, the present invention is not limited to this. The execution process and the input process may be independently performed in order. Further, the table data processing apparatus is configured to use a PC, but is not limited thereto, and may be configured to use another type of apparatus such as a processing apparatus related to a specific process, a server apparatus, or a portable device. .

  In addition, it goes without saying that the detailed configuration and detailed operation of each component of the PC 10 in the above embodiment can be changed as appropriate without departing from the spirit of the present invention.

It is a block diagram which shows the structure of PC10 of embodiment which concerns on this invention. It is a figure which shows operation | movement and data flow of PC10. (A) is a figure which shows an example of the inquiry item file 30. FIG. FIG. 8B is a diagram illustrating an example of the conversion table 40. (A) is a figure which shows an example of the estimate ledger file 51. FIG. (B) is a figure which shows an example of the estimate detailed file 52. FIG. It is a flowchart which shows a table data conversion process. It is a flowchart which shows the conversion table creation process of a table data conversion process. It is a figure which shows the outline | summary of a conversion table creation process. It is a figure which shows the table data display area 101a by which the cell was displayed by default. It is a figure which shows the conversion execution process of a table data conversion process. It is a figure which shows the outline | summary of a conversion execution process. It is a flowchart which shows an input process. It is a figure which shows the outline | summary of an input process. It is a figure which shows a product code acquisition process.

Explanation of symbols

10 PC
11 CPU
12 Input unit 13 RAM
14 Display unit 15 Storage unit 16 Communication unit 17 Audio output unit 18 Bus

Claims (7)

Display means for displaying information;
Display control means for displaying table data on the display means;
A query item file storage means for storing a query item file including items used in the layout of the business application;
Corresponding to each item of the inquiry item file, designating means for designating cell position information of the table data;
A table data processing apparatus comprising: conversion table creation means for creating a conversion table by associating position information of the designated cell with the item. Conversion table storage means for storing the conversion table created by the conversion table creation means,
The display control means default-displays the cell position of the table data corresponding to each item of the inquiry item file based on a conversion table stored in the conversion table storage means. The table data processing device according to 1.   The conversion means for creating a conversion result transaction file including data of the position of the specified cell in the table data based on the conversion table created by the conversion table creation means. 2. A table data processing apparatus according to 2.   4. The table data processing apparatus according to claim 3, further comprising an editing unit that edits the conversion result transaction file created by the conversion unit to create business application data corresponding to the layout of the business application.   5. The table data processing apparatus according to claim 4, wherein the editing unit creates business application data including identification information for identifying a layout pattern of the business application.   6. The table data processing apparatus according to claim 1, further comprising voice output means for outputting voice guidance related to designation of position information of cells of the table data. On the computer,
The ability to display tabular data;
A function that stores a query item file that contains items used in the layout of business applications in memory;
Corresponding to each item of the inquiry item file, a function to specify cell position information of the table data;
A function of creating a conversion table by associating the location information of the designated cell with the item;
Table data processing program for realizing

Images