CN107562949A - The method for realizing consolidated accounts Excel template write into Databasce - Google Patents
The method for realizing consolidated accounts Excel template write into Databasce Download PDFInfo
- Publication number
- CN107562949A CN107562949A CN201710889254.7A CN201710889254A CN107562949A CN 107562949 A CN107562949 A CN 107562949A CN 201710889254 A CN201710889254 A CN 201710889254A CN 107562949 A CN107562949 A CN 107562949A
- Authority
- CN
- China
- Prior art keywords
- database
- row
- data
- gauge outfit
- excel
- 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
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Document Processing Apparatus (AREA)
Abstract
The present invention relates to the application of XBRL language, it discloses a kind of method for realizing consolidated accounts Excel template write into Databasce, realize that XBRL criteria for classifications establish mapping relations automatically with consolidated accounts dimension, so as to reach the purpose of the financial report in Dynamic Display consolidated accounts on project interface.This method includes：A. the three dimensionality excel templates of consolidated accounts ten are parsed, the list data in excel templates are categorized into gauge outfit, table row and list data content three parts, and be respectively put into gauge outfit object set, table row object set, list data content object set；B. the gauge outfit object dress of excel parsings is changed into database gauge outfit object, table row object dress changes database row object into, and list data object fills list data coordinates object, the three dimensionality formula object of list data ten for changing database into；C. database gauge outfit object set, database row object set, the set of database data coordinates object, database data dimension formula object set are respectively written into the corresponding database table of database.
Description
Technical field
The present invention relates to the application of XBRL language, and in particular to one kind realizes consolidated accounts Excel template write into Databasce
Method.
Background technology
XBRL (Extensible Business Reporting Language) is one and is used for the language that business information carries out electron exchange, contributes to business
Establishment, analysis and the exchange of industry information.XBRL technological frames are divided into XBRL specifications, XBRL criteria for classifications and XBRL instance documents three
Part.Wherein, criteria for classification is divided into schema file and link library file, and link library file generally includes to define chained library, row report
Chained library, calculating linking storehouse, label chained library, reference link storehouse and role's label chained library.Schema file defines example text
True concept in shelves, the relation between chained library document definition concept.With XBRL gradual popularization, possessing a set of can efficiently locate
The system for managing XBRL files is particularly important.
Consolidated accounts is the form of parent company's establishment in group company, after it collects the accounting statement of subsidiary, is supported
Disappear connected transaction part, draws the report data in whole group's angle.It may also be said that formed with parent company and its subsidiary
Accounting subject, based on indivedual financial statements that holding company and its subsidiary individually work out, by the anti-of holding company's establishment
The group reflected after offsetting group internal contact accounts merges the financial statement of financial situation and management performance, and consolidated accounts includes closing
And balance sheet, consolidated income statement, the consolidated statement of cash flows or merging statement of change in financial position etc..
At present, how by consolidated accounts template write into Databasce, with establish XBRL criteria for classifications and consolidated accounts dimension it
Between mapping relations be to realize the key of efficient process XBRL files, and a study hotspot and difficulties.
The content of the invention
The technical problems to be solved by the invention are：It is proposed a kind of consolidated accounts Excel template write into Databasce realized
Method, realize that XBRL criteria for classifications establish mapping relations automatically with consolidated accounts dimension, so as to reach dynamic on project interface
Show the purpose of the financial report in consolidated accounts.
The technical solution adopted by the present invention is as follows：
The method for realizing consolidated accounts Excel template write into Databasce, comprises the following steps：
A. the three dimensionality excel templates of consolidated accounts ten are parsed, the list data in excel templates is categorized into gauge outfit, table
Row and list data content three parts, and it is respectively put into gauge outfit object set, table row object set, list data content object
In set；
B. the gauge outfit object dress of excel parsings is changed into database gauge outfit object, table row object dress changes database row pair into
As list data object fills list data coordinates object, the three dimensionality formula object of list data ten for changing database into；
C. database gauge outfit object set, database row object set, the set of database data coordinates object, database
Data dimension formula object set is respectively written into the corresponding database table of database.
Optimize as further, in step a, pass through POI technologies and parse the three dimensionality excel templates of consolidated accounts ten.
Optimize as further, in step c, by way of batch inserts, database gauge outfit object set, database
Row object set, the set of database data coordinates object, database data dimension formula object set are respectively written into database phase
In the database table answered.
As further optimization, step a is specifically included：
The gauge outfit of each form starts the title of first row in a1, the acquisition three dimensionality excel templates of consolidated accounts ten；
A2, the title of first row started to the form in the three dimensionality excel templates of consolidated accounts ten by the gauge outfit of acquisition
Parsed, the gauge outfit data of the form are read by the title of first row, and be fitted into gauge outfit object, then by sorting,
List coordinate is produced, gauge outfit data are encapsulated into data gauge outfit list object set；
A3, the table row data message for reading by the title of first row the form, and be fitted into table row object, then pass through
The row coordinate sequence of acquirement, produces row table coordinate, table row data is encapsulated into data table row object set；
A4, the title reading list data information by first row, by row, column coordinate calculate the seat of data item
Mark, and data item coordinate is encapsulated into database data item object set；
A5, the value for reading each data item, classify to value, type corresponding to the value setting corresponding to, and data item
Coordinate be encapsulated into database data dimension formula object set.
Optimize as further, in step a5, the type that described pair of value is classified includes：
The three dimensionality formula of consolidated accounts ten, excel sum formulas, excel addition subtraction multiplication and divisions formula, excel condition formulas, often
Measure, be other.
The beneficial effects of the invention are as follows：After consolidated accounts excel templates are put in storage, displaying, which merges, on interface reports
The financial report of table is just directly read from database, be its speed faster, it is more efficient；By after storage with regard to that can be used for three
Ten dimensions carry out Auto-matching with XBRL criteria for classifications element, so as to reach the effect of automatic mapping.
Embodiment
The present invention is directed to propose a kind of method for realizing consolidated accounts Excel template write into Databasce, realizes that XBRL classifies
Standard establishes mapping relations automatically with consolidated accounts dimension, so as to reach the wealth in Dynamic Display consolidated accounts on project interface
The purpose of business report.
In specific implementation, the method for realizing consolidated accounts Excel template write into Databasce in the present invention includes following
Step：
1st, the gauge outfit for obtaining each form in the three dimensionality excel templates of consolidated accounts ten starts the title of first row, or
Agree to that modification excel template gauge outfits start entitled " project " of first row.
2nd, the title for starting first row by the gauge outfit of acquisition is entered to the form in the three dimensionality excel templates of consolidated accounts ten
Row parsing, the gauge outfit data of the form are read by the title of first row, and are fitted into gauge outfit object, raw then by sequence
List coordinate is produced, gauge outfit data are encapsulated into data gauge outfit list object set.
3rd, the table row data message of the form is read by the title of first row, and is fitted into table row object, is then passed through
The row coordinate sequence of acquirement, produces row table coordinate, table row data is encapsulated into data table row object set
4th, list data information is read by the title of first row, by row, column coordinate calculate the coordinate of data item,
And data item coordinate is encapsulated into database data item object set.
5th, the value of each data item is read, value is classified, type has：The three dimensionality formula of consolidated accounts ten, excel are asked
With formula, excel addition subtraction multiplication and divisions formula, excel condition formulas, constant (fixed value), other.Corresponding to value is set corresponding to
Type, and the coordinate of data item are encapsulated into database data dimension formula object set.
6th, the gauge outfit object dress of excel parsings is changed into database gauge outfit object, table row object dress changes database row pair into
As list data object fills list data coordinates object, the three dimensionality formula object of list data ten for changing database into.
7th, database gauge outfit object set, the set of database row table object, the set of database data coordinates object, data
Storehouse data dimension formula object set is write in corresponding data table by way of batch inserts respectively.
Claims (5)
1. realize the method for consolidated accounts Excel template write into Databasce, it is characterised in that comprise the following steps：
A. parse the three dimensionality excel templates of consolidated accounts ten, the list data in excel templates be categorized into gauge outfit, table row and
List data content three parts, and it is respectively put into gauge outfit object set, table row object set, list data content object set
In；
B. the gauge outfit object dress of excel parsings is changed into database gauge outfit object, table row object dress changes database row object, table into
Lattice data object fills list data coordinates object, the three dimensionality formula object of list data ten for changing database into；
C. database gauge outfit object set, database row object set, the set of database data coordinates object, database data
Dimension formula object set is respectively written into the corresponding database table of database.
2. the method as claimed in claim 1 for realizing consolidated accounts Excel template write into Databasce, it is characterised in that step a
In, the three dimensionality excel templates of consolidated accounts ten are parsed by POI technologies.
3. the method as claimed in claim 1 for realizing consolidated accounts Excel template write into Databasce, it is characterised in that step c
In, by way of batch inserts, database gauge outfit object set, database row object set, database data coordinate pair
As set, database data dimension formula object set are respectively written into the corresponding database table of database.
4. the method as claimed in claim 1 for realizing consolidated accounts Excel template write into Databasce, it is characterised in that step a
Specifically include：
The gauge outfit of each form starts the title of first row in a1, the acquisition three dimensionality excel templates of consolidated accounts ten；
A2, the title for starting by the gauge outfit of acquisition first row are carried out to the form in the three dimensionality excel templates of consolidated accounts ten
Parsing, the gauge outfit data of the form are read by the title of first row, and are fitted into gauge outfit object, then pass through sequence, production
List coordinate, gauge outfit data are encapsulated into data gauge outfit list object set；
A3, the table row data message for reading by the title of first row the form, and be fitted into table row object, then pass through acquirement
Row coordinate sequence, produce row table coordinate, table row data are encapsulated into data table row object set；
A4, the title reading list data information by first row, by row, column coordinate calculate the coordinate of data item, and
Data item coordinate is encapsulated into database data item object set；
A5, the value for reading each data item, classify to value, type corresponding to the value setting corresponding to, and the seat of data item
Mark is encapsulated into database data dimension formula object set.
5. the method as claimed in claim 4 for realizing consolidated accounts Excel template write into Databasce, it is characterised in that step
In a5, the type that described pair of value is classified includes：
The three dimensionality formula of consolidated accounts ten, excel sum formulas, excel addition subtraction multiplication and divisions formula, excel condition formulas, constant,
It is other.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710889254.7A CN107562949B (en) | 2017-09-20 | 2017-09-20 | Method for writing merged report Excel template into database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710889254.7A CN107562949B (en) | 2017-09-20 | 2017-09-20 | Method for writing merged report Excel template into database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107562949A true CN107562949A (en) | 2018-01-09 |
| CN107562949B CN107562949B (en) | 2020-11-03 |
Family
ID=60983364
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710889254.7A Expired - Fee Related CN107562949B (en) | 2017-09-20 | 2017-09-20 | Method for writing merged report Excel template into database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107562949B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109933771A (en) * | 2019-03-22 | 2019-06-25 | 广州市玄武无线科技股份有限公司 | A kind of automatic merging method of report, device, equipment and storage medium |
| CN111046632A (en) * | 2019-11-29 | 2020-04-21 | 智器云南京信息科技有限公司 | Data extraction and conversion method, system, storage medium and electronic equipment |
| CN113779941A (en) * | 2021-09-08 | 2021-12-10 | 无锡艾布斯智能科技发展有限公司 | Configurable dynamic report generation device, system and method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070050698A1 (en) * | 2005-08-29 | 2007-03-01 | Stefan Chopin | Add-in tool and method for rendering financial data into spreadsheet compliant format |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
| CN105320742A (en) * | 2015-09-24 | 2016-02-10 | 四川长虹电器股份有限公司 | Method for mapping subject information of traditional financial statement to XBRL classification standard format |
| CN106933835A (en) * | 2015-12-29 | 2017-07-07 | 航天信息软件技术有限公司 | The data lead-in method and system of a kind of compatibility parsing Excel file |
-
2017
- 2017-09-20 CN CN201710889254.7A patent/CN107562949B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070050698A1 (en) * | 2005-08-29 | 2007-03-01 | Stefan Chopin | Add-in tool and method for rendering financial data into spreadsheet compliant format |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
| CN105320742A (en) * | 2015-09-24 | 2016-02-10 | 四川长虹电器股份有限公司 | Method for mapping subject information of traditional financial statement to XBRL classification standard format |
| CN106933835A (en) * | 2015-12-29 | 2017-07-07 | 航天信息软件技术有限公司 | The data lead-in method and system of a kind of compatibility parsing Excel file |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109933771A (en) * | 2019-03-22 | 2019-06-25 | 广州市玄武无线科技股份有限公司 | A kind of automatic merging method of report, device, equipment and storage medium |
| CN109933771B (en) * | 2019-03-22 | 2023-04-14 | 广州市玄武无线科技股份有限公司 | Report automatic merging method, device, equipment and storage medium |
| CN111046632A (en) * | 2019-11-29 | 2020-04-21 | 智器云南京信息科技有限公司 | Data extraction and conversion method, system, storage medium and electronic equipment |
| CN111046632B (en) * | 2019-11-29 | 2023-11-10 | 智器云南京信息科技有限公司 | Data extraction and conversion method, system, storage medium and electronic equipment |
| CN113779941A (en) * | 2021-09-08 | 2021-12-10 | 无锡艾布斯智能科技发展有限公司 | Configurable dynamic report generation device, system and method |
| CN113779941B (en) * | 2021-09-08 | 2023-07-25 | 无锡艾布斯智能科技发展有限公司 | Configurable dynamic report generation device, system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107562949B (en) | 2020-11-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104731941B (en) | method for capturing data from unstructured financial report based on XBR L technology | |
| CN106202536B (en) | Global metadata standardized platform system and its construction method based on XBRL | |
| US20120303645A1 (en) | System and method for extraction of structured data from arbitrarily structured composite data | |
| US11055307B2 (en) | Automatic modeling method and classifier for OLAP data model | |
| CN101308490A (en) | Dynamic report generation method and platform | |
| CN102214243A (en) | Version management system for x extensible business reporting language (XBRL) classification standard | |
| CN107562949A (en) | The method for realizing consolidated accounts Excel template write into Databasce | |
| CN113902535A (en) | Automatic accounting method and system for consumption tax | |
| CN110516221A (en) | Extract method, equipment and the storage medium of chart data in PDF document | |
| CN101140562A (en) | Method for realizing user-defined report forms | |
| CN106547841A (en) | A kind of data automatic switching method of Excel XML mappings | |
| CN105893053B (en) | report generation method based on Excel annotation | |
| CN105205038A (en) | Complete material list table generation method and device | |
| CN106372044A (en) | Method for generating typed dimension XBRL (Extensible Business Reporting Language) report based on report form | |
| CN110851667A (en) | Integrated analysis method and tool for multi-source large data | |
| CN111950921A (en) | Multi-person collaborative review method based on offline networking environment | |
| CN102866986A (en) | Document format conversion system | |
| CN107168937A (en) | Financial cloud accounting element particle and assemble method based on XBRL | |
| CN105589897B (en) | Report methods of exhibiting and system based on XBRL | |
| WO2019242125A1 (en) | Method and apparatus for acquiring upstream and downstream relationships between companies, terminal device and medium | |
| CN102819542A (en) | Method and device for presenting instance documents | |
| CN110378569A (en) | Industrial relations chain building method, apparatus, equipment and storage medium | |
| WO2005076900A2 (en) | Data and metadata linking form mechanism and method | |
| CN103473316A (en) | Data column dynamically displaying method and device | |
| CN105912723A (en) | Storage method of custom field |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20201103 Termination date: 20210920 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |