Complex table file multi-person cooperation method based on private cloud

Abstract

The invention provides a private cloud-based complex table file multi-person cooperation method. The method comprises the following steps: establishing a private cloud platform on a server with a public network ip address, uploading a to-be-processed table file to the private cloud platform of the server, converting the table file into a shared table file based on a website, and enabling the collaborator to access the shared form file through the website and processes the form file. According to the invention, the shared form file is stored in a private cloud server of a small and medium-sized company or a certain business department, so that the data security is ensured; only one small NAS server device needs to be purchased additionally, and the NAS server device can be used all the time after being purchased once, so that the cost is low; a collaborative editor of the form file only needs to copy a string of websites to the address bar of the browser, and the rest websites are the same as the local form file, so the operation is simple and convenient, and the use threshold is low. The shared document format used in the method perfectly supports the Excel form file, seamless conversion is achieved, and any data, reference and link are not lost.

Description

technical field

[0001] The invention relates to the technical field of multi-person collaborative table processing, in particular to a private cloud-based multi-person collaborative method for complex table files. Background technique

[0002] Excel has been very mature as a tool and means for data statistics, analysis and processing. It has good compatibility, rich expansion capabilities, powerful formula editing capabilities, and can easily realize mutual reference and calculation between cells, workbooks and even files.

[0003] With the development of the times, technology is changing with each passing day, especially in the context of the current global epidemic, telecommuting has increasingly become an indispensable way of working, but if you want to use the traditional local area network of a small and medium-sized company or a business department to collaborate Problems arise when the large and complex Excel spreadsheet files formed by the model are put on the publi...

Examples

Embodiment approach

[0023] A more specific implementation is as follows:

[0024] 1. Purchase a NAS private cloud server, install the server system, configure server-side accounts and permissions, install server-side software suites, apply for public network ip addresses, and configure server local and public network access addresses. After completion, test to test server security, local and public network access reliability.

[0025] 2. According to business needs, the administrator uploads the large form file to be collaborated to the NAS private cloud server, and then clicks to convert it into a shared Office file. After completion, configure the shared Office file collaboration method, collaborator permissions, collaboration password, and generate a collaboration URL, etc.

[0026] 3. The administrator copies the collaboration URL, and then distributes the collaboration URL and collaboration password to the collaborative editors of the document in a reliable manner. The collaborators access t...

technical field

[0001] The invention relates to the technical field of multi-person collaborative table processing, in particular to a private cloud-based multi-person collaborative method for complex table files. Background technique

[0002] Excel has been very mature as a tool and means for data statistics, analysis and processing. It has good compatibility, rich expansion capabilities, powerful formula editing capabilities, and can easily realize mutual reference and calculation between cells, workbooks and even files.

[0003] With the development of the times, technology is changing with each passing day, especially in the context of the current global epidemic, telecommuting has increasingly become an indispensable way of working, but if you want to use the traditional local area network of a small and medium-sized company or a business department to collaborate Problems arise when the large and complex Excel spreadsheet files formed by the model are put on the publi...

Examples

Embodiment approach

[0023] A more specific implementation is as follows:

[0024] 1. Purchase a NAS private cloud server, install the server system, configure server-side accounts and permissions, install server-side software suites, apply for public network ip addresses, and configure server local and public network access addresses. After completion, test to test server security, local and public network access reliability.

[0025] 2. According to business needs, the administrator uploads the large form file to be collaborated to the NAS private cloud server, and then clicks to convert it into a shared Office file. After completion, configure the shared Office file collaboration method, collaborator permissions, collaboration password, and generate a collaboration URL, etc.

[0026] 3. The administrator copies the collaboration URL, and then distributes the collaboration URL and collaboration password to the collaborative editors of the document in a reliable manner. The collaborators access t...