CN109558575A - Online Table edit method, apparatus, computer equipment and storage medium - Google Patents
Online Table edit method, apparatus, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109558575A CN109558575A CN201811250255.8A CN201811250255A CN109558575A CN 109558575 A CN109558575 A CN 109558575A CN 201811250255 A CN201811250255 A CN 201811250255A CN 109558575 A CN109558575 A CN 109558575A
- Authority
- CN
- China
- Prior art keywords
- data
- user
- table edit
- saved
- client
- 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
- 238000000034 method Methods 0.000 title claims abstract description 57
- 230000005540 biological transmission Effects 0.000 claims abstract description 11
- 238000004590 computer program Methods 0.000 claims description 20
- 238000006243 chemical reaction Methods 0.000 claims description 8
- 238000002372 labelling Methods 0.000 claims description 2
- 238000000605 extraction Methods 0.000 abstract 1
- 238000013515 script Methods 0.000 description 54
- 230000006870 function Effects 0.000 description 29
- 230000008569 process Effects 0.000 description 13
- 238000007689 inspection Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000011161 development Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 239000000284 extract Substances 0.000 description 3
- 230000003993 interaction Effects 0.000 description 3
- 238000011017 operating method Methods 0.000 description 3
- 238000003491 array Methods 0.000 description 2
- 238000013497 data interchange Methods 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 230000008846 dynamic interplay Effects 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000002407 reforming Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of online Table edit method, apparatus, computer equipment and storage mediums, the described method includes: if receiving the logging request of client transmission, authentication, and the user group according to belonging to the result of authentication acquisition user are then carried out to user according to the user identity information for including in logging request；Client is sent by the Table edit page corresponding with user group；With the first prefixed time interval, the data in the Table edit page are received, and are saved in storage platform, wherein storage platform is for storing the data that user edits；The data submission request that client is sent is received, and obtains the data for including in data submission request and submits identification information；Data in the Table edit page are saved in database corresponding with data submission identification information, wherein database is used to store the data of user's submission.Technical solution of the present invention solves the low problem of the data efficiency in electronics table poor compatibility, and extraction electrical form.
Description
Technical field
The present invention relates to field of information processing, more particularly to online Table edit method, apparatus, computer equipment and storage
Medium.
Background technique
Electrical form is the commonly used tool in routine office work.The electrical form tool of mainstream includes on the market at present
The Excel of Microsoft, the WPS of Kingsoft Co. and the LibreOffice of open source etc..Each electrical form tool provider by
In the needs of competition, the electrical form product of oneself is widelyd popularize, and has cultivated respective relatively-stationary user group.Due to not having
There is unified professional standard, cannot be completely compatible between different electrical form products, brings problem to user's use.
For example, each one may use different electrical form tools because of the difference of use habit in enterprises.In this way
So that occur compatibility issue when accessing to shared electrical form, such as in the reference to mathematical formulae, and to picture,
These elements cannot be normally shown when the reference of the objects such as link, file.Meanwhile electrical form number is submitted by enterprises each department
According to when, or submitted by by sending document in the form of Email attachment, or in the form of direct transferring documents, higher level department
It needs to arrange different electronic form documents one by one when summarizing data, then extracts data, so that arranging and statistical data
Process efficiency is not high.
Summary of the invention
The embodiment of the present invention provides a kind of online Table edit method, apparatus, computer equipment and storage medium, to solve
Electrical form poor compatibility, and extract the low problem of data efficiency in electrical form.
A kind of online Table edit method, comprising:
If the logging request of client transmission is received, according to the user identity information pair for including in the logging request
The user carries out authentication, and according to the result of authentication obtain the user belonging to user group；
The client is sent by the Table edit page corresponding with the user group；
With the first prefixed time interval, the data in the Table edit page are received, and are saved in storage platform,
In, the storage platform is for storing the data that user edits；
The data submission request that the client is sent is received, and obtains the data for including in the data submission request and mentions
Hand over identification information；
Data in the Table edit page are saved in database corresponding with data submission identification information,
Wherein, the database is used to store the data of user's submission.
A kind of online Table edit device, comprising:
Login authentication module, if the logging request for receiving client transmission, is wrapped according in the logging request
The user identity information contained carries out authentication to the user, and belonging to obtaining the user according to the result of authentication
User group；
Page sending module, for sending the client for the Table edit page corresponding with the user group；
Module is automatically saved, for receiving the data in the Table edit page, and protect with the first prefixed time interval
It is stored to storage platform, wherein the storage platform is for storing the data that user edits；
Authentication module is submitted, the data submission request sent for receiving the client, and obtain the data and submit
The data for including in request submit identification information；
Data submit module, submit mark letter with the data for being saved in the data in the Table edit page
It ceases in corresponding database, wherein the database is used to store the data of user's submission.
A kind of computer equipment, including memory, processor and storage are in the memory and can be in the processing
The computer program run on device, the processor realize above-mentioned online Table edit method when executing the computer program
Step.
A kind of computer readable storage medium, the computer-readable recording medium storage have computer program, the meter
The step of calculation machine program realizes above-mentioned online Table edit method when being executed by processor.
Above-mentioned online Table edit method, apparatus, computer equipment and storage medium provide the online of unification for user
The Table edit page avoids user using different local electrical form tools and carries out editor's bring compatibility issue；With
The content that prefixed time interval edits user is saved in storage platform, realizes the function that real-time online automatically saves, prevents
Data are surprisingly lost；Authentication is carried out to the user of login, provides the Table edit page for the user of different user groups；It receives
The data submission request that client is sent, and the data submitted user according to the default identification information in data submission request into
Row classification, is saved in respectively in corresponding database, and the data that the convenient user to particular group of users submits automatically extract,
Reduce the time for summarizing data in different electrical forms, improves the efficiency of data processing.
Detailed description of the invention
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below by institute in the description to the embodiment of the present invention
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the invention
Example, for those of ordinary skill in the art, without any creative labor, can also be according to these attached drawings
Obtain other attached drawings.
Fig. 1 is an application environment schematic diagram of online Table edit method in one embodiment of the invention；
Fig. 2 is the flow chart of online Table edit method in one embodiment of the invention；
Fig. 3 is the flow chart that the data that user edits are exported in one embodiment of the invention；
Fig. 4 is the flow chart that user's operation step is recorded in one embodiment of the invention；
Fig. 5 is the flow chart for recording user's operation step in one embodiment of the invention by interim array；
Fig. 6 is the flow chart of step S5 in online Table edit method in one embodiment of the invention；
Fig. 7 is the schematic diagram of online Table edit device in one embodiment of the invention；
Fig. 8 is the schematic diagram of computer equipment in one embodiment of the invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
Online Table edit method provided by the present application, can be applicable in the application environment such as Fig. 1, wherein server-side is
The computer equipment of online Table edit service is provided, server-side can be server or server cluster；Client is user
The computer terminal for carrying out online Table edit and using, including but not limited to browser, cell phone application etc.；Storage platform
Be store the online Table edit of user content memory space, storage platform include provide memory space computer equipment,
Cloud storage platform etc.；Database is the data submitted after the completion of storing user's online editing；Between client and server-side, service
Between end and storage platform, by network connection between server-side and database, network can be finite element network or wireless network.
Online Table edit method provided in an embodiment of the present invention is applied to server-side.
In one embodiment, as shown in Fig. 2, providing a kind of online Table edit method, specific implementation flow includes
Following steps:
S1: if the logging request of client transmission is received, according to the user identity information pair for including in logging request
User carries out authentication, and the user group according to belonging to the result of authentication acquisition user.
User can be taken with registering the identity of user or the identity logs server-side of anonymous using online Table edit
Business.When identity logs of the user to register user, it is desirable to provide user name and login password；When user is with the body of anonymous
When part logs in, without providing user name and login password.
User is divided into different user groups by server-side, such as user can be divided into the user group and anonymity of registration user
The user group of user, and different online Table edit services is provided the user of different user groups, such as registration user can make
With user-defined data table grid template function, and anonymous cannot then use user-defined data table grid template function, etc..
Server-side is deployed with customer data base, and customer data base can also pass through network and clothes in server-side local
Business end is connected.Customer data base is for verifying the identity of login user.Specifically, customer data base includes but is not limited to
Various relationship types or non-relational database, as MS-SQL, Oracle, MySQL, Sybase, DB2, Redis, MongodDB,
Hbase etc..
User group belonging to user identity information and user is stored in customer data base.Wherein, user identity information
It is the mark to user identity, for example, it may be user id (identification, identity) number.Register the use of user
There is corresponding record at family id in customer data base, and anonymous does not record then accordingly.User group includes registration user
Group, anonymous group and other customized group of preset users.Specifically, customer data base mainly includes user message table,
The table is used to store the essential information of registration user.Field that user message table includes but be not limited to: user No. id, user name,
Login password, user group, work number, name, gender, affiliated department etc..
Specifically, by taking user initiates logging request to server-side by browser as an example, user opens the login of server-side
The page inputs user name and login password if the user belongs to registration user；If the user belongs to nonregistered user, can
It is skipped according to the prompt of login page.Server-side receives the logging request that client is sent, and checks the user in logging request
Identification information, if registration user, then user identity information is user name and login password；If nonregistered user, then user
Identification information is sky.Use of the server-side using user identity information as querying condition, where obtaining user in customer data base
The group number of family group.Wherein, if server-side running environment is Java, server-side can access customer data base by JDBC.
JDBC (connection of Java DataBase Connectivity, Java database) is a kind of for executing the Java of SQL statement
API, can provide unified access for a variety of relational databases, and the class and interface that it is write by one group with Java language form.
JDBC provides a kind of benchmark, can construct more advanced tool and interface accordingly, database development personnel is enable to write number
According to library application program.Database development personnel can be suitably used for different databases by the interface routine that JDBC writes, and no longer
It needs to write interface routine respectively for different databases, greatly improves development efficiency.
S2: client is sent by the Table edit page corresponding with user group.
The Table edit page is the Web page that server-side is supplied to that client carries out online Table edit, including HTML text
Part, CSS file and JS script.Wherein, HTML represents HyperText Markup Language, is a kind of hypertext markup
Language, can be used for creating the standard markup language of webpage, and HTML runs on a web browser, parsed by browser；CSS is represented
Cascading Style Sheets, is cascading style sheets, is that one kind is used to show HTML or XML (extensible markup language) etc.
The computer language of file pattern.CSS not only can statically modified web page, various scripting languages can also be cooperated dynamically right
Webpage each element is formatted；JS represents JavaScript, and a kind of literal translation formula scripting language of JavaScript, is a kind of dynamic
Type, weak type, the language based on prototype, built-in support type.The interpreter of JS is referred to as JavaScript engine, for browsing
A part of device is widely used in the scripting language of client, is applied on html web page, increases to html web page dynamic
State function.
The Table edit page is deployed under the different file directorys of server-side.For example, server-side is registration user group distribution
Registration user's Table edit page directory, in the case where registering user's Table edit page directory further includes html file catalogue, CSS
File directory, JS script catalogue.HTML text is respectively housed under html file catalogue, CSS file directory and JS script catalogue
Part, CSS file and JS script.It is to be appreciated that server-side is that anonymous group is assigned with the anonymous Table edit page
Catalogue, anonymous Table edit page directory equally include html file, CSS file and JS script.
The Table edit page respectively realizes different functions: html file is mainly used for showing content of pages, CSS file
It is mainly used for being laid out content in HTML, JS script is mainly used for realizing data dynamic interaction function.Wherein, html file and CSS
The page that file is mainly responsible for online Table edit shows, JS script is also known as client script, and JS script is by client from clothes
Business end is downloaded and is executed, and the data processing of client local and the data interaction function with server-side, client here are responsible for
End mainly includes browser.It may include several JS scripts in JS script catalogue, different functions may be implemented in different JS scripts,
Or it is combined by several JS scripts and realizes a certain function.
For example, operation associated with the file, including the operation such as created, deleted, being replicated, being renamed to table, it can be with
It is realized respectively by newly-built table JS script, Delete Table JS script, responsible table JS script and renaming table JS script
Respective function.For creating online table, the process of table is specifically created are as follows: create when user clicks in html page
When table button, will trigger the newly-built table event in newly-built table JS script will adjust after server-side receives newly-built table event
It is selected with form template selection interface for user, and waits user to make and act in next step；When user has selected a table mould
After plate, server-side will call the selected html file of user to edit for user, to complete the process of newly-built table.Wherein,
Form template includes but is not limited to job schedule, attendance sheet, summary, daily work report, address list etc..
Different user groups can possess different Table edit page directories, can use different online Table edit function
Energy.For example, the Table edit catalogue of registration user group is different from the Table edit catalogue of anonymous group；It is equally registration user
The user of group, Table edit catalogue and the Table edit catalogue difference of personal user of enterprise customer, etc..
Server-side further includes server side script in addition to being deployed with the Table edit page.Server side script is and client's end feet
Originally in contrast, server side script is deployed in server-side, and runs in server-side, is mainly responsible for server-side and server-side rear end
Between data interaction.Wherein, server-side rear end includes but is not limited to database, storage platform, other server-sides etc..Common
Server side script includes PHP, JSP, ASP etc..Wherein, PHP, that is, PHP:Hypertext Preprocessor, which is that one kind is general, to be opened
Source scripting language is primarily adapted for use in Web development field；JSP entitled Java Server Pages entirely, is by Sun
Microsystems company advocates, many companies participate in a kind of dynamic web page technique standard established together；ASP, that is, Active
Server Pages is the server side scripts environment of MicroSoft company exploitation, can be used to create dynamically interactive type webpage simultaneously
Establish powerful weblication.
After server-side carries out authentication to login user, according to the user group where user, by different Table edits
The page is sent to client.
Specifically, server side script is according to the group number of user group, obtains corresponding Table edit page directory, and to browsing
Device sends page jump message, makes browser from corresponding Table edit page directory downloading html file, CSS file and JS
Script sends client for the Table edit page corresponding with user group to realize.
S3: with the first prefixed time interval, the data in the Table edit page are received, and are saved in storage platform, wherein
Storage platform is for storing the data that user edits.
First prefixed time interval can be user and carry out customized setting by the setting function in the Table edit page
Time interval, it is also possible to be the time interval defaulted in client script.Wherein, the setting in the Table edit page
Function can be provided front end data acquisition by html file, such as carry out customized setting for user in a manner of list；And by
Server side script provides data interaction, such as the time interval value of the customized setting of user is saved in server-side.First is default
The value of time interval can be as unit of the times such as minute, hour, acquiescently, and the first prefixed time interval is 5 minutes.
Data in the Table edit page are the data that user inputs when carrying out online Table edit, including user exists
The data inputted in all lists of html page.All lists in html page are corresponding with form NO., when user is in table
In list when input data, server-side can obtain the content that user is inputted according to form NO..
Storage platform is used to store the data of user's input when carrying out online editing.Storage platform bag includes empty for storage
Between computer equipment, cloud storage platform etc..Storage platform can provide FTP, HTTP or HTTPS service to server-side.Service
End automatically saves the number that user edits in the data forwarding to storage platform in the Table edit page received with realization
According to.
Specifically, by taking prefixed time interval is 5 minutes as an example, client script was every 5 minutes acquisition active sheet editors
Data in the page in all cells, and these data are sent to server-side in the form of JSON format.Server side script connects
The JSON data that client is sent are received, and are saved in storage platform.Wherein, all cells include unique identification number, such as
" 1-1 " represents the cell of the first row first row.JSON (JavaScript Object Notation, JS object numbered musical notation) is one
The data interchange format of kind lightweight.JSON file is stored with ASCII coding mode, can quilt independent of operating system
Computer program quickly reads or generates, and is a kind of data interchange format of prevalence.One after line table is converted
JSON data can indicate are as follows:
In the above JSON data, " 1-1 " to " 1-6 " represents in the Table edit page in the first row first row to the 6th column
Value, wherein " 1-6 " cell includes several subelement lattice again.
Data in the Table edit page are saved in storage platform by server-side, while recording the mark of each cell
Number and cell in value can carry out data convert accordingly when needing to carry out list data reduction.
S4: receiving the data submission request that client is sent, and obtains the data for including in data submission request and submit mark
Know information.
The content of online editing can be directly submitted to server-side by user, realize online submission data.Online data mentions
Function is handed over to can be applied to the data collection of enterprises and summarize or other similar application environment.For example, department, junior, enterprise
Using the online table for the unified standard that server-side provides, and it is directly submitted to server-side, so that data are collected by higher level department.
Data submission request is the request of data that client is submitted in html page by list.Data submission request packet
The data and data for including user's online editing submit identification information.Wherein, it is to user's online editing that data, which submit identification information,
Data mark, data submit identification information to can be No. id, such as can be in online table column name or certain row that certain is arranged
Row name.
Specifically, user carries out the editor of online table in client, and each cell in online table is one corresponding
List, each list have list id of a unique identification, and list id is made of a line number and a row number, according to row
Row number can uniquely determine the position an of cell and the value of the inside.When the user clicks when submitting button in html page,
Client script sends form data to server-side, include in form data user's online editing data and online table
Row name or column name；Form data will be submitted to server-side by post () method by corresponding list.Server-side receives visitor
The data submission request that family end is sent, and obtain the data in list.Wherein, server-side is by the data in online table according to row
Or column are grouped, and obtain the array comprising several row or column data.
S5: the data in the Table edit page are saved in database corresponding with data submission identification information, wherein
Database is used to store the data of user's submission.
Database is used to store the data of user's submission, realizes the collection to user data and summarizes, mentions for various applications
For service, referred to as application database.Application database is connected by network with server-side.Application database includes but is not limited to
Various relationship types or non-relational database, as MS-SQL, Oracle, MySQL, Sybase, DB2, Redis, MongodDB,
Hbase etc..The quantity of application database can be default according to application demand, and the quantity of application database is at least one.Using
It mainly include document information table in database, document information table is used to store the data and relevant information of user's submission.Document letter
Field in breath table includes but is not limited to: user No. id, user submit in creation time or the modification time, online table of data
Row name or column name etc..
Server-side submits identification information according to data, chooses corresponding table name or library name in application database, and will be by table
Data in lattice edit page are saved in corresponding database.
For example, if data are the job performance year report of all employees of certain department in the Table edit page, wherein table
Row in lattice represents the data of each employee, and the column in table represented for 12 month, and each cell represents moon work in table
Performance, then table can be divided into 4 arrays according to month by server-side, and each array is represented when all employees' of the season department
Job performance, and 4 several groups are saved in respectively in department's season job performance table of application database；Server-side can also root
Table is divided into several arrays according to employee name, each array represents the data of employee's annual work performance, and employee's year
Job performance is saved in employee's annual work performance table of application database.
Specifically, if server-side running environment is Java, and it is the table name in application database that data, which submit identification information,
Or the library name of application database, then the data in the Table edit page can be inserted into accordingly by server side script by JDBC
In application database or in corresponding tables of data.
In the present embodiment, online Table edit method provides the unified online Table edit page for user, avoids
User carries out editor's bring compatibility issue using different local electrical form tool；With prefixed time interval by user
The content of editor is saved in storage platform, realizes the function that real-time online automatically saves, prevents data from surprisingly losing；To login
User carry out authentication, provide the Table edit page for the user of different user groups；The data that client is sent are received to mention
Request is handed over, and the data that user submits are classified according to the default identification information in data submission request, is saved in respectively
In corresponding database, the data that the convenient user to particular group of users submits are automatically extracted, and are reduced and are summarized different electricity
The time of data in sub-table, improve the efficiency of data processing.
Further, in one embodiment, as shown in figure 3, after step s 5, i.e., by the data in the Table edit page
After being saved in database corresponding with data submission identification information, online Table edit method further includes following steps:
S6: receiving the data that client is sent and export request, and obtains the file type and storage in data export request
Location information.
Data export request is that user needs the content of online Table edit exporting to local or other network storage positions
When setting, to the solicited message of server-side sending.Data export request includes the storage position of derived file type and export
It sets.File type includes spreadsheet file types, such as xls, xlsx etc.；Label file type such as html, xml etc., text text
Part type, such as txt.The storage location of export mainly includes client local and network storage location, storage location with
The form of file store path indicates.
Specifically, user clicks export button in html page can trigger client transmission data export request, i.e.,
Triggering realizes that the client script of export function sends information to server-side, and server-side can obtain from list and want derived text
Part type and the location information to be stored.
S7: obtaining the corresponding coding mode of file type, and by the data conversion in the Table edit page at coding staff
The matched document data flow of formula.
Document data flow refers to export in the data storage method of server-side.Data in the Table edit page use
Be Unicode coding mode, that is, represent during user edit table, user input data client be with
What Unicode coding mode was kept in and was shown.Wherein, Unicode (Unicode, Unicode, single code) is computer science neck
An industrywide standard, including character set, encoding scheme in domain etc..Unicode is to solve traditional character coding method
Limitation and generate, it is the unified and unique binary coding of each character setting in every kind of language, to meet
Across language, the cross-platform requirement for carrying out text conversion, processing.
Data in different file types use different coding modes.For example, txt is most for the text file of suffix
It is using ASCII coding mode.Wherein, ASCII (American Standard Code for Information
Interchange, ASCII) it is a set of computer code's system based on the Latin alphabet, it is mainly used for showing
Show current english and other Western-European languages.
By taking export type is xls as an example, server-side is called according to different file types and executes corresponding service
End feet sheet, to realize the data conversion in the Table edit page into corresponding coding mode.Specifically, server side script can
Can be converted the data in the Table edit page using POI, by the Content Transformation in each list in Excel table
Sheet pages of a cell, to obtain document data flow.Wherein, POI full name is Apache POI, it is compiled with Java
The cross-platform Java API freely to increase income write, using it may be implemented in Microsoft Office Excel,
The format files such as Word, PowerPoint, Visio are read and are write.
S8: document data flow is saved in the specified storage location of storage location information.
In server-side, document data flow is saved in client local and is saved in client's end feet of network storage location
It originally is to be deployed under different JS script catalogues respectively.Specifically, the storage location that server-side is specified according to storage location information
Corresponding client script is called, and sends client executing for the client script, protects document data flow to realize
It is stored to the specified storage location of storage location information.
In the present embodiment, the data that server-side receives that client is sent export request, obtain in data export request
File type and storage location, and then the data conversion in the Table edit page is saved at corresponding document data flow
The specified storage location of storage location information provides for user data exporting to the local function with network storage location of client
Can, it can support multiple file types, be conducive to improve online Table edit function.
It further, in one embodiment, i.e., will be with as shown in figure 4, upon step s 2, and before step S 4
The corresponding Table edit page of user group is sent to after client, and the data submission request sent in reception client,
And before obtaining the data submission identification information for including in data submission request, online Table edit method further includes walking as follows
It is rapid:
S9: being basic table by the data markers in the Table edit page, and using basic table as the of preset group
One element is saved in preset group.
Preset group is for being retracted or being reformed to the operating procedure during Table edit.By by certain time
In interval, the situation of change of the data in the Table edit page is stored in preset data, records user in Table edit process
In operating procedure pass through preset group when needing that the operating procedure during Table edit is retracted or reformed
The data of record are realized fast fallback or are reformed.
Preset group is the temporary memory space by server-side for each user distribution, and the size of preset group can basis
Grouping belonging to user and it is different, for example, registration user preset group be greater than anonymous.The size of preset group is by individual
All cells can receive the sum of byte number of user's input to determine in table.For example, if being comprising ranks number in table
26, then the table unit lattice quantity is 676；The byte number that each cell can receive user's input is 512 bytes, then whole table institute
Occupied space size is 338M byte when having cell to fill up, and the size of preset group can take the integral multiple of 338M byte.
Specifically, by taking individual table maximum occupies memory space as 338M byte as an example, server-side will be under JS script catalogue
Client script be sent to client executing, be the size that user distributes preset group be 1014M byte, and by Table edit
Data in the page are saved in preset group as first element of preset group.
S10: with the second prefixed time interval, using the data got from the Table edit page as current data, and
The difference set of current data and basic table is saved in preset group.
Second prefixed time interval is by the time interval of default setting in JS script.Preferably, between the second preset time
It is divided into 1 second.
Current data and the difference set of basic table are data and base in all cells in active sheet edit page
The difference set set of data in plinth table in all cells.For example, if having cell 676 in basic table, wherein
Have cell 20 of user input data, user increases the data of 10 cells in subsequent editing process, then when
Preceding data and the difference set of basic table are the data in subsequent increased 10 cells of user；If user is in subsequent editor
The data of 5 cells are deleted in journey, then current data and the difference set of basic table are 5 cells that user then deletes
Data.
Specifically, the client script under JS script catalogue is sent client executing by server-side, if second it is default when
Between between be divided into 1 second, then every 1 second, client first obtains the data in active sheet edit page in all cells, then
The difference set of current data and basic table is calculated, and difference set is successively added in preset group.
In the present embodiment, be basic table by the data markers in the Table edit page, and save with second it is default when
Between interval acquiring the Table edit page in data and basic table difference set, grasped in editing process to have recorded user
The step of making, when user needs to retract to edit step or reform during Table edit, server-side can pass through
The step of recording in preset group is rapidly completed rollback or reforms function, to further improve the function of online Table edit.
Further, in one embodiment, as shown in figure 5, after step S9, and before step S 4, i.e., by table
Data markers in lattice edit page are basic table, and are saved in using basic table as first element of preset group pre-
If after array, and receiving the data submission request of client transmission, and obtain the data for including in data submission request
Before submitting identification information, online Table edit method further includes following steps:
S11: interim array is established, and is saved in interim array for basic table as first element of interim array.
Interim array is used to save the median occurred in calculating process, and destroyed after calculating process completion, releases
Put memory headroom.The size of interim array can be set in individual table the whole of the sum of byte shared by data in all cells
Several times.
Specifically, interim array space is distributed for user, and is protected basic table as first element of interim array
It is stored to interim array.
S12: it with the second prefixed time interval, is saved the data got from the Table edit page as current data
To interim array, and by the difference between current data and previous element adjacent with the element where current data in interim array
Collection is saved in preset group.
Second prefixed time interval is by the time interval of default setting in JS script.Preferably, between the second preset time
It is divided into 1 second.
For example, first element of interim array is basic table, if the second prefixed time interval is 1 second, the 1st
After second, client first obtains the data in active sheet edit page in all cells, and adds as current data
Into interim array, become second element of interim array；Then the difference between second element and first element is calculated
Collect and difference set is added in preset group.After 2nd second, client obtains all units in active sheet edit page again
Data in lattice, and be added in interim array as current data, become the third element of interim array；Then is calculated
Difference set is simultaneously added in preset group by difference set between three elements and second element.And so on, with second it is default when
Between be spaced, be saved in interim array using the data got from the Table edit page as current data, and by current data
Difference set between previous element adjacent with the element where current data in interim array is saved in preset group.
Specifically, the client script under JS script catalogue is sent client executing by server-side, if second it is default when
Between between be divided into 1 second, then every 1 second, client first obtains the data in active sheet edit page in all cells and adds
It is added to interim array, is then calculated between the previous element adjacent with the element where current data of current data in interim array
Difference set, and difference set is successively added in preset group.
In the present embodiment, the intermediate variable calculated by establishing interim array caching, saves in adjacent time inter
The difference set of data in the Table edit page realizes user and edits to have recorded the step of user operates in editing process
The rollback of step and the function of reforming.Simultaneously as in adjacent time inter in the Table edit page difference set of data variation
It is smaller relative to current data and the difference set of basic table, to save the memory space of preset group.
Further, in one embodiment, as shown in fig. 6, being directed to step S5, i.e., the data in the Table edit page are protected
It is stored in database corresponding with data submission identification information, can specifically include following steps:
S51: according to preset data type, validity checking is carried out to the data in the Table edit page.
Preset data type be in the Table edit page to user input data made by type limit.Preset data class
Type includes character type, integer, Boolean type, date format type and customization type etc..
Validity checking includes whether the data in the inspection to data type, such as the Table edit page belong to character
Type, integer, Boolean type, date format type etc.；Validity checking can also include carrying out to the data in the Table edit page
Application-level logic inspection, such as check that the employee performance data that client is submitted whether there is exception, hence it is evident that do not meet practical feelings
Condition.
Client script and server side script may be implemented to the data line validity checking in the Table edit page.Tool
Body, by taking server side script as an example, server-side first obtains the data in the Table edit page, for example including employee registration date,
Default date format type is compared on the registration date by server side script with employee, and is operated according to result is further.
S52: if data and preset data Type-Inconsistencies in the Table edit page, data is issued to client and are submitted
Failed message.
Data submit failed message for informing that the reason of client data submits failure, such as data format are not inconsistent, count
According to over range etc..Data submit the mode that failed message can be by way of showing error coded or simple text describes to send out
It is sent to client.For example, 404 mistakes being commonly encountered in browsing webpage, 501 mistakes etc..
Specifically, if data in the Table edit page and preset data Type-Inconsistencies, server side script or client
Script can will be sent to client with the ranks number where the cell of preset data Type-Inconsistencies, and prompt correctly number
According to type.
S53: if the data in the Table edit page are consistent with preset data type, by the data in the Table edit page
It is saved in database corresponding with data submission identification information.
If the data in the Table edit page are consistent with preset data type, server side script or client script can lead to
Data in the Table edit page are saved in by the Applied layer interface for crossing calling database submits identification information corresponding with data
In database.
In the present embodiment, it is legal to be carried out by server side script or client script to the data in the Table edit page
Property inspection, wherein include mainly inspection to data type, and data storage or refusal carried out according to the result of validity checking
The submission of client is requested, and the data submitted to client are screened, and has ensured that client submits the legitimacy of data, into
The perfect function of online Table edit service of one step.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
In one embodiment, a kind of online Table edit device is provided, the online Table edit device and above-described embodiment
In online Table edit method correspond.As shown in fig. 7, the online Table edit device includes login authentication module 71, page
Face sending module 72 automatically saves module 73, authentication module 74 and data is submitted to submit module 75.Each functional module is described in detail
It is as follows:
Login authentication module 71, if the logging request for receiving client transmission, includes according in logging request
User identity information to user carry out authentication, and according to the result of authentication obtain user belonging to user group；
Page sending module 72, for sending client for the Table edit page corresponding with user group；
Module 73 is automatically saved, for receiving the data in the Table edit page with the first prefixed time interval, and is saved
To storage platform, wherein storage platform is for storing the data that user edits；
Authentication module 74 is submitted, for receiving the data submission request of client transmission, and is obtained in data submission request
The data for including submit identification information；
Data submit module 75, submit identification information corresponding to data for being saved in the data in the Table edit page
Database in, wherein database be used for store user submission data.
Further, online Table edit device further include:
Export request module is received, for receiving the data export request of client transmission, and obtains data export request
In file type and storage location information；
Data conversion module, for obtaining the corresponding coding mode of file type, and by the data in the Table edit page
It is converted into and the matched document data flow of coding mode；
Data export module, for document data flow to be saved in the specified storage location of storage location information.
Further, online Table edit device further include:
Basic table labelling module, for being basic table by the data markers in the Table edit page, and by underlying table
Lattice are saved in preset group as first element of preset group；
First difference set computing module is used for the second prefixed time interval, the number that will be got from the Table edit page
Preset group is saved according to as current data, and by the difference set of current data and basic table.
Further, online Table edit device further include:
Ephemeral data establishes module, for establishing interim array, and using basic table as first member of interim array
Element is saved in interim array；
Second difference set computing module is used for the second prefixed time interval, the number that will be got from the Table edit page
It is saved in interim array according to as current data, and current data is adjacent with the element where current data with interim array
Previous element between difference set be saved in preset group.
Further, data submission module 75 includes:
Validity checking submodule, for according to preset data type, it to be legal to carry out to the data in the Table edit page
Property inspection；
Submission unsuccessfully alerts submodule, if for data and preset data Type-Inconsistencies in the Table edit page,
Data, which are issued, to client submits failed message；
Data submit submodule, if the data in the Table edit page are consistent with preset data type, by table
Data in edit page are saved in database corresponding with data submission identification information.
Specific about online Table edit device limits the limit that may refer to above for online Table edit method
Fixed, details are not described herein.Modules in above-mentioned online Table edit device can fully or partially through software, hardware and its
Combination is to realize.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also be with
It is stored in the memory in computer equipment in a software form, in order to which processor calls the above modules of execution corresponding
Operation.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 8.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The network interface of machine equipment is used to communicate with external terminal by network connection.When the computer program is executed by processor with
Realize a kind of online Table edit method.
In one embodiment, a kind of computer equipment is provided, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, processor realize online table in above-described embodiment when executing computer program
The step of edit methods, such as step S1 shown in Fig. 2 to step S5.Alternatively, processor is realized when executing computer program
State the function of each module/unit of online Table edit device in embodiment, such as module 71 shown in Fig. 7 is to the function of module 75
Energy.To avoid repeating, which is not described herein again.
In one embodiment, a computer readable storage medium is provided, computer program, computer program are stored thereon with
Online Table edit method in above method embodiment is realized when being executed by processor, alternatively, the computer program is by processor
The function of each module/unit in online Table edit device in above-mentioned apparatus embodiment is realized when execution.To avoid repeating, here
It repeats no more.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function
Can unit, module division progress for example, in practical application, can according to need and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of described device is divided into different functional unit or module, more than completing
The all or part of function of description.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although referring to aforementioned reality
Applying example, invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features；And these are modified
Or replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of online Table edit method, which is characterized in that the online Table edit method includes:
If the logging request of client transmission is received, according to the user identity information for including in the logging request to described
User carry out authentication, and according to the result of authentication obtain the user belonging to user group；
The client is sent by the Table edit page corresponding with the user group；
With the first prefixed time interval, the data in the Table edit page are received from client, and be saved in storage platform,
Wherein, the storage platform is for storing the data that user is edited in the Table edit page of client；
The data submission request that the client is sent is received, and obtains the data for including in the data submission request and submits mark
Know information；
Data in the Table edit page are saved in database corresponding with data submission identification information,
In, the database is used to store the data of user's submission.
2. Table edit method as described in claim 1 online, which is characterized in that it is described will be in the Table edit page
After data are saved in database corresponding with data submission identification information, the online Table edit method is also wrapped
It includes:
The data export request that the client is sent is received, and obtains the file type and storage in the data export request
Location information；
Obtain the corresponding coding mode of the file type, and by the data conversion in the Table edit page at the volume
The code matched document data flow of mode；
The document data flow is saved in the specified storage location of the storage location information.
3. Table edit method as described in claim 1 online, which is characterized in that it is described will table corresponding with the user group
Lattice edit page is sent to after the client, and in the data submission request for receiving the client and sending, and
Before obtaining the data submission identification information for including in the data submission request, the online Table edit method further include:
It is basic table by the data markers in the Table edit page, and using the basic table as the of preset group
One element is saved in the preset group；
With the second prefixed time interval, using the data got from the Table edit page as current data, and by institute
The difference set for stating current data and the basic table is saved in the preset group.
4. Table edit method as claimed in claim 3 online, which is characterized in that it is described will be in the Table edit page
Data markers are basic table, and are saved in the preset group using the basic table as first element of preset group
Later, it and in the data submission request for receiving the client and sending, and obtains in the data submission request and includes
Data submit identification information before, the online Table edit method further include:
Interim array is established, and is saved in the nonce using the basic table as first element of the interim array
Group；
With second prefixed time interval, using the data got from the Table edit page as the current data
Be saved in the interim array, and by the current data in the interim array with the element phase where the current data
Difference set between adjacent previous element is saved in the preset group.
5. Table edit method as described in claim 1 online, which is characterized in that it is described will be in the Table edit page
Data are saved in database corresponding with data submission identification information, comprising:
According to preset data type, validity checking is carried out to the data in the Table edit page；
If data and the preset data Type-Inconsistencies in the Table edit page issue data to the client
Submit failed message；
If the data in the Table edit page are consistent with the preset data type, will be in the Table edit page
Data are saved in database corresponding with data submission identification information.
6. a kind of online Table edit device, which is characterized in that the online Table edit device, comprising:
Login authentication module, if the logging request for receiving client transmission, includes according in the logging request
User identity information to the user carry out authentication, and according to the result of authentication obtain the user belonging to user
Group；
Page sending module, for sending the client for the Table edit page corresponding with the user group；
Module is automatically saved, for receiving the data in the Table edit page, and be saved in the first prefixed time interval
Storage platform, wherein the storage platform is for storing the data that user edits；
Authentication module is submitted, the data submission request sent for receiving the client, and obtain the data submission request
In include data submit identification information；
Data submit module, submit identification information phase with the data for being saved in the data in the Table edit page
In the database answered, wherein the database is used to store the data of user's submission.
7. online Table edit device as claimed in claim 6, which is characterized in that the online Table edit device also wraps
It includes:
Export request module is received, the data export request sent for receiving the client, and obtain the data export
File type and storage location information in request；
Data conversion module is used for according to the file type, by the data conversion in the Table edit page at number of files
According to stream；
Data export module, for the document data flow to be saved in the specified storage location of the storage location information.
8. online Table edit device as claimed in claim 6, which is characterized in that the online Table edit device also wraps
It includes:
Basic table labelling module, for being basic table by the data markers in the Table edit page, and by the base
Plinth table is saved in the preset group as first element of preset group；
Difference set computing module, for the second prefixed time interval, the data got from the Table edit page to be made
For current data, and the difference set of the current data and the basic table is saved in the preset group.
9. a kind of computer equipment, including memory, processor and storage are in the memory and can be in the processor
The computer program of upper operation, which is characterized in that the processor realized when executing the computer program as claim 1 to
The step of any one of 5 online Table edit method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In realizing the online Table edit method as described in any one of claim 1 to 5 when the computer program is executed by processor
Step.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811250255.8A CN109558575B (en) | 2018-10-25 | 2018-10-25 | Online form editing method, online form editing device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811250255.8A CN109558575B (en) | 2018-10-25 | 2018-10-25 | Online form editing method, online form editing device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109558575A true CN109558575A (en) | 2019-04-02 |
| CN109558575B CN109558575B (en) | 2024-03-29 |
Family
ID=65865250
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811250255.8A Active CN109558575B (en) | 2018-10-25 | 2018-10-25 | Online form editing method, online form editing device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109558575B (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110119489A (en) * | 2019-04-16 | 2019-08-13 | 深圳壹账通智能科技有限公司 | The automatic register method of information, device, computer equipment and storage medium |
| CN110119502A (en) * | 2019-05-13 | 2019-08-13 | 江西金格科技股份有限公司 | A method of dynamic table single domain is realized based on OFD document |
| CN110162373A (en) * | 2019-05-28 | 2019-08-23 | 阿里巴巴集团控股有限公司 | The method and device of chart is shown in webpage |
| CN110196971A (en) * | 2019-04-23 | 2019-09-03 | 平安科技（深圳）有限公司 | Online document edit methods, device, terminal device and storage medium |
| CN110704573A (en) * | 2019-09-04 | 2020-01-17 | 平安科技（深圳）有限公司 | Directory storage method and device, computer equipment and storage medium |
| CN110795651A (en) * | 2019-09-26 | 2020-02-14 | 北京淇瑀信息科技有限公司 | Method and device for saving front-end data and electronic equipment |
| CN111339087A (en) * | 2020-02-20 | 2020-06-26 | 重庆锐云科技有限公司 | Method for automatically exporting real estate marketing data monitoring result report as Excel file |
| CN111460776A (en) * | 2020-03-12 | 2020-07-28 | 山东浪潮通软信息科技有限公司 | Method and device for designing contract form and generating contract text on line |
| CN111639118A (en) * | 2020-05-29 | 2020-09-08 | 金现代信息产业股份有限公司 | Dynamic generation method and system for test report of power equipment |
| WO2020238618A1 (en) * | 2019-05-31 | 2020-12-03 | 北京字节跳动网络技术有限公司 | Interactive information notification method, apparatus and device, and computer readable storage medium |
| CN112416329A (en) * | 2019-08-23 | 2021-02-26 | 上海幻电信息科技有限公司 | Data editing method and device and storage medium |
| CN112733503A (en) * | 2021-01-22 | 2021-04-30 | 浪潮卓数大数据产业发展有限公司 | Method for generating EXCEL based on HTML table of POI |
| CN113850067A (en) * | 2021-11-30 | 2021-12-28 | 天津联想协同科技有限公司 | Information collection method and device based on online editing, network disk and storage medium |
| CN115169302A (en) * | 2022-09-08 | 2022-10-11 | 天津联想协同科技有限公司 | Data collection method and device based on online form document and storage medium |
| CN115328363A (en) * | 2022-08-12 | 2022-11-11 | 深圳乐播科技有限公司 | File processing method, electronic equipment and related product |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101588350A (en) * | 2008-05-19 | 2009-11-25 | 北京亿企通信息技术有限公司 | Method and system for realizing file sharing |
| CN102193933A (en) * | 2010-03-10 | 2011-09-21 | 北大方正集团有限公司 | Method and system for webpage editing |
| CN102521407A (en) * | 2011-12-28 | 2012-06-27 | 谢勇 | Method for document collaboration among users |
| CN103077185A (en) * | 2012-12-18 | 2013-05-01 | 厦门雅迅网络股份有限公司 | Object-based user-defined information-expanding method |
| CN104090850A (en) * | 2014-06-24 | 2014-10-08 | 上海铀尼信息科技有限公司 | Online table system and data management method thereof |
-
2018
- 2018-10-25 CN CN201811250255.8A patent/CN109558575B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101588350A (en) * | 2008-05-19 | 2009-11-25 | 北京亿企通信息技术有限公司 | Method and system for realizing file sharing |
| CN102193933A (en) * | 2010-03-10 | 2011-09-21 | 北大方正集团有限公司 | Method and system for webpage editing |
| CN102521407A (en) * | 2011-12-28 | 2012-06-27 | 谢勇 | Method for document collaboration among users |
| CN103077185A (en) * | 2012-12-18 | 2013-05-01 | 厦门雅迅网络股份有限公司 | Object-based user-defined information-expanding method |
| CN104090850A (en) * | 2014-06-24 | 2014-10-08 | 上海铀尼信息科技有限公司 | Online table system and data management method thereof |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110119489A (en) * | 2019-04-16 | 2019-08-13 | 深圳壹账通智能科技有限公司 | The automatic register method of information, device, computer equipment and storage medium |
| CN110196971A (en) * | 2019-04-23 | 2019-09-03 | 平安科技（深圳）有限公司 | Online document edit methods, device, terminal device and storage medium |
| CN110119502A (en) * | 2019-05-13 | 2019-08-13 | 江西金格科技股份有限公司 | A method of dynamic table single domain is realized based on OFD document |
| CN110162373A (en) * | 2019-05-28 | 2019-08-23 | 阿里巴巴集团控股有限公司 | The method and device of chart is shown in webpage |
| CN110162373B (en) * | 2019-05-28 | 2022-07-19 | 创新先进技术有限公司 | Method and device for displaying chart in webpage |
| WO2020238618A1 (en) * | 2019-05-31 | 2020-12-03 | 北京字节跳动网络技术有限公司 | Interactive information notification method, apparatus and device, and computer readable storage medium |
| US11455463B2 (en) | 2019-05-31 | 2022-09-27 | Beijing Bytedance Network Technology Co., Ltd. | Facilitating user interaction in online spreadsheets |
| CN112416329A (en) * | 2019-08-23 | 2021-02-26 | 上海幻电信息科技有限公司 | Data editing method and device and storage medium |
| CN110704573A (en) * | 2019-09-04 | 2020-01-17 | 平安科技（深圳）有限公司 | Directory storage method and device, computer equipment and storage medium |
| CN110704573B (en) * | 2019-09-04 | 2023-12-22 | 平安科技（深圳）有限公司 | Catalog storage method, catalog storage device, computer equipment and storage medium |
| CN110795651A (en) * | 2019-09-26 | 2020-02-14 | 北京淇瑀信息科技有限公司 | Method and device for saving front-end data and electronic equipment |
| CN111339087A (en) * | 2020-02-20 | 2020-06-26 | 重庆锐云科技有限公司 | Method for automatically exporting real estate marketing data monitoring result report as Excel file |
| CN111460776A (en) * | 2020-03-12 | 2020-07-28 | 山东浪潮通软信息科技有限公司 | Method and device for designing contract form and generating contract text on line |
| CN111460776B (en) * | 2020-03-12 | 2024-03-15 | 浪潮通用软件有限公司 | Method and device for online designing contract form and generating contract text |
| CN111639118A (en) * | 2020-05-29 | 2020-09-08 | 金现代信息产业股份有限公司 | Dynamic generation method and system for test report of power equipment |
| CN112733503A (en) * | 2021-01-22 | 2021-04-30 | 浪潮卓数大数据产业发展有限公司 | Method for generating EXCEL based on HTML table of POI |
| CN113850067B (en) * | 2021-11-30 | 2022-03-15 | 天津联想协同科技有限公司 | Information collection method and device based on online editing, network disk and storage medium |
| CN113850067A (en) * | 2021-11-30 | 2021-12-28 | 天津联想协同科技有限公司 | Information collection method and device based on online editing, network disk and storage medium |
| CN115328363A (en) * | 2022-08-12 | 2022-11-11 | 深圳乐播科技有限公司 | File processing method, electronic equipment and related product |
| CN115328363B (en) * | 2022-08-12 | 2023-11-03 | 深圳乐播科技有限公司 | File processing method, electronic equipment and related products |
| CN115169302A (en) * | 2022-09-08 | 2022-10-11 | 天津联想协同科技有限公司 | Data collection method and device based on online form document and storage medium |
| CN115169302B (en) * | 2022-09-08 | 2022-12-09 | 天津联想协同科技有限公司 | Data collection method and device based on online form document and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109558575B (en) | 2024-03-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109558575A (en) | Online Table edit method, apparatus, computer equipment and storage medium | |
| CN110196971A (en) | Online document edit methods, device, terminal device and storage medium | |
| CN109948132A (en) | A kind of data of configuration template make a report on method and system | |
| CN108491475A (en) | Data rapid batch import method, electronic device and computer readable storage medium | |
| Ebrero et al. | The XMM-Newton serendipitous survey-VI. The X-ray luminosity function | |
| CN103077185B (en) | A kind of method of object-based self-defined extension information | |
| US8078986B1 (en) | Method and system for a browser module | |
| CN110427774A (en) | Data based on block chain deposit card method, data verification method and relevant apparatus | |
| US7644351B1 (en) | Data collection and processing system and methods | |
| CN107145480B (en) | Method for compiling XBRL report based on Word | |
| CN102117202B (en) | J2EE architecture-based code generating device | |
| CN103500196A (en) | EXCEL data export method and export device in multi-concurrence large data volume environment | |
| CN101021890A (en) | Method, system and server for checking page data | |
| CN109240692A (en) | A kind of method for building up and system of the web database exploitation based on common template | |
| CN104049972A (en) | Data verification method and system | |
| CN105224544A (en) | A kind of data editing method of database and device | |
| CN110008447A (en) | The processing method and processing device of electrical form | |
| CN104346407B (en) | Form and the method and its device of XML file data interaction in data reporting system | |
| CN104991785A (en) | Standardized clinical data service support system and method | |
| CN112131289A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN106777398A (en) | The generation method and device of a kind of csv file | |
| CN103020318A (en) | Method for maintenance of database tables in database | |
| AU2015331028A1 (en) | Electronic processing system for electronic document and electronic file | |
| CN109429260B (en) | Method and device for checking northbound data | |
| US8205010B1 (en) | User system applicaton interaction for a system as a service |
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 |