CN114051230A - Excel platform-based data transmission method - Google Patents
Excel platform-based data transmission method Download PDFInfo
- Publication number
- CN114051230A CN114051230A CN202111239115.2A CN202111239115A CN114051230A CN 114051230 A CN114051230 A CN 114051230A CN 202111239115 A CN202111239115 A CN 202111239115A CN 114051230 A CN114051230 A CN 114051230A
- Authority
- CN
- China
- Prior art keywords
- excel
- data
- rfid
- information
- platform
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W8/00—Network data management
- H04W8/02—Processing of mobility data, e.g. registration information at HLR [Home Location Register] or VLR [Visitor Location Register]; Transfer of mobility data, e.g. between HLR, VLR or external networks
- H04W8/08—Mobility data transfer
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
Abstract
The invention provides a data transmission method based on an Excel platform, which comprises the following steps of establishing a wireless communication platform; based on the Excel platform, the wireless communication platform is utilized to upload and issue data, the problems that manual data input is time-consuming and labor-consuming in real life under a large data volume scene, the efficiency is low, errors are easy to occur are solved, automatic uploading and issuing of the large data volume can be achieved, and the data transmission accuracy is high.
Description
Technical Field
The invention relates to the technical field of data transmission methods, in particular to a data transmission method based on an Excel platform.
Background
Microsoft Excel is spreadsheet software developed by Microsoft corporation, has intuitive effect, visualized graphics and various integrated formulas and tools, and becomes the most popular data processing software in the world and office software essential for daily life of people.
The management of data can be carried out to the utilization Excel, but carry out data management's prerequisite and will carry out the manual entry to a small amount of data in to Excel, but to under the big data volumes such as financial statement, student's archives or factory data, adopt the mode of manual entry to waste time and energy, inefficiency and very easily the mistake appears, produces bad influence to work easily.
Disclosure of Invention
The Excel platform-based data transmission method solves the problems that manual data entry is time-consuming and labor-consuming in large data volume scenes in real life, efficiency is low, errors are easy to occur, automatic uploading and issuing of large data volume can be achieved, and data transmission accuracy is high.
In order to achieve the purpose, the technical scheme of the invention is realized as follows:
the invention discloses a data transmission method based on an Excel platform, which comprises the following steps: building a wireless communication platform; based on the Excel platform, the wireless communication platform is utilized to upload and issue data.
Further, the device forming the wireless communication platform comprises a PC, a wireless receiving box, a mobile terminal, a transmitting terminal and a printer, wherein Excel office software is installed on the PC, and MSCOM controls are registered; the wireless receiving box is used for receiving wireless signals and interacting with Excel; the mobile terminal is used for scanning the two-dimensional code or the bar code printed by the printer and uploading data to the PC; the transmitting terminal is used for transmitting wireless information to the wireless receiving box; the printer is used for printing the two-dimensional code or the bar code.
Further, the step of uploading data comprises: setting a data rule of data to be uploaded in Excel; printing a related two-dimensional code or a bar code according to the data rule to serve as an RFID; the mobile terminal scans the two-dimensional code or the bar code and sends the scanned information to the PC; the Excel opens a VBA editing environment, adds a window, adds an MSCOM control in the window, sets corresponding serial port parameters, and copies a VBA code in a table; establishing a starting button in Excel to start a VBA code; the Excel receives and analyzes the information sent by the mobile terminal to judge whether the information sent by the mobile terminal meets the set data rule or not; if the data information accords with the set data rule, the data information sent by the mobile terminal is automatically filled in the Excel; if the data information does not accord with the set data rule, the data information sent by the mobile terminal is discarded.
Further, the step of sending data includes: the Excel is positioned in a first cell in the RFID address area after data uploading is finished, and whether the address content of the RFID is legal or not is read and judged; calling parameters set for a transmitting terminal according to the read RFID information, and sending the parameters to the transmitting terminal containing an RFID address after the parameters are sorted; the transmitting terminal containing the RFID address receives the information, writes in an identifier for judging whether the information is successfully transmitted or not, and transmits the identifier to Excel of the PC terminal; the Excel of the PC terminal receives the transmitted information and marks the corresponding cells into different colors according to the written identification whether the transmission is successful; if the information is successfully sent, automatically moving to the address of the next RFID for issuing; if it fails, not move; and if the transmission fails for more than two times, marking the cell corresponding to the RFID address as yellow, and moving to the next RFID address for issuing.
Further, the wireless receiving box is a USB interface.
Further, Excel of the PC end receives the sent information, and marks the cell corresponding to the successfully sent RFID address to be green according to the written identifier whether the RFID address is successful or not; and marking the cell corresponding to the RFID address with the failed transmission as red.
The beneficial technical effects are as follows:
the invention discloses a data transmission method based on an Excel platform, which comprises the following steps of establishing a wireless communication platform; based on the Excel platform, the wireless communication platform is utilized to upload and issue data, the problems that manual data input is time-consuming and labor-consuming in real life under a large data volume scene, the efficiency is low, errors are easy to occur are solved, automatic uploading and issuing of the large data volume can be achieved, and the data transmission accuracy is high.
Drawings
In order to more clearly illustrate the technical solution of the present invention, the drawings used in the description of the embodiments will be briefly described below.
Fig. 1 is a system structure diagram of a wireless communication platform constructed in a data transmission method based on an Excel platform according to the present invention;
FIG. 2 is a flow chart of steps of data uploading in the Excel platform-based data transmission method according to the present invention;
fig. 3 is a flowchart of data issuing steps in a data transmission method based on an Excel platform according to the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the accompanying drawings are illustrative only for the purpose of explaining the present invention, and are not to be construed as limiting the present invention.
Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.
The invention discloses a data transmission method based on an Excel platform, which specifically comprises the following steps:
s1: building a wireless communication platform;
specifically, the device forming the wireless communication platform, see fig. 1, specifically comprises a PC, a wireless receiving box, a mobile terminal, a transmitting terminal and a printer, wherein Excel office software is installed on the PC, and an MSCOM control is registered; the wireless receiving box is used for receiving wireless signals and interacting with Excel, preferably, the wireless receiving box is a USB interface, and after the drive is correctly installed, the equipment manager displays the corresponding COM port; the mobile terminal is used for scanning the two-dimensional code or the bar code printed by the printer and uploading data to the PC, can be handheld equipment such as a mobile phone and the like, and can realize normal code scanning work and wireless uploading function; the transmitting terminal is used for transmitting wireless information to the wireless receiving box; the printer is used for printing the two-dimensional code or the bar code.
S2: based on the Excel platform, the wireless communication platform is utilized to upload and issue data.
Specifically, after the wireless communication platform is successfully built, the mobile terminal can scan codes and actively upload data to the Excel, and the Excel can issue data to the transmitting terminal.
The specific steps of actively uploading data to Excel by code scanning of the mobile terminal, referring to fig. 2, include:
s211: setting a data rule of data to be uploaded in Excel;
specifically, the set data rules include, but are not limited to, data length, data type, data check bit and the like;
s212: printing a related two-dimensional code or a bar code according to the data rule to serve as an RFID;
specifically, a related two-dimensional code or barcode is printed, and the code can be used as a unique identifier pointing to the transmitting terminal, called RFID, which is equivalent to identity information of the transmitting terminal, and can be pasted on the transmitting terminal device.
S213: the mobile terminal scans the two-dimensional code or the bar code and sends the scanned information to the PC;
specifically, at the PC end of the computer, a wireless receiving box is installed in advance, serial communication is adopted, 433MHz wireless communication is used, a channel 1 is selected for communication, the mobile terminal is the same as the wireless setting information of the PC end, the mobile terminal is used for scanning two-dimensional codes or bar codes, and the mobile terminal can automatically send the scanned information to the PC end.
S214: the Excel opens a VBA editing environment, adds a window, adds an MSCOM control in the window, sets corresponding serial port parameters, and copies a VBA code in a table;
specifically, Excel opens the VBA editing environment, and certainly, a shortcut key ALT + F11 can be pressed to add a form, add an MSCOM control to the form, set corresponding serial port parameter data, and copy a related VBA code in the sheet.
S215: establishing a starting button in Excel to start a VBA code;
s216: the Excel receives and analyzes the information sent by the mobile terminal to judge whether the information sent by the mobile terminal meets the set data rule or not;
s217: if the data information accords with the set data rule, the data information sent by the mobile terminal is automatically filled in the Excel; if the data information does not accord with the set data rule, the data information sent by the mobile terminal is discarded.
Excel issues data to a transmitting terminal, and the corresponding specific steps of the transmitting terminal, referring to fig. 3, specifically include:
s221: the Excel is positioned in a first cell in the RFID address area after data uploading is finished, and whether the address content of the RFID is legal or not is read and judged;
s222: calling parameters set for a transmitting terminal according to the read RFID information, and sending the parameters to the transmitting terminal containing an RFID address after the parameters are sorted;
specifically, according to the read RFID, the parameters to be set for the transmitting terminal are called, the parameters are sorted and combined and then are transmitted, the transmitting packet is transmitted through 433MHz wireless signals and then automatically points to the transmitting terminal containing the RFID address, and the set transmitting terminal is unique because the RFID is the unique identifier.
S223: the transmitting terminal containing the RFID address receives the information, writes in an identifier for judging whether the information is successfully transmitted or not, and transmits the identifier to Excel of the PC terminal;
s224: the Excel of the PC terminal receives the transmitted information and marks the corresponding cells into different colors according to the written identification whether the transmission is successful;
specifically, Excel of the PC end receives the sent information, and marks the cell corresponding to the successfully sent RFID address to green according to the written identifier whether the RFID address is successful; and marking the cell corresponding to the RFID address with the failed transmission as red.
S225: if the information is successfully sent, automatically moving to the address of the next RFID for issuing; if it fails, not move;
specifically, if the information is successfully sent, the mobile terminal automatically moves to the address of the next RFID for issuing; if the information transmission fails, the information is not moved; and continuously sending the command for issuing for 3 times to the address of the RFID, judging whether the command is successful, if so, moving to the address of the next RFID, and if not, executing the next step.
S226: and if the transmission fails for more than two times, marking the cell corresponding to the RFID address as yellow, and moving to the next RFID address for issuing.
Specifically, if three times of continuous issuing fails, the color of the cell corresponding to the RFID address is marked to be yellow, the cell is moved to the next RFID address to be issued until the whole cycle is executed, which RFID addresses are successfully issued and which are not successfully issued can be visually observed in Excel, whether the failed RFID address is correct or not can be checked, the whole cycle can be executed again after checking, the successfully written RFID address can be automatically skipped in the cycle, and the unwritten or failed RFID address is re-sent and written.
According to the data transmission method based on the Excel platform, the common Excel is utilized to build a wireless communication platform, automatic uploading and issuing of large data volume are achieved, the data transmission accuracy is high, and the implementation equipment and the implementation method are simple and easy to implement.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The above examples are only for describing the preferred embodiments of the present invention, and are not intended to limit the scope of the present invention, and various modifications and improvements made to the technical solution of the present invention by those skilled in the art without departing from the spirit of the present invention should fall within the protection scope defined by the claims of the present invention.
Claims (6)
1. A data transmission method based on an Excel platform is characterized by comprising the following steps:
building a wireless communication platform;
based on the Excel platform, the wireless communication platform is utilized to upload and issue data.
2. The Excel platform-based data transmission method according to claim 1, wherein the means for forming a wireless communication platform comprises:
the system comprises a PC (personal computer), wherein Excel office software is installed on the PC, and MSCOM controls are registered;
the wireless receiving box is used for receiving wireless signals and interacting with Excel;
the mobile terminal is used for scanning the two-dimensional code or the bar code printed by the printer and uploading data to the PC;
the transmitting terminal is used for transmitting wireless information to the wireless receiving box;
and the printer is used for printing the two-dimensional code or the bar code.
3. The Excel platform-based data transmission method according to claim 2, wherein the step of uploading data comprises:
setting a data rule of data to be uploaded in Excel;
printing a related two-dimensional code or a bar code according to the data rule to serve as an RFID;
the mobile terminal scans the two-dimensional code or the bar code and sends the scanned information to the PC;
the Excel opens a VBA editing environment, adds a window, adds an MSCOM control in the window, sets corresponding serial port parameters, and copies a VBA code in a table;
establishing a starting button in Excel to start a VBA code;
the Excel receives and analyzes the information sent by the mobile terminal to judge whether the information sent by the mobile terminal meets the set data rule or not;
if the data information accords with the set data rule, the data information sent by the mobile terminal is automatically filled in the Excel; if the data information does not accord with the set data rule, the data information sent by the mobile terminal is discarded.
4. The Excel platform-based data transmission method according to claim 1, wherein the step of issuing data comprises:
the Excel is positioned in a first cell in the RFID address area after data uploading is finished, and whether the address content of the RFID is legal or not is read and judged;
calling parameters set by a transmitting terminal according to the read information of the RFID, and sending the parameters to the transmitting terminal containing an RFID address after the parameters are sorted;
the transmitting terminal containing the RFID address receives the information, writes in an identifier indicating whether the transmission is successful, and transmits the identifier to Excel of the PC terminal for storage;
the Excel of the PC terminal receives the transmitted information and marks the corresponding cells into different colors according to the written identification whether the transmission is successful;
if the information is successfully sent, automatically moving to the address of the next RFID for issuing; if it fails, not move;
and if the transmission fails for more than two times, marking the cell corresponding to the RFID address as yellow, and moving to the next RFID address for issuing.
5. The Excel platform-based data transmission method according to claim 1, wherein the wireless receiving box is a USB interface.
6. The Excel platform-based data transmission method according to claim 4, wherein Excel at PC end receives the transmitted information, and marks the cell corresponding to the RFID address successfully transmitted in green according to the written identifier whether the writing is successful; and marking the cell corresponding to the RFID address with the failed transmission as red.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111239115.2A CN114051230B (en) | 2021-10-25 | 2021-10-25 | Data transmission method based on Excel platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111239115.2A CN114051230B (en) | 2021-10-25 | 2021-10-25 | Data transmission method based on Excel platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114051230A true CN114051230A (en) | 2022-02-15 |
| CN114051230B CN114051230B (en) | 2023-10-13 |
Family
ID=80205996
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111239115.2A Active CN114051230B (en) | 2021-10-25 | 2021-10-25 | Data transmission method based on Excel platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114051230B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140061306A1 (en) * | 2012-08-31 | 2014-03-06 | Hand Held Products, Inc. | Pairing method for wireless scanner via rfid |
| CN103745296A (en) * | 2013-12-05 | 2014-04-23 | 国家电网公司 | Asset management system based on multiple information identification methods and 4G communication network |
| CN107944512A (en) * | 2017-11-02 | 2018-04-20 | 广东摩方托盘科技服务有限公司 | A kind of pallet production approaches to IM based on Internet of Things transmission technology |
| CN112084758A (en) * | 2020-09-19 | 2020-12-15 | 浙江强盛压缩机制造有限公司 | Automatic extraction method of compressor quality inspection data |
-
2021
- 2021-10-25 CN CN202111239115.2A patent/CN114051230B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140061306A1 (en) * | 2012-08-31 | 2014-03-06 | Hand Held Products, Inc. | Pairing method for wireless scanner via rfid |
| CN103745296A (en) * | 2013-12-05 | 2014-04-23 | 国家电网公司 | Asset management system based on multiple information identification methods and 4G communication network |
| CN107944512A (en) * | 2017-11-02 | 2018-04-20 | 广东摩方托盘科技服务有限公司 | A kind of pallet production approaches to IM based on Internet of Things transmission technology |
| CN112084758A (en) * | 2020-09-19 | 2020-12-15 | 浙江强盛压缩机制造有限公司 | Automatic extraction method of compressor quality inspection data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114051230B (en) | 2023-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101656024A (en) | Electronic learning device and realizing method thereof | |
| CN112534464A (en) | Job arrangement and correction method, system and server | |
| CN107672335A (en) | Laser labeling method, laser marking machine and storage medium | |
| CN104715641A (en) | Improved objective item evaluating method and system | |
| CN104182779A (en) | Method and equipment for programming product information | |
| CN113779656B (en) | Stamping method, electronic archive platform and computer readable storage medium | |
| CN110765995A (en) | Answer sheet generation method, answer sheet identification device and storage medium | |
| CN110766015A (en) | Answer sheet identification method, device, server, system and storage medium | |
| CN114051230A (en) | Excel platform-based data transmission method | |
| CN110399334A (en) | The method and system that paper document is ranked up | |
| CN103839028A (en) | Method and system for interaction of paper medium and readers | |
| CN116108804B (en) | Point code file generation method, content review method and content review system | |
| CN106875763A (en) | A kind of interactive network teaching system | |
| CN109033914A (en) | A kind of method and device of automatic load processed file | |
| CN112800735A (en) | Construction method of data filling system | |
| CN104866361A (en) | System and method for editing, transmitting and downloading school homework | |
| CN100504874C (en) | Method, system and apparatus for expanding text collection of same subject | |
| CN104200712A (en) | Touch and talk pen based multiple-choice question classroom interacting method | |
| CN114881612A (en) | Method, device, equipment and medium for realizing integrated printing and writing of engineering data | |
| CN114444439B (en) | Test question set file generation method and device, electronic equipment and storage medium | |
| CN110020432A (en) | A kind of information processing method and information processing equipment | |
| CN105825250A (en) | Method and device for counting poor display panels | |
| CN113268190B (en) | Information interaction method, system, device, electronic equipment and storage medium | |
| CN105512181A (en) | Machine readable card data processing method and system thereof | |
| CN113051457A (en) | Image-text extraction method and terminal |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |