CN101231665A - Apparatus and method for educing data into Excel files from database - Google Patents

Apparatus and method for educing data into Excel files from database Download PDF

Info

Publication number
CN101231665A
CN101231665A CNA2008100579150A CN200810057915A CN101231665A CN 101231665 A CN101231665 A CN 101231665A CN A2008100579150 A CNA2008100579150 A CN A2008100579150A CN 200810057915 A CN200810057915 A CN 200810057915A CN 101231665 A CN101231665 A CN 101231665A
Authority
CN
China
Prior art keywords
data
text
excel file
excel
database
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.)
Pending
Application number
CNA2008100579150A
Other languages
Chinese (zh)
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.)
ZTE Corp
Original Assignee
ZTE Corp
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 ZTE Corp filed Critical ZTE Corp
Priority to CNA2008100579150A priority Critical patent/CN101231665A/en
Publication of CN101231665A publication Critical patent/CN101231665A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a device which can export the data in a database into an Excel file, as well as a method thereof, wherein, the method comprises the following steps that: step one, the data of the database are exported into a text file; step two, the data of the text file are read according to the data quantity set each time, format conversion is carried out to the data of the text file read each time, and the generated Excel file is written into a disk; step three, restoration is carried out to the Excel file, and a file which is used to read and open the Excel program is generated. The invention greatly reduces the memory occupying when the data of the database are converted into the Excel file, thereby greatly improving the conversion efficiency compared with the prior art.

Description

Data in the database are exported to the devices and methods therefor of Excel file
Technical field
The present invention relates to data processing technique, particularly relate to a kind of devices and methods therefor that data in the database is exported to the Excel file.
Background technology
Society of today belongs to the epoch of information explosion, all producing a large amount of information every day, these information major parts all leave in the database, yet the information that leaves in the database belongs to raw information, can not from these mixed and disorderly raw informations, obtain Useful Information easily, just need instrument that these raw informations are organized this moment so, they are shown, and the instrument of relatively using always is exactly routine office work softwares such as Excel in mode more intuitively.
At present, (such as Poi, Jxl) can manipulate (reading and writing) Excel file directly, but these softwares are limited to the composition form of Excel file, their shortcoming is all arranged, that is exactly when data volume is big, utmost point consumption internal memory several softwares of increasing income on the network.Below by the composition form of understanding the Excel file, the reason of utmost point consumption internal memory is described.
The Excel file is based on BIFF (Binary Interchange File Format, binary file format) form.In the binary storage of BIFF formatted file data, low level 8 bytes leave the low level of address in, high-order 8 bytes leave the high position of address in, therefore when checking the Excel file with the sexadecimal editing machine, for a complete double byte, its demonstration as: 09 08, its hexadecimal value should be 0x0809 so.The piecemeal of whole Excel file is as shown in table 1.
Table 1
Excel Header district Account for 1block (512 bytes), fixed size
The WorkBook district Minimum accounts for 8 block (4096 bytes)
Summary Information district Account for 8 block (4096 bytes), fixed size
Document Summary Information district Account for 8 block (4096 bytes), fixed size
The RootEntry district Account for 1 block (512 bytes), fixed size
In the Excel file block table shown in the table 1:
1) the Excel file comprises a WorkBook, and a WorkBook can comprise one or more WorkSheet.
2) in the data structure of Excel file, every 512bytes is called a block (piece), and the Excel file is made up of an integer block, therefore the size of Excel file also is 512 multiple, and to each data b lock, must have a pointer (blockPointer) to indicate its position hereof, these blockPointer are beginning or afterbodys of leaving concentratedly at the Excel file.The block that deposits blockPointer is pointer block (pointerBlock), because the number of pointer block piece may be a lot, so the Excel file has adopted the mode of two-level pointer, promptly also need the storage of one piece of data district to point to the pointer (pointerBlockPointer of pointer block, second level pointer), the block that deposits second level pointer is called expansion pointer block (extendPointerBlock).
3) every complete data are to be embodied by sign, length and a data content in the Excel file, be called a record body (Record), as certain bar data presentation 09 08 02 00 00 00,09 08 signs of representing this partial data so, 02 00 represent the length of back content, and 00 00 be actual content-data.
4) the Excel file must have an Excel Header district, this district accounts for 1 block size, is placed on the beginning position of Excel file, and these district's main contents have: the block number of whole Excel file, and 1 09 pointerBlockPointer positions etc., concrete composition can be referring to table 2.
5) an Excel Document Alignment workbook WorkBook must have one to describe the zone, this is described the zone and is placed on before the WorkSheet table data, after Excel Header district, comprising contents such as the form of the table name of each WorkSheet table in the Excel file and the side-play amount in whole file thereof, cell, default font, countries, wherein, most important is exactly the side-play amount of each WorkSheet table in whole file, the minimum zone that will account for 8 Block sizes of WorkBook.
6) the Excel file is to before each WorkSheet table beginning, also must there be one to describe the zone, this is described the zone and is placed on before the cell data begin, wherein deposit the position that line number, columns and per 32 line data begin in this WorkSheet table and arrive the information such as side-play amount that each WorkSheet shows the position of beginning, every WorkSheet table can be deposited the data that reach 65536 row at most.
7) the Excel file is stored per 32 line data (being called RowBlcok) packings at every turn, has in every row in to 32 row after the cell storage of data, must write down in this 32 row every row and begin 32 to go the side-play amount that begins to this.
8) the Excel end-of-file (EOF) has the total interface of RootEntry of 1 block at least.
By above-mentioned Excel file description, as seen to generate an Excel file, must know the size of Excel file in advance, at present all systems that increases income are when generating the Excel file, all be that all data are put into internal memory, by the time during stop, calculate line number, the columns of Excel file in the internal memory again, and block pointer and other all information of generation Excel file, write-once forms the Excel file to disk then, so it is big to work as data volume one, all data all are kept in the internal memory, will take very large memory headroom.This shortcoming can be exaggerated in the system with the Java language exploitation, this is because Java language is different with other language to the internal memory treatment technology, Java is to be realized by jvm (Java Virtual Machine) to the management of internal memory, be not to control by the programmer, in case certain thread accept one from database data export to the order of Excel file, and data volume is very big in the database, then may cause this thread too much directly to be interrupted because of taking resource, thereby cause export (swf) command unsuccessful, this produces in system's (as data statistic analysis of network management system) of mass data more common in every day.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of data in the database is exported to the devices and methods therefor of Excel file, is used for prior art utmost point consumption internal memory and the slow problem when mass data handled when generating the Excel file.
To achieve these goals, the invention provides and a kind of data in the database are exported to the device of Excel file, it is characterized in that, comprising:
Text is derived module, is used for data of database is exported to text;
The text read module, connecting described text derives module, is used for reading by the data volume of each setting the data of described text;
The Data Format Transform module connects described text read module, is used for the data of the described text that at every turn reads are carried out format conversion, and the Excel file that generates is write disk;
The Excel file is repaired module, connects described Data Format Transform module, is used in the mode of random read-write file described Excel file being repaired, and generates the file that reads and open for the Excel program.
Described data in the database are exported to the device of Excel file, wherein, described text is derived module and by database program described data is exported to described text.
The described device that data in the database is exported to the Excel file, wherein, described text read module reads the data of described text by the data volume of each 1024 bytes, and the number of the newline in internal memory is obtained the line number of described text when reading the data of described text by statistics, and first row of analyzing line number obtains the columns of described text.
The described device that data in the database is exported to the Excel file, wherein, Excel Header district's content that described Data Format Transform module is constructed described Excel file according to the line number and the columns of described text and the description district content of WorkBook, the data-switching of the described text of 32 row that will at every turn read again becomes the WorkSheet table data of described Excel file, and Summary Information district and the Document Summary Information district to described Excel file writes content after converting, and obtains described Excel file.
Described data in the database are exported to the device of Excel file, wherein, described Data Format Transform module becomes the data-switching of described text the cell of respective type according to the form of the data of the described text of every row:
When form is integer type, the data-switching of described text is become the cell of Excel integer type; Or
When form is floating point type, the data-switching of described text is become the cell of Excel floating point type; Or
When form is other types, the data-switching of described text is become the cell of character string type.
To achieve these goals, the present invention also provides a kind of data in the database has been exported to the method for Excel file, it is characterized in that, comprising:
Step 1 exports to text with data of database;
Step 2 reads the data of described text by the data volume of each setting, the data of the described text that at every turn reads is carried out format conversion, and the Excel file that generates is write disk;
Step 3 is repaired described Excel file, generates the file that reads and open for the Excel program.
Described data in the database are exported to the method for Excel file, wherein, in the described step 1, further comprise:
Described data are exported to the step of described text by database program.
Described data in the database are exported to the method for Excel file, wherein, in the described step 2, further comprise:
Read the data of described text by the data volume of each 1024 bytes, and the number of the newline in internal memory is obtained the line number of described text when reading the data of described text by statistics, and first row of analyzing line number obtains the step of the columns of described text.
Described data in the database are exported to the method for Excel file, wherein, in the described step 2, further comprise:
Excel Header district's content of constructing described Excel file according to the line number and the columns of described text and the description district content of WorkBook, the data-switching of the described text of 32 row that will at every turn read again becomes the WorkSheet table data of described Excel file, and Summary Information district and the Document Summary Information district to described Excel file writes content after converting, and obtains described Excel file.
Described data in the database are exported to the method for Excel file, wherein, in the described step 2, further comprise:
After the data-switching of the described texts of 32 row that will at every turn read become the WorkSheet table data of described Excel file, revise the step of the WorkSheet side-play amount in the BoundSheet cell in the description district of described WorkBook.
Useful technique effect of the present invention:
Compared with prior art, the present invention is when becoming the Excel file with the data-switching in the database, a spot of data have only been changed at every turn, except needs are deposited the auxiliary byte arrays of the input byte arrays of 1024Byte and several equal length at every turn, committed memory no longer, need not preserve all and need data converted at internal memory, greatly reduced the EMS memory occupation amount, simultaneously in transfer process, derive module and text read module and will change into operation the data manipulation in the database to file data by text, to file operation the time, adopted IO to read optimisation technique, made the efficient of conversion also be greatly improved than prior art.
Describe the present invention below in conjunction with the drawings and specific embodiments, but not as a limitation of the invention.
Description of drawings
Fig. 1 is the structure drawing of device that the present invention exports to data in the database Excel file;
Fig. 2 is the implementing procedure figure that the present invention exports to data in the database Excel file;
Fig. 3 is the implementing procedure figure that the present invention reads text fast;
Fig. 4 is the implementing procedure figure of Data Format Transform of the present invention;
Fig. 5 is the implementing procedure figure that Excel file of the present invention is repaired.
Embodiment
Below in conjunction with the drawings and specific embodiments technical scheme of the present invention is made further more detailed description.
As shown in Figure 1, be the structure drawing of device that data export to the Excel file in the database of the present invention.This device 100 comprises: text is derived module 10, text read module 20, Data Format Transform module 30, Excel file reparation module 40.
Text is derived module 10, is used for data of database is exported to text; This derivation is finished by database program, so velocity ratio obtains the result in program a lot of fast.
Text read module 20, connecting text derives module 10, is used to read the data of text.
Text read module 20 all reads the data of 1024 bytes at every turn, and leave in the buffer memory, Data Format Transform module 30 is when reading of data, be actually the data that from buffer memory, obtain text, after the middle data of buffer memory had been read, text read module 20 read 1024 bytes once more and deposits buffer memory in; In addition, text read module 20 provides line number and columns in the text.
Data Format Transform module 30 connects text read module 20, is used for by by the conversion of text data layout to Excel file data form, and the data-switching of text is become the Excel file, and the Excel file is a binary file.
The Excel file is repaired module 40, connects data format converting module 30, is used for after Data Format Transform is finished, and the Excel file after converting is repaired, and generates for the correct file that reads and open of Excel software (or program).
The Excel file is repaired module 40 and is adopted file random read-write technology, the Excel file is repaired the file that can be read and open by Excel software.
Make that at conversion Excel file to expend internal memory few by installing 100.
As shown in Figure 2, be the implementing procedure figure that the present invention exports to the data in the database Excel file.This flow process is the process that the data-switching in the database is become the Excel file, be from inlet flow, to read a certain amount of data at every turn, these data-switching are become the Excel file layout, write storage medium (disk) then, only take few internal memory in the time of can guaranteeing to change like this, after converting, utilize the mode of random read-write file that the last Excel file of storage medium (disk) is made amendment again, Excel software can correctly be read out content.The step of flow process is specifically:
Step S201 exports to text with the data in the database;
Step S202 obtains the data of text fast;
Step S203 carries out Data Format Transform to the data of text, generates the Excel file;
Step S204 judges whether conversion is finished, if then enter step S205; Otherwise, go to step S203 and continue format conversion;
Step S205 carries out the file reparation to the Excel file.
Realize the conversion of the data of text to the Excel file, the binary content that just needs to understand the Excel file is formed, and it is some Record that the binary content of Excel file is mainly formed, and comprises the Record of WorkBook and the Record of WorkSheet table.These Record will be listed below respectively.
Wherein, WorkBook describes the main composition Record in district:
A1) BOF (sign: 0809H), the beginning Record of WorkBook.
A2) Window1 (sign: 003DH), some settings of document window height, width etc.
A3) Font (sign: 0031H), the font setting, each WorkBook needs 4 FontRecord at least.
A4) XF (sign: 00E0H), the setting of cell, row, column etc., each WorkBook needs 21 XF Record at least.
A5) Style (sign: 0293H), the Show Styles setting of cell.
A6) (sign: 0085H), the expression record body of each WorkSheet table in WorkBook comprises the name of WorkSheet table, information such as side-play amount hereof to BoundSheet.
A7) EOF (sign: 000AH), the WorkBook end record.
Wherein, the main composition Record of WorkSheet table:
B1) BOF (sign: 0809H), the beginning label of WorkSheet table;
B2) (sign: 0200H), body is write down in first row that is used in the table and last column and first row that are used and the indication of rank rear to Dimensions.
B3) (sign: 0208H), line data writes down body (comprising column data) to Row.
B4) DBCELL (sign: 00D7), write down the relevant information of every row, comprise the information such as side-play amount of certain row in RowBlock.
B5) Window2 (sign: 023EH), indicate which row, column as seen.
B6) EOF (sign 000AH), the end mark of WorkSheet table.
In order to allow Excel software correctly read the binary file of changing with the mode of stream, can not wrong byte to the realization in ExcelHeader district and RootEntry district, otherwise will read failure, these two districts are most important parts in the whole Excel file, at first describe the formation in Excel Header district.
Excel Header district is made up of 512 bytes, and table 2 provides the composition of these bytes.It is as follows that Excel Header district forms table in this table 2:
Table 2
The position Effect
0-43 Excel software relevant information immobilizes
44-47 The number of the shared block of expression blockPointer
48-51 The reference position in RootEntry district is a unit with block.
52-67 Information immobilizes
68-71 Indication extendPointerBlock reference position
72-75 The number of indication extendPointerBlock
76-511 Deposit 109 PointerblockPointer
Except that changeless information, out of Memory all need be made amendment with the random read-write mode after converting in the Excel Header district.
The RootEntry district also is made up of 512 bytes, and detailed byte is formed as shown in table 3.The composition table in RootEntry district is as follows in the table 3:
Table 3
The position Effect
0-127 The information such as name of Root Entry, generally constant.
128-255 WorkBook name, and WorkBook reference position are unit with block.
256-377 The name in Summary Information district, and the reference position in this district are unit with block.
378-511 The name in Document Summary Information district, and the reference position in this district are unit with block.
Owing to become in the process of Excel file in data-switching with text, need generate the information of block pointer according to the number of data b lock, so the following totalBlock that derives and need at last according to the shared block number (dataBlock) of real data.
Each data b lock needs the pointer of a 4Byte to indicate, and is pointerBlock so need pointer block number, and this pointerBlock adopts formula one to calculate:
PointerBlock=(dataBlock+127)/(512/4) (formula one)
In order to hold these data b lock pointer, these pointers block also needs a pointer to indicate (second level pointer), because being reserved with 109 positions in Excel Header district deposits second level pointer, so also need to expand the block number is extendPointerBlock, and this extendPointerBlock adopts formula two to calculate:
ExtendPointerBlock=(pointerBlock-109+127)/(512/4) (formula two)
Historical facts or anecdotes border data are dataBlock, need totalBlock storage space altogether, and this totalBlock adopts formula three to calculate:
TotalBlock=dataBlock+pointerBlock+extendPointerBlock (formula three)
As shown in Figure 3, be the realization flow figure that the present invention reads text fast, in this flow process, read text fast by text read module 20, referring to following steps:
Step S301 obtains the line number and the columns of text.
In this step, by read the data of 1024Byte at every turn, the number of statistics newline obtains line number in internal memory, because the data of text are to obtain from database, the columns of each row all is identical, so columns just can obtain as long as analyze first row.
Step S302 provides the input of each 32 line data for data layout.
In this step, text read module 20 need provide input for Data Format Transform module 30, promptly from top of file, 32 line data are provided at every turn, when forming line data, also need to adopt the method that at every turn reads 1024 Byte, in internal memory, carry out column data and divide.
In this step, if the data deficiencies of returning 32 row, then file reads and finishes.
In this flow process, can not obtain line number by read a row method at every turn, it is too many to do startup I/O number of operations like this, and speed is too slow.
As shown in Figure 4, be the implementing procedure figure of Data Format Transform of the present invention.This flow process specifically comprises:
Step S401, at first, the content in the Excel Header district of structure Excel file.
In this step, according to the line number of the data that obtain in the text read module 20 and the content that columns is constructed Excel Header district.Wherein, the content in Excel Header district can be constructed with reference to the explanation in the above-mentioned table 2.
Step S402, the description district content of the WorkBook of structure Excel file.
In this step, the line number of the data that obtain according to text read module 20 and the description district content that columns is constructed WorkBook.Wherein, the description district of WorkBook comprises main composition Record.
In this step, when the description district of structure WorkBook content, according to line number and columns structure BoundSheet Record, other Record can immobilize.
In this step, the description district content of WorkBook must comprise the number of WorkSheet table, a WorkSheet table can only be stored 65536 line data, can calculate the WorkSheet table number of needs according to the line number of text, thereby correctly constructs the description district content of WorkBook.
In the description district content of structure WorkBook, the position of the BoundSheet Record in the description district of needs record WorkBook.
Step S403, the beginning data of structure WorkSheet table write down the side-play amount that current WorkSheet table begins apart from file.
In this step, after whenever having write WorkSheet table data, all need to revise the WorkSheet side-play amount among the BoundSheetRecord.
Step S404 reads 32 line data from text, every column data in 32 row is converted to a cell Record of Excel file.
In this step, the data-switching that at every turn reads 32 style of writing presents becomes the Excel binary file.
In this step,, at first construct the description district content of WorkSheet table if the WorkSheet table is a new WorkSheet table.
Construct the description district content of WorkSheet table according to the main composition Record in the description district of WorkSheet table, wherein mainly be the information of line number, columns and some form aspects of WorkSheet table, and record WorkSheet show the side-play amount of the reference position of WorkBook; Then, the WorkSheet that converts to that at every turn reads 32 line data shows data.
In this step, need analyze every column data form in the time of conversion, if this column data is an integer type, then convert Excel integer type cell Record to, its Record name is RK; If this column data is the data of floating point type, then convert the cell Record of Excel floating point type to, its Record name is Number; Other data type unification converts the Record of character string type to, and its name is Label.
Step S405 judges whether to change 65535 row, if, promptly from text, read 65536 line data, then write WorkSheet and finish Record (EOF), restart then to construct new WorkSheet data, enter step S406.Otherwise, be back to step S404.
Step S406 judges whether all data have been changed to finish, if enter step S407; Otherwise be back to step S403.
Step S407 after converting the data of text, need write the content in Summary Information district and Document Summary Information district.
In this step, these two districts account for the space of 16 block, and to content without limits, get final product so these 16 block can be filled with 0.
As shown in Figure 5, be the implementing procedure figure that Excel file of the present invention is repaired.Behind the Excel file data form that the text data format conversion is become, the Excel file of this moment can't correctly be read by Excel software, need repair it.This process specifically comprises:
Step S501 at first, calculates dataBlock;
In this step, calculate dataBlock, see formula four according to the current side-play amount of file pointer;
DataBlock=file pointer side-play amount/512 (formula four)
If remainder is arranged, then dataBlock need add 1.
Step S502 then, calculates pointerBlock, the extendPointerBlock of needs expansion and the total totalBlock that needs according to formula one, two, three; Content according to totalBlock structure RootEntry district.
Step S503 writes blockPointer, writes PointerblockPointer information.
In this step,, in pointerBlock, write the block pointer information according to the pointerBlock number; If pointerBlock greater than 109, then needs to increase extendPointerBlock block again, and in Excel Header district and extendPointerBlock block, write PointerblockPointer (second level pointer) information;
Step S504 writes the content in RootEntry district.
Step S505, last, file pointer is moved on to top of file Excel Header district, revise each byte information that need revise in ExcelHeader district.
The invention provides a kind of and platform independence, efficiently, the few data with in the database of consumption internal memory export to the Data Handling Equipment And Method of Excel file, in actual applications the result data of inquiring about in the database is exported to the Excel file in the mode that flows, do not need the support of Excel software, its overcome present all other generate the shortcoming of software utmost points consumption internal memory of Excel files and the slow problem when mass data handled.
Certainly; the present invention also can have other various embodiments; under the situation that does not deviate from spirit of the present invention and essence thereof; those of ordinary skill in the art work as can make various corresponding changes and distortion according to the present invention, but these corresponding changes and distortion all should belong to the protection domain of the appended claim of the present invention.

Claims (10)

1. one kind exports to the device of Excel file with data in the database, it is characterized in that, comprising:
Text is derived module, is used for data of database is exported to text;
The text read module, connecting described text derives module, is used for reading by the data volume of each setting the data of described text;
The Data Format Transform module connects described text read module, is used for the data of the described text that at every turn reads are carried out format conversion, and the Excel file that generates is write storage medium;
The Excel file is repaired module, connects described Data Format Transform module, is used in the mode of random read-write file described Excel file being repaired, and generates the file that reads and open for the Excel program.
2. according to claim 1 data in the database are exported to the device of Excel file, it is characterized in that described text is derived module and by database program described data exported to described text.
3. the device that data in the database is exported to the Excel file according to claim 1 and 2, it is characterized in that, described text read module reads the data of described text by the data volume of each 1024 bytes, and the number of the newline in internal memory is obtained the line number of described text when reading the data of described text by statistics, and first row of analyzing line number obtains the columns of described text.
4. the device that data in the database is exported to the Excel file according to claim 3, it is characterized in that, Excel Header district's content that described Data Format Transform module is constructed described Excel file according to the line number and the columns of described text and the description district content of WorkBook, the data-switching of the described text of 32 row that will at every turn read again becomes the WorkSheet table data of described Excel file, and Summary Information district and the DocumentSummary Information district to described Excel file writes content after converting, and obtains described Excel file.
5. the device that data in the database is exported to the Excel file according to claim 4, it is characterized in that, described Data Format Transform module becomes the data-switching of described text the cell of respective type according to the form of the data of the described text of every row:
When form is integer type, the data-switching of described text is become the cell of Excel integer type; Or
When form is floating point type, the data-switching of described text is become the cell of Excel floating point type; Or
When form is other types, the data-switching of described text is become the cell of character string type.
6. one kind exports to the method for Excel file with data in the database, it is characterized in that, comprising:
Step 1 exports to text with data of database;
Step 2 reads the data of described text by the data volume of each setting, the data of the described text that at every turn reads is carried out format conversion, and the Excel file that generates is write storage medium;
Step 3 is repaired described Excel file, generates the file that reads and open for the Excel program.
7. according to claim 6 data in the database are exported to the method for Excel file, it is characterized in that, in the described step 1, further comprise:
Described data are exported to the step of described text by database program.
8. described data in the database are exported to the method for Excel file according to claim 6 or 7, it is characterized in that, in the described step 2, further comprise:
Read the data of described text by the data volume of each 1024 bytes, and the number of the newline in internal memory is obtained the line number of described text when reading the data of described text by statistics, and first row of analyzing line number obtains the step of the columns of described text.
9. according to claim 8 data in the database are exported to the method for Excel file, it is characterized in that, in the described step 2, further comprise:
Excel Header district's content of constructing described Excel file according to the line number and the columns of described text and the description district content of WorkBook, the data-switching of the described text of 32 row that will at every turn read again becomes the WorkSheet table data of described Excel file, and Summary Information district and the Document Summary Information district to described Excel file writes content after converting, and obtains described Excel file.
10. according to claim 9 data in the database are exported to the method for Excel file, it is characterized in that, in the described step 2, further comprise:
After the data-switching of the described texts of 32 row that will at every turn read become the WorkSheet table data of described Excel file, revise the step of the WorkSheet side-play amount in the BoundSheet cell in the description district of described WorkBook.
CNA2008100579150A 2008-02-20 2008-02-20 Apparatus and method for educing data into Excel files from database Pending CN101231665A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNA2008100579150A CN101231665A (en) 2008-02-20 2008-02-20 Apparatus and method for educing data into Excel files from database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNA2008100579150A CN101231665A (en) 2008-02-20 2008-02-20 Apparatus and method for educing data into Excel files from database

Publications (1)

Publication Number Publication Date
CN101231665A true CN101231665A (en) 2008-07-30

Family

ID=39898137

Family Applications (1)

Application Number Title Priority Date Filing Date
CNA2008100579150A Pending CN101231665A (en) 2008-02-20 2008-02-20 Apparatus and method for educing data into Excel files from database

Country Status (1)

Country Link
CN (1) CN101231665A (en)

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102486772A (en) * 2009-12-29 2012-06-06 北京方正阿帕比技术有限公司 Method and device for exporting data
CN102542343A (en) * 2010-12-27 2012-07-04 上海市电力公司 Unified shared data management platform of power system and control method
CN102760118A (en) * 2011-04-25 2012-10-31 中兴通讯股份有限公司 Method and device for exporting data as Excel file
CN103810238A (en) * 2013-11-20 2014-05-21 国家电网公司 Large-data-volume Excel file exporting method based on asynchronous processing
CN105677698A (en) * 2015-12-11 2016-06-15 重庆川仪自动化股份有限公司 Report data exporting method
CN105843819A (en) * 2015-01-15 2016-08-10 中国移动通信集团河南有限公司 Method and device for exporting data
CN107526813A (en) * 2017-08-23 2017-12-29 北京明朝万达科技股份有限公司 A kind for the treatment of method and apparatus for the data that desensitize
CN107784085A (en) * 2017-09-30 2018-03-09 平安科技(深圳)有限公司 The deriving method and its terminal of a kind of data list
CN108108411A (en) * 2017-12-12 2018-06-01 苏州蜗牛数字科技股份有限公司 A kind of reading system and method for information list file
CN108153765A (en) * 2016-12-05 2018-06-12 天脉聚源(北京)科技有限公司 A kind of high-volume data export as the method and system of Excel file
CN110059303A (en) * 2019-04-23 2019-07-26 中铁电气化局集团有限公司 Excel file is converted to the method and device of JSON file
CN111046643A (en) * 2019-11-23 2020-04-21 方正株式(武汉)科技开发有限公司 System and method for generating excel form by rapid customization, server and medium
CN113138959A (en) * 2020-01-19 2021-07-20 上海静客网络科技有限公司 Method for exporting data in database into Excel file

Cited By (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102486772A (en) * 2009-12-29 2012-06-06 北京方正阿帕比技术有限公司 Method and device for exporting data
CN102542343A (en) * 2010-12-27 2012-07-04 上海市电力公司 Unified shared data management platform of power system and control method
CN102760118A (en) * 2011-04-25 2012-10-31 中兴通讯股份有限公司 Method and device for exporting data as Excel file
CN102760118B (en) * 2011-04-25 2015-06-03 中兴通讯股份有限公司 Method and device for exporting data as Excel file
CN103810238A (en) * 2013-11-20 2014-05-21 国家电网公司 Large-data-volume Excel file exporting method based on asynchronous processing
CN105843819A (en) * 2015-01-15 2016-08-10 中国移动通信集团河南有限公司 Method and device for exporting data
CN105677698A (en) * 2015-12-11 2016-06-15 重庆川仪自动化股份有限公司 Report data exporting method
CN105677698B (en) * 2015-12-11 2019-03-05 重庆川仪自动化股份有限公司 A kind of report data deriving method
CN108153765A (en) * 2016-12-05 2018-06-12 天脉聚源(北京)科技有限公司 A kind of high-volume data export as the method and system of Excel file
CN107526813A (en) * 2017-08-23 2017-12-29 北京明朝万达科技股份有限公司 A kind for the treatment of method and apparatus for the data that desensitize
CN107784085A (en) * 2017-09-30 2018-03-09 平安科技(深圳)有限公司 The deriving method and its terminal of a kind of data list
CN107784085B (en) * 2017-09-30 2021-04-13 平安科技(深圳)有限公司 Data list exporting method and terminal thereof
CN108108411A (en) * 2017-12-12 2018-06-01 苏州蜗牛数字科技股份有限公司 A kind of reading system and method for information list file
CN110059303A (en) * 2019-04-23 2019-07-26 中铁电气化局集团有限公司 Excel file is converted to the method and device of JSON file
CN110059303B (en) * 2019-04-23 2023-02-07 中铁电气化局集团有限公司 Method and device for converting Excel file into JSON file
CN111046643A (en) * 2019-11-23 2020-04-21 方正株式(武汉)科技开发有限公司 System and method for generating excel form by rapid customization, server and medium
CN113138959A (en) * 2020-01-19 2021-07-20 上海静客网络科技有限公司 Method for exporting data in database into Excel file

Similar Documents

Publication Publication Date Title
CN101231665A (en) Apparatus and method for educing data into Excel files from database
US8996981B2 (en) Managing forms in electronic documents
CN100440165C (en) Memory device and record regenerator using it
CN102760118B (en) Method and device for exporting data as Excel file
CN104423894B (en) Data memory device and method for controlling flash memory
CN103019970A (en) Memory device and method of controlling the same
CN101976232A (en) Method for identifying data form in document and device thereof
CN109857670B (en) Test report automatic generation method based on universal template
CN102346712A (en) Memory management device, information processing device, and memory management method
CN107766374B (en) Optimization method and system for storage and reading of massive small files
CN101996067A (en) Data export method and device
CN104881275A (en) Electronic spreadsheet generating method and device
CN102999441B (en) Fine granularity memory access method
CN104199899A (en) Method and device for storing massive pictures based on Hbase
CN105183915A (en) Multi-version management method for reducing index maintenance overhead
CN103207830A (en) Simulator with software breakpoint
CN103744744B (en) The data verification method of data memory device and volatile memory
CN111008175A (en) Method and device for generating EXCEL-to-DBC file
CN101458655B (en) Internal memory management method, system and internal memory control device
CN102193873B (en) Method of quickly reading and writing mass data file
CN106372002B (en) A kind of date storage method and read restoring method
CN102467496A (en) Method and device for converting stream mode typeset content into block mode typeset document
CN102407683B (en) Stepless zooming printing control method and device of printer
CN104699664A (en) Type setting system and method with independent templates
CN110502735B (en) Method and system for quickly manufacturing universal process file of electronic equipment

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Open date: 20080730