Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for creating spreadsheet

A technology for creating electronic forms and methods, which is applied in the field of databases, and can solve the problems of non-existing separation of format and dynamic data, and inability to reflect the dynamic characteristics of dynamic data.

Active Publication Date: 2015-07-15
深圳市金蝶精斗云网络科技有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In view of this, the present invention provides a method for establishing an electronic form to solve the problem that there is no separation of format and dynamic data in the prior art, and the problem that the dynamic characteristics of dynamic data cannot be reflected

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for creating spreadsheet
  • Method for creating spreadsheet
  • Method for creating spreadsheet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0045] Please refer to the attached figure 1 , which is a flowchart of a method for establishing an electronic form disclosed by the present invention, mainly includes the following steps:

[0046] Step S101, according to the ID number of the electronic form, obtain the pre-encapsulated package file.

[0047] Execute step S101 to obtain the package file corresponding to the electronic form. The package file is pre-established, and its establishment process can be found in the attached figure 2 ,mainly include:

[0048] Step S201, setting the format of the electronic form and generating a corresponding format file.

[0049] Step S202, establishing a correspondence between the format file of the electronic form and the data source field file.

[0050] Wherein, the data source field file is stored in a corresponding established database; or, stored in a corresponding XML or ini file.

[0051] Step S203, determining the position of the active row in the electronic form file, ...

Embodiment 2

[0070] like Figure 4 As shown, taking the establishment of a Cell unit format report as an example, the specific process includes:

[0071] Step S401, make a report format on the Cell format control, without including the data source, and store it as "040101.rpt". Among them, 040101 is the unique ID of the report. The specific report format is shown in Table 1 below.

[0072] Table 1:

[0073]

[0074] Step S402, establishing the corresponding relationship between the data source field file and the format file. In the second embodiment, an XML file is used as an example of a data source field file. The specific relationship established is shown in Table 2 below.

[0075] Table 2:

[0076]

[0077] Among them, the Data node represents the data source field file, and the Format node represents the relationship between the format file and the data source field file.

[0078] In Data:

[0079] Id represents the ID number of the data source; Data Source represents th...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for creating a spreadsheet. The method mainly comprises the following steps of: acquiring a packaged file which is pre-packaged according to the identity (ID) number of the spreadsheet; splitting the packaged file, and thus obtaining a format file of a preset spreadsheet and a data source field file which corresponds to the format file; creating a data source of a movable line in the corresponding spreadsheet according to the data source field file; and according to a corresponding relation between the format file and the data source field file, loading the data source to the position of the movable line in the format file, and generating a complete spreadsheet. In the process of creating the spreadsheet, the format file and the data source field file, which correspond to the spreadsheet, are respectively called and loaded, dynamic data which are created in the data source field file are written into the position of the corresponding movable line in the format file, and the data dynamic characteristics of the dynamic data which are stored in the spreadsheet can be realized.

Description

technical field [0001] The invention relates to the field of databases, and more specifically, relates to a method for establishing an electronic form. Background technique [0002] Existing spreadsheets can not only input, output, and display data, but also display various complex statistical operations on the input data. At the same time, spreadsheets can also convert a large amount of boring data into charts and displays. Therefore, in the prior art, the required tables or charts are mostly established based on electronic tables. [0003] However, for tables or charts with diverse formats and dynamic data, such as reports. In the process of establishing electronic forms in the prior art, the format and dynamic data are closely combined, that is, the data to be dynamically displayed is bound, defined, and static, and dynamic changes cannot be realized . That is, when creating tables or charts with various formats and dynamic data in the prior art, it is impossible to r...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
Inventor 张锡百
Owner 深圳市金蝶精斗云网络科技有限公司