CN101976236A - Method and device for importing floating row data through worksheet - Google Patents
Method and device for importing floating row data through worksheet Download PDFInfo
- Publication number
- CN101976236A CN101976236A CN 201010292028 CN201010292028A CN101976236A CN 101976236 A CN101976236 A CN 101976236A CN 201010292028 CN201010292028 CN 201010292028 CN 201010292028 A CN201010292028 A CN 201010292028A CN 101976236 A CN101976236 A CN 101976236A
- Authority
- CN
- China
- Prior art keywords
- unsteady
- worksheet
- judgment
- rule
- row
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Abstract
The invention provides a method for inputting floating row data. The method comprises the following steps of: (S102) reading a worksheet; (S104) judging whether the worksheet is exported from a system and confirming floating row judgment conditions to be used according to a judgment result; (S106) scanning the worksheet and generating a floating row according to the floating row judgment conditions; (S108) adding the generated floating row to a system template to form a system table; and (S110) importing the data of the floating row to the system table under the condition that the system table has the same format as the worksheet, or else, prompting on import failure. The invention can solve the problem on compiling floating row data added, modified or deleted by a user in Excel to a corresponding datasheet. The technical scheme of the invention can be used for accurately identifying the region of the floating row, analyzing the dimension members of the floating row and copying the corresponding data to the datasheet. The invention also provides a method for inputting the floating row data into the Excel.
Description
Technical field
The present invention relates to the data importing technology, and the method and apparatus that relates more specifically to import by worksheet the line data that floats.
Background technology
Before enterprise disposed infosystem, most of company information or data were stored in the thousands of Excel table, and this is undivided with the development of Excel and the use habit of the long-term formation of Chinese user.But the existence of a large amount of Excel tables has also formed a lot of problems, is difficult for sharing such as data, and data permission mechanism is unsound, adjusts difficulty etc. between table.
Certainly, disposing ripe infosystem can address these problems easily, and it can finish the function that nearly all Excel can provide for the user, and other function that provides Excel to finish.
So, how the used thousands of Excel of enterprise is shown to be entered in the infosystem to go, just become the enterprise customer, the problem that developer and enforcement personnel are concerned about the most.
Now, almost all infosystems all can provide the Excel import feature.The enforcement personnel make template to enterprise's table commonly used and set in advance in the infosystem, such as: employee's payroll.Because each employee's wage, subsidy project are all identical, just wage what can be because various factors and difference.Like this, when importing employee's payroll, only need scan all cells then, those data that need import are dosed the corresponding position of template, form a new payroll at last and be put in the system and get final product on template and the current payroll correspondence.
It is easily that the Excel of this fixed form imports, and also has a kind of Excel application mode in the actual application, and this application mode is a problem to be solved by this invention.
At first, explain two notions at this: dimension and dimension member.
(1) dimension is meant according to what and comes the organized data table.For example work out the sales revenue table, wish to work out according to stock and area, stock, area are exactly dimension so.Usually, the dimension of an infosystem all is that the overall situation is shared and unique.
(2) the dimension member is meant value concrete in a certain dimension.This dimension of stock for example, the member comprises contents such as colour TV, washing machine, refrigerator, these all are the dimension members.
In fact tables of data is exactly that several dimensions and dimension member thereof fill these dimensions and make up the form that pairing numeral is formed.Such as personnel's (dimension): Zhang San (dimension member), month (dimension): in January (dimension member), wage project (dimension): basic wage (dimension member)=2000, describe and be exactly: Zhang San's a monthly base pay is 2000 yuan.
In the fixed form, these dimensions and dimension member fix, the just data of variation, just Li Si's a monthly base pay is 2500 yuan, variation just 2000 yuan become 2500 yuan.
So, except this pattern of fixed form, also exist a kind of application model to be called unsteady line data.It is constant referring in template except dimension, and a part of dimension member also changes, and in use, people use for convenience, the dimension that all members are changed is put on the row of table, and fixing part is put into and lists, and has just formed present call: line data floats.Reality, ranks can be replaced in table, and being called the row that floats is a kind of custom.That is to say that for the row that float be identical.
Why existence has the template of going of floating is because but there is different dimension members in a lot of companies (perhaps department) when using certain identical dimension.For example: A company this dimension of working service project has desk, chair (seeing Table 1); And B company does not have desk, the such Maintenance Significant Items of chair, and Maintenance Significant Items (seeing Table 2) such as computer have only taken place.In this case, just the template that can not use the dimension member to fix is worked out, and can only use a kind of template (seeing Table 3) of unsteady row, and the user is in use except organized data, also to specify the dimension member of relevant dimension, the unsteady line data of establishment just.
Table 1A company establishment table
Table 2B company establishment table
The template that has the row that floats that provides in the infosystem, as shown in table 3:
Table 3 has the template of the row that floats
A, two companies of B (main body) except will filling and presenting data on the template, also will fill out the concrete member of Maintenance Significant Items when using the unsteady capable template shown in the table 3, are computer and mouse for A company, then are desk and chair etc. for B company.
Existing capability is user's on-line selection respective dimensions member, imports data by hand or by Excel then.But the problem of bringing is exactly under a lot of situation of the unsteady line data table that need work out as the user, a kind of disaster that Here it is.
Therefore, the method and apparatus that provides a kind of Excel typing to float line data is very important.Can greatly improve the efficient that the user uses budgeting system like this, also be a kind of embodiment of ease for use.Its appearance can be liberated the user, reduces mechanical typing, and its more time is put on the business processing.
Summary of the invention
In view of the above problems, one of purpose of the present invention provides the float method and apparatus of line data of a kind of Excel typing, its can solve the user is newly-increased on Excel, revise or the unsteady line data of deletion is organized into problem in the corresponding tables of data.Can accurately discern the row zone (one or more) of floating according to technical scheme of the present invention, resolve the dimension member's (one or more) of row that floats, and duplicate in the corresponding data to data table.
According to the method by the unsteady line data of worksheet importing of the present invention, comprising: step S102, read described worksheet; Step S104 judges whether described worksheet is the worksheet of deriving from system, and according to the definite unsteady capable Rule of judgment that will use of judged result; Step S106 scans described worksheet, generates the row that floats according to described unsteady capable Rule of judgment; Step S108 adds the described unsteady row that is generated on system template formation system form; And step S110, under the described system form situation identical with described work tableau format, to described system form, otherwise prompting imports failure with the data importing of described unsteady row.
In technique scheme, the row Rule of judgment that floats comprises the unsteady capable Rule of judgment and the user-defined unsteady capable Rule of judgment of described worksheet acquiescence, and wherein said user-defined unsteady capable Rule of judgment is recorded in the configuration information.
In technique scheme, preferably, in described step 104, be the worksheet that system derives if determine described worksheet, then determine to use the unsteady capable Rule of judgment of described worksheet acquiescence; And if determine that described worksheet is not the worksheet that system derives, and then determines to use described user-defined unsteady capable Rule of judgment.
In technique scheme, preferably, described step S108 is specially: scan described system template, delete original unsteady line item in the described system template, only keep delegation and serve as a mark, the unsteady row of record information; And scan described worksheet, add the row that floats according to the described unsteady capable information matches of described unsteady capable Rule of judgment and described system template.
In technique scheme, preferably, before described step S108, also comprise: back up described system template.
In technique scheme, preferably, described step S110 also comprises: after the data importing failure, current system template is returned to described system template.
In technique scheme, preferably, described worksheet is the EXCEL worksheet.
According to a further aspect in the invention, also provide a kind of device, having comprised by the unsteady line data of worksheet importing: reading unit, read described worksheet; The Rule of judgment determining unit judges whether described worksheet is the worksheet of deriving from system, and according to the definite unsteady capable Rule of judgment that will use of judged result; Unsteady row generation unit scans described worksheet, and the described unsteady capable Rule of judgment of determining according to described Rule of judgment determining unit generates unsteady going; System's form forms the unit, the described unsteady row that described unsteady capable generation unit generated is added to forming system's form on the system template; And the data importing unit, under the described system form situation identical with described work tableau format, to described system form, otherwise prompting imports failure with the data importing of described unsteady row.
In technique scheme, preferably, described unsteady capable Rule of judgment comprises the unsteady capable Rule of judgment and the user-defined unsteady capable Rule of judgment of described worksheet acquiescence, and wherein said user-defined unsteady capable Rule of judgment is recorded in the configuration information.
In technique scheme, preferably, described Rule of judgment determining unit is determining that described worksheet is under the situation of system's worksheet of deriving, and determines to use the unsteady capable Rule of judgment of described worksheet acquiescence; And determining that described worksheet is not under the situation of system's worksheet of deriving, and determines to use described user-defined unsteady capable Rule of judgment.
In technique scheme, preferably, described system form forms the described system template of unit scan, deletes original unsteady line item in the described system template, only keeps delegation and serves as a mark, the unsteady row of record information; And scan described worksheet, mate in described system template according to the described unsteady capable information of described unsteady capable Rule of judgment and described system template and add the row that floats.
In technique scheme, preferably, also comprise backup units, be used to back up described system template.
In technique scheme, preferably, also comprise recovery unit, be used for after the data importing failure, current system template being returned to the described system template of backup.
In technique scheme, preferably, described worksheet is the EXCEL worksheet.
According to technical scheme of the present invention, can solve the user in the difficulty that the unsteady row of typing is faced, especially in the infosystem implementation process, brought into play vital role, for the enforcement personnel have alleviated very big work load.
Description of drawings
Fig. 1 shows the process flow diagram that imports the method for the line data that floats by worksheet according to an embodiment of the invention.
Fig. 2 shows the block diagram that imports the device of the line data that floats by worksheet according to an embodiment of the invention.
Fig. 3 shows the process flow diagram that importing is according to still another embodiment of the invention floated and gone.
Fig. 4 shows the process flow diagram that generation is according to still another embodiment of the invention floated and gone.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with the drawings and specific embodiments.
Set forth a lot of details in the following description so that fully understand the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following public specific embodiment.
Fig. 1 shows the process flow diagram that imports the method for the line data that floats by worksheet according to an embodiment of the invention.As shown in Figure 1, the method by the unsteady line data of worksheet importing according to the present invention comprises: step S102, read described worksheet; Step S104 judges whether described worksheet is the worksheet of deriving from system, and according to the definite unsteady capable Rule of judgment that will use of judged result; Step S106 scans described worksheet, generates the row that floats according to described unsteady capable Rule of judgment; Step S108 adds the described unsteady row that is generated on system template formation system form; And step S110, under the described system form situation identical with described work tableau format, to described system form, otherwise prompting imports failure with the data importing of described unsteady row.
By technical scheme shown in Figure 1, can generate the row that floats by worksheet, and then import the line data that floats, significantly reduced the workload of the unsteady line data of typing.
In technique scheme, the row Rule of judgment that floats comprises the unsteady capable Rule of judgment and the user-defined unsteady capable Rule of judgment of described worksheet acquiescence, and wherein said user-defined unsteady capable Rule of judgment is recorded in the configuration information.
In technique scheme, preferably, in described step 104, be the worksheet that system derives if determine described worksheet, then determine to use the unsteady capable Rule of judgment of described worksheet acquiescence; And if determine that described worksheet is not the worksheet that system derives, and then determines to use described user-defined unsteady capable Rule of judgment.
In technique scheme, preferably, described step S108 is specially: scan described system template, delete original unsteady line item in the described system template, only keep delegation and serve as a mark, the unsteady row of record information; And scan described worksheet, add the row that floats according to the described unsteady capable information matches of described unsteady capable Rule of judgment and described system template.
In technique scheme, preferably, before described step S108, also comprise: back up described system template.
In technique scheme, preferably, described step S110 also comprises: after the data importing failure, current system template is returned to described system template.
In technique scheme, preferably, described worksheet is the EXCEL worksheet.
Fig. 2 shows the block diagram that imports the device of the line data that floats by worksheet according to an embodiment of the invention.As shown in Figure 2, this device comprises: reading unit 202, read described worksheet; Rule of judgment determining unit 204 judges whether described worksheet is the worksheet of deriving from system, and according to the definite unsteady capable Rule of judgment that will use of judged result; Unsteady row generation unit 206 scans described worksheet, and the described unsteady capable Rule of judgment of determining according to described Rule of judgment determining unit generates unsteady going; System's form forms unit 208, the described unsteady row that described unsteady capable generation unit generated is added to forming system's form on the system template; And data importing unit 210, under the described system form situation identical with described work tableau format, to described system form, otherwise prompting imports failure with the data importing of described unsteady row.
In technique scheme, preferably, described unsteady capable Rule of judgment comprises the unsteady capable Rule of judgment and the user-defined unsteady capable Rule of judgment of described worksheet acquiescence, and wherein said user-defined unsteady capable Rule of judgment is recorded in the configuration information.
In technique scheme, preferably, described Rule of judgment determining unit 204 is determining that described worksheet is under the situation of system's worksheet of deriving, and determines to use the unsteady capable Rule of judgment of described worksheet acquiescence; And determining that described worksheet is not under the situation of system's worksheet of deriving, and determines to use described user-defined unsteady capable Rule of judgment.
In technique scheme, preferably, described system form forms the described system template of unit 208 scannings, deletes original unsteady line item in the described system template, only keeps delegation and serves as a mark, the unsteady row of record information; And scan described worksheet, mate in described system template according to the described unsteady capable information of described unsteady capable Rule of judgment and described system template and add the row that floats.
In technique scheme, preferably, also comprise backup units 210, be used to back up described system template.
In technique scheme, preferably, also comprise recovery unit 212, be used for after the data importing failure, current system template being returned to the described system template of backup.
In technique scheme, preferably, described worksheet is the EXCEL worksheet.
According to technical scheme of the present invention, can solve the user in the difficulty that the unsteady row of typing is faced, especially in the infosystem implementation process, brought into play vital role, for the enforcement personnel have alleviated very big work load.
Fig. 3 shows the process flow diagram that importing is according to still another embodiment of the invention floated and gone.In this embodiment, be that example is described with the Excel worksheet.Main technical schemes comprises two parts, and one is the main flow that imports the row that floats, and another is reading and disposing of relevant configuration file.
Fig. 3 shows the process flow diagram that importing is according to still another embodiment of the invention floated and gone.As shown in Figure 3, in step 302, read the Excel document; In step 304, judge whether the Excel document that is read is the document of deriving from system, if then proceed to step 306, otherwise proceed to step 308; In step 306, be the document that system derives because determine the Excel document, the row Rule of judgment so the instantiation acquiescence is floated, just the unsteady capable Rule of judgment of using system acquiescence proceeds to step 310 then; In step 308, because determining the Excel document is not the document that system derives, so come the unsteady row of instantiation configuration condition according to configuration information, in this embodiment, self-defining unsteady capable Rule of judgment is kept in the configuration file, so come the unsteady row of instantiation configuration condition according to configuration file, just come instantiation according to self-defining unsteady capable Rule of judgment, proceed to step 310 then; In step 310, scanning Excel worksheet also generates the row that floats; In step 312, scanning Excel worksheet also imports data then.
Import the row main flow that floats and comprise two steps: instantiation is floated and is gone Rule of judgment (step 306 and step 308) and import the line data (step 312) that floats.To be described in detail below.
(1) the unsteady row of instantiation Rule of judgment
The row Rule of judgment that floats is such object, and it determines that by the attribute information of a series of key word-values (key-value) row at certain Excel cell place is the unsteady row that need carry out typing.Attribute information generally is the attribute that utilizes the Excel cell more common, as font, and background colour, information such as note literal, the capable zone of will floating identifies.
Be an Excel worksheet that needs typing below, as shown in table 4:
Table 4Excel worksheet
Table 5 is the templates in the budgeting system.
Table 5
Obviously, if want to allow system discern unsteady row in the Excel worksheet automatically, just must distinguish according to the characteristic that some of some cell on the row that floats is different from other cell.The unsteady row of the Excel worksheet in table 5 example has following feature:
(1) the cell background colour of the unsteady dimension of unsteady row is different with other dimensions;
(2) character string of beginning and end unit lattice has underscore.
By top two features, just can instantiation the row Rule of judgment that floats, and the effect of this conditional object to be system judge the main foundation of floating row and adding the relevant dimension member of floating.
The row Rule of judgment that floats has two kinds, and a kind of is the template that derives for system, and the peculiar condition of Excel, the characteristics of this condition are that attribute information is stored in the place that the user can't see, and can be stored in the extended attribute of cell generally speaking.But concrete condition is subjected to the influence of many-sided factor, such as the compatible context of current information system and Excel, Excel self version situation etc.Use corresponding algorithm as the case may be, for example: information is recorded on the SmartTag attribute that Excel provides, even is stored in the note that is hidden.
The Excel that using system is derived comes typing, and advantage is that information is detailed and accurate, is not easy to make mistakes; But the user must be at the enterprising edlin of the Excel of current derivation, and these conditions could be by correct instantiation.This application is adapted in the ripe infosystem usually, and user's off-line uses when working out new tables of data.
Also can utilize user-defined Rule of judgment when the Excel that goes is floated in a large amount of the having of importing, the characteristics of this condition are that the user needn't derive Excel again, only need the cell representative record of unsteady line data among the Excel in configuration file.Generally, the user has certain customary form and distinguishes unsteady line data, if do not have, simply changing when importing, form just can reach corresponding effects.At this, the processing scheme that reads and dispose of relevant configuration file is once described simply.Configuration file has write down the unsteady capable Rule of judgment of active user when using the Excel typing to float line data, just top said color, information such as font.The information that reads is easy in fact, utilize the current ripe technology that reads file just can accomplish, and the process of configuration file, all judgement attributes (as: color etc.) that the present invention will support are enumerated on the interface, the user is configured in the mode (as: color is chosen as redness etc.) of alternative condition, preserves then to get final product.
At the Excel worksheet in the previous example, Rule of judgment for example:
Attribute setting at the dimension of floating
Setting at background colour
Float area begins sign
Float area finishes sign
Font style is provided with
Such attribute-value has a lot, and system is all sought institute's attribute that might relate to one time at instantiation Rule of judgment object Shi Hui, if existence then is set in the instance object.Generally speaking, the user is provided with the use habit of 2-3 item oneself, as: font, background colour etc. get final product.
For the Excel table of deriving from system, unsteady line identifier has been exported among the Excel, after judging through system, according to compatible context, it has been recorded in the hiding note of unsteady capable dimension, obtains the unsteady capable template that system derives, and is as shown in table 6 below.
The unsteady capable template that table 6 system derives
Information gap in information in the note and the top example is few, and difference may be that the information that system derives has a lot of redundant informations, in order that other purposes later on.
(2) import the line data that floats
The row that generate to float is the key of whole unsteady capable typing, but the Rule of judgment of (1) has been arranged, comparatively speaking, complexity will be low many.In order to reach unified effect, increase, modification, the deletion of the typing of unsteady row all use the modes that elder generation deletes, the back increases to carry out, and the purpose of doing like this is to have guaranteed that the data of typing are up-to-date, if there is not new data line, can play the effect of deletion too.
The flow process that generating floats goes as shown in Figure 4.
In step 402, dubbing system template model_clone, the purpose of dubbing system template is in order to be thought data and the state before can returning in the failure by system in whole importing.
In step 404, the scanning system template, the unsteady row of record information Var_Info: in the original template, each row zone of floating has only delegation, and without any the dimension information about firms.But,, then need original unsteady row deletion is only stayed delegation with marking if template was modified.Keep the descriptor of certain row that floats on the template with an object, comprising: initial row index, the column index and the unsteady dimensional information of the dimension of floating.Has a more than Var_Info on the template.
In step 406, scanning Excel worksheet, add the row that floats: this step is the core of whole flow process, also is to concern the key that can whole importing be finished smoothly.In this step, comprising:
1) scans the Excel worksheet, and judge that according to Rule of judgment which has float among the Excel goes the zone and write down the information of going of floating.Generally speaking, the reliability of the initial row in the Rule of judgment and the unsteady capable dimensional characteristics of end line is stronger, is used some other condition, can reach certain effect.
2) the unsteady line item information of contrast Excel table and template mainly is the number that contrasts the row zone of floating, and whether each to go the number of the unsteady dimension that comprised identical if floating.If these main region numbers do not match, then declaration imports failure.
3) add the row that floats, this also is the part of most critical.According to the unsteady line item of Excel worksheet and template, add the row that floats from top to bottom correspondingly.It should be noted that in the unsteady line item of original template all be the capable index of the unsteady start of line of record, after the row that floats was added, the initial row index of back can be inaccurate, so, need write down this skew by an external variable offset.Specific algorithm is as follows:
Offset=varlineCount (the unsteady capable number of having added)+offset
NextStartIndex (the next start of line line index of floating)=nextStartIndex+offset
Like this, after the unsteady row of front was successfully added, the initial row index in next unsteady row zone can increase along with the number of the row interpolation of floating.
Step 408 and 410 or step 408 and 412 in, carry out to import data.At first whether template and the Excel worksheet overall format after step 408 judge to add is floated row mates, and such as always line number and columns, if identical then mean and can import data, proceeds to step 410.The method that imports data is very simple, imports corresponding cell data according to the ranks coordinate; If the two form has deviation, then proceed to step 412, return to the template state of backup at first, and can export importing failure daily record.
Describe in detail above according to embodiments of the invention,, can be clear that according to technical scheme of the present invention and can accurately discern the row zone of floating, resolve the dimension member of row that floats, and duplicate in the corresponding data to data table by top description.Technical scheme of the present invention has solved the user in the difficulty that the unsteady row of typing is faced, and has especially brought into play vital role in the infosystem implementation process, for the enforcement personnel have alleviated very big work load.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (14)
1. the method by the unsteady line data of worksheet importing is characterized in that, comprising:
Step S102 reads described worksheet;
Step S104 judges whether described worksheet is the worksheet of deriving from system, and according to the definite unsteady capable Rule of judgment that will use of judged result;
Step S106 scans described worksheet, generates the row that floats according to described unsteady capable Rule of judgment;
Step S108 adds the described unsteady row that is generated on system template formation system form; And
Step S110, under the described system form situation identical with described work tableau format, to described system form, otherwise prompting imports failure with the data importing of described unsteady row.
2. method according to claim 1, it is characterized in that, described unsteady capable Rule of judgment comprises the unsteady capable Rule of judgment and the user-defined unsteady capable Rule of judgment of described worksheet acquiescence, and wherein said user-defined unsteady capable Rule of judgment is recorded in the configuration information.
3. method according to claim 2 is characterized in that, in described step 104, is the worksheet that system derives if determine described worksheet, then determines to use the unsteady capable Rule of judgment of described worksheet acquiescence; And if determine that described worksheet is not the worksheet that system derives, and then determines to use described user-defined unsteady capable Rule of judgment.
4. according to each described method in the claim 1 to 3, it is characterized in that described step S108 is specially:
Scan described system template, delete original unsteady line item in the described system template, only keep delegation and serve as a mark, the unsteady row of record information; And
Scan described worksheet, add the row that floats according to the described unsteady capable information matches of described unsteady capable Rule of judgment and described system template.
5. method according to claim 4 is characterized in that, also comprises before described step S108: back up described system template.
6. method according to claim 5 is characterized in that, described step S110 also comprises: after the data importing failure, current system template is returned to described system template.
7. according to each described method in the claim 1 to 3, it is characterized in that described worksheet is the EXCEL worksheet.
8. the device by the unsteady line data of worksheet importing is characterized in that, comprising:
Reading unit reads described worksheet;
The Rule of judgment determining unit judges whether described worksheet is the worksheet of deriving from system, and according to the definite unsteady capable Rule of judgment that will use of judged result;
Unsteady row generation unit scans described worksheet, and the described unsteady capable Rule of judgment of determining according to described Rule of judgment determining unit generates unsteady going;
System's form forms the unit, the described unsteady row that described unsteady capable generation unit generated is added to forming system's form on the system template; And
The data importing unit, under the described system form situation identical with described work tableau format, to described system form, otherwise prompting imports failure with the data importing of described unsteady row.
9. device according to claim 8, it is characterized in that, described unsteady capable Rule of judgment comprises the unsteady capable Rule of judgment and the user-defined unsteady capable Rule of judgment of described worksheet acquiescence, and wherein said user-defined unsteady capable Rule of judgment is recorded in the configuration information.
10. device according to claim 9 is characterized in that, described Rule of judgment determining unit is determining that described worksheet is under the situation of system's worksheet of deriving, and determines to use the unsteady capable Rule of judgment of described worksheet acquiescence; And determining that described worksheet is not under the situation of system's worksheet of deriving, and determines to use described user-defined unsteady capable Rule of judgment.
11. each described device in 10 is characterized in that according to Claim 8, described system form forms the described system template of unit scan, deletes original unsteady line item in the described system template, only keeps delegation and serves as a mark, the record row information of floating; And scan described worksheet, mate in described system template according to the described unsteady capable information of described unsteady capable Rule of judgment and described system template and add the row that floats.
12. device according to claim 11 is characterized in that, also comprises backup units, is used to back up described system template.
13. device according to claim 12 is characterized in that, also comprises recovery unit, is used for current system template being returned to the described system template of backup after the data importing failure.
14. each described device in 10 is characterized in that described worksheet is the EXCEL worksheet according to Claim 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102920289A CN101976236B (en) | 2010-09-26 | 2010-09-26 | Method and device for importing floating row data through worksheet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102920289A CN101976236B (en) | 2010-09-26 | 2010-09-26 | Method and device for importing floating row data through worksheet |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101976236A true CN101976236A (en) | 2011-02-16 |
| CN101976236B CN101976236B (en) | 2012-01-18 |
Family
ID=43576122
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102920289A Active CN101976236B (en) | 2010-09-26 | 2010-09-26 | Method and device for importing floating row data through worksheet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101976236B (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102945160A (en) * | 2012-10-24 | 2013-02-27 | 浪潮集团山东通用软件有限公司 | General method for importing Excel data independent of rule configurations |
| CN105138563A (en) * | 2015-07-23 | 2015-12-09 | 浪潮电子信息产业股份有限公司 | Method for rapidly extracting key information of test log |
| CN105824940A (en) * | 2016-03-17 | 2016-08-03 | 深圳市永兴元科技有限公司 | Method and device for importing data |
| CN106469215A (en) * | 2016-09-06 | 2017-03-01 | 广州视睿电子科技有限公司 | Data lead-in method based on page end and system |
| CN106503024A (en) * | 2015-09-08 | 2017-03-15 | 北京国双科技有限公司 | Log information processing method and device |
| CN107742190A (en) * | 2017-11-16 | 2018-02-27 | 郑州云海信息技术有限公司 | The method and system that a kind of ERP system master data batch imports |
| CN108984494A (en) * | 2017-06-04 | 2018-12-11 | 深圳市北斗智研科技有限公司 | A kind of Excel software data integration method |
| CN109491742A (en) * | 2018-10-31 | 2019-03-19 | 天津字节跳动科技有限公司 | Page tabular rendering method and device |
| CN112860245A (en) * | 2021-03-10 | 2021-05-28 | 厦门极致互动网络技术股份有限公司 | Batch remarking method based on Jira system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20010016855A1 (en) * | 2000-02-18 | 2001-08-23 | Yuko Hiroshige | Multi-dimensional table data management unit and recording medium storing therein a spreadsheet program |
| CN1343947A (en) * | 2000-09-19 | 2002-04-10 | 北京新华国信科贸有限责任公司 | Method for processing very large capacity of text information data |
| CN101211360A (en) * | 2006-12-28 | 2008-07-02 | 鸿富锦精密工业（深圳）有限公司 | System and method for processing a plurality of data form of report forms data source |
| CN101419628A (en) * | 2008-12-03 | 2009-04-29 | 浪潮集团山东通用软件有限公司 | Data general-purpose leading-in method based on excel file format |
-
2010
- 2010-09-26 CN CN2010102920289A patent/CN101976236B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20010016855A1 (en) * | 2000-02-18 | 2001-08-23 | Yuko Hiroshige | Multi-dimensional table data management unit and recording medium storing therein a spreadsheet program |
| CN1343947A (en) * | 2000-09-19 | 2002-04-10 | 北京新华国信科贸有限责任公司 | Method for processing very large capacity of text information data |
| CN101211360A (en) * | 2006-12-28 | 2008-07-02 | 鸿富锦精密工业（深圳）有限公司 | System and method for processing a plurality of data form of report forms data source |
| CN101419628A (en) * | 2008-12-03 | 2009-04-29 | 浪潮集团山东通用软件有限公司 | Data general-purpose leading-in method based on excel file format |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102945160A (en) * | 2012-10-24 | 2013-02-27 | 浪潮集团山东通用软件有限公司 | General method for importing Excel data independent of rule configurations |
| CN105138563A (en) * | 2015-07-23 | 2015-12-09 | 浪潮电子信息产业股份有限公司 | Method for rapidly extracting key information of test log |
| CN106503024A (en) * | 2015-09-08 | 2017-03-15 | 北京国双科技有限公司 | Log information processing method and device |
| CN105824940A (en) * | 2016-03-17 | 2016-08-03 | 深圳市永兴元科技有限公司 | Method and device for importing data |
| CN106469215A (en) * | 2016-09-06 | 2017-03-01 | 广州视睿电子科技有限公司 | Data lead-in method based on page end and system |
| CN108984494A (en) * | 2017-06-04 | 2018-12-11 | 深圳市北斗智研科技有限公司 | A kind of Excel software data integration method |
| CN107742190A (en) * | 2017-11-16 | 2018-02-27 | 郑州云海信息技术有限公司 | The method and system that a kind of ERP system master data batch imports |
| CN109491742A (en) * | 2018-10-31 | 2019-03-19 | 天津字节跳动科技有限公司 | Page tabular rendering method and device |
| CN112860245A (en) * | 2021-03-10 | 2021-05-28 | 厦门极致互动网络技术股份有限公司 | Batch remarking method based on Jira system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101976236B (en) | 2012-01-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101976236B (en) | Method and device for importing floating row data through worksheet | |
| US11210456B2 (en) | Method relating to preparation of a report | |
| CN106886418B (en) | HTML interface control label | |
| CN101308490B (en) | Dynamic report generation method and platform | |
| CN1232913C (en) | Computerized system and method for optimally controlling storage and transfer of computer programs on a computer network | |
| US7269605B1 (en) | Personal information manager data synchronization and augmentation | |
| CN110717320A (en) | Form/report designer and method suitable for multiple platforms and information management system | |
| CN107807954B (en) | Visual modeling multidimensional analysis system and method thereof | |
| CN103019693A (en) | System and method for generating user interface | |
| CN111428212A (en) | Data visualization system and data authority management method thereof | |
| CN102110142A (en) | Method for dynamically expanding personnel transaction in human resource management information system | |
| CN107679417A (en) | A kind of method and system of user's operating right management | |
| CN111881662A (en) | Form generation method, device, processing equipment and storage medium | |
| CN104182225A (en) | General mobile information system adaptation method and device | |
| CN104182226A (en) | General mobile information system adaptation method and device | |
| JP4959501B2 (en) | Information processing apparatus, information processing method, and program | |
| CN104199648A (en) | General mobile information system adaptation method and device | |
| CN113254835B (en) | Intelligent scenic spot server architecture and data processing method thereof | |
| KR20200091560A (en) | Method and system extracting terms within documention for automating customs declaration process | |
| JPWO2011129144A1 (en) | ELECTRONIC DISTRIBUTION METHOD, ELECTRONIC DISTRIBUTION DEVICE, AND ELECTRONIC DISTRIBUTION PROGRAM | |
| JP2022097971A (en) | Application document preparation support system, application document preparation support method and application document preparation support program | |
| CN111985015A (en) | System and method for automatically generating BOM (Bill of Material) by using VBA (visual basic Access) function | |
| Lambert et al. | Microsoft Access 2013 Step by Step | |
| Preedy et al. | OR and the boardroom for the 90s | |
| JP7440979B1 (en) | File sorting system, file sorting method, and file sorting program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee |
Owner name: YONYOU NETWORK TECHNOLOGY CO., LTD. Free format text: FORMER NAME: UFIDA SOFTWARE CO., LTD. |
|
| CP03 | Change of name, title or address |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Patentee after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Patentee before: UFIDA Software Co., Ltd. |