CN113126981B - Medical data processing method and device based on Excel - Google Patents
Medical data processing method and device based on Excel Download PDFInfo
- Publication number
- CN113126981B CN113126981B CN201911406159.2A CN201911406159A CN113126981B CN 113126981 B CN113126981 B CN 113126981B CN 201911406159 A CN201911406159 A CN 201911406159A CN 113126981 B CN113126981 B CN 113126981B
- Authority
- CN
- China
- Prior art keywords
- data
- cell
- key value
- value pair
- processed
- 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.)
- Active
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 22
- 238000000034 method Methods 0.000 claims abstract description 74
- 230000008676 import Effects 0.000 claims description 20
- 238000013075 data extraction Methods 0.000 claims description 3
- 239000003814 drug Substances 0.000 description 15
- 230000008569 process Effects 0.000 description 12
- 238000004458 analytical method Methods 0.000 description 5
- 229930193140 Neomycin Natural products 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 229940079593 drug Drugs 0.000 description 4
- 229960001347 fluocinolone acetonide Drugs 0.000 description 4
- FEBLZLNTKCEFIT-VSXGLTOVSA-N fluocinolone acetonide Chemical compound C1([C@@H](F)C2)=CC(=O)C=C[C@]1(C)[C@]1(F)[C@@H]2[C@@H]2C[C@H]3OC(C)(C)O[C@@]3(C(=O)CO)[C@@]2(C)C[C@@H]1O FEBLZLNTKCEFIT-VSXGLTOVSA-N 0.000 description 4
- 229960004927 neomycin Drugs 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000018109 developmental process Effects 0.000 description 3
- 238000005457 optimization Methods 0.000 description 3
- 230000002035 prolonged effect Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000036541 health Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000000750 progressive effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 239000006071 cream Substances 0.000 description 1
- 239000002552 dosage form Substances 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/35—Creation or generation of source code model driven
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H70/00—ICT specially adapted for the handling or processing of medical references
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- Medical Informatics (AREA)
- Health & Medical Sciences (AREA)
- Epidemiology (AREA)
- Data Mining & Analysis (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention discloses a medical data processing method based on Excel, which can determine the data of each key value in a medical data table to be processed according to the layout meta information corresponding to the medical data table to be processed, so that the data of the medical data table to be processed can be imported or exported by utilizing each key value. Therefore, when the method and the device are used for importing or exporting the Excel files, the method and the device can be used for importing or exporting the Excel files in a manner of determining the key values in the medical data table to be processed for various Excel templates without depending on the fixed templates of the Excel, and realize decoupling between the Excel templates and the code programs of the Excel file importing or exporting database. Therefore, compared with the prior art, the method and the device do not need to modify the code program according to different Excel templates manually frequently, and errors caused by modifying the code program manually can be avoided, so that the efficiency of importing or exporting the Excel file is improved.
Description
Technical Field
The invention relates to the field of medical data processing, in particular to an Excel-based medical data processing method and device.
Background
Excel can conveniently make various electronic forms, and can perform complex operations on data by using formulas and functions. When managing a medical system, the medical system may generate a large amount of medical data; in order to conveniently browse or use the medical data, an Excel file import or export function is provided in the medical system so that a large amount of medical data can be imported into the database or exported for use.
In the prior art, the method for importing or exporting the database by using the Excel file is mainly realized by using a specific Excel template and an importing or exporting code program aiming at the specific Excel template. However, the existing method for importing or exporting the Excel file into or from the database leads to tight coupling between the Excel template and the code program of importing or exporting the Excel file into or from the database; thus, when any change occurs to the Excel template, the code program of the Excel file import or export database needs to be manually modified. Because the process of manually modifying the code program is repeated and tedious and is prone to error, the existing method for importing or exporting the Excel file into or from the database causes inefficiency in importing or exporting the Excel file. Therefore, a method for improving the efficiency of Excel file import and export is needed.
Disclosure of Invention
The invention provides a medical data processing method and device based on Excel, which are used for realizing that code programs do not need to be manually and frequently modified according to different Excel templates, and errors caused by manually modifying the code programs can be avoided, so that the efficiency of importing or exporting Excel files is improved.
In a first aspect, the present invention provides an Excel-based medical data processing method, the method comprising:
acquiring a processing instruction and a medical data table to be processed, wherein the processing instruction comprises a table import instruction or a table export instruction;
determining layout meta information corresponding to the medical data table to be processed, wherein the layout meta information comprises position information corresponding to data of each key value in the medical data table to be processed;
and processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
In a second aspect, the present invention provides an Excel-based medical data processing apparatus, the apparatus comprising:
the acquisition unit is used for acquiring a processing instruction and a medical data table to be processed, wherein the processing instruction comprises a table import instruction or a table export instruction;
A determining unit, configured to determine layout meta information corresponding to the medical data table to be processed, where the layout meta information includes location information corresponding to data of each key value in the medical data table to be processed;
and the processing unit is used for processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
In a third aspect, the present invention provides a readable medium comprising execution instructions which, when executed by a processor of an electronic device, perform the method according to any of the first aspects.
In a fourth aspect, the present invention provides an electronic device comprising a processor and a memory storing execution instructions, the processor performing the method according to any one of the first aspects when executing the execution instructions stored in the memory.
According to the technical scheme, the processing instruction and the medical data table to be processed can be obtained, the layout meta information corresponding to the medical data table to be processed is determined, and then, the data of each key value in the medical data table to be processed can be processed according to the processing instruction and the layout meta information, so that the processed medical data is obtained. Therefore, the invention can determine the data of each key value in the medical data table to be processed according to the layout meta information corresponding to the medical data table to be processed, thereby realizing the import or export of the data of the medical data table to be processed by utilizing each key value. Therefore, when the method and the device are used for importing or exporting the Excel files, the method and the device can be used for importing or exporting the Excel files in a manner of determining the key values in the medical data table to be processed for various Excel templates without depending on the fixed templates of the Excel, and realize decoupling between the Excel templates and the code programs of the Excel file importing or exporting database. Therefore, compared with the prior art, the method and the device do not need to modify the code program according to different Excel templates manually frequently, and errors caused by modifying the code program manually can be avoided, so that the efficiency of importing or exporting the Excel file is improved.
Further effects of the above-described non-conventional preferred embodiments will be described below in connection with the detailed description.
Drawings
In order to more clearly illustrate the embodiments of the invention or the prior art solutions, the drawings which are used in the description of the embodiments or the prior art will be briefly described below, it being obvious that the drawings in the description below are only some of the embodiments described in the present invention, and that other drawings can be obtained according to these drawings without inventive faculty for a person skilled in the art.
FIG. 1A is a schematic flow chart of a medical data processing method based on Excel in the present invention;
FIG. 1B is a schematic flow chart of an Excel-based medical data processing method of the present invention;
FIG. 1C is a schematic flow chart of an Excel-based medical data processing method of the present invention;
FIG. 2 is a diagram of a medical data table to be processed according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a medical data processing device based on Excel according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to specific embodiments and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In order to solve the problems that in the prior art, the process of manually modifying a code program is repeated and tedious and is easy to make mistakes, the existing method for importing or exporting an Excel file into or from a database causes low efficiency of importing or exporting the Excel file.
The invention provides a medical data processing method based on Excel, in the method, the layout meta information corresponding to a medical data table to be processed can be determined, and the data of each key value in the medical data table to be processed can be determined according to the layout meta information corresponding to the medical data table to be processed, so that the data of the medical data table to be processed can be imported or exported by utilizing each key value. Therefore, when the method and the device are used for importing or exporting the Excel files, the method and the device can be used for importing or exporting the Excel files in a manner of determining the key values in the medical data table to be processed for various Excel templates without depending on the fixed templates of the Excel, and realize decoupling between the Excel templates and the code programs of the Excel file importing or exporting database. Therefore, compared with the prior art, the method and the device do not need to modify the code program according to different Excel templates manually frequently, and errors caused by modifying the code program manually can be avoided, so that the efficiency of importing or exporting the Excel file is improved.
Various non-limiting embodiments of the present invention are described in detail below with reference to the attached drawing figures.
Referring to fig. 1A, an Excel-based medical data processing method in an embodiment of the present invention is shown. In this embodiment, the method may include, for example, the steps of:
s101: and acquiring the processing instruction and the medical data table to be processed.
Processing instructions may be understood as instructions that require processing of a table, where processing instructions may reflect the manner in which processing of a table is required. In one implementation, the processing instruction may include a table import instruction or a table export instruction, where the table import instruction may be understood as an instruction that needs to import the content data in the table into the database, that is, an instruction that reflects the import processing that needs to be performed on the table, and the table export instruction may be understood as an instruction that needs to import the content data in the database into the table, that is, an instruction that reflects the export processing that needs to be performed on the table.
A medical data form to be processed may be understood as a medical data form that needs to be processed. For example, the medical data form to be processed may be an Excel form of a hospital drug use catalog drug summary analysis.
It should be noted that, in one implementation, the medical data table to be processed may be a table that needs to be processed and includes medical information to be processed, for example, when the processing instruction is a table import instruction, the medical data table to be processed may be an Excel table that includes medical drug usage data to be processed.
In another implementation, the medical data to be processed form may be a template form that needs to be processed and does not include medical information to be processed, for example, when the processing instruction is a form export instruction, the medical data to be processed form may be an Excel template form that does not include any hospital drug usage data to be processed. It should be noted that, the template form may be understood as a form in which the content format is fixed and standardized according to a preset rule, where the template form represents standardization of the structural form; it will be appreciated that the template table includes keys in key-value pairs, but does not include values in key-value pairs, and that the medical data table to be processed, which includes medical information to be processed, includes keys and values in key-value pairs. The key-value pair is a container for associating a key (key object) with a value (i.e., value object), that is, the key and the value are associated to form a key-value pair, so that a value corresponding to the key can be obtained by using the key, for example, the key in the medical data table to be processed may be "basic medicine" and the value corresponding to the key may be "neomycin fluocinolone acetonide cream".
In this embodiment, the manner of acquiring the processing instruction and the medical data table to be processed may be various, for example, the processing instruction and the medical data table to be processed may be input by the user through an input device (such as a keyboard and a microphone), for example, the user may store the processing instruction and the medical data table to be processed in a designated path in advance, for example, the processing instruction may be input by the user through the input device, and the medical data to be processed is acquired from another terminal or a server.
S102: and determining the layout meta information corresponding to the medical data table to be processed.
Although the format layout of each different table is different for the different-format medical data tables to be processed, the data content in the different-format medical data tables to be processed is composed of key value pair data. Therefore, the importing and exporting processing of the medical data table to be processed can be realized by determining the data of each key value pair in the medical data table to be processed and utilizing the data of each key value pair in the medical data table to be processed; therefore, decoupling between the Excel template and the code program of the Excel file import or export database is realized, namely, for the medical data tables to be processed in different formats, the data can be imported and exported in a mode of each key value in the medical data tables to be processed, so that the code program does not need to be manually modified after the format of the medical data tables to be processed is changed.
Specifically, after the medical data table to be processed is acquired, the layout meta information of the medical data table to be processed may be determined first. The layout meta information may be understood as information capable of reflecting characteristics of each key value pair data in the medical data table to be processed, and in one implementation, the layout meta information of the medical data table to be processed may include location information corresponding to each key value pair data in the medical data table to be processed, for example, the number of rows and columns of the key in the table in the key value pair, and the number of columns of the key value pair in the table.
That is, in the present embodiment, after the medical data table to be processed is acquired, the respective key value pair data in the medical data table to be processed may be determined first. And then, determining the position information of the keys and the position information of the values in the data of each key value pair, and obtaining the position information of the data of each key value pair. Thus, the layout meta information of the medical data table to be processed can be obtained.
S103: and processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
After determining the layout meta information of the medical data table to be processed, the layout meta information of the medical data table to be processed can comprise position information corresponding to the data by each key value; therefore, according to the processing instruction and the layout meta information, the processing instruction corresponding to the processing instruction can be performed on the data of each key value in the medical data table to be processed, so that the processed medical data can be obtained.
For example, in one implementation, when the processing instruction is a table import instruction, the data may be imported according to the table import instruction and the layout meta information, so as to extract the medical information corresponding to each of the key values in the medical data table to be processed, that is, in this case, the medical information corresponding to each of the key values in the medical data table to be processed. For example, the medical information corresponding to the data by the key value may be extracted as a correspondence between "label basic drug" and "neomycin fluocinolone acetonide".
For another implementation manner, when the processing instruction is a table export instruction, the data of each key value in the medical data table to be processed may be exported according to the table export instruction and the layout meta information, that is, each key value is filled into the medical data table to be processed with the corresponding medical information of the data, so as to obtain the medical data table to be processed with the filled medical information, that is, the processed medical data is the medical data table to be processed with the filled medical information; for example, the key value may be used to correspond to medical information for data: the corresponding relation between the key 'marked basic medicine' and the value 'neomycin fluocinolone acetonide' is filled into the cell corresponding to the key value pair data in the medical data table to be processed, namely the neomycin fluocinolone acetonide is filled in the same column of the cell corresponding to the key 'marked basic medicine' and in the cells of the next row.
Therefore, in the method, the layout meta information corresponding to the medical data table to be processed can be determined, and the key value data in the medical data table to be processed can be determined according to the layout meta information corresponding to the medical data table to be processed, so that the data to be processed can be imported or exported by using the key value data. Therefore, when the method and the device are used for importing or exporting the Excel files, the method and the device can be used for importing or exporting the Excel files in a manner of determining the key values in the medical data table to be processed for various Excel templates without depending on the fixed templates of the Excel, and realize decoupling between the Excel templates and the code programs of the Excel file importing or exporting database. Therefore, compared with the prior art, the method and the device do not need to modify the code program according to different Excel templates manually frequently, and errors caused by modifying the code program manually can be avoided, so that the efficiency of importing or exporting the Excel file is improved.
Fig. 1A shows only a basic embodiment of the method according to the invention, on the basis of which certain optimizations and developments are made, but other alternative embodiments of the method can also be obtained.
Next, another specific embodiment of the Excel-based medical data processing method of the present invention will be described. This embodiment is further described with respect to S102 based on the corresponding embodiment of fig. 1A (S102 includes S202-S204). As shown in fig. 1B, in this embodiment, the method specifically includes the following steps:
s201: and acquiring the processing instruction and the medical data table to be processed.
S201 in this embodiment is the same as S101 in the embodiment corresponding to fig. 1A. Therefore, in the present embodiment, S201 will not be described again, and the description of S101 may be referred to specifically.
S202: and determining a template form corresponding to the medical data form to be processed.
Because the template table includes the keys in the key value pair, but does not include the values in the key value pair, and the keys in the key value pair are usually preset fields, the layout meta information is more easily obtained by determining the position information of the keys in the key value pair, determining the corresponding values according to the keys, and determining the position information corresponding to the values. Therefore, after the medical data form to be processed is acquired, the template form corresponding to the medical data form to be processed can be determined. In one implementation, if the acquired medical data form to be processed is a template form, the template form corresponding to the medical data form to be processed may be directly obtained. In another implementation manner, if the acquired medical data table to be processed is not the template table, the template table corresponding to the medical data table to be processed may be acquired according to the medical data table to be processed, for example, the template table corresponding to the medical data table to be processed may be acquired from a server, a cloud server or locally according to the medical data table to be processed.
S203: and determining the type of each key value pair data in the template table according to the template table.
It should be noted that, the type of the key-value pair data in the template table is used to reflect the positional relationship between the key and the value in the key-value pair data, that is, the type of the key-value pair data may represent the relationship between the positional information of the key and the positional information of the value. In one implementation, the key-value pair data types may include: data filling type, placeholder type, header type and mark type; wherein, the data filling type can reflect that the key value is in the same row as the value in the key value pair data, but the value is positioned in the latter column of the key; the placeholder can reflect that keys in the key-value pair data are in the same row and the same column as the values; the header type may reflect that keys in the key-value pair data are listed with values, but the values are located in the next row of keys; the label may reflect that a key in the key-value pair data is co-located with a value but the value is located in the next column of keys, or that a key in the key-value pair data is co-located with a value but the value is located in the next row of keys.
As an example, the progressive scanning may be started from a cell corresponding to the first row and the first column in the template table, and whether the cell is a key in the key value pair data is determined according to the condition of a character string included in the cell, the condition of a character string included in a cell adjacent to the cell, and the condition of a character string included in each cell in the row of the cell, if so, the type of the key value pair data corresponding to each key is further determined. If the cell and other adjacent cells are detected as merging cells, the character string included in any one of the merging cells may be used as the character string included in each of the merging cells. For example, as shown in fig. 2, if the 3 rd row to the 5 th row of the a column are a merging cell, and the character string included in the merging cell is "serial number", the character strings included in the cell corresponding to the 3 rd row of the a column, the cell corresponding to the 4 th row of the a column, and the cell corresponding to the 5 th row of the a column are all "serial numbers".
Next, how to determine the type of each key pair data in the template table will be described with the types of the key pair data being the data fill type, the placeholder type, the header type, and the flag type, respectively.
First, how to determine key pair data of the type data filling type in the template table data will be described.
Specifically, in this embodiment, it is necessary to scan cells in the template table one by one and determine the type of each cell, and for convenience of description, the currently determined cell may be referred to as a first cell in this embodiment. If the first cell includes a preset character string and the second cell which is in the same row as the first cell and is adjacent to the first cell and is positioned behind the first cell does not have a character string, the character string in the first cell is used as a key, and the character string in the second cell is used as a value, so that the type of the key value pair data formed by the values respectively included in the first cell and the second cell can be determined as a data filling type. It should be noted that the preset character string may be a preset proprietary character string, for example, the preset character string may be a medical term and/or a common form term, for example, the preset character string may be a medical term such as a medicine YPID number, a dosage form, or a common form term such as a serial number, a date, or the like.
The illustration is continued by taking fig. 2 as an example. Assuming that the first cell is the cell of the A column and the 2 row; since the first cell includes a preset character string "filling unit (unit official seal)", and there is no character string in a second cell that is in the same row as the first cell, is adjacent to the first cell, and is located behind the first cell, the character string "filling unit (unit official seal)" in the first cell can be used as a key, and the character string in the second cell can be used as a value, so that a key value pair can be formed between the character string "filling unit (unit official seal)" in the first cell and the character string in the second cell, and the type of the key value pair data is data filling.
Next, how to determine key value pair data of which the type is placeholder in the template table data will be described.
Specifically, in this manner, it is necessary to scan cells in the template table one by one and determine the type of each cell. Assuming that any cell in the template table is a first cell, if the first cell includes a placeholder, the placeholder in the first cell is used as a key, a character string corresponding to the placeholder is used as a value, and the type of the key value pair data is the placeholder. It should be noted that a placeholder may be understood as a symbol that is used to occupy a fixed position in a cell and may be added with content, for example, a title of a template: the xxxx province (district, city) selects a medical health institution medicine use catalog medicine summary analysis table_2019, and can change xxxx into a placeholder $ { provicename } or $ { meta entity.provicename }, so that xxxx in the title can be replaced by a true value according to specific situations.
The illustration is continued by taking fig. 2 as an example. Assuming that the first cell is a cell of the A column and the 1 st row, the first cell comprises a preset character string "$ { provicename } province (district, city) and selecting a medical health institution medicine use catalog medicine summary analysis table_2019"; because the placeholder of $ { provicename } can be obtained by removing the table of analysis of the summary of medicine usage of medical care institution, namely, the table of analysis of medicine usage, namely, 2019, in the province (district, city), of the first cell, the placeholder in the first cell can be used as a key, the character string corresponding to the placeholder is used as a value, the key and the value form a key value pair data, and the type of the key value pair data is the placeholder.
Next, how to determine key pair data of which the type is the header type in the template table data will be described.
Specifically, in this manner, it is necessary to scan cells in the template table one by one and determine the type of each cell. Assuming that any cell in the template table is a first cell, if each cell in a row where the first cell is located includes a preset character, and each cell in a next row of the first cell does not include a character string, that is, assuming that the row number corresponding to the first cell is an nth row, each cell in the n+1th row does not include a character string; the character string in the first cell is used as a key, the character string in a third cell which is in the same column as the first cell but is positioned in the next row of the first cell is used as a value, and the type of the key value pair data is in a header type.
The illustration is continued by taking fig. 2 as an example. Assuming that the first cell is the cell of the A column and the 5 th row; since each cell of the row of the first cell includes a preset character, and each cell of the next row of the first cell (i.e., each cell of the 6 th row) does not include a character string; therefore, the character string "serial number" in the first cell can be used as a key, and the character string in the third cell (namely, the cells in the A-th column and the 6-th column) which is in the same column as the first cell but is positioned in the next row of the first cell can be used as a value, so that a key value pair is formed by the character string "serial number" in the first cell and the character string in the third cell, and the type of the key value pair data is in a header type.
Finally, how to determine key pair data of which the type is a label type in the template table data will be described.
Specifically, in this manner, it is necessary to scan cells in the template table one by one and determine the type of each cell. And assuming any cell in the template table is a first cell, if the first cell comprises a preset character string, and a fourth cell adjacent to the first cell comprises a mark character string corresponding to the preset character string. The fourth cell may be a cell that is in the same row as the first cell and is located in the next row of the first cell, or may be a cell that is in the same row as the first cell and is located in the next row of the first cell; the marking character string corresponding to the preset character string may be understood as at least one fixed character string corresponding to the preset character string, which is preset, for example, the preset character string is "unit", and the marking character string corresponding to the preset character string may include "laundry hospital", "sunward hospital" and the like. In this way, the character string in the first cell can be used as a key, the character string in the fourth cell can be used as a value, and the type of key value pair data formed by the character string in the first cell and the character string in the fourth cell is marked.
S204: for each key value pair data in the template table, determining the position information of the value in the key value pair data according to the position information and the type of the key value pair data, and taking the position information of the key and the position information of the value as the position information corresponding to the key value pair data.
It should be noted that, since the type of the key-value pair data in the template table may represent the relationship between the position information of the key and the position information of the value, after determining the position information of the key in the key-value pair data and the type of the key-value pair data, the position information of the value in the key-value pair data may be determined. Therefore, in this embodiment, after determining the type of each key value pair data in the template table, for each key value pair data in the template table, the position information of the value in the key value pair data (i.e. the rank number of the value) may be determined according to the position information and the type of the key value pair data, and the position information of the key and the position information of the value may be used as the position information corresponding to the key value pair data.
For example, if the position information of the key-value pair data is the nth row and the mth column and the type of the key-value pair data is the data padding type, the position information of the value in the key-value pair data may be determined to be the nth row and the mth+1st column.
For another example, if the position information of the key-value pair data is the nth row and the mth column and the type of the key-value pair data is the placeholder type, the position information of the value in the key-value pair data may be determined to be the nth row and the mth column.
For another example, if the position information of the key-value pair data is the nth row and the mth column and the type of the key-value pair data is the header type, the position information of the value in the key-value pair data may be determined to be the n+1th row and the mth column.
For example, if the position information of the key-value pair data is the nth row and the mth column and the type of the key-value pair data is the flag type, the position information of the value in the key-value pair data may be determined to be the n+1th row and the mth column or the nth row and the mth+1th column. Note that, N, M is a positive integer.
S205: and processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
S205 in this embodiment is the same as S103 in the embodiment corresponding to fig. 1A. Therefore, in the present embodiment, S205 will not be described again, and the description of S103 may be referred to specifically.
So far, the embodiment realizes the medical data processing process based on Excel by combining with a specific application scene. It should of course be appreciated that the above scenario is merely an exemplary scenario and is not intended to limit the methods provided by the present invention. The method provided by the invention can be prolonged to be applied to the processing process of the Excel-based medical data processing method of other same principles.
Fig. 1A shows only a basic embodiment of the method according to the invention, on the basis of which certain optimizations and developments are made, but other alternative embodiments of the method can also be obtained.
Next, another specific embodiment of the Excel-based medical data processing method of the present invention will be described. In this embodiment, S103 is further described in the case where the processing instruction is a table import instruction on the basis of the corresponding embodiment of fig. 1A (S103 includes S303). As shown in fig. 1C, in this embodiment, the method specifically includes the following steps:
s301: and acquiring the processing instruction and the medical data table to be processed.
In this embodiment, the processing instruction is a form importing instruction, and correspondingly, the medical data form to be processed is a template form including medical information.
Note that S301 in this embodiment is similar to S101 in the corresponding embodiment of fig. 1A. Therefore, in the present embodiment, S301 will not be described again, and reference may be made specifically to the description of S101.
S302: determining layout meta information corresponding to the medical data table to be processed, wherein the layout meta information comprises position information corresponding to data of each key value in the medical data table to be processed;
s302 in this embodiment is the same as S102 in the embodiment corresponding to fig. 1A. Therefore, in the present embodiment, S302 will not be described again, and reference may be made specifically to the description of S102.
S303: and carrying out data extraction on the medical data table to be processed according to the layout meta information to obtain medical information corresponding to each key value data respectively.
Because the layout meta information of the medical data table to be processed may include the position information corresponding to the data of each key value in the medical data table to be processed, the cell corresponding to the key and the cell corresponding to the value in the data of each key value pair in the medical data table to be processed may be determined according to the layout meta information. And then, extracting the character strings included in the cells corresponding to the keys in the data of each key value pair and the character strings included in the cells corresponding to the values, so that the character strings included in the cells corresponding to the keys and the character strings included in the cells corresponding to the values can be used as medical information corresponding to the data of the key value pair.
For example, it is assumed that according to the layout meta information, it may be determined that a cell a corresponding to a key in the key-value pair data is located in the a-th column and the third row, and the character string included in the cell a is "unit"; the cell B corresponding to the key in the key value pair data is positioned in the B column and the third row, and the character string included in the cell B is "sea lake hospital". Thus, by extracting the character strings in the cells a and B, the correspondence between the "unit" and the "laundry hospital" of the medical data corresponding to the data by the key value can be determined.
S304: and storing medical information corresponding to the data of each key value to a preset database.
After determining the medical information corresponding to each key value in the medical data table to be processed, the medical information corresponding to each key value in the data can be stored in a preset database so as to be exported for processing. It should be noted that, when the medical data table to be processed is acquired, the acquisition source may be determined, and the acquisition source, for example, a user name corresponding to the terminal, may be used as the user identifier; and, the medical information respectively corresponding to the user identification and the key value data can be stored in a preset database as a corresponding relation. For example, if the medical data table to be processed is uploaded by a seashore hospital, the medical information corresponding to the data respectively by each key value in the table to be processed and the corresponding relation of the user identifier of the seashore hospital can be stored in a preset database, so that the medical data corresponding to the user identifier can be extracted from the preset database for processing according to the user identifier.
So far, the embodiment realizes the medical data processing process based on Excel by combining with a specific application scene. It should of course be appreciated that the above scenario is merely an exemplary scenario and is not intended to limit the methods provided by the present invention. The method provided by the invention can be prolonged to be applied to the processing process of the Excel-based medical data processing method of other same principles.
Fig. 1A shows only a basic embodiment of the method according to the invention, on the basis of which certain optimizations and developments are made, but other alternative embodiments of the method can also be obtained.
Next, another specific embodiment of the Excel-based medical data processing method of the present invention will be described. In this embodiment, S103 is further described in the case where the processing instruction is a table export instruction on the basis of the corresponding embodiment of fig. 1A (S103 includes S403). In this embodiment, the method specifically includes the following steps:
s401: acquiring the form export instruction and a medical data form to be processed, and determining medical information to be exported according to the form export instruction;
in this embodiment, the processing instruction is a table export instruction, and the medical data table to be processed is a template table. The table export instruction may include an identifier corresponding to the medical information to be exported, for example, in an implementation manner, the table export instruction may include a user identifier corresponding to the medical information to be exported, so that the medical information corresponding to the user identifier may be obtained from a preset database according to the user identifier, and the medical information is used as the medical information to be exported.
Note that S401 in this embodiment is similar to S101 in the corresponding embodiment of fig. 1A. Therefore, in the present embodiment, S401 will not be described again, and reference may be made specifically to the description of S101.
S402: and determining the layout meta information corresponding to the medical data table to be processed.
S402 in this embodiment is the same as S102 in the embodiment corresponding to fig. 1A. Therefore, in the present embodiment, S402 will not be described again, and reference may be made specifically to the description of S102.
S403: and filling the medical information to be exported into the medical data table to be processed according to the key value pair data corresponding to the medical data to be exported and the layout meta information.
Because the layout meta information of the medical data table to be processed may include the position information corresponding to the data of each key value in the medical data table to be processed, the cell corresponding to the key and the cell corresponding to the value in the data of each key value pair in the medical data table to be processed may be determined according to the layout meta information. Then, key value pair data corresponding to each of the medical information to be derived can be determined. Next, the data of the key value corresponding to the medical data and each key value in the medical data table to be processed can be matched, if the key value corresponding to the medical data matches the data of the key value in the medical data table to be processed, for example, the key in the key value pair data is the same as the key in the data, for example, the key in the key value pair data corresponding to the medical data is the "unit", and the key in the key value pair data in the medical data table to be processed is the "unit", the key value corresponding to the medical data can be considered to match the data of the key value pair data in the medical data table to be processed; the key value data corresponding to the medical information can be filled into the position corresponding to the key value pair data matched with the key value pair data corresponding to the medical information, so that the medical data table to be processed filled with the medical information can be exported.
So far, the embodiment realizes the medical data processing process based on Excel by combining with a specific application scene. It should of course be appreciated that the above scenario is merely an exemplary scenario and is not intended to limit the methods provided by the present invention. The method provided by the invention can be prolonged to be applied to the processing process of the Excel-based medical data processing method of other same principles.
Referring now to FIG. 3, an embodiment of an Excel-based medical data processing device according to the present invention is shown. The apparatus of this embodiment is an entity apparatus for performing the method of the foregoing embodiment. The technical solution is essentially identical to the above embodiment, and the corresponding description in the above embodiment is also applicable to this embodiment. The device in this embodiment includes:
an obtaining unit 301, configured to obtain a processing instruction and a medical data table to be processed, where the processing instruction includes a table import instruction or a table export instruction;
a determining unit 302, configured to determine layout meta information corresponding to the medical data table to be processed, where the layout meta information includes location information corresponding to each key value in the medical data table to be processed;
and a processing unit 303, configured to process the data according to the processing instruction and the layout meta information, so as to obtain processed medical data.
Optionally, the determining unit 302 is specifically configured to:
determining a template form corresponding to the medical data form to be processed;
determining the type of each key value pair data in the template table according to the template table;
for each key value pair data in the template table, determining the position information of the value in the key value pair data according to the position information and the type of the key value pair data, and taking the position information of the key and the position information of the value as the position information corresponding to the key value pair data.
Optionally, the types of the key value pair data include: data filling type, placeholder type, header type and mark type;
the determining unit 302 is further specifically configured to:
if the first cell comprises a preset character string and a second cell which is in the same row with the first cell, is adjacent to the first cell and is positioned behind the first cell does not comprise the character string, the character string in the first cell is used as a key, the character string in the second cell is used as a value, and the type of the key value pair data is data filling type;
if the first cell comprises a placeholder, the placeholder in the first cell is used as a key, a character string corresponding to the placeholder is used as a value, and the type of the key value pair data is the placeholder;
If each cell in the row of the first cell comprises a preset character and each cell in the next row of the first cell does not comprise a character string, taking the character string in the first cell as a key, taking the character string in the third cell which is in the same column as the first cell but is positioned in the next row of the first cell as a value, and taking the type of key value pair data as a header type;
if the first cell includes a preset character string and the fourth cell adjacent to the first cell includes a marking character string corresponding to the preset character string, the character string in the first cell is used as a key, the character string in the fourth cell is used as a value, and the type of the key value pair data is marked.
Optionally, the determining unit 302 is further specifically configured to:
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is data filling type, determining that the position information of the value in the key value pair data is the nth row and the mth+1th column;
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the placeholder, determining that the position information of the value in the key value pair data is the nth row and the mth column;
If the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the header type, determining that the position information of the value in the key value pair data is the (n+1) th row and the mth column;
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the mark type, determining that the position information of the value in the key value pair data is the (n+1) th row and the mth column or the (n+1) th row and the mth column; wherein N, M is a positive integer.
Optionally, the processing instruction is a table importing instruction; accordingly, the processing unit 303 is configured to:
and carrying out data extraction on the medical data table to be processed according to the layout meta information to obtain medical information corresponding to each key value data respectively.
Optionally, the apparatus further comprises a storage unit configured to:
and storing medical data corresponding to the data of each key value to a preset database.
Optionally, the processing instruction is a table export instruction; the acquiring unit 301 is specifically configured to:
acquiring the form export instruction and a medical data form to be processed, and determining medical information to be exported according to the form export instruction;
Accordingly, the processing unit 303 is specifically configured to:
and filling the medical information to be exported into the medical data table to be processed according to the key value pair data corresponding to the medical data to be exported and the layout meta information.
Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention. At the hardware level, the electronic device comprises a processor, optionally an internal bus, a network interface, a memory. The Memory may include a Memory, such as a Random-Access Memory (RAM), and may further include a non-volatile Memory (non-volatile Memory), such as at least 1 disk Memory. Of course, the electronic device may also include hardware required for other services.
The processor, network interface, and memory may be interconnected by an internal bus, which may be an ISA (Industry Standard Architecture ) bus, a PCI (Peripheral Component Interconnect, peripheral component interconnect standard) bus, or EISA (Extended Industry Standard Architecture ) bus, among others. The buses may be classified as address buses, data buses, control buses, etc. For ease of illustration, only one bi-directional arrow is shown in FIG. 4, but not only one bus or type of bus.
And the memory is used for storing the execution instruction. In particular, a computer program that executes instructions may be executed. The memory may include memory and non-volatile storage and provide the processor with instructions and data for execution.
In one possible implementation manner, the processor reads the corresponding execution instruction from the nonvolatile memory into the memory and then executes the execution instruction, and may also acquire the corresponding execution instruction from other devices, so as to form the medical data processing apparatus based on Excel on a logic level. The processor executes the execution instructions stored in the memory to implement the Excel-based medical data processing method provided in any embodiment of the present invention by executing the execution instructions.
The method performed by the Excel-based medical data processing device provided in the embodiment of fig. 1A of the present invention may be applied to a processor or implemented by a processor. The processor may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware in a processor or by instructions in the form of software. The processor may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU), a network processor (Network Processor, NP), etc.; but also digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), field programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components. The disclosed methods, steps, and logic blocks in the embodiments of the present invention may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The steps of the method disclosed in connection with the embodiments of the present invention may be embodied directly in the execution of a hardware decoding processor, or in the execution of a combination of hardware and software modules in a decoding processor. The software modules may be located in a random access memory, flash memory, read only memory, programmable read only memory, or electrically erasable programmable memory, registers, etc. as well known in the art. The storage medium is located in a memory, and the processor reads the information in the memory and, in combination with its hardware, performs the steps of the above method.
The embodiment of the invention also provides a readable medium, wherein the readable storage medium stores an execution instruction, and when the stored execution instruction is executed by a processor of an electronic device, the electronic device can be enabled to execute the medical data processing method based on Excel provided in any embodiment of the invention, and the method is specifically used for executing the medical data processing method based on Excel.
The electronic device described in the foregoing embodiments may be a computer.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method or a computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment, or a combination of software and hardware aspects.
The embodiments of the present invention are described in a progressive manner, and the same and similar parts of the embodiments are all referred to each other, and each embodiment is mainly described in the differences from the other embodiments. In particular, for the device embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and reference is made to the description of the method embodiments in part.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The foregoing is merely exemplary of the present invention and is not intended to limit the present invention. Various modifications and variations of the present invention will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. which come within the spirit and principles of the invention are to be included in the scope of the claims of the present invention.
Claims (7)
1. An Excel-based medical data processing method, characterized in that the method comprises:
acquiring a processing instruction and a medical data table to be processed, wherein the processing instruction comprises a table import instruction or a table export instruction;
determining layout meta information corresponding to the medical data table to be processed, wherein the layout meta information comprises position information corresponding to data of each key value in the medical data table to be processed;
according to the processing instruction and the layout meta information, processing the data of each key value in the medical data table to be processed to obtain processed medical data;
the determining the layout meta information corresponding to the medical data table to be processed includes:
determining a template form corresponding to the medical data form to be processed; the key value pair data types include: data filling type, placeholder type, header type and mark type;
determining the type of each key value pair data in the template table according to the template table; the method comprises the following steps:
if the first cell comprises a preset character string and a second cell which is in the same row with the first cell, is adjacent to the first cell and is positioned behind the first cell does not comprise the character string, the character string in the first cell is used as a key, the character string in the second cell is used as a value, and the type of the key value pair data is data filling type;
If the first cell comprises a placeholder, the placeholder in the first cell is used as a key, a character string corresponding to the placeholder is used as a value, and the type of the key value pair data is the placeholder;
if each cell in the row of the first cell comprises a preset character and each cell in the next row of the first cell does not comprise a character string, taking the character string in the first cell as a key, taking the character string in the third cell which is in the same column as the first cell but is positioned in the next row of the first cell as a value, and taking the type of key value pair data as a header type;
if the first cell comprises a preset character string and a fourth cell adjacent to the first cell comprises a marked character string corresponding to the preset character string, the character string in the first cell is used as a key, the character string in the fourth cell is used as a value, and the type of the key value pair data is marked;
for each key value pair data in the template table, determining the position information of the value in the key value pair data according to the position information and the type of the key value pair data, and taking the position information of the key and the position information of the value as the position information corresponding to the key value pair data; the method comprises the following steps:
If the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is data filling type, determining that the position information of the value in the key value pair data is the nth row and the mth+1th column;
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the placeholder, determining that the position information of the value in the key value pair data is the nth row and the mth column;
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the header type, determining that the position information of the value in the key value pair data is the (n+1) th row and the mth column;
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the mark type, determining that the position information of the value in the key value pair data is the (n+1) th row and the mth column or the (n+1) th row and the mth column; wherein N, M is a positive integer.
2. The method of claim 1, wherein the processing instruction is a table import instruction; correspondingly, the medical data form to be processed is a template form comprising medical information; and processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain processed medical data, wherein the processing method comprises the following steps of:
And carrying out data extraction on the medical data table to be processed according to the layout meta information to obtain medical information corresponding to each key value data respectively.
3. The method according to claim 2, wherein, after the step of extracting data from the medical data table to be processed according to the layout meta information to obtain medical information corresponding to each key value and each data, the method further comprises:
and storing medical information corresponding to the data of each key value to a preset database.
4. The method of claim 1, wherein the processing instruction is a table export instruction; the medical data form to be processed is a template form; the acquiring the processing instruction and the medical data table to be processed comprises the following steps:
acquiring the form export instruction and a medical data form to be processed, and determining medical information to be exported according to the form export instruction;
correspondingly, the processing the data according to the processing instruction and the layout meta information for each key value in the medical data table to be processed to obtain the processed medical data includes:
and filling the medical information to be exported into the medical data table to be processed according to the key value pair data corresponding to the medical information to be exported and the layout meta information.
5. An Excel-based medical data processing device, the device comprising:
the acquisition unit is used for acquiring a processing instruction and a medical data table to be processed, wherein the processing instruction comprises a table import instruction or a table export instruction;
a determining unit, configured to determine layout meta information corresponding to the medical data table to be processed, where the layout meta information includes location information corresponding to data of each key value in the medical data table to be processed;
the processing unit is used for processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data;
the determining unit is specifically configured to:
determining a template form corresponding to the medical data form to be processed; the key value pair data types include: data filling type, placeholder type, header type and mark type;
determining the type of each key value pair data in the template table according to the template table; the method comprises the following steps:
if the first cell comprises a preset character string and a second cell which is in the same row with the first cell, is adjacent to the first cell and is positioned behind the first cell does not comprise the character string, the character string in the first cell is used as a key, the character string in the second cell is used as a value, and the type of the key value pair data is data filling type;
If the first cell comprises a placeholder, the placeholder in the first cell is used as a key, a character string corresponding to the placeholder is used as a value, and the type of the key value pair data is the placeholder;
if each cell in the row of the first cell comprises a preset character and each cell in the next row of the first cell does not comprise a character string, taking the character string in the first cell as a key, taking the character string in the third cell which is in the same column as the first cell but is positioned in the next row of the first cell as a value, and taking the type of key value pair data as a header type;
if the first cell comprises a preset character string and a fourth cell adjacent to the first cell comprises a marked character string corresponding to the preset character string, the character string in the first cell is used as a key, the character string in the fourth cell is used as a value, and the type of the key value pair data is marked;
for each key value pair data in the template table, determining the position information of the value in the key value pair data according to the position information and the type of the key value pair data, and taking the position information of the key and the position information of the value as the position information corresponding to the key value pair data; the method comprises the following steps:
If the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is data filling type, determining that the position information of the value in the key value pair data is the nth row and the mth+1th column;
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the placeholder, determining that the position information of the value in the key value pair data is the nth row and the mth column;
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the header type, determining that the position information of the value in the key value pair data is the (n+1) th row and the mth column;
if the position information of the key value pair data is the nth row and the mth column and the type of the key value pair data is the mark type, determining that the position information of the value in the key value pair data is the (n+1) th row and the mth column or the (n+1) th row and the mth column; wherein N, M is a positive integer.
6. A readable storage medium storing execution instructions which, when executed by a processor of an electronic device, perform the method of any one of claims 1 to 4.
7. An electronic device comprising a processor and a memory storing execution instructions that, when executed by the processor, perform the method of any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911406159.2A CN113126981B (en) | 2019-12-31 | 2019-12-31 | Medical data processing method and device based on Excel |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911406159.2A CN113126981B (en) | 2019-12-31 | 2019-12-31 | Medical data processing method and device based on Excel |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113126981A CN113126981A (en) | 2021-07-16 |
| CN113126981B true CN113126981B (en) | 2023-10-03 |
Family
ID=76768706
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911406159.2A Active CN113126981B (en) | 2019-12-31 | 2019-12-31 | Medical data processing method and device based on Excel |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113126981B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114866531A (en) * | 2022-04-02 | 2022-08-05 | 山东体育学院 | Cross-network data transmission method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101183356A (en) * | 2007-12-14 | 2008-05-21 | 华为技术有限公司 | Realization method of Excel report forms and Excel reporting system |
| CN107608669A (en) * | 2017-08-15 | 2018-01-19 | 山西云度知识产权服务有限公司 | A kind of method based on database table structure automatic generation function and the page |
| CN107887009A (en) * | 2017-11-20 | 2018-04-06 | 浪潮金融信息技术有限公司 | Processing method and processing device, computer-readable storage medium and the terminal of information for hospital data |
| CN108322492A (en) * | 2017-01-16 | 2018-07-24 | 医渡云（北京）技术有限公司 | Medical data synchronous method and device |
| CN109582286A (en) * | 2018-07-04 | 2019-04-05 | 福州震旦计算机技术有限公司 | Data standard method of calibration and its device based on Freemarker technology |
| CN109933752A (en) * | 2017-12-15 | 2019-06-25 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus exporting electronic document |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100005115A1 (en) * | 2008-07-03 | 2010-01-07 | Sap Ag | Method and system for generating documents usable by a plurality of differing computer applications |
| SG188320A1 (en) * | 2011-08-31 | 2013-04-30 | Apixio Inc | Medical information navigation engine (mine) system |
| US10540153B2 (en) * | 2016-12-03 | 2020-01-21 | Thomas STACHURA | Spreadsheet-based software application development |
-
2019
- 2019-12-31 CN CN201911406159.2A patent/CN113126981B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101183356A (en) * | 2007-12-14 | 2008-05-21 | 华为技术有限公司 | Realization method of Excel report forms and Excel reporting system |
| CN108322492A (en) * | 2017-01-16 | 2018-07-24 | 医渡云（北京）技术有限公司 | Medical data synchronous method and device |
| CN107608669A (en) * | 2017-08-15 | 2018-01-19 | 山西云度知识产权服务有限公司 | A kind of method based on database table structure automatic generation function and the page |
| CN107887009A (en) * | 2017-11-20 | 2018-04-06 | 浪潮金融信息技术有限公司 | Processing method and processing device, computer-readable storage medium and the terminal of information for hospital data |
| CN109933752A (en) * | 2017-12-15 | 2019-06-25 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus exporting electronic document |
| CN109582286A (en) * | 2018-07-04 | 2019-04-05 | 福州震旦计算机技术有限公司 | Data standard method of calibration and its device based on Freemarker technology |
Non-Patent Citations (1)
| Title |
|---|
| 医疗质控数据统计中EXCEL软件实用技巧;杜德洁 等;《医学研究生学报》;第25卷(第3期);第298页-第300页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113126981A (en) | 2021-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10963833B2 (en) | Method and apparatus for processing logistics information | |
| CN111290956B (en) | Brain graph-based test method and device, electronic equipment and storage medium | |
| CN107992492B (en) | Data block storage method, data block reading method, data block storage device, data block reading device and block chain | |
| CN109271315B (en) | Script code detection method, script code detection device, computer equipment and storage medium | |
| CN111159329A (en) | Sensitive word detection method and device, terminal equipment and computer-readable storage medium | |
| CN111209736A (en) | Text file analysis method and device, computer equipment and storage medium | |
| CN114090671A (en) | Data import method and device, electronic equipment and storage medium | |
| CN113126981B (en) | Medical data processing method and device based on Excel | |
| CN115391439A (en) | Document data export method, device, electronic equipment and storage medium | |
| CN110543450A (en) | Electronic document generation method and device, computer equipment and storage medium | |
| CN116029080A (en) | Chip storage device design and verification method and device and electronic equipment | |
| CN109102845B (en) | Medical document auditing method, device, computer equipment and storage medium | |
| CN109542890B (en) | Data modification method, device, computer equipment and storage medium | |
| CN111159985A (en) | Data export method, data export device, computer equipment and computer-readable storage medium | |
| CN110647568B (en) | Method and device for converting graph database data into programming language data | |
| CN113254455B (en) | Dynamic configuration method and device of database, computer equipment and storage medium | |
| CN114860238A (en) | Page generation method and device and electronic equipment | |
| CN114741077A (en) | Page effect preview method, device, equipment and medium based on field granularity | |
| CN114925127A (en) | Two-dimensional graph generation method and device for cascade structure data and storage medium | |
| CN111199805A (en) | Type hierarchy extraction method and device based on medical data | |
| CN111177179B (en) | Information recording method and device | |
| CN115270748B (en) | File generation method, device, electronic equipment and storage medium | |
| CN113220382B (en) | Abnormality detection method and device for application language package | |
| CN111061863B (en) | Journal catalog display method, device and equipment | |
| CN113033177B (en) | Method and device for analyzing electronic medical record data |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230217 Address after: Room 304, Unit 1, Floor 4, Building 9, West District, No. 9 Courtyard, Linglong Road, Haidian District, Beijing, 100089 Applicant after: BEIJING YIYIYUN TECHNOLOGY Co.,Ltd. Address before: Floor 4, 5, 6 and 7, building E7, Zhihui Yunjin incubation base of Guizhou great health pharmaceutical industry, Wudang District, Guiyang City, Guizhou Province Applicant before: GUIZHOU YIDU CLOUD TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |