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

Data modification method and device, electronic equipment and storage medium

A data modification, data technology, applied in the computer field

Pending Publication Date: 2022-05-13
PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In view of this, the embodiment of the present application provides a data modification method, device, electronic equipment and storage medium to solve the problem of how to efficiently and accurately implement Excel data modification in the prior art

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
  • Data modification method and device, electronic equipment and storage medium
  • Data modification method and device, electronic equipment and storage medium
  • Data modification method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0059] see figure 1 , figure 1 It shows the implementation flowchart of a data modification method provided by the embodiment of the present application. The execution body of the method is an electronic device, and the electronic device includes but is not limited to a smart phone, a tablet computer, a notebook, a desktop computer, and the like. Such as figure 1 The data modification methods shown are detailed below:

[0060] In S101, the Excel file to be modified and the information to be modified are acquired; the information to be modified is used to indicate the data to be modified in the Excel file to be modified and the target data content to be modified by the data to be modified.

[0061] In the embodiment of the present application, the Excel file to be modified is an Excel file that needs to be modified currently. The information to be modified includes information indicating the data to be modified (that is, the data to be modified in the Excel file to be modifi...

Embodiment 2

[0129] figure 2 It shows a schematic structural diagram of a data modification device provided by the embodiment of the present application. For the convenience of description, only the parts related to the embodiment of the present application are shown:

[0130] The data modification device includes: an acquisition unit 21 , a batch reading unit 22 , a modification unit 23 and a splicing unit 24 . in:

[0131] The acquiring unit 21 is configured to acquire the Excel file to be modified and the information to be modified; the information to be modified is used to indicate the data to be modified in the Excel file to be modified and the content of the target data to be modified into by the data to be modified.

[0132] The batch reading unit 22 is configured to sequentially read a preset amount of data in batches from the Excel file to be modified in a stream processing manner, and store the data in each sub-Excel file respectively.

[0133] The modification unit 23 is conf...

Embodiment 3

[0147] image 3 It is a structural block diagram of an electronic device provided by another embodiment of the present application. Such as image 3 As shown, the electronic device 30 of this embodiment includes: a processor 31, a memory 32, and a computer program 33 stored in the memory 32 and operable on the processor 31, such as a program of a data modification method. When the processor 31 executes the computer program 33, the steps in the embodiments of the above-mentioned data modification methods are realized, for example figure 1 S101 to S104 shown. Or, when the processor 31 executes the computer program 33, the above-mentioned figure 2 The function of each unit in the corresponding embodiment, for example, figure 2 The functions of acquisition unit 21 to splicing unit 24 are shown, please refer to figure 2 Relevant descriptions in the corresponding embodiments are not repeated here.

[0148] Exemplarily, the computer program 33 may be divided into one or more...

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 is suitable for the technical field of computers, and provides a data modification method and device, electronic equipment and a storage medium, and the method comprises the steps: obtaining a to-be-modified Excel file and to-be-modified information; the to-be-modified information is used for indicating to-be-modified data in the to-be-modified Excel file and target data content to be modified by the to-be-modified data; reading a preset number of data from the to-be-modified Excel file in batches in sequence according to a stream processing mode, and respectively storing the data in each sub Excel file; according to the to-be-modified information, the to-be-modified data is searched in all the sub Excel files, and the data content of the searched to-be-modified data is modified into the target data content; and all the modified sub Excel files are spliced, so that a modified Excel file is obtained. According to the embodiment of the invention, Excel data modification can be efficiently and accurately realized.

Description

technical field [0001] The present application relates to the field of computer technology, and in particular to a data modification method, device, electronic equipment and storage medium. Background technique [0002] At present, in software application development, there are functions such as creating, writing data, reading data, modifying data, and the like of an Excel file through a programming language (such as java language). Among them, the data modification of the Excel file is realized through the programming language, and it is usually necessary to read all the data in the Excel file into the memory, and then analyze all the data in the memory and find the data that needs to be modified to complete the corresponding data modification . However, when the amount of data stored in the Excel file is too large, data modification in this way may cause memory overflow and affect the operation of the application. Contents of the invention [0003] In view of this, the...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/23G06F16/2455G06F16/22
CPCG06F16/23G06F16/24553G06F16/24552G06F16/2282
Inventor 李鹏
Owner PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD