[go: up one dir, main page]

CN107832477A - A kind of method and system that database is created based on Excel forms - Google Patents

A kind of method and system that database is created based on Excel forms Download PDF

Info

Publication number
CN107832477A
CN107832477A CN201711249074.9A CN201711249074A CN107832477A CN 107832477 A CN107832477 A CN 107832477A CN 201711249074 A CN201711249074 A CN 201711249074A CN 107832477 A CN107832477 A CN 107832477A
Authority
CN
China
Prior art keywords
database
parameter
excel forms
program
read
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
Application number
CN201711249074.9A
Other languages
Chinese (zh)
Other versions
CN107832477B (en
Inventor
杨显平
金翔宇
吴凯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Yunjia Intelligent Technology Co Ltd
Original Assignee
SHENZHEN XTOOLTECH Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by SHENZHEN XTOOLTECH Co Ltd filed Critical SHENZHEN XTOOLTECH Co Ltd
Priority to CN201711249074.9A priority Critical patent/CN107832477B/en
Publication of CN107832477A publication Critical patent/CN107832477A/en
Application granted granted Critical
Publication of CN107832477B publication Critical patent/CN107832477B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2291—User-Defined Types; Storage management thereof
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/21—Design, administration or maintenance of databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Stored Programmes (AREA)

Abstract

The invention discloses a kind of method and system that database is created based on Excel forms, wherein, method includes：Excel forms are configured according to User Defined structure, the User Defined structure includes user-defined multiple sheet pages, and in every one attribute that unique function is configured with sheet pages；By in corresponding sheet pages of parameter read-in needed for database code；The parameter is read by make functions, generates executable database.Therefore, compared with prior art, the embodiment of the present invention can reduce code, improve development efficiency, and easy to maintain.

Description

A kind of method and system that database is created based on Excel forms
Technical field
The present invention relates to field of computer technology, more particularly to it is a kind of based on Excel forms create database method and System.
Background technology
Database (Database) is to come tissue, storage according to data structure and manage the foundation of data in computer storage Warehouse in equipment.It is the file cabinet that can be considered electronization in itself in simple terms, that is, stores the place of e-file, user can be with Data in file increased newly, intercepted, being updated, being deleted etc. with operation.
In automobile management program development process, database is just be unable to do without, usual engineer is needed some and automobile phase The data of pass are put into such " warehouse ", and are handled accordingly according to the needs of management.
With the development of automotive engineering, the function on automobile is more and more, and database is more and more huger, causes required volume The code collected is also more and more, and will consume engineer and the longer working time code is written in database, and is compiling It is also easy to malfunction during volume.
The content of the invention
, can be by data the embodiments of the invention provide a kind of method and system that database is created based on Excel forms The parameter that bank code needs is write in corresponding sheet pages of Excel forms, is read these parameters by make functions, is ultimately generated Required executable database.It can reduce code, improve development efficiency, and easy to maintain.
In view of this, the first aspect of the embodiment of the present invention provides a kind of side that database is created based on Excel forms Method, including：
Excel forms are configured according to User Defined structure, the User Defined structure includes user-defined more Individual sheet pages, and in every one attribute that unique function is configured with sheet pages；
By in corresponding sheet pages of parameter read-in needed for database code；
The parameter is read by make functions, generates the executable database.
Further, the parameter include program identification and with the corresponding routine data of described program mark, it is described Routine data is associated with corresponding sheet pages of attribute.
Further, the program identification after the generation compiling of described program mark compiled program, and in the make functions In with the program identification and the mapping relations of respective function after the compiling, and with the letter in the make functions Several function prototypes.
Further, it is described to be included by the make functions reading parameter：
Data in global variable and the class reading Excel forms are passed through by the make functions.
Further, after the executable database of the generation, methods described also includes：
Target component is replaced in corresponding sheet pages of the parameter read-in, the target component includes target Program identification and target program data corresponding with target program mark, the target program mark and described program mark Sensible same, the target program data are different from described program data；
The target component is read by the make functions, updates the database.
The second aspect of the embodiment of the present invention provides a kind of system that database is created based on Excel forms, including：Can Depending on changing editing machine, Excel forms and make functions；
Wherein, the Excel forms and the make functions are stored in the visual editor, and the visualization is compiled Device is collected to be used for：
Excel forms are configured according to User Defined structure, the User Defined structure includes user-defined more Individual sheet pages, and in every one attribute that unique function is configured with sheet pages；
By in corresponding sheet pages of parameter read-in needed for database code；
The parameter is read by make functions, generates the executable database.
Further, the parameter include program identification and with the corresponding routine data of described program mark, it is described Routine data is associated with corresponding sheet pages of attribute.
Further, the system also includes compiler, and described program mark is after compiler generation compiling Program identification, and with the program identification and the mapping relations of respective function after the compiling in the make functions, with And the function prototype of the function is written with the make functions.
Further, it is described to be included by the make functions reading parameter：
Data in global variable and the class reading Excel forms are passed through by the make functions.
Further, the visual editor is additionally operable to：
Target component is replaced in corresponding sheet pages of the parameter read-in, the target component includes target Program identification and target program data corresponding with target program mark, the target program mark and described program mark Sensible same, the target program data are different from described program data；
The target component is read by the make functions, updates the database.
In technical scheme provided in an embodiment of the present invention, by configuring Excel forms, the use according to User Defined structure Family self-defined structure includes user-defined multiple sheet pages, and in every one category that unique function is configured with sheet pages Property；By in corresponding sheet pages of parameter read-in needed for database code；The parameter is read by make functions, generation is executable Database.Therefore, compared with prior art, the embodiment of the present invention can reduce code, improve development efficiency, and be easy to tie up Shield.
Brief description of the drawings
Fig. 1 is the method one embodiment schematic diagram for creating database in the embodiment of the present invention based on Excel forms；
Fig. 2 is Setting pages of one embodiment schematic diagram corresponding to ABS system in the embodiment of the present invention；
Fig. 3 is function menu one embodiment schematic diagram of ABS system in the embodiment of the present invention；
Fig. 4 is that database reads current failure code one embodiment schematic diagram in the embodiment of the present invention；
Fig. 5 is to read freeze frame one embodiment schematic diagram in the embodiment of the present invention；
Fig. 6 is FreezeFrame pages of one embodiment schematic diagram in the embodiment of the present invention；
Fig. 7 is method one embodiment schematic diagram based on Excel table update databases in the embodiment of the present invention；
Fig. 8 is the system one embodiment schematic diagram for creating database in the embodiment of the present invention based on Excel forms.
Embodiment
In order to which technical characteristic, purpose and the effect of the present invention is more clearly understood, below in conjunction with of the invention real The accompanying drawing in example is applied, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described implementation Example only part of the embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, art technology The every other embodiment that personnel are obtained under the premise of creative work is not made, belongs to the scope of protection of the invention.
The method for being created database in the embodiment of the present invention based on Excel forms is described with reference to the accompanying drawings, needed It is noted that the database that the present invention is created can apply to automotive system.
Referring to Fig. 1, being created method one embodiment of database in the embodiment of the present invention based on Excel forms is included：
S101, Excel forms are configured according to User Defined structure, the User Defined structure includes user-defined Multiple sheet pages, and in every one attribute that unique function is configured with sheet pages；
Wherein, to cause created database to disclosure satisfy that the function of automotive system, in the Excel forms, the use Setting pages, EnterSystem pages, ExitSystem can be followed successively by family customized multiple sheet pages (i.e. books) Page, EcuInfo pages, ReadDtc pages, ClearDtc pages, ReadCds pages, FreezeFrame pages, Function pages, Command Page, Text pages, Dtc pages, Stat pages, LookUp pages, its every one attribute configured in sheet pages can have unique function.
It is described in detail individually below：
This Setting pages can be used for being configured automotive system, and its attribute can include：ID, systematic parameter, order Mark, menu identification, script, program identification.Wherein, in systematic parameter can include slave computer protocol type, handshake method, Handshake parameter, packaging method, order default flag, packing parameter, verification mode, upper and lower computer time-out, the link retention time, examine The byte interval time of disconnected instrument request, the frame period time of diagnostic equipment request, diagnostic equipment receives data frame timeout, diagnostic equipment receives Data byte time-out, ECU baud rates, data bit, check bit, send IO, receive IO, IO control parameter, filter type, filtering ginseng Number etc.；The command id can include keeping command id, exit command mark, CAN to flow control automatically into command id, link Command id processed etc.；The menu identification can include diagnostic function menu identification and freeze frame reading code menu identification etc..
This EnterSystem pages can be used for setting and enter the automotive system, and its attribute can include：ID, command id, Method, script, program identification；
This ExitSystem pages can be used for setting and exit the automotive system, and its attribute can include：ID, command id, Method, script, program identification；
This EcuInfo pages can be used for setting ECU (Electronic ControlUnit) letters for showing the automotive system Breath, its attribute can include：ID, menu identification, command id, display text, frame number, original position, end position, byte Number, expression formula, display format, script, program identification；
This ReadDtc pages can be used for set read the automotive system DTC (Diagnostic TroubleCode, are examined Disconnected DTC) information, its attribute can include：ID, menu identification, command id, method, number position, original position, interval Number, DTC expression formulas, display format, state expression formula, DTC storehouses, script, program identification；
This ClearDtc pages can be used for setting the DTC information removed in the automotive system, and its attribute can include：ID、 Message, expression formula, clear code failed message, clear code success message, script, program before menu identification, command id, method, clear code Mark；
This ReadCds pages can be used for setting the traffic flow information for reading the automotive system, and its attribute can include：ID、 Menu identification, title, unit, command id, form, position, deviant, multiply the factor, except the factor, mask, expression formula, minimum Value, maximum, reference value, help, script, program identification, support expression formula；
This FreezeFrame pages can be used for setting and read the automotive system and freeze frame information, and its attribute can include： ID, menu identification, title, unit, command id, form, position, deviant, multiply the factor, except the factor, mask, expression formula, most Small value, maximum, reference value, help, script, program identification, support expression formula；
This Function pages can be used for setting function variable, and its attribute can include：ID, menu identification, method, order Mark, expression formula, terminate prompting, unsuccessfully prompting, program identification, STEP1, STEP2, STEP3, STEP4, STEP5, STEP6, STEP7、STEP8、EXIT；
This Command pages is used to set the command id in above-mentioned sheet pages, and its attribute can include：ID, processing mark Will, order, method, expression formula, LSN, script, program identification；
This Text pages can be used for setting text message, and its attribute can include：ID, text；
This Stat pages can be used for setting status information, and its attribute can include：ID, text；
This DTC pages can be used for setting DTC information, and its attribute can include：ID, code, description, help；
This Lookup pages can be used for setting and table look-up information, and its attribute can include：ID, number, type.
It should be noted that above-mentioned every one command id in sheet pages can with Command pages of the attribute ID is corresponding to be associated.
S102, by corresponding sheet pages of parameter read-in needed for database code；
In the present embodiment, to create the database, program identification can be included in the parameter needed for the database code And routine data corresponding with the program identification, and the routine data can be the number associated with above-mentioned sheet pages of attribute According to, for example, with the ABS (Antilock Brake System, anti-blocking brake system) in automotive system exemplified by, for the ABS The routine data of system, it writes can be with as shown in Fig. 2 ID can be distinguished in the ABS system with 0 and 1 in Setting pages Two kinds of settings, wherein, slave computer protocol type could be arranged to PT_KWP in the ID 0, handshake method could be arranged to HS_ QUICKPULSE, handshake parameter can be set including SF_PACK etc., packaging method could be arranged to PT_KWP, the default mark of order Will can set including KWP_8X and PF_UNPACK etc., packing parameter could be arranged to 0x28 and 0xf1, upper and lower computer time-out can It could be arranged to 800, diagnostic equipment request byte interval time to be arranged to for 3000, link retention time and could be arranged to 5, examine The frame period time of disconnected instrument request could be arranged to 55, diagnostic equipment reception data frame timeout and could be arranged to the reception of 500, diagnostic equipment Data byte time-out could be arranged to 30, ECU baud rates could be arranged to 10400, data bit could be arranged to 8, check bit can To be arranged to PB_NONE, transmission IO could be arranged to OBDII_NONE, reception IO could be arranged to OBDII_P9, IO control ginseng Number could be arranged to SETIOPAR_ISO_12V_4K7, link keeps command id to could be arranged to the 2, mark that exits command can be with It is arranged to that 3, filter type could be arranged to SERRIMEOUTFILTER, diagnostic function menu identification could be arranged to MENU_ XXX_FLYER_ABS, freeze frame reading code menu identification could be arranged to IDM_READ_DTC, etc..
It should be noted that as shown in figure 3, the function menu of the ABS system can also be write in the embodiment of the present invention Into notepad, by the function menu of the ABS system, logically association order is recorded in notepad in the form of menu tree, Wherein in the menu tree, the distance of a TAB key can be spaced between sub-menus and Previous Menu, and in the menu tree Each function menu may be followed by menu identification, and the menu identification is above-mentioned every one menu identification in sheet pages.
S103, the parameter read by make functions, generate executable database.
In the present embodiment, when being compiled to the Excel forms by the configuration of User Defined structure, wherein, Every one program identification write in sheet pages can generate the program identification after compiling with compiled program in Excel forms, such as Program identification corresponding to data flow DataStream in sheet pages is compiled as IDP_DataStream1.
And can also be in the make functions with the program identification and the mapping relations of respective function after the compiling, example Such as：
BEGIN_FUNC_MAP (XXX) //XXX is Module names
ON_FUNCTION(XXX,IDP_DataStream1,DataStream1)
END_FUNC_MAP()
IDP_DataStream1 is the program identification of compiling generation
DataStream1 is function corresponding to the mark
And can be in the make functions with function DataStream1 function prototype, its function prototype can be with For customized rules in function calling, do not limit herein specifically.
In the present embodiment, the parameter that the make functions are read in sheet pages of above-mentioned write-in Excel forms can be passed through Global variable and class read the data (including above-mentioned program identification and routine data) in the Excel forms.
Wherein, being read by global variable to be：
—extern CReceiveFrame g_rf；The data that // storage ECU is returned, i.e. a CBinaryGroup become Amount；
—extern AFX_RET_DATAg_ret；// return value, its type have RT_NUL, RT_NUM, RT_STR；
—extern CSheetSet g_set；// parameter in Setting workbooks can be read；
—extern CExcelFile g_file；Parameter during // read work is thin, such as the text in text；
—extern CBinary g_dtc；// parameter in ReadDtc workbooks can be read；
—extern CReceiveFrame g_save；// can be used to read the order that a certain bar is replied；
—extern CInputValue g_input；// input dialogue frame；
—extern DWORD g_val,g_in_val；//g_va:INC, DEC result, g_in_val：InputBox The integer value of middle input；
—extern BYTE g_calc[4]；The result of // storage particular algorithm, public 4 bytes, a high position is in preceding, low level Rear；
—extern CReceiveFrame g_enter；// can be read reply enter order.
Being read by class to be：
- class CSheet//Csheet classes, base class；
—class CSheetSet:Public CSheet//include the parameter in Setting workbooks；
—class CSheetEnter:Public CSheet//include the parameter in EnterSystem workbooks；
- #define CSheetExit CSheetEnter//include the parameter in ExitSystem workbooks；
—class CSheetInfo:Public CSheet//include the parameter in EcuInfo workbooks；
—class CSheetDtc:Public CSheet//include the parameter in ReadDtc workbooks；
—class CSheetClr:Public CSheet//include the parameter in ClearDtc workbooks；
—class CSheetCds:Public CSheet//include the parameter in ReadCds workbooks；
—class CSheetScript:Public CSheet//include the parameter in Function workbooks；
—class CSheetCmd:Public CSheet//include the parameter in Command workbooks；
—class CSheetText:Public CSheet//group includes the parameter in Text workbooks；
- #define CSheetStat CSheetText//include the parameter in Stat workbooks；
—class CSheetTable:Public CSheet//include the parameter in Lookup workbooks.
It is understood that the make functions and compiler in the embodiment of the present invention can be user-defined, And the database that the parameter generation in above-mentioned sheet pages can perform finally is read by the make functions, wherein, the data of the generation Upon execution, exemplified by performing and read freeze frame function, in failure that time, the correlation of the automobile of reading occur for the freeze frame in storehouse Performance parameter, similar to time data stream, according to freezing the reason for frame data can help failure judgement to occur.
And database needs first Read fault code before the freeze frame function is read in execution, as shown in Figure 4, the data are operated Current failure code is read in storehouse, can enter the function interface of the reading freeze frame afterwards, as shown in Figure 5；And it is corresponding its Parameter in FreezeFrame pages of Excel forms is referred to shown in Fig. 6, menu identification IDM_FROZEN, title difference For system voltage and system condenser, wherein, unit corresponding to the system voltage is V, command id 150, form % .2f, position 1, expression formula 0.067*X, command id corresponding to the system condenser is also 150, form is on Shu off, position It is (X＆0X80) to be set to 2, expression formula0:1.
In the technical scheme that the embodiment of the present invention is provided, by configuring Excel forms according to User Defined structure, And the User Defined structure includes user-defined multiple sheet pages, and unique work(is configured with sheet pages every one The attribute of energy；By in corresponding sheet pages of parameter read-in needed for database code；And the parameter is read by make functions, it is raw Into executable database, so as to reach reduction code, the purpose of development efficiency is improved.
Meanwhile the database to enable this to be created based on Excel forms is more readily maintained renewal, implement in the present invention The another aspect of example provides the method based on Excel table update databases, referring to Fig. 7, being based in the embodiment of the present invention Method one embodiment of Excel table update databases includes：
S201, target component is replaced to the parameter read-in that has been written into in corresponding sheet pages, the target component includes Target program identifies and target program data corresponding with target program mark, in target program mark and the parameter Program identification is identical, and the target program data are different from the routine data in the parameter；
S202, by the make functions read target component, update the data storehouse.
It should be understood that make functions are implemented with the above-mentioned method that database is created based on Excel forms in the present embodiment Make function performances in example are identical with effect, will not be described here.
The present embodiment, by changing the parameter replaced in the Excel forms that custom-configure of original subscriber so that generated Database is more readily maintained and updated, while code can also be reduced, and improves development efficiency.
Referring to Fig. 8, system one embodiment of database is created in the embodiment of the present invention based on Excel forms：
Visual editor 100, Excel forms 200 and make functions 300；
Wherein, Excel forms 200 and make functions 300 can be stored in the visual editor 100, the visualization Editing machine 100 specifically can be used for：
The Excel forms 200 are configured according to User Defined structure, the User Defined structure includes user-defined Multiple sheet pages, and in every one attribute that unique function is configured with sheet pages；
By in corresponding sheet pages of parameter read-in needed for database code；
The parameter is read by the make functions 300, generates executable database.
Further, in some embodiments of the invention, in the parameter can include program identification and with the program Routine data corresponding to mark, the routine data can be associated with corresponding sheet pages of attribute.
Further, in some embodiments of the invention, compiler, the program identification can also be included in the system Program identification after the compiler is generated as compiling, and can be with the program after the compiling in the make functions 300 The mapping relations with corresponding function are identified, and the function original of the function can also be written with the make functions 300 Type.
Further, in some embodiments of the invention, the make functions 300 read the parameter and are specifically as follows：
The data in the Excel forms 200 are read by global variable and class by the make functions 300.
Further, in some embodiments of the invention, the visual editor 100 specifically can be also used for：
Target component replacement above-mentioned parameter is written in corresponding sheet pages, target can be included in the target component Program identification and target program data corresponding with target program mark, and target program mark and the program identification phase Together, the target program data are different from the routine data；
The target component is read by the make functions 300, updates the database.
It is apparent to those skilled in the art that the above-mentioned system that database is created based on Excel forms With based on Excel forms create database method can be based on identical design concept and thinking, for description convenience with Succinctly, the specific work process of the system of foregoing description, the corresponding process in preceding method embodiment is may be referred to, herein no longer Repeat.
It is understood that part that technical scheme substantially contributes to prior art in other words or The all or part of the technical scheme can be embodied in the form of software product, and the computer software product is stored in one In storage medium, including some instructions are make it that a computer equipment (can be personal computer, server, or net Network equipment etc.) perform all or part of step of each embodiment methods described of the present invention.And foregoing storage medium includes：U Disk, mobile hard disk, read-only storage (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), magnetic disc or CD etc. are various can be with the medium of store program codes.
Described above, the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although with reference to before Embodiment is stated the present invention is described in detail, it will be understood by those within the art that：It still can be to preceding State the technical scheme described in each embodiment to modify, or equivalent substitution is carried out to which part technical characteristic；And these Modification is replaced, and the essence of appropriate technical solution is departed from the spirit and scope of various embodiments of the present invention technical scheme.

Claims (10)

  1. A kind of 1. method that database is created based on Excel forms, it is characterised in that including：
    Excel forms are configured according to User Defined structure, the User Defined structure includes user-defined multiple Sheet pages, and in every one attribute that unique function is configured with sheet pages；
    By in corresponding sheet pages of parameter read-in needed for database code；
    The parameter is read by make functions, generates the executable database.
  2. 2. the method according to claim 1 that database is created based on Excel forms, it is characterised in that in the parameter Including program identification and with the corresponding routine data of described program mark, described program data with corresponding sheet pages Attribute be associated.
  3. 3. the method according to claim 2 that database is created based on Excel forms, it is characterised in that described program mark Know compiled program generation compiling after program identification, and in the make functions with the program identification after the compiling with The mapping relations of respective function, and with the function prototype of the function in the make functions.
  4. 4. the method according to claim 3 that database is created based on Excel forms, it is characterised in that described by make Function, which reads the parameter, to be included：
    Data in global variable and the class reading Excel forms are passed through by the make functions.
  5. 5. the method according to claim 2 that database is created based on Excel forms, it is characterised in that the generation can After the database performed, methods described also includes：
    Target component is replaced in corresponding sheet pages of the parameter read-in, the target component includes target program Mark and target program data corresponding with target program mark, the target program mark identify phase with described program Together, the target program data are different from described program data；
    The target component is read by the make functions, updates the database.
  6. A kind of 6. system that database is created based on Excel forms, it is characterised in that including：Visual editor, Excel tables Lattice and make functions；
    Wherein, the Excel forms and the make functions are stored in the visual editor, the visual editor For：
    Excel forms are configured according to User Defined structure, the User Defined structure includes user-defined multiple Sheet pages, and in every one attribute that unique function is configured with sheet pages；
    By in corresponding sheet pages of parameter read-in needed for database code；
    The parameter is read by make functions, generates the executable database.
  7. 7. the system according to claim 6 that database is created based on Excel forms, it is characterised in that in the parameter Including program identification and with the corresponding routine data of described program mark, described program data with corresponding sheet pages Attribute be associated.
  8. 8. the system according to claim 7 that database is created based on Excel forms, it is characterised in that the system is also Including compiler, program identification of the described program mark after compiler generation compiling, and in the make functions In with the program identification and the mapping relations of respective function after the compiling, and be written with the make functions described The function prototype of function.
  9. 9. the system according to claim 8 that database is created based on Excel forms, it is characterised in that described by make Function, which reads the parameter, to be included：
    Data in global variable and the class reading Excel forms are passed through by the make functions.
  10. 10. the system according to claim 7 that database is created based on Excel forms, it is characterised in that the visualization Editing machine is additionally operable to：
    Target component is replaced in corresponding sheet pages of the parameter read-in, the target component includes target program Mark and target program data corresponding with target program mark, the target program mark identify phase with described program Together, the target program data are different from described program data；
    The target component is read by the make functions, updates the database.
CN201711249074.9A 2017-12-01 2017-12-01 Method and system for creating database based on Excel table Active CN107832477B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711249074.9A CN107832477B (en) 2017-12-01 2017-12-01 Method and system for creating database based on Excel table

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711249074.9A CN107832477B (en) 2017-12-01 2017-12-01 Method and system for creating database based on Excel table

Publications (2)

Publication Number Publication Date
CN107832477A true CN107832477A (en) 2018-03-23
CN107832477B CN107832477B (en) 2021-10-15

Family

ID=61647111

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711249074.9A Active CN107832477B (en) 2017-12-01 2017-12-01 Method and system for creating database based on Excel table

Country Status (1)

Country Link
CN (1) CN107832477B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114154469A (en) * 2021-12-02 2022-03-08 北京字跳网络技术有限公司 A document form processing method, device, device and medium
CN114722030A (en) * 2022-05-19 2022-07-08 江铃汽车股份有限公司 A Method of Establishing ECU Calibration Database Based on Excel VBA

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103744982A (en) * 2014-01-15 2014-04-23 北京神州普惠科技股份有限公司 Method for importing Excel data into database
US20140115433A1 (en) * 2012-10-23 2014-04-24 Daniel BERNERS Business management system and method
CN104123271A (en) * 2014-08-01 2014-10-29 贵阳供电局 Secondary design system for intelligent substation on basis of Excel
CN104932904A (en) * 2015-07-14 2015-09-23 福建农林大学 Configurable database programming mode aiming at intelligent smart home
US20170097923A1 (en) * 2015-10-01 2017-04-06 Sap Se Open fiori apps out of ms excel
CN106933835A (en) * 2015-12-29 2017-07-07 航天信息软件技术有限公司 The data lead-in method and system of a kind of compatibility parsing Excel file
CN107291674A (en) * 2017-06-12 2017-10-24 广东川田卫生用品有限公司 A kind of method that Excel list datas are converted to database format

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140115433A1 (en) * 2012-10-23 2014-04-24 Daniel BERNERS Business management system and method
CN103744982A (en) * 2014-01-15 2014-04-23 北京神州普惠科技股份有限公司 Method for importing Excel data into database
CN104123271A (en) * 2014-08-01 2014-10-29 贵阳供电局 Secondary design system for intelligent substation on basis of Excel
CN104932904A (en) * 2015-07-14 2015-09-23 福建农林大学 Configurable database programming mode aiming at intelligent smart home
US20170097923A1 (en) * 2015-10-01 2017-04-06 Sap Se Open fiori apps out of ms excel
CN106933835A (en) * 2015-12-29 2017-07-07 航天信息软件技术有限公司 The data lead-in method and system of a kind of compatibility parsing Excel file
CN107291674A (en) * 2017-06-12 2017-10-24 广东川田卫生用品有限公司 A kind of method that Excel list datas are converted to database format

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
蔡小艳等: "基于C#的Excel数据导入导出研究与实现", 《智能计算机与应用》 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114154469A (en) * 2021-12-02 2022-03-08 北京字跳网络技术有限公司 A document form processing method, device, device and medium
CN114154469B (en) * 2021-12-02 2024-12-31 北京字跳网络技术有限公司 A document table processing method, device, equipment and medium
CN114722030A (en) * 2022-05-19 2022-07-08 江铃汽车股份有限公司 A Method of Establishing ECU Calibration Database Based on Excel VBA

Also Published As

Publication number Publication date
CN107832477B (en) 2021-10-15

Similar Documents

Publication Publication Date Title
US20110225288A1 (en) Method and system for efficient storage and retrieval of analytics data
CN107656520A (en) CAN data analysis method and computer-readable recording medium
CN108388598A (en) Electronic device, date storage method and storage medium
CN104050248B (en) A kind of document storage system and storage method
CN112363984B (en) Method and device for generating in-vehicle security rule file
CN103092687B (en) A kind of application program management apparatus and method
CN107832477A (en) A kind of method and system that database is created based on Excel forms
CN114090574B (en) Redis Sentinel cluster deployment method, device, equipment and storage medium
CN102202087A (en) Method for identifying storage equipment and system thereof
CN103559184A (en) Form page display method and device
CN103595569A (en) Method for handling database storage of alarm information of network management system
CN107870980A (en) Electronic installation, billing data processing method and computer-readable storage medium
CN110460473B (en) Communication configuration method and device of configuration software and computer readable storage medium
CN109558453A (en) A kind of storage of block chain data networkization and move the method deposited
CN110018949B (en) Universal log management method and system based on IPMI protocol
CN119484427A (en) A message reorganization compression method, device, equipment and storage medium
CN109446167A (en) A kind of storage of daily record data, extracting method and device
CN115238204A (en) Data transmission method and device, electronic equipment and storage medium
CN109542678B (en) Method and device for regularly backing up key information of server
CN109117351A (en) A kind of front end displaying implementation method of Docker container cloud host and Dashboard
CN101668028A (en) Extendable system structure-based distributed system and application method thereof
CN110222169A (en) A kind of visualized data processing resolution system and its processing method
CN116089529A (en) Data synchronization method, device, electronic equipment and storage medium
CN109828719A (en) Magnetic disc control method, device and relevant device where commitLog file based on cloud monitoring
CN117851348A (en) Method for efficiently exporting import file by RBD snapshot

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: 20210526

Address after: 518000 1701-1708, 1801-1806, block D, building 1, Chuangzhi Yuncheng bid section 1, Liuxian Avenue, Xili community, Xili street, Nanshan District, Shenzhen City, Guangdong Province

Applicant after: Shenzhen Yunjia Intelligent Technology Co.,Ltd.

Address before: 518000 Yue Meilin Central Plaza, Kang Road, Futian District, Shenzhen City, Guangdong Province (North District), 2nd floor 204, 205, 206

Applicant before: SHENZHEN XTOOLTECH Co.,Ltd.

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant