CN114118038A - Table document online editing method, device, equipment and medium - Google Patents
Table document online editing method, device, equipment and medium Download PDFInfo
- Publication number
- CN114118038A CN114118038A CN202111439518.1A CN202111439518A CN114118038A CN 114118038 A CN114118038 A CN 114118038A CN 202111439518 A CN202111439518 A CN 202111439518A CN 114118038 A CN114118038 A CN 114118038A
- Authority
- CN
- China
- Prior art keywords
- document
- data
- template
- client
- edited
- 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
Links
Images
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)
- Document Processing Apparatus (AREA)
Abstract
The invention relates to the field of data processing, and provides a method, a device, equipment and a medium for online editing of a form document, wherein the method comprises the following steps: acquiring a table document to be edited; analyzing a table document to be edited by using a document online editor to obtain template data and source data after the table document is analyzed; converting template data corresponding to a table document to be edited according to a parameter configuration file and displaying the template data into a client, converting a mapping relation between a metadata table in source data corresponding to the table document to be edited and fields in the metadata table, and correspondingly filling the converted data in the metadata table into a template in the client; the method and the device receive the editing operation of the target data in the client, update the target data by using the editing operation, and respectively store the updated target data.
Description
Technical Field
The invention relates to the field of data processing, and provides a table document online editing method, device, equipment and medium.
Background
Online editing is a client-side (web page) based component for online browsing and editing of tabular documents. The method used at present is a process of uploading a file to a cloud server, analyzing the file and editing a table document in a front-end display interface. For example, the need for online editing of form documents is often encountered in WEB projects and is often handled using software such as Tencent documents, Jinshan documents, graphite documents, google doc, and other open source excels.
However, when an existing form document is edited online, only a preset template in a client can be edited, once a user uses a locally uploaded Excel template, the current template cannot be edited, and meanwhile, data stored in the current template cannot be analyzed, so that the Excel scheme for online editing and analyzing is not strong in universality, and the problem that traditional local Excel data cannot be considered at the same time is solved.
Disclosure of Invention
The invention provides a method, a device, equipment and a medium for editing a table document on line, which mainly aim to analyze the table document to be edited and respectively store the analyzed table document according to template data and source data, wherein the template data and the source data are mutually associated, each Excel corresponds to different data tables, and corresponding fields are stored in the data tables; the method has the advantages that the specific template data uploaded locally are obtained, the form document to be edited is converted according to the template data and the source data, online preview, editing and dynamic analysis can be achieved in a web browser, meanwhile, the method has the advantages of being simple and convenient to use, fast and efficient in processing and the like, great convenience is brought to future project development, support is provided for an enterprise report platform and a data analysis platform, and form document processing capacity and processing efficiency are improved.
In order to achieve the above object, the present invention provides an online editing method for a table document, comprising:
acquiring a table document to be edited;
analyzing the table document to be edited by using a document online editor to obtain template data and source data after the table document is analyzed, wherein the template data stores each template and a corresponding template parameter configuration file, and the source data stores metadata in the corresponding template;
converting the template data corresponding to the table document to be edited according to a parameter configuration file and displaying the template data in a client, converting a metadata table in the source data corresponding to the table document to be edited and a mapping relation of fields in the metadata table, and correspondingly filling the converted data in the metadata table into a template in the client;
and receiving editing operation on the target data in the client, performing data updating on the target data by using the editing operation, and respectively storing the updated target data.
Optionally, before the obtaining of the table document to be edited, the method includes:
constructing a progressive framework of a user interface, and generating an external cascading style sheet and an external scripting language file of the user interface by using an online form component under the progressive framework;
determining a user-defined configuration item according to the external cascading style sheet and the external scripting language file;
configuring template parameters and themes in a template parameter configuration file table according to the user-defined configuration items to complete initialization;
and calling the initialized template data, and creating a data table in the database by using an online table component method to store table data.
Optionally, the converting the template data corresponding to the form document to be edited according to the parameter configuration file and displaying the template data in the client, converting the mapping relationship between the metadata table in the source data corresponding to the form document to be edited and the fields in the metadata table, and correspondingly filling the converted data in the metadata table into the template in the client includes:
creating a monitor according to the currently acquired external cascading style sheet, the external script language file and the acquired component name;
monitoring a local uploaded component of the current client by using the listener;
when a locally uploaded component is monitored, carrying out format conversion on the template data analyzed by the component according to a corresponding parameter configuration file, generating a template with online editing capability, and displaying the template in a client;
and carrying out batch conversion on the mapping relation between the metadata table in the source data analyzed by the component and the fields in the metadata table, and correspondingly filling the converted data in the metadata table to a template in a client.
Optionally, the receiving an editing operation on the target data in the client, performing data update on the target data by using the editing operation, and respectively storing the updated target data includes:
acquiring editing operation for processing target data in a client;
generating an editing instruction according to the type of the editing operation;
acquiring the position information of the target data in a client;
and updating the current target data according to the position information of the target data in the client according to the editing instruction, and respectively storing the updated target data according to template data and source data.
Optionally, the online editing method for a form document further includes:
acquiring template data and source data of a currently opened form document in a current client; the source data at least comprises a used document template number, an area number for identifying a table in the document template, name information and corresponding storage data;
when detecting that the current form document needs to be changed by a document template, carrying out region mapping on the content displayed by the current form document;
and copying the content of the current new document template according to the area mapping relation to generate a form document of the new document template.
Optionally, the online editing method for a form document further includes:
acquiring user names of all clients, and setting different editing authorities in a form document according to different user names of all the clients;
when an instruction of a new form document is received, generating a use authority table according to a user name of the new form document, and generating unique identification information with a hidden effect in the new form document;
detecting whether the user name corresponding to the current client has the authority for opening the form document or not by using the use authority table of the form document;
and when detecting that the user name corresponding to the current client does not have the right of opening the form document, encrypting the form document, sending information to a specific URL (uniform resource locator) address, and returning alarm information of information leakage.
Optionally, the online editing method for a form document further includes:
acquiring position information of each computational expression in a table document to be edited in the table document to be edited;
carrying out serialization processing on each computational expression to obtain a serialization value of each computational expression;
and updating the table document to be edited according to the serialized values of the calculation expressions and the corresponding position information.
In addition, to achieve the above object, the present invention provides an online editing apparatus for a table document, including:
the acquisition module is used for acquiring a table document to be edited;
the document analysis module is used for analyzing the table document to be edited by using a document online editor to obtain template data and source data after the table document is analyzed, wherein the template data stores each template and a corresponding template parameter configuration file, and the source data is metadata stored in the corresponding template;
the document conversion module is used for converting the template data corresponding to the table document to be edited into a client according to a parameter configuration file, converting a metadata table in the source data corresponding to the table document to be edited and a mapping relation of fields in the metadata table, and correspondingly filling the converted data in the metadata table into a template in the client;
and the document editing module is used for receiving the editing operation on the target data in the client, updating the data of the target data by using the editing operation, and respectively storing the updated target data.
Furthermore, to achieve the above object, the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and running on the processor, wherein the processor executes the computer program to implement the steps of the method according to any one of the above embodiments.
Furthermore, to achieve the above object, the present invention further provides a computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the steps of the method according to any one of the above embodiments.
The invention provides a form document online editing method, a form document online editing device, a form document online editor to analyze a form document to be edited to obtain template data and source data analyzed by the form document, wherein the template data stores each template and a corresponding template parameter configuration file, and the source data stores metadata in the corresponding template; the template data corresponding to the table document to be edited are converted and displayed in a client according to a parameter configuration file, a metadata table in the source data corresponding to the table document to be edited and the mapping relation of fields in the metadata table are converted, and the converted data in the metadata table are correspondingly filled in a template in the client, wherein the template data and the source data are correlated, each Excel corresponds to different data tables, and corresponding fields are stored in the data tables; the method has the advantages that the specific template data uploaded locally are obtained, the form document to be edited is converted according to the template data and the source data, online preview, editing and dynamic analysis can be achieved in a web browser, meanwhile, the method has the advantages of being simple and convenient to use, fast and efficient in processing and the like, great convenience is brought to future project development, support is provided for an enterprise report platform and a data analysis platform, and form document processing capacity and processing efficiency are improved.
Drawings
FIG. 1 is a flowchart illustrating a method for online editing of a table document according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating a document conversion process in the online editing method for a table document according to an embodiment of the present invention;
FIG. 3 is a schematic diagram illustrating a template replacement process in the online editing method for a form document according to an embodiment of the present invention;
FIG. 4 is a schematic view illustrating a leak detection process in a table document online editing method according to an embodiment of the present invention;
FIG. 5 is a schematic structural diagram of an online editing apparatus for table documents according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a computer device provided in an embodiment of the present invention.
The objects, features and advantages of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
To facilitate understanding of the present application, the concepts related to the present application will be explained first.
In an embodiment, a flow diagram of a method for online editing a table document provided in an embodiment of the present invention is shown in fig. 1, and the method includes the following steps:
step S101, obtaining a table document to be edited;
the type of the table document to be edited mainly includes two types, one type is a document ending with ". xls", the core structure of the table document is a composite document type structure, the other type is a document ending with ". xlsx", and the core structure of the table document is an XML type structure. Openxml can parse a form document by using a third-party open source library documentformat when the document is opened according to the document type, so that various attributes, styles, contents and the like in the document can be obtained. For example, the client, common web-Excel is Tencent document, Jinshan document, graphite document, google doc and other open source Excel, or the Office preview service (such as Google docs, Microsoft Office) is realized by converting form document to PDF, directly converting form document to html, and deploying Microsoft Office Online service (Office web apps) to realize Online preview. Excel to html can be converted to generate html files and the like through a third-party tool openoffice, microsoft office or a third-party library such as POI/NPOI, aspose.
It should be noted that, in the embodiment, the document to be edited is an Excel file uploaded in a third party form, and since the Excel file stored by the third party includes, but is not limited to, an epidemic prevention topic, an autumn admission topic, a research topic and an office topic according to the difference of the topic and the application scene, different and non-universal form document templates and corresponding data stored in the document templates are obtained according to the difference of the types of the topics.
Step S102, analyzing the table document to be edited by using a document online editor to obtain template data and source data after the table document is analyzed, wherein the template data stores each template and a corresponding template parameter configuration file, and the source data stores metadata in the corresponding template;
for example, Excel is spreadsheet software written by microsoft for users using Windows and Apple Macintosh operating systems, and has become the most popular data processing software at present due to advantages of intuitive interface, excellent computing function, and perfect graphical tool.
The method comprises the steps of analyzing a table document to be edited by a document online editor, namely an Excel online editor, generating a uniform standard data object according to different file types of the table document to be edited, and analyzing the standard data object in an online editing client, so that the table document can be displayed and edited in a WYSIWYG mode in a webpage of an internet browser of the online editing client.
Specifically, whether a document template of the form document to be edited belongs to a document template stored in template data in advance is judged, if yes, the document template is a general template, and if not, the document template is a customized template uploaded locally; when the document template of the form document to be edited is a locally uploaded customized template, analyzing template data and source data of the customized template by using a document online editor, wherein the source data in the embodiment is JSON data, and the template data and the source data are respectively stored through associated mapping.
Optionally, if the number of the current table document data to be edited exceeds a preset threshold, the Excel to be edited is processed by utilizing the browser multithreading, the overall analysis interaction process time is shortened by utilizing the browser multithreading technology and the xlsx analysis technology, and the load of the server is reduced.
Step S103, converting the template data corresponding to the table document to be edited into a client according to a parameter configuration file, converting a metadata table in the source data corresponding to the table document to be edited and a mapping relation of fields in the metadata table, and correspondingly filling the converted data in the metadata table into a template in the client;
in particular, JSON (JS Object Notation) is a lightweight data exchange format that stores and represents data in a text format that is completely independent of the programming language based on a subset of ECMAScript (JS specification set by the european computer association). The compact and clear hierarchy makes JSON an ideal data exchange language. The network transmission method is easy to read and write by people, and is easy to analyze and generate by machines, so that the network transmission efficiency can be effectively improved.
And step S104, receiving an editing operation on the target data in the client, performing data updating on the target data by using the editing operation, and respectively storing the updated target data.
Specifically, an editing operation for processing target data in a client is obtained; generating an editing instruction according to the type of the editing operation; acquiring the position information of the target data in a client; and updating the current target data according to the position information of the target data in the client according to the editing instruction, and respectively storing the updated target data according to template data and source data.
By the mode, the form document of the customized template can be dynamically analyzed, the stock data can be edited on line, and meanwhile, the capability of dynamically analyzing the file by the form document is improved. The dynamic analysis is to display the data of the analyzed xlsx file according to excel software layout, provide the capability of editing and modifying the data in real time and support to lock the regional data according to a fixed rule; the online editing is used for carrying out migration, conversion, deletion, screening and arrangement operations on data.
In the embodiment, compared with the traditional web project development, Excel online editing has no particularly good solution all the time, existing Excel-to-html can be used for webpage preview directly, but no method for realizing functions of editing, timely analyzing and the like is available, Excel data can be edited online, an analysis file can be dynamically configured, the method is suitable for most projects, the method has the characteristics of simplicity and convenience in use, rapidness and high efficiency in processing and the like, the functions are most abundant, the configuration and the use are simplest, great convenience is brought to the project development in the future, support is provided for an enterprise report platform and a data analysis platform, the development efficiency is improved, the development time is saved, tedious repeated labor force is reduced, the common functions of Excel, the data analysis, display and editing requirements are basically supported, the Excel files and the separated data of existing stock data only need to be stored in a document template first, then, the data is generated by the xml dynamic configuration query sql, which is very simple.
Optionally, in some embodiments, in order to better store the table, the configuration file, and the corresponding information, initialized data management needs to be performed, and before acquiring the table document to be edited, the method further includes:
step (1), constructing a progressive framework of a user interface based on vue.js, and generating an external cascading style sheet (CSS style) and a script language file (external JS file) of the user interface by using an online form component luckyshet under the progressive framework;
step (2), determining a user-defined configuration item according to the external cascading style sheet and the external scripting language file;
step (3), configuring template parameters and themes in a template parameter configuration file table according to the user-defined configuration items, and completing initialization;
and (4) calling the initialized template data, and creating a data table in the database by using an online table component method to store table data.
Js is a set of progressive frames for constructing a user interface, and Vue adopts a design developed in bottom-up increments, unlike other heavyweight frames; the core library only focuses on the view layer, is very easy to learn and is very easy to integrate with other libraries or existing projects. It can employ a single file component and a complex single page application of Vue ecosystem-supported library development; it has a simple, flexible API with the goal of implementing responsive data binding and composable view components through as simple an API as possible.
Specifically, when template management is performed, firstly, related js and CSS (external cascading style sheet and external scripting language file, namely, CSS file and scripting language file) are introduced under a folder of vue, a listener is created by uploading Id of a component, then, by using a conversion method transformexcelletelltolocky of LuckyExcel, a file of the uploading component is converted into a format which can be read by a front-end online form component, Data of a template is taken, finally, configuration items options are written, the Data is assigned to the options to be dynamically displayed, and after the template is modified online, the template Data is stored and stored in a database.
For example, the online form component is a front-end form library written in JavaScript, and can be embedded into any front-end project or application program, so that the functions of the original system can be enhanced, and Excel or other complex software is not required to be used for data processing. The data processing, analysis, display and storage can be completed by one system without switching platforms or systems, so that the integration and the full automation are facilitated.
For example, the style attribute may be used directly within the div tag, which may set the cascading style sheet; directly adding align attributes into the labels to enable the contents in the objects to have left, center and right effects; using id in div tag, on one hand, if it is JS special effect, it may be action script class identification function, on the other hand, the style selector style named with # number in CSS is usually set for object style usage; setting a title attribute for the div or other tags, and displaying prompt contents when the mouse is hovered over and hovers with the div or changes the object.
By the method, the template data corresponding to the current form document is configured according to the template parameter configuration file table by configuring the initialized template parameter configuration file table, so that the data stored in the template data can be processed conveniently, and the processing efficiency is greatly improved.
Optionally, the template data corresponding to the form document to be edited is converted and displayed in the client according to the parameter configuration file, the metadata table in the source data corresponding to the form document to be edited and the mapping relationship of the fields in the metadata table are converted, and the converted data in the metadata table is correspondingly filled in the template in the client, which is shown in detail in fig. 2, and is a schematic diagram of a document conversion process in the form document online editing method provided in an embodiment of the present invention, which is detailed as follows:
step S201, a monitor is created according to the currently acquired external cascading style sheet, the external script language file and the acquired component name;
step S202, monitoring the locally uploaded components of the current client by using the listener;
the current client is a current online editing client, and the locally uploaded components are table documents to be edited and displayed through a specific template.
Step S203, when the locally uploaded module is monitored, format conversion is carried out on the template data analyzed by the module according to the corresponding parameter configuration file, and a template with online editing capability is generated and displayed in a client;
the method comprises the steps that a current online editing client side monitors, when a form document to be edited is monitored to be a specific template, an online editing server is called to analyze the form document to be edited, the form document to be edited adopts a mode that source data and template data are respectively stored in an associated mode, format conversion is carried out on the analyzed template data according to a corresponding parameter configuration file, and the specific document template can be converted into a general template to be displayed.
Step S204, carrying out batch conversion on the mapping relation between the metadata table in the source data analyzed by the component and the fields in the metadata table, and correspondingly filling the converted data in the metadata table to a client internal template.
Specifically, converting according to a preset format according to a parameter configuration file table in the template data, generating an online edited template and displaying the online edited template to a webpage; and carrying out batch conversion according to a metadata table in the source data and the mapping relation of fields in the metadata table, and correspondingly filling the data in the metadata table into the webpage template.
For example, by reading an Excel form object; reading Excel cell merging information; reading Excel cell data and patterns; reading the position information and data of the Excel picture, carrying out batch conversion on a metadata table and the mapping relation of fields in the metadata table, and correspondingly filling the data in the metadata table into a webpage template.
It should be noted that, first, based on the vue framework, the script language file and the css file associated with the online form component are introduced, and then, the div is set and the related configuration item is created, and the container Id is set to be the same as the div palette Id, and a related data table is created in mysql (database) for storing form data, configuration files and other information. The method for importing the template includes two ways, namely directly uploading the document template, or directly creating the document template on a page for modification, writing a monitor in an uploading component at the front end by uploading the document template, calling a conversion method when modification operation captured by the monitor is performed, then obtaining converted source data by using a callback function, storing the converted source data into mysql, reading and assigning related cellData from a database by java when the front end vue is displayed, editing and displaying the table online, finally generating a file, and finally writing related analysis xml configuration, wherein the following rear end uses springboot, the database is mysql, and the front end vue is taken as an example for configuration, which is detailed as follows:
firstly, tables of three modules are established in a mysql database, template data are used for storing each template and corresponding template parameter configuration files, source data are used for storing metadata in the corresponding templates, the template parameter configuration files and the analysis metadata after analysis can be correspondingly stored with the template data and the source data, and the analysis tables can also be used for storing the template parameter configuration files and the analysis metadata.
When template management is carried out, firstly, related js and CSS (external cascading style sheet and external scripting language file, namely CSS file and scripting language file) are introduced under a folder of vue, a monitor is created through Id of an uploading component, then, by means of a conversion method of LuckyExcel, file of the uploading component is converted into a format which can be read by a front-end online form component, Data of a template is taken, finally, configuration items are compiled, Data are assigned to options to be dynamically displayed, and template Data can be stored and stored in a database after the template is modified online.
And thirdly, online compiling a configuration file, compiling xml analysis data and warehousing, wherein each different excel may correspond to different data tables of different backgrounds, and online compiling the xml configuration file, for example, < workbook name ═ > < sheet name > < sql > </sql > < row startIndex > < row > </sheet > and a specific sql statement in xml, defining a specific value of a certain row and directly storing the specific value in a database after definition.
Creating div and initializing excel, defining configuration items, requesting template data from a background to obtain template parameters, setting title and other parameters, creating a form through a create method, then displaying the template on a page, calling a stored data interface when modifying, simultaneously reading an analysis xml file by using a document online editor, calling a public xml analysis method, analyzing the xml, dynamically transmitting parameters of the data transmitted from an online editing client, generating sql, and finally inserting the sql into a corresponding data table. In order to obtain the data after relevant analysis, in another case, when some data already exist in the database (for example, part of the data is analyzed by using java before the project is made), the storage data is processed by configuring an initialized data configuration file to convert the analyzed data into a format capable of being identified.
By the mode, the template data and the source data are separately managed and stored, the form document template and the form document data can be edited online, the data can be modified according to the template, the data can be dynamically analyzed and configured, and the method is very flexible and efficient.
Optionally, an online document editor, that is, an online editing server is used, wherein the step of identifying the form document to be edited by using the online editing server is detailed as follows:
analyzing the table document by utilizing an online editing server to identify the type of the table document;
in the online editing server, converting a document element object in the form document into a corresponding source data object, called a first standard data object, according to the type of the form document, and storing the first standard data object in a source data exchange format;
transmitting the first standard data object from the online editing server to the online editing client through a WebSocket network communication protocol;
analyzing the first standard data object in the source data exchange format at the online editing client to generate a standard webpage document, and displaying the standard webpage document in the Internet browser;
editing the standard webpage document in the Internet browser at the online editing client;
converting the webpage element objects in the edited standard webpage document into corresponding source data objects, namely second standard data objects, at the online editing client;
and transmitting the second standard data object from the online editing client to the online editing server through a WebSocket network communication protocol.
In the online editing server, analyzing a second standard data object in the source data exchange format according to the type of the form document, converting the source data object of the second standard data object into a corresponding document element object, and generating an edited second document object;
in the online editing server, modifying the table document according to the edited second document object; setting a document version number for the modified form document in the online editing server;
and saving the new version of the form document.
In the embodiment, the form document is displayed and edited in the Internet browser in a WYSIWYG mode without converting a document template, so that the phenomenon that objects with different formats in the form document cannot be processed is overcome, and the efficiency of displaying and editing the form document is improved.
Optionally, referring to fig. 3 in detail, which is a schematic diagram of a template replacement flow in the form document online editing method provided in an embodiment of the present invention, the form document online editing method further includes:
step S301, acquiring template data and source data of a currently opened form document in a current client; the source data at least comprises a used document template number, an area number for identifying a table in the document template, name information and corresponding storage data;
specifically, because the template data is stored in association with the source data, the template data stores document templates with different numbers and template parameter configuration files corresponding to the document templates, wherein the source data includes the number of the document template used, the area number and name information identifying the table in the document template, and the storage data corresponding to the area number and name information, that is, the data stored in the source data is mapped in association with each row and each column of the table data corresponding to the template data, so as to ensure the accuracy of data storage.
Step S302, when detecting that the current form document needs to be changed by the document template, performing area mapping on the content displayed by the current form document;
specifically, by monitoring an instruction for replacing the document template used by the client, when the above situation is monitored, the area mapping is performed by using the display content (the whole text area) of the current form document, that is, the display area formed by several rows and columns of the document template occupied by the current display content forms an overall association mapping.
Step S303, according to the area mapping relation, the content of the current new document template is copied, and a form document of the new document template is generated.
Specifically, the form model is switched according to the area mapping relation, the data of the old document template is copied in the new document template, and manual data filling is avoided, so that the accuracy of the data after the document template is replaced is ensured.
In this embodiment, first, a data source of a current table area needs to be defined; according to the data source, defining a configuration table of a system table area, wherein the configuration table is used for identifying the information of the table including the area number and the name and the corresponding data source; selecting a form document template existing in the system, manually setting identifiable system record information for different positions of a form document in the system by matching with an online editing function of an online document editor, storing the form and the position information for later use, and jumping to a system form area and an EXCEL form area mapping function after storing; and finishing the mapping of the system table area and the EXCEL table area. The configuration table of the system table area can mark a single data source of the system table area, and when some table areas need to dynamically summarize some data, the configuration table also provides a user-defined access SQL and a storage process, so that the requirement of a complex data source is met. In the step of mapping the system table area and the EXCEL table area, the functions of viewing, modifying, saving and deleting the configuration relation of the table position mapping function operation are provided in a visual interface mode. Each system table area can be used in the table of the same table document for multiple times, the system automatically analyzes the table and area information in the table document into the corresponding system table area, and data is loaded through the data source specified by the area position.
Optionally, referring to fig. 4 in detail, in an embodiment of the present invention, a leak detection flow diagram in a table document online editing method is provided, where the table document online editing method further includes:
step S401, obtaining user names of all clients, and setting different editing authorities in table documents according to different user names of all the clients;
specifically, the clients log in through the terminal device, and after each client is authenticated through the account, the user is identified by corresponding unique identification code information, for example, the user can be distinguished by using a user name of the unique identification code information. For example, the user names corresponding to the clients are different, and different permissions are divided from high to low according to different job titles of the users.
It should be noted that, if the user a corresponds to the authority of the director, a form document 1 is created in the user a, and the user B corresponds to the authority of the department manager, in the form document 1, the user B can only edit the document data belonging to its own domain, and cannot modify the business data not belonging to its authority range, although the user a creates the form document 1, the factor influencing the authority of the user a is that the corresponding authority is the director, so that the user a can modify any business data of the form document 1 without limitation, and meanwhile, the data modification trace in the form document 1 is retained, which is beneficial to subsequent tracing back, and further standardizes the user editing operation.
By adopting the mode, on one hand, the data are ensured not to be randomly changed when the plurality of browser clients punch cards, and on the other hand, the reliability and the authenticity of editing the form document data are improved.
Step S402, when receiving an instruction of a new form document, generating a use authority table according to a user name of the new form document, and generating unique identification information with an invisible effect in the new form document;
specifically, any client has the authority to create the form document, and only the user objects of the new form document are different, which affects the authorities of other users, and is not listed here.
For example, a usage authority table is generated for a user name of a newly created form document, for example, the authority of each user is determined according to the division of authority, so as to generate and store the usage authority table, and at the same time, unique identification information with a stealth effect is generated, and the identification information is associated with and stores the currently newly created form document and is not displayed on the current client.
Step S403, detecting whether the user name corresponding to the current client has the authority to open the form document by using the use authority table of the form document;
specifically, the user authority table is matched with the user name corresponding to the current client, and if the user name corresponding to the current client exists in the user authority table, it is determined that the user name corresponding to the current client has the opening authority; and if the user name corresponding to the current client does not have the use authority table memory, determining that the user name corresponding to the current client does not have the opening authority.
And S404, when detecting that the user name corresponding to the current client does not have the right of opening the form document, encrypting the form document, sending information to a specific URL (uniform resource locator) address, and returning alarm information of information leakage.
Specifically, when a form document is opened, due to the fact that authority verification is needed, if a user name corresponding to a current client does not have the authority for opening the form document; the form document is encrypted using an encryption algorithm including, but not limited to, symmetric encryption, asymmetric encryption, digital signatures, and the like. The specific URL can be a preset company server website, a website of a safety management department and the like, staff in the company can be informed to process the leakage alarm information in time by returning the leakage alarm information, and meanwhile, the leakage condition can be tracked reversely by using the identification information to associate the client and the downloaded client.
In the embodiment, reading each browser ID, and setting different editing rights for the form document according to different corresponding IDs of each browser; the users of each browser are prevented from disorderly editing and altering the form document through the authority management, so that the authenticity of the form document data is reduced. For another example, if the editing right is divided according to the user responsibilities, the responsibilities of the user a include the responsibilities of the user B, that is, the job of the user a is higher than that of the user B; when detecting that the service data corresponding to the user A contains the service data of the user B, the browser belonging to the user A can edit the service data of the user B, otherwise, the browser corresponding to the user B can only edit the service data belonging to the browser.
It should be noted that, each time a user logs in a browser to use a form document edited online, each browser client has an ID correspondingly; for example, different rights can be set according to one of the parameters such as the responsibility, position, sex, age, etc. of the company where the ID is located, by the difference of the ID. For another example, if the user ID is "some in liu", the "some in liu" is set in the form document and can be edited according to the service data belonging to the user (different permissions are set in each row), and when it is detected that the mouse belonging to "some in liu" of the user is edited in the form document, if some in liu does not edit the service data belonging to the user, the editing operation is obviously not allowed due to different editing permissions; if the range of the editing operation clicked by the mouse belongs to the service range of the user, the user can edit the operation.
Optionally, when it is detected that a field in a certain column of a corresponding row in the form document is changed, the changed field history record is stored in the attribute corresponding to the field, because each row in the form document does not correspond to a corresponding role, that is, some fields in the form document cannot be attributed, the history record is stored by setting the attribute, which is convenient for tracking the change trace of the field.
By the method, different editing authorities can be set for the browsers of different users, and the phenomenon that the users have messy paint, messy drawing and unconscious change when editing the form document on line through the browsers is avoided.
In other embodiments, the form document is edited online, which is often very convenient and fast, however, the hidden danger of data security also exists, for example, downloading the edited form document or taking a picture of the edited form document for external transmission easily causes information leakage, and the key is that the leakage source cannot be traced.
For example, infrared refers to electromagnetic waves with a wavelength between 0.76 and 1000 micrometers, and identification information invisible to the naked eye and unique is generated by infrared, and the identification information can be watermarks, two-dimensional codes, bar codes, check codes and the like.
Specifically, a form document to be tracked is obtained, and unique identification information with an invisible function is generated in the form document to be tracked by infrared rays; embedding the identification information into a sheet table corresponding to the form document; storing the sheet table embedded with the identification information into the sheet data packet; and compressing the sheet data packet to obtain the to-be-tracked form document implanted with the tracking watermark.
The method comprises the steps that embedded hidden identification information is provided for a form document, when the form document embedded with the hidden identification information is opened, a request is automatically sent to a specific URL address, and a unique identification or other related information carrying the form document is returned, so that the tracking of the opening track of the form document is realized; when the file is divulged, the divulging tracing work can be completed in a short time according to the file opening track, so that the work difficulty of operators is reduced, the file divulging tracing speed and accuracy are improved, the leakage of the business sensitive file is effectively prevented, and the business data asset safety of a company is protected. Through returning the unique identifier carrying the form document or other related information, the tracking of the form document opening track can be obviously promoted through the mode. In addition, the watermark can be clearly seen through the camera, so that a divulgent can be warned conveniently.
By the mode, the online editing and using safety of the form document can be remarkably improved, and meanwhile, the data privacy, the data protection and the data tracing are greatly improved.
Optionally, in other embodiments, the table document usually includes a large number of calculation formulas, for example, operations such as summing and averaging some columns in the Excel table, when the table document includes a large number of calculation formulas, calculation is performed each time the user opens the table document, and when many calculation formulas need to be calculated, the speed of opening the table document is greatly slowed down, which results in a poor user experience, and the method for online editing of the table document further includes:
step a, acquiring the position information of each computational expression in a table document to be edited in the table document to be edited;
b, performing serialization processing on each computational expression to obtain a serialized value of each computational expression;
and c, updating the table document to be edited according to the serialized values of the calculation expressions and the corresponding position information.
Specifically, for example, a table document to be edited includes a plurality of tables, and a table includes a plurality of rows and columns, and each row-column intersection is a cell. According to the method and the device for searching the calculation expression in the cells of the target table document, the search of the calculation expression in the cells of the target table document can be quickly achieved by calling an existing class library, for example, a visual basic application language (VBA) class library, and the calculation expression can also be searched in a mode of traversing the cells of the table document to be edited.
For example, the data stored in the cell H9 in the table document to be edited is the calculation expression SUM (H1: H8) in which the calculated value calculated by the serialization processing calculation expression SUM (H1: H8) is 100, and the calculated value is replaced with the calculation value in the cell, for example, the calculation expression SUM (H1: H8) in the cell H9 is replaced with the calculated value 100. It should be noted that calculated values obtained by performing the serialization processing on other positions by using other calculation formulas are the same, and are not repeated herein.
By the mode, the calculation expression stored in the cell of the table document to be edited is replaced by the calculated calculation value, so that the loading time increased due to calculation of the calculation expression when the table document to be edited is opened can be avoided, and the speed of opening the table document containing a large number of calculation formulas is effectively improved.
The embodiment provides a table document online editing method, which obtains template data and source data after the table document is analyzed by using a document online editor, wherein the template data stores each template and a corresponding template parameter configuration file, and the source data stores metadata in the corresponding template; the template data corresponding to the table document to be edited are converted and displayed in a client according to a parameter configuration file, a metadata table in the source data corresponding to the table document to be edited and the mapping relation of fields in the metadata table are converted, and the converted data in the metadata table are correspondingly filled in a template in the client, wherein the template data and the source data are correlated, each Excel corresponds to different data tables, and corresponding fields are stored in the data tables; the method has the advantages that the specific template data uploaded locally are obtained, the form document to be edited is converted according to the template data and the source data, online preview, editing and dynamic analysis can be achieved in a web browser, meanwhile, the method has the advantages of being simple and convenient to use, fast and efficient in processing and the like, great convenience is brought to future project development, support is provided for an enterprise report platform and a data analysis platform, and form document processing capacity and processing efficiency are improved.
In one embodiment, the present invention further provides a table document online editing apparatus 500, referring to fig. 5, including:
an obtaining module 501, configured to obtain a table document to be edited;
it should be noted that, before the obtaining module 501, the method includes:
js, establishing a progressive framework of the user interface, and generating an external cascading style sheet and an external scripting language file of the user interface by using an online form component under the progressive framework;
determining a user-defined configuration item according to the external cascading style sheet and the external scripting language file;
configuring template parameters and themes in a template parameter configuration file table according to the user-defined configuration items to complete initialization;
and calling the initialized template data, and creating a data table in the database by using an online table component method to store table data.
A document analysis module 502, configured to analyze the form document to be edited by using a document online editor to obtain template data and source data after the form document is analyzed, where the template data stores each template and a corresponding template parameter configuration file, and the source data is metadata stored in a corresponding template;
the document conversion module 503 is configured to convert the template data corresponding to the form document to be edited according to the parameter configuration file and display the template data in the client, convert a metadata table in the source data corresponding to the form document to be edited and a mapping relationship between fields in the metadata table, and correspondingly fill the converted data in the metadata table into a template in the client;
it should be noted that the document conversion module 503 further includes:
creating a monitor according to the currently acquired external cascading style sheet, the external script language file and the acquired component name;
monitoring a local uploaded component of the current client by using the listener;
when a locally uploaded component is monitored, carrying out format conversion on the template data analyzed by the component according to a corresponding parameter configuration file, generating a template with online editing capability, and displaying the template in a client;
and carrying out batch conversion on the mapping relation between the metadata table in the source data analyzed by the component and the fields in the metadata table, and correspondingly filling the converted data in the metadata table to a template in a client.
The document editing module 504 is configured to receive an editing operation on target data in the client, perform data update on the target data by using the editing operation, and store the updated target data respectively.
By the mode, the form document of the customized template can be dynamically analyzed, the stock data can be edited on line, and meanwhile, the capability of dynamically analyzing the file by the form document is improved. The dynamic analysis is to display the data of the analyzed xlsx file according to excel software layout, provide the capability of editing and modifying the data in real time and support to lock the regional data according to a fixed rule; the online editing is used for carrying out migration, conversion, deletion, screening and arrangement operations on data.
It should be noted that the document editing module 504 further includes:
acquiring editing operation for processing target data in a client;
generating an editing instruction according to the type of the editing operation;
acquiring the position information of the target data in a client;
updating the current target data according to the position information of the target data in the client and the editing instruction, and respectively storing the updated target data according to template data and source data
Optionally, based on the foregoing embodiment, the online editing apparatus for table document further includes: a template replacement module, the template replacement module further comprising:
acquiring template data and source data of a currently opened form document in a current client; the source data at least comprises a used document template number, an area number for identifying a table in the document template, name information and corresponding storage data;
when detecting that the current form document needs to be changed by a document template, carrying out region mapping on the content displayed by the current form document;
and copying the content of the current new document template according to the area mapping relation to generate a form document of the new document template.
Optionally, based on the foregoing embodiment, the online editing apparatus for table document further includes: an information leakage detection module, the information leakage detection module further comprising:
acquiring user names of all clients, and setting different editing authorities in a form document according to different user names of all the clients;
when an instruction of a new form document is received, generating a use authority table according to a user name of the new form document, and generating unique identification information with a hidden effect in the new form document;
detecting whether the user name corresponding to the current client has the authority for opening the form document or not by using the use authority table of the form document;
and when detecting that the user name corresponding to the current client does not have the right of opening the form document, encrypting the form document, sending information to a specific URL (uniform resource locator) address, and returning alarm information of information leakage.
Optionally, based on the foregoing embodiment, the online editing apparatus for table document further includes: an information update module, the information update module further comprising:
acquiring position information of each computational expression in a table document to be edited in the table document to be edited;
carrying out serialization processing on each computational expression to obtain a serialization value of each computational expression;
and updating the table document to be edited according to the serialized values of the calculation expressions and the corresponding position information.
The embodiment provides a table document online editing device, which obtains template data and source data after the table document is analyzed by using a document online editor, wherein the template data stores each template and a corresponding template parameter configuration file, and the source data stores metadata in the corresponding template; the template data corresponding to the table document to be edited are converted and displayed in a client according to a parameter configuration file, a metadata table in the source data corresponding to the table document to be edited and the mapping relation of fields in the metadata table are converted, and the converted data in the metadata table are correspondingly filled in a template in the client, wherein the template data and the source data are correlated, each Excel corresponds to different data tables, and corresponding fields are stored in the data tables; the method has the advantages that the specific template data uploaded locally are obtained, the form document to be edited is converted according to the template data and the source data, online preview, editing and dynamic analysis can be achieved in a web browser, meanwhile, the method has the advantages of being simple and convenient to use, fast and efficient in processing and the like, great convenience is brought to future project development, support is provided for an enterprise report platform and a data analysis platform, and form document processing capacity and processing efficiency are improved.
It should be understood that the above table document online editing apparatus is substantially provided with a plurality of modules for executing the table document online editing method in any of the above embodiments, and specific functions and technical effects may refer to the above embodiments, which are not described herein again.
In an embodiment, referring to fig. 6, the embodiment further provides a computer device 600, which includes a memory 601, a processor 602, and a computer program stored on the memory and executable on the processor, and when the processor 602 executes the computer program, the steps of the method according to any one of the above embodiments are implemented.
In an embodiment, a computer-readable storage medium is also provided, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method according to any of the above embodiments.
The embodiment of the application can acquire and process related data based on an artificial intelligence technology. Among them, Artificial Intelligence (AI) is a theory, method, technique and application system that simulates, extends and expands human Intelligence using a digital computer or a machine controlled by a digital computer, senses the environment, acquires knowledge and uses the knowledge to obtain the best result.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, apparatus, article, or method that includes the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments. Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A method for online editing of a tabular document, the method comprising:
acquiring a table document to be edited;
analyzing the table document to be edited by using a table online editor to obtain template data and source data after the table document is analyzed, wherein the template data stores each template and a corresponding template parameter configuration file, and the source data stores metadata in the corresponding template;
converting the template data corresponding to the table document to be edited according to a parameter configuration file and displaying the template data in a client, converting a metadata table in the source data corresponding to the table document to be edited and a mapping relation of fields in the metadata table, and correspondingly filling the converted data in the metadata table into a template in the client;
and receiving editing operation on the target data in the client, performing data updating on the target data by using the editing operation, and respectively storing the updated target data.
2. The method for online editing of a form document according to claim 1, wherein before the obtaining of the form document to be edited, the method comprises:
constructing a progressive framework of a user interface, and generating an external cascading style sheet and an external scripting language file of the user interface by using an online form component under the progressive framework;
determining a user-defined configuration item according to the external cascading style sheet and the external scripting language file;
configuring template parameters and themes in a template parameter configuration file table according to the user-defined configuration items to complete initialization;
and calling the initialized template data, and creating a data table in the database by using an online table component method to store table data.
3. The form document online editing method of claim 2, wherein the converting the template data corresponding to the form document to be edited into a client according to a parameter configuration file, converting a mapping relationship between a metadata table in the source data corresponding to the form document to be edited and a field in the metadata table, and correspondingly filling the converted data in the metadata table into a template in the client comprises:
creating a monitor according to the currently acquired external cascading style sheet, the external script language file and the acquired component name;
monitoring a local uploaded component of the current client by using the listener;
when a locally uploaded component is monitored, carrying out format conversion on the template data analyzed by the component according to a corresponding parameter configuration file, generating a template with online editing capability, and displaying the template in a client;
and carrying out batch conversion on the mapping relation between the metadata table in the source data analyzed by the component and the fields in the metadata table, and correspondingly filling the converted data in the metadata table to a template in a client.
4. The form document online editing method of any one of claims 1 to 3, wherein the receiving of the editing operation on the target data in the client, performing data update on the target data by using the editing operation, and storing the updated target data respectively comprises:
acquiring editing operation for processing target data in a client;
generating an editing instruction according to the type of the editing operation;
acquiring the position information of the target data in a client;
and updating the current target data according to the position information of the target data in the client according to the editing instruction, and respectively storing the updated target data according to template data and source data.
5. The form document online editing method of any one of claims 1 to 3, further comprising:
acquiring template data and source data of a currently opened form document in a current client; the source data at least comprises a used document template number, an area number for identifying a table in the document template, name information and corresponding storage data;
when detecting that the current form document needs to be changed by a document template, carrying out region mapping on the content displayed by the current form document;
and copying the content of the current new document template according to the area mapping relation to generate a form document of the new document template.
6. The form document online editing method of claim 1, further comprising:
acquiring user names of all clients, and setting different editing authorities in a form document according to different user names of all the clients;
when an instruction of a new form document is received, generating a use authority table according to a user name of the new form document, and generating unique identification information with a hidden effect in the new form document;
detecting whether the user name corresponding to the current client has the authority for opening the form document or not by using the use authority table of the form document;
and when detecting that the user name corresponding to the current client does not have the right of opening the form document, encrypting the form document, sending information to a preset network address, and returning alarm information of information leakage.
7. The form document online editing method of claim 1, further comprising:
acquiring position information of each computational expression in a table document to be edited in the table document to be edited;
carrying out serialization processing on each computational expression to obtain a serialization value of each computational expression;
and updating the table document to be edited according to the serialized values of the calculation expressions and the corresponding position information.
8. An apparatus for online editing of a table document, the apparatus comprising:
the acquisition module is used for acquiring a table document to be edited;
the document analysis module is used for analyzing the table document to be edited by using a document online editor to obtain template data and source data after the table document is analyzed, wherein the template data stores each template and a corresponding template parameter configuration file, and the source data is metadata stored in the corresponding template;
the document conversion module is used for converting the template data corresponding to the table document to be edited into a client according to a parameter configuration file, converting a metadata table in the source data corresponding to the table document to be edited and a mapping relation of fields in the metadata table, and correspondingly filling the converted data in the metadata table into a template in the client;
and the document editing module is used for receiving the editing operation on the target data in the client, updating the data of the target data by using the editing operation, and respectively storing the updated target data.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 7 are implemented by the processor when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111439518.1A CN114118038A (en) | 2021-11-30 | 2021-11-30 | Table document online editing method, device, equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111439518.1A CN114118038A (en) | 2021-11-30 | 2021-11-30 | Table document online editing method, device, equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114118038A true CN114118038A (en) | 2022-03-01 |
Family
ID=80368440
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111439518.1A Pending CN114118038A (en) | 2021-11-30 | 2021-11-30 | Table document online editing method, device, equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114118038A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114676671A (en) * | 2022-03-09 | 2022-06-28 | 中国邮政储蓄银行股份有限公司 | Document online editing method and device and computer readable storage medium |
| CN114841127A (en) * | 2022-06-29 | 2022-08-02 | 天津联想协同科技有限公司 | Layer superposition method and device based on streaming electronic collaboration document |
| CN115328363A (en) * | 2022-08-12 | 2022-11-11 | 深圳乐播科技有限公司 | File processing method, electronic equipment and related product |
| CN115858984A (en) * | 2023-01-06 | 2023-03-28 | 三峡高科信息技术有限责任公司 | Method and system for dynamically generating form based on webpage end |
| CN117077650A (en) * | 2023-10-18 | 2023-11-17 | 金现代信息产业股份有限公司 | Document generation system, method, equipment and medium based on dynamic template configuration |
| CN118095242A (en) * | 2024-04-24 | 2024-05-28 | 航天宏图信息技术股份有限公司 | Method, device, equipment and medium for making document in real time based on BS frame |
-
2021
- 2021-11-30 CN CN202111439518.1A patent/CN114118038A/en active Pending
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114676671A (en) * | 2022-03-09 | 2022-06-28 | 中国邮政储蓄银行股份有限公司 | Document online editing method and device and computer readable storage medium |
| CN114841127A (en) * | 2022-06-29 | 2022-08-02 | 天津联想协同科技有限公司 | Layer superposition method and device based on streaming electronic collaboration document |
| 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 |
| CN115858984A (en) * | 2023-01-06 | 2023-03-28 | 三峡高科信息技术有限责任公司 | Method and system for dynamically generating form based on webpage end |
| CN117077650A (en) * | 2023-10-18 | 2023-11-17 | 金现代信息产业股份有限公司 | Document generation system, method, equipment and medium based on dynamic template configuration |
| CN117077650B (en) * | 2023-10-18 | 2024-02-06 | 金现代信息产业股份有限公司 | Document generation system, method, equipment and medium based on dynamic template configuration |
| CN118095242A (en) * | 2024-04-24 | 2024-05-28 | 航天宏图信息技术股份有限公司 | Method, device, equipment and medium for making document in real time based on BS frame |
| CN118095242B (en) * | 2024-04-24 | 2024-06-28 | 航天宏图信息技术股份有限公司 | Method, device, equipment and medium for making document in real time based on BS frame |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114118038A (en) | Table document online editing method, device, equipment and medium | |
| US10817613B2 (en) | Access and management of entity-augmented content | |
| US10255253B2 (en) | Augmenting and presenting captured data | |
| CN105230051A (en) | For the method for the collaborative authoring with editing function, device and computer-readable medium | |
| CN110069683B (en) | Method and device for crawling data based on browser | |
| US9959257B2 (en) | Populating visual designs with web content | |
| EP3021232A1 (en) | System and method for curation of content | |
| US20160259630A1 (en) | Systems, apparatus and methods for sharing visual model-based applications | |
| CN108595697B (en) | Webpage integration method, device and system | |
| CN103678487A (en) | Method and device for generating web page snapshot | |
| US10606935B2 (en) | Transforming a website for dynamic web content management | |
| CN107533544A (en) | Component identifier generates | |
| US20160034431A1 (en) | Method and system for assigning a content item as a link target to a managed object | |
| US11468228B2 (en) | Content frames for productivity applications | |
| US20230246924A1 (en) | Automatic canvas creation associated with a group-based communication channel | |
| KR19990027325A (en) | Apparatus for web document authoring and its operation method | |
| CN114528510A (en) | Webpage data processing method and device, electronic equipment and medium | |
| US20150261733A1 (en) | Asset collection service through capture of content | |
| US7590634B2 (en) | Detection of inaccessible resources | |
| Borum et al. | Spreadsheet Patents | |
| WO2017042836A1 (en) | A method and system for content creation and management | |
| JP2014081958A (en) | Annotation adding method, annotation restoring method, annotation adding device, and annotation restoring device | |
| CN114662465A (en) | Document processing method, device, equipment and system | |
| CN117910043A (en) | Electronic document information hiding depth mining method, system and device | |
| CN117112946A (en) | Footnote processing method, footnote processing device, footnote processing equipment and storage medium |
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 |