JP5032455B2 - 2D barcode generation method in spreadsheet system - Google Patents

Description

Detailed Description of the Invention

TECHNICAL FIELD OF THE INVENTION

  The present invention relates to a two-dimensional barcode generation method in spreadsheet software operating on a computer such as a personal computer.

Conventional technology

  In recent years, in order to easily capture character data of a printed material into a personal computer or a mobile phone, a predetermined character area portion of the printed material is often converted into a two-dimensional barcode and printed. A spreadsheet software for a computer such as a personal computer employs a method of realizing a function on a cell by converting a character on a cell into a two-dimensional barcode with an address consisting of a row number and a column number of each cell as an argument.

Problems to be solved by the invention

Such conventional systems have the following disadvantages.
1) If there are many cells whose conversion target is a character string, the arguments of the function increase, and the complicated input is troublesome. This is particularly true for tabular data.
2) For the same reason, the order of cells to be converted and cells to be converted is often wrong.
The present invention has been invented in order to solve such problems of the conventional system.

Means to solve the problem

The configuration of claim 1 of the present invention is as follows:
(B) In spreadsheet software running on a computer, the large rectangle area specified by the row number and column number at the upper left corner and the lower right corner on the table input / output screen, and the large rectangle by the row number and column number, etc. A function that takes any one or more cells specified in the region as arguments.
(B) Means for obtaining the number of rows or the number of columns of the minimum-sized small rectangular area including each cell designated as an argument in the function.
(C) A new value obtained by adding a value obtained by multiplying the number of rows or columns of the small rectangular area obtained by means of (b) by a positive integer multiple to the row number or column number of each cell specified as an argument in the function. Means for specifying a cell in the large rectangular area by a unique row number or column number.
(D) Means for sequentially combining the character string on each cell specified as an argument in the function and the character string on each cell specified by means (c).
(E) Means for converting the character string obtained by means of (2) into a two-dimensional barcode.
Consists of.
Further, the configuration of claim 2 of the present invention is (f) a function using as arguments a rectangular area specified by each row number and column number in the upper left corner and lower right corner in spreadsheet software running on a computer.
(G) In the function, the rectangular area is scanned from left to right (column direction), and the character string on each cell is combined using a delimiter code such as a comma code "," as a delimiter, When the rightmost cell of the area is reached, the process proceeds to the next line. At this time, a delimiter code such as a line feed code “LF” is used as a line feed character. Means for generating so-called CSV data that combines character strings on the entire cells.
(H) Means for converting the CSV data generated by the means (G) into a two-dimensional barcode in the function.
Consists of.
The present invention eliminates all the disadvantages of the conventional system by adopting any one of the above-described configurations, the cell to be converted into a two-dimensional barcode is simple, and the cell to be converted, Provided is a two-dimensional barcode generation method in a spreadsheet system that can reduce the order of cells to be converted.

As an example, a case where the present invention is applied to spreadsheet software on a personal computer will be described.
FIG. 1 is a block diagram of a two-dimensional barcode generation system showing an example of the present invention. A table input / output screen 4 of a spreadsheet software 3 is displayed on a display 2 of a personal computer 1. Next, a method for converting a cell in which text on the table input / output screen 4 is input into a two-dimensional barcode will be described below.
FIG. 2 is a diagram showing an example of a table input / output screen. A cell group indicated by a bold frame on the table input / output screen 4 is a cell 5 that has been text-inputted and is to be converted into a two-dimensional barcode. The function input cell 6 is a cell in which a function for converting the text data of the cell 5 with text input into a two-dimensional barcode is described. In the conventional two-dimensional barcode generation method, in order to convert all the text data of the input cell 5 into a two-dimensional barcode, it is necessary to specify 42 cells as function arguments in this example.
First, the method according to claim 1 of the present invention will be described below. FIG. 3 is an explanatory diagram of a table input / output screen processing method according to claim 1 of the present invention. The large rectangular area 7 in FIG. 3 includes all cells in which text data to be converted into a two-dimensional barcode is entered. The small rectangular area 8 is an area included in the large rectangular area 7 and includes all the cells specified by the argument of the function for converting to a two-dimensional barcode. As can be seen from FIG. There are seven repeated cell patterns in the large rectangular area 7 in which the text data included is present.
Next, a method for converting all text data in the large rectangular area 7 into a two-dimensional barcode by designating each cell in which the text data in the small rectangular area 8 exists and the large rectangular area 7 as arguments will be described below. I write.
FIG. 4 shows an example of a two-dimensional barcode conversion function according to claim 1 of the present invention, and shows a function 9 for generating a two-dimensional barcode. The function 9 is described in the function input cell 6 and has arguments “A1: E14” for the large rectangular area 7 and arguments “A1, A2, B1, C1, D1, E1” for each cell in the small rectangular area 8.
FIG. 5 is a flowchart according to claim 1 of the present invention and shows a method for converting text data on a cell into a two-dimensional barcode. In this flowchart, the first processing (S501 to S512) for obtaining the number of rows in the small rectangular area 8 and the number of small rectangular areas 8 in the large rectangular area 7 and the text data on the cells in the large rectangular area 7 are combined. Text data combined with the second process (S513 to S523) can be broadly divided into a third process (S524 to S526) for converting the text data into a two-dimensional barcode.
In the first process, the line number of each cell in the small rectangular area 8 of the function 9, that is, the line number of the second and subsequent arguments of the function 9 is compared to obtain the maximum line number and the minimum line number, and then The number of lines in the small rectangular area is obtained by subtracting the minimum line number from the line number and adding a numerical value “1” (S501 to S511). Next, the number of small rectangular areas 8 included in the large rectangular area 7 is obtained by dividing the number of lines in the large rectangular area 7 by the number of lines in the small rectangular area 8 (S512). At this time, if the result of division includes a decimal point, the number of lines in the large rectangular area 7 includes an extra line that is a positive integer multiple or more of the number of lines in the small rectangular area 8, so the decimal part is ignored.
In the second process, a character string variable S to be converted into a two-dimensional barcode is first initialized with a length “0” (null) (S513). The character string on each cell of the small rectangular area 8 is added to the character string variable S in the order of arguments (S517), but this process is repeated as many times as the small rectangular area 8 exists in the large rectangular area 7. At this time, an offset value, that is, a value obtained by multiplying the number of rows of the small rectangular area 8 obtained in the first processing by an integer multiple is added to the cell number of each argument cell of the small rectangular area 8. This integer starts from 0 and is incremented by 1 up to a value obtained by subtracting 1 from the number of small rectangular areas (S516). By processing in this way, each character string is stored in the character string variable S for all cells in which the target character string in the large rectangular area 7 is input (S514 to S523). Note that a comma “,” code is inserted as a delimiter between character strings on each cell in the process of combining character strings (S519), or a line feed “LF” code is inserted every time processing of the small rectangular area is completed. It is good (S522).
FIG. 6 shows an example of the combined character string according to claim 1 of the present invention, and shows the state of the combined character string 10 as the contents of the character string variable S as a result of the processing of this example.
In the third process, the character string of the character string variable S is converted into a two-dimensional barcode, and the upper left corner of the function input cell 6 where the function 9 exists and the coordinates on the screen at the center are output as the base points (S524, S525). ).
FIG. 7 shows an output example of a two-dimensional barcode according to the present invention, and shows a state in which the two-dimensional barcode 11 is output at the center of the function input cell 6.
In this example, the processing example for the pattern in which the small rectangular area 8 repeats in the row direction is shown, but the pattern that repeats in the column number direction can be performed in the same process.
Next, the method according to claim 2 of the present invention will be described below. FIG. 8 is an explanatory diagram of a table input / output screen processing method according to claim 2 of the present invention. The large rectangular area 7 in FIG. 8 includes all cells in which text data to be converted into a two-dimensional barcode is input. Next, a method for converting all text data in the large rectangular area 7 into a two-dimensional barcode by designating the large rectangular area 7 as an argument will be described below. 8 shows a function for generating a two-dimensional barcode according to claim 2 of the present invention. The function 12 is described in the function input cell 6 and has arguments “A1: E14” for the large rectangular area 7.
FIG. 9 is a flowchart of claim 2 of the present invention and shows a method of converting text data on a cell into a two-dimensional barcode. In this flowchart, conversion into CSV data corresponding to the character string of each cell in the large rectangular area 7 is performed as the first processing. First, the character string variable S is initialized with a length “0” (null), the variable I is used as the row number and the variable J is used as the index of each cell, and the character string of each cell is converted into the character string variable. Add to S. In this case, it is not added when the character string does not exist in the cell. In addition, a process of outputting a comma “,” code as a delimiter between cells and a line feed “LF” code for a line break of a cell is performed (S901 to S911). When all the lines in the large rectangular area 7 have been processed in this way, CSV data indicated by the character string 13 shown in FIG. In addition to the comma “,” code and line feed “LF” code, a character code such as a tab “TAB” may be used as a delimiter.
Next, as a second process, the character string in the character string variable S is converted into a two-dimensional barcode, and the coordinates on the upper left corner or the center screen of the function input cell 6 where the function 12 exists are output from the base point. . (S912 to S914). In this way, the conversion process into the two-dimensional barcode is completed for all the cells in the large rectangular area.

Effect of the invention

[Effect of Claim 1] According to the invention of Claim 1, a two-dimensional barcode in a spreadsheet system can be created easily and with few errors. In addition, cells that do not need to be converted into a two-dimensional barcode can be excluded from conversion targets, and the order of cells to be converted can be freely changed.
[Effect of Claim 2] According to the invention of Claim 2, a two-dimensional barcode in a spreadsheet system can be created easily and with few mistakes, and further, a partition for joining cells in each row when the barcode is generated. By matching the character code and delimiter code that connects each line with the key data input specifications of the spreadsheet system, tabular data at the time of barcode conversion is reproduced without creating a special program when key data is input from the barcode reader. it can. In addition, by copying or moving the contents of the cell in which the function is described to another cell, it is possible to greatly reduce the work involved in generating a plurality of barcodes and changing the tabular form.

  The block diagram of the two-dimensional barcode production | generation system which shows an example of this invention.   Example of table input / output screen   Explanatory drawing of the processing method of the table | surface input / output screen by Claim 1 of this invention   An example of a two-dimensional barcode conversion function according to claim 1 of the present invention   Flowchart of claim 1 of the present invention   An example of a combined character string according to claim 1 of the present invention   Output example of two-dimensional barcode according to the present invention   Explanatory drawing of the processing method of the table | surface input / output screen by Claim 2 of this invention   The flowchart of claim 2 of the present invention   An example of a combined character string according to claim 2 of the present invention

Explanation of symbols

1 is a computer 2, a computer display 3, a spreadsheet software 4, a spreadsheet input / output screen 5 of a spreadsheet software is a cell group 6 into which a character string to be converted into a two-dimensional barcode is input is a two-dimensional barcode conversion function The cell 7 in which is described is the large rectangular area 8 is the small rectangular area 9 is the function description 10 of claim 1 is the combined character string 11 of the claim 1 is the two-dimensional barcode 12 is the function description of the claim 2 13 is the combined character string of claim 2

Claims (2)

(B) In spreadsheet software running on a computer, the large rectangle area specified by the row number and column number at the upper left corner and the lower right corner on the table input / output screen, and the large rectangle by the row number and column number, etc. A function that takes any one or more cells specified in the region as arguments.
(B) Means for obtaining the number of rows or the number of columns of the minimum-sized small rectangular area including each cell designated as an argument in the function.
(C) A new value obtained by adding a value obtained by multiplying the number of rows or columns of the small rectangular area obtained by means of (b) by a positive integer multiple to the row number or column number of each cell specified as an argument in the function. Means for specifying a cell in the large rectangular area by a unique row number or column number.
(D) Means for sequentially combining the character string on each cell specified as an argument in the function and the character string on each cell specified by means (c).
(E) Means for converting the character string obtained by means of (2) into a two-dimensional barcode.
As described above, the two-dimensional barcode generation method in the spreadsheet system configured as (a) to (e). (F) In spreadsheet software running on a computer, a function that takes a rectangular area specified by the row number and column number of the upper left corner and lower right corner as arguments.
(G) In the function, a character string on each cell in each row in the rectangular area is combined using an arbitrary character code as a delimiter to generate a character string corresponding to each row, and corresponding to each row Means for combining all character strings in the entire rectangular area by combining character strings with an arbitrary character code different from the character code used for combining the character strings on the cells as a delimiter;
(H) Means for converting, in the function, a character string of the entire rectangular area generated by means of (g) into a two-dimensional barcode.
As described above, the two-dimensional barcode generation method in the spreadsheet system which is configured as (f) to (h) and further has the method of claim 1.

Images