WO2019223091A1 - 工作簿处理方法、装置、计算机设备和存储介质 - Google Patents

工作簿处理方法、装置、计算机设备和存储介质 Download PDF

Info

Publication number
WO2019223091A1
WO2019223091A1 PCT/CN2018/096906 CN2018096906W WO2019223091A1 WO 2019223091 A1 WO2019223091 A1 WO 2019223091A1 CN 2018096906 W CN2018096906 W CN 2018096906W WO 2019223091 A1 WO2019223091 A1 WO 2019223091A1
Authority
WO
WIPO (PCT)
Prior art keywords
worksheet
workbook
thumbnail
identifier
tab
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.)
Ceased
Application number
PCT/CN2018/096906
Other languages
English (en)
French (fr)
Inventor
李泳章
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Publication of WO2019223091A1 publication Critical patent/WO2019223091A1/zh
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor

Definitions

  • the present application relates to a workbook management method, device, computer equipment, and storage medium.
  • a user after editing a workbook, a user usually needs to manage the edited workbook according to the user's permissions, such as judging whether the edited workbook needs to be synchronized and updated online and whether other users can access it.
  • the management staff facing the huge amount of data on the data management platform, it usually takes a lot of time for the management staff to manage, resulting in very low data management efficiency.
  • a workbook management method, apparatus, computer device, and storage medium are provided.
  • a workbook management method includes:
  • a workbook processing device includes:
  • An update request receiving module configured to receive a workbook update request and a worksheet to be updated sent by a user terminal, where the workbook update request carries a workbook identifier and a current login account;
  • a source folder search module configured to find a source folder corresponding to the workbook identifier
  • An editing permission obtaining module configured to obtain the editing permission corresponding to the current login account
  • a folder filtering module configured to filter a first folder matching the editing permission from the source file
  • a workbook update module is configured to update an original workbook corresponding to the workbook identifier in the first folder according to the worksheet to be updated.
  • a computer device includes a memory and one or more processors.
  • the memory stores computer-readable instructions.
  • the one or more processors are executed. The following steps:
  • One or more non-volatile computer-readable storage media storing computer-readable instructions.
  • the one or more processors execute the following steps:
  • FIG. 1 is an application scenario diagram of a workbook processing method according to one or more embodiments.
  • FIG. 2 is a schematic flowchart of a workbook processing method according to one or more embodiments.
  • FIG. 3 is a schematic flowchart of a workbook processing method in another embodiment.
  • FIG. 4 is a block diagram of a workbook processing apparatus according to one or more embodiments.
  • FIG. 5 is a block diagram of a computer device according to one or more embodiments.
  • the workbook processing method provided in this application can be applied to the application environment shown in FIG. 1.
  • the user terminal communicates with the server through the network.
  • the user terminal sends a workbook update request and a worksheet to be updated to the server.
  • the server reads the workbook identifier and the current login account carried in the request, and the server searches for the source folder corresponding to the workbook identifier and obtains the current login account
  • the server filters the first folder matching the editing permissions from the source folder, and updates the original workbook corresponding to the workbook identifier in the first folder according to the worksheet to be updated.
  • the user terminal may be, but is not limited to, various personal computers, notebook computers, smart phones, and tablet computers.
  • the server may be implemented by an independent server or a server cluster composed of multiple servers.
  • a workbook processing method is provided.
  • the method is applied to the server in FIG. 1 as an example, and includes the following steps:
  • Step 210 Receive a workbook update request and a worksheet to be updated sent by the user terminal.
  • the workbook update request carries a workbook identifier and a current login account.
  • a workbook is a file used to store and process work data, such as an excel file.
  • the workbook identifier is used to uniquely identify the workbook.
  • the workbook identifier can be, but is not limited to, the file name, code, and number.
  • a workbook can consist of multiple worksheets.
  • a worksheet is a data table displayed in a workbook window. Each worksheet also has a worksheet identifier that uniquely identifies it. The work of all worksheets corresponding to the same workbook.
  • the table ID is associated with the corresponding workbook ID.
  • the server is a public data management platform that uniformly manages each user's workbook. Users can log in and access the public data management platform through the user terminal, and perform online viewing, modification, and editing operations on the platform's workbook. The user can save the workbook on the management platform locally in the user terminal or save it to another path address. When the user terminal detects the save as operation of the user, the user terminal determines whether the data content of the workbook that the user performed the save as has changed from the original workbook.
  • the user terminal determines that the data content of the saved workbook has changed from the original workbook, that is, the user edits and updates the original workbook
  • the user terminal looks for the modification work with the changed data content from the saved workbook Table, and obtain the user ’s current login account, generate a workbook update request based on the workbook ID of the saved workbook and the current login account, and send the workbook update request and the modified worksheet to the server so that the server
  • the worksheet updates a worksheet corresponding to the modified worksheet stored on the server.
  • the user terminal before the user terminal determines whether the data content of the workbook saved by the user as compared to the original workbook changes, the user terminal obtains the current login account, and marks the corresponding workbook with the corresponding account according to the current login account. Mark, and save the workbook as the account ID corresponding to the mark according to the save as path.
  • the user terminal obtains a preset time. When the preset time is reached, the user terminal judges whether the save as workbook marked with the corresponding account ID is successfully saved.
  • the user terminal determines that the save of the workbook fails, the user terminal continues to perform the step of identifying the account of the saved workbook according to the current login account; when the user terminal evaluates that the workbook is saved as successful, the user terminal judges the user for saving Steps to determine whether the data content of the workbook has changed relative to the original workbook.
  • the user terminal automatically detects whether the workbook is successfully saved, thereby ensuring that the workbook can be saved to a storage location corresponding to the save as path.
  • the server receives the workbook update request and the modified worksheet sent by the user terminal.
  • the modified worksheet is the worksheet to be updated.
  • the server reads the workbook identifier and the current login account from the workbook update request.
  • Step 220 Find a source folder corresponding to the workbook identifier.
  • the server stores workbooks in categories. You can store workbooks in folders corresponding to their properties based on the data content of the workbook, the business category to which they belong, and other attributes. The same workbook may be stored in multiple folders. Each folder can be called a source folder. The server finds the source folder corresponding to the workbook according to the workbook identifier. The source folder found may be one or multiple.
  • Step 230 Obtain editing rights corresponding to the currently logged in account.
  • the server sets user permissions in advance, and the specific set permissions may include, but is not limited to, the user's permission to view, edit, and audit data.
  • the server sets the operation level of the operation authority for the user, such as high, intermediate, and low. The higher the level, the greater the operation authority.
  • the server can also set the operation authority level according to other methods, and is not limited to the method described above.
  • the server stores the user's login account and the permission level of the user's various operations in advance, and the server searches for the permission level of the editing operation corresponding to the current login account.
  • Step 240 Filter out the first folder matching the editing permission from the source file.
  • permissions are set in batches using folders as data collection units.
  • permissions can also be set in larger data collection units such as folder groups, or in workbooks or even workbooks. Worksheets and smaller data collection units.
  • the server sets the operation authority for each data collection unit in advance.
  • the operation authority is set for each folder.
  • the setting of the folder's operational permissions corresponds to the user's operation permissions. For example, if the user's editing permissions are set to three levels: high, intermediate, and low, the folder's operational permissions are also set to high and intermediate. Low-level.
  • the server obtains the editable permissions of each source folder found, matches the edit permissions corresponding to the current login account with the editable permissions of each source folder, and filters the editable permissions from the source folder to match the edit permission level First folder.
  • the first folder is a subset of the source folder, and the number of the first folder may be one or more.
  • Step 250 Update the original workbook corresponding to the workbook identifier in the first folder according to the worksheet to be updated.
  • the server searches the workbook corresponding to the workbook identifier from the first folder, that is, the original workbook before the worksheet update.
  • the server adds the data content of the worksheet to be updated to the original workbook according to a preset workbook update rule. ,
  • the original workbook in the first folder is updated with data.
  • the server after receiving the workbook update request and the worksheet to be updated sent by the user terminal, the server searches for a corresponding source folder according to the workbook identifier in the workbook update request, and obtains the source folder corresponding to the workbook update request.
  • the edit permission corresponding to the current login account automatically finds the first folder that matches the edit permission, and only updates the original workbook corresponding to the workbook identifier in the first folder, eliminating the need to manually organize data and improve Efficiency and accuracy of data management.
  • the workbook processing method further includes the following steps:
  • Step 260 Receive a worksheet thumbnail and a thumbnail adding instruction generated by the user terminal according to the worksheet to be updated.
  • the to-be-updated worksheet is extracted, and a worksheet thumbnail is generated according to the to-be-updated worksheet.
  • Update the worksheet for thumbnail processing For example, you can generate a compressed image of the worksheet, capture data from preset positions in the worksheet, and generate thumbnails.
  • the specific thumbnail processing method is set according to user needs, and there is no restriction on this.
  • the user terminal generates a thumbnail adding instruction according to the current login account of the current user, and sends the worksheet thumbnail and the thumbnail adding instruction to the server.
  • the server receives the worksheet thumbnail and the thumbnail adding instruction sent by the user terminal, and extracts the current login account from the thumbnail adding instruction.
  • Step 270 Add the worksheet thumbnail to the personal folder corresponding to the current login account according to the thumbnail adding instruction.
  • a personal folder is set for each user in the server.
  • the personal folder can be named after the user's login account. After the user logs in to the account at the user terminal, the user terminal can obtain from the server the user account corresponding to the user's login account.
  • personal folders users can view and edit workbooks and other files in personal folders.
  • the server finds a personal folder corresponding to the current login account, and adds a worksheet thumbnail to the found personal folder.
  • the worksheet thumbnail is directly generated according to the worksheet, and the worksheet thumbnail is added to the user's personal folder, thereby facilitating the user to modify himself Search past worksheets, and generate thumbnails for users to easily find worksheets in folders.
  • adding the worksheet thumbnail to the personal folder corresponding to the current login account according to the thumbnail adding instruction includes: finding out whether there is a historical thumbnail corresponding to the worksheet thumbnail in the personal folder; when searching When the historical thumbnail is reached, the historical thumbnail and the worksheet thumbnail are used to generate a thumbnail collection, and the worksheet thumbnail is set as the display icon of the thumbnail set.
  • the server When the server adds a worksheet thumbnail to a personal folder, the server obtains the worksheet identifier corresponding to the worksheet thumbnail, and looks for a history thumbnail corresponding to the worksheet identifier from the personal folder. The user can view the same worksheet Edit and modify multiple times. After each edit, thumbnails are generated and stored in personal folders. Historical thumbnails are user history thumbnails generated after editing the same worksheet. In other embodiments, the historical thumbnail may also be a thumbnail generated after the current user's associated user edits the same worksheet. The associated user may be a user of the same group as the current user, or a user with associated settings.
  • a thumbnail set is generated according to the received worksheet thumbnail and historical thumbnail.
  • the newly added worksheet thumbnail can be set as the icon of the thumbnail set, and You can name the thumbnail collection by sheet identifier.
  • the newly added worksheet thumbnail is directly added to the personal folder.
  • the thumbnail collection can be operated.
  • the user terminal can expand and display the thumbnail collection to facilitate the user to view the thumbnails in the collection.
  • the workbook processing method may further include: when a hidden identifier is identified from the workbook update request, searching for an account level corresponding to the current login account; and performing hidden settings for the updated worksheet according to the account level.
  • the user can choose whether to hide the workbook.
  • the user terminal detects that the user performs the workbook hiding operation, the user obtains a preset hidden identifier.
  • the user When the user generates a workbook update request, the user will The hidden flag set is added to the workbook update request.
  • the server After receiving the workbook update request sent by the user terminal, the server identifies whether a hidden identifier exists in the workbook update request. When the server recognizes the hidden identifier from the workbook update request, it looks for the account level corresponding to the current login account.
  • the user's account is divided into multiple account levels. Generally, the operation authority of a user with a higher account level is greater than the operation authority of a user with a lower account level.
  • the server hides the worksheet to be updated according to the account level of the found user, sets the worklist to be updated to invisible to users whose account level is lower than the found account level, and users whose account level is higher than the found account level Set to visible.
  • the user terminal When the user terminal detects the user's workbook viewing operation, it obtains the to-be-viewed workbook identifier of the workbook to be viewed for the viewing operation, finds the to-be-viewed workbook corresponding to the to-be-viewed workbook identifier, and detects the work to be viewed
  • the user terminal obtains the to-be-viewed workbook identifier of the workbook to be viewed for the viewing operation, finds the to-be-viewed workbook corresponding to the to-be-viewed workbook identifier, and detects the work to be viewed
  • obtain the hidden permission of the hidden worksheet obtain the account level of the user who performs the workbook viewing operation.
  • the hidden permission and the account level determine whether the worksheet with hidden settings requires the current The operation user is hidden.
  • the user terminal hides the worksheet with the level setting when displaying the workbook to be viewed.
  • the transparency of the worksheet can be adjusted to an invisible state.
  • the worksheet icon is listed, and the data content part is not transparent.
  • the worksheet can be adjusted to be invisible. Status, users can still see worksheets in invisible status.
  • the server when the server does not recognize the hidden identifier from the workbook update request, the worksheet to be updated in the original workbook may not be hidden.
  • the workbook processing method may further include: receiving a worksheet viewing request sent by the user terminal, the worksheet viewing request carrying a hidden worksheet identifier; finding a management account corresponding to the hidden worksheet identifier; and generating the worksheet viewing request Worksheet view application, send the worksheet view application to the management terminal corresponding to the management account; receive the management terminal to view the approval result after the worksheet view application is approved; when the approval result is the application is approved, generate a worksheet display instruction to send to For a user terminal, the worksheet display instruction is used to instruct the user terminal to display a hidden worksheet corresponding to the hidden worksheet identifier.
  • a view request operation can be performed on the invisible worksheet.
  • the user terminal detects the user's worksheet view request operation, the hidden worksheet identifier of the hidden worksheet viewed according to the user request Generate a worksheet review request and send the worksheet review request to the server.
  • the server When the server receives the worksheet view request, it reads the hidden worksheet ID from the worksheet view request, finds the management account corresponding to the hidden worksheet ID for the hidden setting, and reads the request account that issued the view request from the worksheet view request. According to the requested account, a worksheet view application is generated, and the worksheet view application is sent to the management terminal corresponding to the management account.
  • the server can send the worksheet view application to the management terminal by email, text message, WeChat, or application prompt.
  • the server When the server receives the review and approval result after the management terminal approves the worksheet review application, it determines whether the approval result is the application approval. When the server determines that the approval result is the application approval, it generates a worksheet display instruction and sends it to the user terminal. When the user terminal receives the worksheet display instruction, the hidden worksheet is displayed according to the worksheet display instruction, and the hidden worksheet is adjusted to a visible state.
  • the server when the server determines that the result of the approval is an application failure, the server generates a notification of refusal to view and returns it to the user terminal. After receiving the notification of refusal to view, the user terminal generates a worksheet to view the restricted prompt and displays it.
  • updating the original workbook corresponding to the workbook identifier in the first folder according to the worksheet to be updated includes: generating a first tab according to the worksheet to be updated; obtaining the worksheet identifier to be updated from the original In the workbook, find the tab set corresponding to the ID of the worksheet to be updated; find whether there is a second tab in the tab set that matches the current login account; when there is a matching second tab, the The second tab is replaced with the first tab; when there is no matching second tab, the first tab is inserted into the tab collection.
  • Tabs are worksheet labels.
  • the workbook includes multiple worksheet tabs. Setting tabs in the workbook makes it easy to display and find worksheets.
  • the server generates a first tab according to the worksheet to be updated, and a label of the first tab may be set to a worksheet name or a worksheet identifier of the worksheet to be updated.
  • the tabs in the workbook are associated with the worksheet ID of the corresponding worksheet.
  • the server obtains the ID of the worksheet to be updated and finds the tab set corresponding to the ID of the worksheet to be updated. Since a worksheet may be edited and modified by multiple people, a worksheet can correspond to multiple tabs. Multiple tabs form a tab collection. The tabs in the tab set can be identified according to the login account of the editing user. The server looks up from the tab set whether there is a second tab that matches the current login account, and specifically looks for whether there is a second tab that identifies the current login account. When a matching second tab exists in the tab set, the server replaces the second tab with the first tab, so that only the newly edited worksheet of the same user is retained in the tab set, reducing data redundant storage. When there is no matching second tab in the tab set, the server directly inserts the first tab into the tab set, and performs account identification on the first tab inserted in the tab set according to the current login account.
  • steps in the flowchart of FIG. 2-3 are sequentially displayed according to the directions of the arrows, these steps are not necessarily performed sequentially in the order indicated by the arrows. Unless explicitly stated in this document, the execution of these steps is not strictly limited, and these steps can be performed in other orders. Moreover, at least part of the steps in Figure 2-3 may include multiple sub-steps or stages. These sub-steps or stages are not necessarily performed at the same time, but may be performed at different times. These sub-steps or stages The execution order of is not necessarily performed sequentially, but may be performed in turn or alternately with at least a part of another step or a sub-step or stage of another step.
  • a workbook processing apparatus including: an update request receiving module 410, a source folder search module 420, an editing permission acquisition module 430, a folder filtering module 440, and a workbook.
  • Update module 450 where:
  • the update request receiving module 410 is configured to receive a workbook update request and a worksheet to be updated sent by a user terminal.
  • the workbook update request carries a workbook identifier and a current login account.
  • the source folder search module 420 is configured to search for a source folder corresponding to a workbook identifier.
  • the editing authority obtaining module 430 is configured to obtain the editing authority corresponding to the current login account.
  • the folder filtering module 440 is configured to filter a first folder matching the editing permission from the source file.
  • the workbook update module 450 is configured to update the original workbook corresponding to the workbook identifier in the first folder according to the worksheet to be updated.
  • the workbook processing apparatus may further include:
  • the thumbnail generating module is configured to receive a worksheet thumbnail and a thumbnail adding instruction generated by the user terminal according to the worksheet to be updated.
  • the thumbnail adding module is used to add a worksheet thumbnail to a personal folder corresponding to the current login account according to the thumbnail adding instruction.
  • the thumbnail adding module may include:
  • History map search module used to find out whether there is a history thumbnail corresponding to the worksheet thumbnail in the personal folder.
  • the graph collection generating module is configured to generate a thumbnail collection from a historical thumbnail and a worksheet thumbnail when a historical thumbnail is found, and set the worksheet thumbnail as a display icon of the thumbnail collection.
  • the workbook processing apparatus may further include:
  • the account level search module is used to find the account level corresponding to the currently logged in account when a hidden identifier is identified from the workbook update request.
  • Hidden module used to hide the worksheet to be updated according to the account level.
  • the workbook processing apparatus may further include:
  • the viewing request receiving module is configured to receive a worksheet viewing request sent by a user terminal.
  • the worksheet viewing request carries a hidden worksheet identifier.
  • the management account search module is used to find the management account corresponding to the hidden worksheet identifier.
  • the view application sending module is configured to generate a worksheet view request according to the worksheet view request, and send the worksheet view request to a management terminal corresponding to the management account.
  • the approval result receiving module is used to receive the review and approval results after the management terminal approves the worksheet review application.
  • a display module is configured to generate a worksheet display instruction and send it to a user terminal when the approval result is that the application is approved.
  • the worksheet display instruction is used to instruct the user terminal to display a hidden worksheet corresponding to the hidden worksheet identifier.
  • the workbook update module 450 may include:
  • a tab generation module is configured to generate a first tab according to a worksheet to be updated.
  • the tab set search module is used to obtain the identifier of the worksheet to be updated, and find the tab collection corresponding to the identifier of the worksheet to be updated from the original workbook.
  • the tab matching module is used to find whether a second tab matching the current login account exists in the tab set.
  • a tab replacement module is used to replace the second tab in the tab set with the first tab when there is a matching second tab.
  • a tab adding module is used to insert a first tab into a tab collection when there is no matching second tab.
  • Each module in the above-mentioned workbook processing apparatus may be implemented in whole or in part by software, hardware, and a combination thereof.
  • the above-mentioned modules may be embedded in the hardware in or independent of the processor in the computer device, or may be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.
  • a computer device is provided.
  • the computer device may be a server, and its internal structure diagram may be as shown in FIG. 5.
  • the computer device includes a processor, a memory, a network interface, and a database connected through a system bus.
  • the processor of the computer device is used to provide computing and control capabilities.
  • the memory of the computer device includes a non-volatile storage medium and an internal memory.
  • the non-volatile storage medium stores an operating system, computer-readable instructions, and a database.
  • the internal memory provides an environment for the operation of the operating system and computer-readable instructions in a non-volatile storage medium.
  • the computer equipment database is used to store workbook data.
  • the network interface of the computer device is used to communicate with an external terminal through a network connection.
  • the computer-readable instructions are executed by a processor to implement a workbook processing method.
  • FIG. 5 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied.
  • the specific computer equipment may be Include more or fewer parts than shown in the figure, or combine certain parts, or have a different arrangement of parts.
  • a computer device which includes a memory and a processor.
  • Computer-readable instructions are stored in the memory, and when the computer-readable instructions are executed by the processor, one or more processors execute the following steps: receiving The workbook update request and the worksheet to be updated sent by the user terminal.
  • the workbook update request carries the workbook ID and the current login account; finds the source folder corresponding to the workbook ID; obtains the editing permissions corresponding to the current login account; from the source file
  • the first folder matching the editing permission is filtered out in the database; the original workbook corresponding to the workbook identifier in the first folder is updated according to the worksheet to be updated.
  • the processor executes the computer-readable instructions, the following steps are further implemented: receiving a worksheet thumbnail and a thumbnail adding instruction generated by the user terminal according to the worksheet to be updated; adding the worksheet thumbnail according to the thumbnail adding instruction Go to the personal folder corresponding to the current login account.
  • the processor when the processor executes the computer-readable instructions, the processor adds a worksheet thumbnail to a personal folder corresponding to the current login account when the processor adds the worksheet thumbnail according to the thumbnail adding instruction, and is further used for: finding whether a personal folder exists and works Historical thumbnails corresponding to table thumbnails; when historical thumbnails are found, generate a thumbnail collection of historical thumbnails and worksheet thumbnails, and set the worksheet thumbnails as the display icon for the thumbnail collection.
  • the processor when the processor executes the computer-readable instructions, the processor further implements the following steps: when a hidden identifier is identified from the workbook update request, the account level corresponding to the current login account is looked up; the updated worksheet is hidden according to the account level Settings.
  • the processor when the processor executes the computer-readable instructions, the processor further implements the following steps: receiving a worksheet viewing request sent by the user terminal, the worksheet viewing request carrying a hidden worksheet identifier; finding a management account corresponding to the hidden worksheet identifier; Worksheet review request Generates a worksheet review application and sends the worksheet review request to the management terminal corresponding to the management account; receives the management terminal to review the review approval result after the worksheet review application is approved; when the review result is that the application is approved, generates a job
  • the table display instruction is sent to the user terminal, and the worksheet display instruction is used to instruct the user terminal to display the hidden worksheet corresponding to the hidden worksheet identifier.
  • the processor when the processor executes the computer-readable instructions to implement updating the original workbook corresponding to the workbook identifier in the first folder according to the worksheet to be updated, the processor is further configured to: Generate the first tab of the worksheet; obtain the ID of the worksheet to be updated, and find the tab set corresponding to the ID of the worksheet to be updated from the original workbook; find whether there is a second tab in the tab set that matches the current login account ; When there is a matching second tab, replace the second tab in the tab set with the first tab; when there is no matching second tab, insert the first tab into the tab set.
  • One or more non-volatile computer-readable storage media storing computer-readable instructions.
  • the one or more processors execute the following steps: Workbook update request and worksheet to be updated.
  • the workbook update request carries the workbook ID and the current login account; finds the source folder corresponding to the workbook ID; obtains the editing permissions corresponding to the current login account; filters out from the source file
  • the first folder matching the editing authority; the original workbook corresponding to the workbook identifier in the first folder is updated according to the worksheet to be updated.
  • the following steps are further implemented: receiving a worksheet thumbnail and a thumbnail adding instruction generated by the user terminal according to the worksheet to be updated; and thumbnailing the worksheet according to the thumbnail adding instruction Add to the personal folder corresponding to the current login account.
  • the worksheet thumbnail is added to the personal folder corresponding to the current login account according to the thumbnail adding instruction, and the method is further used for: finding whether a personal folder exists in the personal folder.
  • Historical thumbnails corresponding to worksheet thumbnails when historical thumbnails are found, generate a thumbnail collection of historical thumbnails and worksheet thumbnails, and set the worksheet thumbnails as the display icon for the thumbnail collection.
  • the following steps are also implemented: when a hidden identification is identified from the workbook update request, searching for an account level corresponding to the currently logged in account; and updating the worksheet according to the account level Hide settings.
  • the following steps are further implemented: receiving a worksheet viewing request sent by the user terminal, the worksheet viewing request carrying a hidden worksheet identifier; finding a management account corresponding to the hidden worksheet identifier; Generate a worksheet review application according to the worksheet review request, and send the worksheet review application to the management terminal corresponding to the management account; receive the review and review results of the worksheet review application after the management terminal has approved it;
  • the worksheet display instruction is sent to the user terminal, and the worksheet display instruction is used to instruct the user terminal to display the hidden worksheet corresponding to the hidden worksheet identifier.
  • the computer-readable instructions are implemented by the processor to update the original workbook corresponding to the workbook identifier in the first folder according to the worksheet to be updated, and are further configured to: Generate the first tab of the table; obtain the ID of the worksheet to be updated, find the tab set corresponding to the ID of the worksheet to be updated from the original workbook; find out whether there is a second tab in the tab set that matches the current login account; When there is a matching second tab, the second tab in the tab set is replaced with the first tab; when there is no matching second tab, the first tab is inserted into the tab set.
  • Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory.
  • Volatile memory can include random access memory (RAM) or external cache memory.
  • RAM is available in various forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous chain (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
  • Storage Device Security (AREA)

Abstract

一种工作簿处理方法，包括：接收用户终端发送的工作簿更新请求和待更新工作表，工作簿更新请求携带工作簿标识和当前登录账号；查找与工作簿标识对应的源文件夹；获取当前登录账号对应的编辑权限；从源文件中筛选出与编辑权限匹配的第一文件夹；根据待更新工作表对第一文件夹中工作簿标识对应的原工作簿进行更新。

Description

工作簿处理方法、装置、计算机设备和存储介质
相关申请的交叉引用
本申请要求于2018年05月21日提交中国专利局，申请号为2018104908752，申请名称为“工作簿管理方法、装置、计算机设备和存储介质”的中国专利申请的优先权，其全部内容通过引用结合在本申请中。
技术领域
本申请涉及一种工作簿管理方法、装置、计算机设备和存储介质。
背景技术
现有的数据管理平台对海量的数据工作表进行存储管理，用户可以对工作簿进行在线访问、编辑或下载等操作。
目前，用户在对工作簿编辑后，通常需要管理人员根据用户的权限对编辑后的工作簿进行管理，如判断是否需要将经过编辑的工作簿进行同步在线更新，其他用户是否可以进行访问等。然而，面对数据管理平台上的海量数据，通常需要消耗管理人员大量的时间进行管理，导致数据管理的效率非常低。
发明内容
根据本申请公开的各种实施例，提供一种工作簿管理方法、装置、计算机设备和存储介质。
一种工作簿管理方法包括：
接收用户终端发送的工作簿更新请求和待更新工作表，所述工作簿更新请求携带工作簿标识和当前登录账号；
查找与所述工作簿标识对应的源文件夹；
获取所述当前登录账号对应的编辑权限；
从所述源文件中筛选出与所述编辑权限匹配的第一文件夹；及
根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新。
一种工作簿处理装置包括：
更新请求接收模块，用于接收用户终端发送的工作簿更新请求和待更新工作表，所述工作簿更新请求携带工作簿标识和当前登录账号；
源文件夹查找模块，用于查找与所述工作簿标识对应的源文件夹；
编辑权限获取模块，用于获取所述当前登录账号对应的编辑权限；
文件夹筛选模块，用于从所述源文件中筛选出与所述编辑权限匹配的第一文件夹；及
工作簿更新模块，用于根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新。
一种计算机设备，包括存储器和一个或多个处理器，所述存储器中储存有计算机可读指令，所述计算机可读指令被所述处理器执行时，使得所述一个或多个处理器执行以下步骤：
接收用户终端发送的工作簿更新请求和待更新工作表，所述工作簿更新请求携带工作簿标识和当前登录账号；
查找与所述工作簿标识对应的源文件夹；
获取所述当前登录账号对应的编辑权限；
从所述源文件中筛选出与所述编辑权限匹配的第一文件夹；及
根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新。
一个或多个存储有计算机可读指令的非易失性计算机可读存储介质，计算机可读指令被一个或多个处理器执行时，使得一个或多个处理器执行以下步骤：
接收用户终端发送的工作簿更新请求和待更新工作表，所述工作簿更新请求携带工作簿标识和当前登录账号；
查找与所述工作簿标识对应的源文件夹；
获取所述当前登录账号对应的编辑权限；
从所述源文件中筛选出与所述编辑权限匹配的第一文件夹；及
根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新。
本申请的一个或多个实施例的细节在下面的附图和描述中提出。本申请的其它特征和优点将从说明书、附图以及权利要求书变得明显。
附图说明
为了更清楚地说明本申请实施例中的技术方案，下面将对实施例中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本申请的一些实施例，对于本领域普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其它的附图。
图1为根据一个或多个实施例中工作簿处理方法的应用场景图。
图2为根据一个或多个实施例中工作簿处理方法的流程示意图。
图3为另一个实施例中工作簿处理方法的流程示意图。
图4为根据一个或多个实施例中工作簿处理装置的框图。
图5为根据一个或多个实施例中计算机设备的框图。
具体实施方式
为了使本申请的技术方案及优点更加清楚明白，以下结合附图及实施例，对本申请进行进一步详细说明。应当理解，此处描述的具体实施例仅仅用以解释本申请，并不用于限定本申请。
本申请提供的工作簿处理方法，可以应用于如图1所示的应用环境中。用户终端通过网络与服务器进行通信。用户终端向服务器发送工作簿更新请求和待更新工作表，服务器接收请求后，读取请求中携带的工作簿标识和当前登录账号，服务器查找工作簿标识对应的源文件夹，并获取当前登录账号对应的编辑权限，服务器从源文件夹中筛选出与编辑权限匹配的第一文件夹，并根据待更新工作表对第一文件夹中工作簿标识对应的原工作簿进行更新。其中，用户终端可以但不限于是各种个人计算机、笔记本电脑、智能手机、平板电脑等，服务器可以用独立的服务器或者是多个服务器组成的服务器集群来实现。
在一个实施例中，如图2所示，提供了一种工作簿处理方法，以该方法应用于图1中的服务器为例进行说明，包括以下步骤：
步骤210，接收用户终端发送的工作簿更新请求和待更新工作表，工作簿更新请求携带工作簿标识和当前登录账号。
工作簿为用来储存并处理工作数据的文件，例如excel文件，工作簿标识用于对工作簿进行唯一标识，工作簿标识可以但不限于文件名称、代码、编号等。一个工作簿可以由多张工作表组成，工作表是显示在工作簿窗口中的数据表格，每张工作表也具有对其进行唯一标识的工作表标识，同一工作簿对应的所有工作表的工作表标识与相应的工作簿标识进行关联。
服务器是对各用户的工作簿进行统一管理的公共数据管理平台，用户可以通过用户终端登录、访问公共数据管理平台，对平台上的工作簿进行在线的查看、修改、编辑等操作。用户可以将管理平台上的工作簿另存在用户终端本地或另存至其他路径地址中。当用户终端检测到用户的另存为操作时，用户终端判断用户进行另存为的工作簿相对于原工作簿的数据内容是否发生变化。
当用户终端判定出另存为的工作簿相对于原工作簿的数据内容发生了变化，即用户对原工作簿进行了编辑更新，用户终端从另存为的工作簿中查找数据内容发生改变的修改工作表，并获取用户的当前登录账号，根据另存为 的工作簿的工作簿标识和当前登录账号生成工作簿更新请求，将工作簿更新请求和修改工作表关联发送给服务器，以使服务器根据待修改工作表对服务器上存储的与修改工作表对应的工作表进行更新。
在一个实施例中，用户终端判断用户进行另存为的工作簿相对于原工作簿的数据内容是否发生变化之前，用户终端获取当前登录账号，根据当前登录账号对另存为的工作簿标记对应的账号标识，将标记对应的账号标识的另存为的工作簿根据另存为路径进行存储。用户终端获取预设时间，当到达预设时间后，用户终端判断标记对应的账号标识的另存为的工作簿是否另存为成功。当用户终端判定工作簿另存为失败时，用户终端继续执行根据当前登录账号对另存为的工作簿进行账号标识的步骤；当用户终端评定工作簿另存为成功时，则执行用户终端判断用户进行另存为的工作簿相对于原工作簿的数据内容是否发生变化的步骤。在本实施中，当到达预设另存为时间后，用户终端自动检测工作簿是否另存为成功，从而保证工作簿能够保存至另存为路径对应的存储位置。
服务器接收用户终端发送的工作簿更新请求和修改工作表，修改工作表即为待更新工作表，服务器从工作簿更新请求中读取工作簿标识和当前登录账号。
步骤220，查找与工作簿标识对应的源文件夹。
服务器对工作簿进行分类存储，可以根据工作簿的数据内容、所属的业务类别、机构等属性将工作簿存储至与其属性对应的文件夹中，同一工作簿可能被存储至多个文件夹中，多个文件夹均可称为源文件夹。服务器根据工作簿标识查找工作簿对应的源文件夹，查找到的源文件夹可能为一个，也可能为多个。
步骤230，获取当前登录账号对应的编辑权限。
服务器事先对用户进行权限设置，具体设置的权限可以包括但不限于用户对数据的查看、编辑、审核权限等操作权限。服务器对用户设置操作权限的操作等级，如高级、中级、低级等，等级越高对应的操作权限越大，服务器也可以根据其他方式设置操作权限的等级，并不限于上述描述的方法。服务器将用户的登录账号与用户各项操作的权限等级事先进行关联存储，服务器查找与当前登录账号对应的编辑操作的权限等级。
步骤240，从源文件中筛选出与编辑权限匹配的第一文件夹。
在本实施例中，权限以文件夹为数据集合单元进行批量设置，在其他实施例中，权限也可以以文件夹组等更大的数据集合单元进行设置，也可以以工作簿甚至工作簿中的工作表等更小的数据集合单元进行设置。服务器事先对各数据集合单元设置可操作权限，在本实施中，则对各文件夹设置可操作 权限。文件夹的可操作权限的设置与用户的操作权限的设置相对应，例如，用户的编辑权限设置为高级、中级、低级三种权限，则文件夹的可操作权限也相应地设置为高级、中级、低级。
服务器获取查找到的各源文件夹的可编辑权限，并将当前登录账号对应的编辑权限与各源文件夹的可编辑权限进行匹配，从源文件夹中筛选出可编辑权限与编辑权限等级一致的第一文件夹。第一文件夹为源文件夹的一个子集，第一文件夹的数量可能为一个或多个。
步骤250，根据待更新工作表对第一文件夹中工作簿标识对应的原工作簿进行更新。
服务器从第一文件夹中查找与工作簿标识对应的工作簿，即为工作表更新之前的原工作簿，服务器根据预设工作簿更新规则将待更新工作表的数据内容添加至原工作簿中，第一文件夹中的原工作簿进行数据更新。
在本实施例中，服务器接收到用户终端发送的工作簿更新请求和待更新工作表后，根据工作簿更新请求中的工作簿标识查找对应的源文件夹，并获取与工作簿更新请求中的当前登录账号对应的编辑权限，自动查找出与编辑权限相匹配的第一文件夹，并只对第一文件夹中的与工作簿标识对应的原工作簿进行更新，无需人工进行数据整理，提高数据管理的工作效率和准确率。
在一个实施例中，如图2所示，工作簿处理方法还包括以下步骤：
步骤260，接收用户终端根据待更新工作表生成的工作表缩略图和缩略图添加指令。
用户终端判定出另存为的工作簿中存在内容经过修改的待更新工作表时，将待更新工作表提取出来，根据待更新工作表生成工作表缩略图，用户终端可以按照预设处理方式将待更新工作表进行缩略图处理，如可以生成工作表的压缩图像，从工作表中截取预设位置的数据生成缩略图等，具体的缩略图处理方式根据用户需要进行设置，不对此进行限制。
用户终端根据当前用户的当前登录账号生成缩略图添加指令，将工作表缩略图和缩略图添加指令发送给服务器。服务器接收到用户终端发送的工作表缩略图和缩略图添加指令，并从缩略图添加指令中提取出当前登录账号。
步骤270，根据缩略图添加指令将工作表缩略图添加至当前登录账号对应的个人文件夹中。
在本实施例中，服务器中为每个用户设置有个人文件夹，个人文件夹可以以用户的登录账号进行命名，用户在用户终端进行账号登录后，用户终端可以从服务器获取与用户登录账号对应的个人文件夹，用户可以对个人文件夹中的工作簿等文件进行查看、编辑等操作。服务器查找与当前登录账号对应的个人文件夹，并将工作表缩略图添加至查找到的个人文件夹中。
在本实施中，当用户另存为的工作簿中存在更新的工作表时，直接根据工作表生成工作表缩略图，并将工作表缩略图添加至用户的个人夹中，从而方便用户对自己修改过的工作表进行查找，同时生成缩略图方便用户进行文件夹中工作表的查找。
在一个实施例中，根据缩略图添加指令将工作表缩略图添加至当前登录账号对应的个人文件夹中，包括：查找个人文件夹中是否存在与工作表缩略图对应的历史缩略图；当查找到历史缩略图时，将历史缩略图与工作表缩略图生成缩略图合集，并将工作表缩略图设置为缩略图集合的显示图标。
服务器在将工作表缩略图添加至个人文件夹时，服务器获取工作表缩略图对应的工作表标识，从个人文件夹中查找是否存在与工作表标识对应的历史缩略图，用户可以对同一工作表进行多次编辑和修改，每次编辑修改后均生成缩略图存储在个人文件夹中，历史缩略图为用户历史是上对同一工作表编辑后生成的缩略图。在其他实施例中，历史缩略图也可以为当前用户的关联用户对同一工作表进行编辑后生成的缩略图，关联用户可以为当前用户同一组别的用户，或者是具有关联设置的用户等。
当服务器查找到历史缩略图时，根据接收到的工作表缩略图与历史缩略图生成缩略图集合，在一个实施例中，可以将新增的工作表缩略图设置为缩略图集合的图标，并可以工作表标识对缩略图集合进行命名。当没有查找到对应的历史缩略图时，则直接将新增的工作表缩略图添加至个人文件夹中。
用户在用户终端查看缩略图集合时，可以对缩略图集合进行操作，当进行查看历史缩略图操作时，用户终端可以将缩略图集合展开显示，方便用户对集合中的缩略图进行查看。
在一个实施例中，工作簿处理方法还可以包括：当从工作簿更新请求中识别出隐藏标识时，查找当前登录账号对应的账号级别；根据账号级别对待更新工作表进行隐藏设置。
用户在用户终端进行另存为操作时，可以选择是否将工作簿进行隐藏，当用户终端检测到用户进行工作簿隐藏操作时，获取预设的隐藏标识，用户在生成工作簿更新请求时，将预设的隐藏标识添加至工作簿更新请求中。
服务器接收到用户终端发送的工作簿更新请求后，识别工作簿更新请求中是否存在隐藏标识。当服务器从工作簿更新请求中识别出隐藏标识时，查找当前登录账号对应的账号级别。用户的账号被划分为多个账号级别，一般地，账号级别高的用户的操作权限大于账号级别低的用户的操作权限。
服务器根据查找到的用户的账号级别对待更新工作表进行隐藏设置，将待更新工作表对账号级别小于查找到的账号级别的用户设置为不可见，而账号级别高于查找到的账号级别的用户设置为可见。
当用户终端检测到用户的工作簿查看操作时，获取进行被进行查看操作的待查看工作簿的待查看工作簿标识，查找待查看工作簿标识对应的待查看工作簿，当检测到待查看工作簿中存在进行级别隐藏设置的工作表时，获取隐藏工作表的隐藏权限，并获取进行工作簿查看操作的用户的账号级别，根据隐藏权限和账号级别判断进行隐藏设置的工作表是非需要对当前操作用户隐藏，当判定当前操作用户的账号级别低于进行隐藏设置的账号级别时，用户终端在展示待查看工作簿时将进行级别隐藏设置的工作表进行隐藏显示。
具体地，用户终端在对工作表进行隐藏显示时，可以将工作表的透明度调节至不可见状态，如只列出工作表图标，将数据内容部分非透明化等方式将工作表调节至不可见状态，用户依然可以看见不可见状态的工作表。
在一个实施例中，当服务器从工作簿更新请求中未识别出隐藏标识时，则可以不对原工作簿中的待更新工作表进行隐藏设置。
在一个实施例中，工作簿处理方法还可以包括：接收用户终端发送的工作表查看请求，工作表查看请求携带隐藏工作表标识；查找隐藏工作表标识对应的管理账号；根据工作表查看请求生成工作表查看申请，将工作表查看申请发送给管理账号对应的管理终端；接收管理终端对工作表查看申请进行审批后的查看审批结果；当审批结果为申请通过时，生成工作表显示指令发送给用户终端，工作表显示指令用于指示用户终端将隐藏工作表标识对应的隐藏工作表进行显示。
当用户想要查看不可见的工作表时，可以对不可见工作表进行查看请求操作，当用户终端检测到用户的工作表查看请求操作时，根据用户请求查看的隐藏工作表的隐藏工作表标识生成工作表查看请求，将工作表查看请求发送给服务器。
服务器接收到工作表查看请求时从工作表查看请求中读取隐藏工作表标识，查找隐藏工作表标识对应的进行隐藏设置的管理账号，并从工作表查看请求中读取发出查看请求的请求账号，根据请求账号生成工作表查看申请，将工作表查看申请发送给管理账对应的管理终端，服务器可以邮件、短信、微信、应用提示等方式将工作表查看申请发送给管理终端。
当服务器接收到管理终端对工作表查看申请进行审批后的查看审批结果时，判断审批结果是否为申请通过，服务器判定审批结果为申请通过时，生成工作表显示指令发送给用户终端。用户终端接收到工作表显示指令时，根据工作表显示指令将隐藏工作表进行显示，将隐藏工作表调节至可见状态。
在一个实施例中，当服务器判定审批结果为申请失败时，服务器生成拒绝查看通知并返回给用户终端，用户终端接收到拒绝查看通知后，生成工作表查看受限提示并进行展示。
在一个实施例中，根据待更新工作表对第一文件夹中工作簿标识对应的原工作簿进行更新，包括：根据待更新工作表生成第一选项卡；获取待更新工作表标识，从原工作簿中查找与待更新工作表标识对应的选项卡集合；查找选项卡集合中是否存在与当前登录账号匹配的第二选项卡；当存在匹配的第二选项卡时，将选项卡集合中的第二选项卡替换为第一选项卡；当不存在匹配的第二选项卡时，将第一选项卡插入选项卡集合中。
选项卡为工作表标签，工作簿中包括多个工作表选项卡，在工作簿中设置选项卡便于进行工作表展示和查找。服务器根据待更新工作表生成第一选项卡，第一选项卡的标签可以设置为待更新工作表的工作表名称或工作表标识等。工作簿中的选项卡与相应工作表的工作表标识进行关联记录。
服务器获取待更新工作表标识，并查找与待更新工作表标识对应的选项卡集合，由于一张工作表可能经过多个人的多次编辑修改，因此一张工作表可以对应与多个选项卡，多个选项卡形成选项卡集合。选项卡集合中的选项卡可以根据编辑用户的登录账号等进行标识。服务器从选项卡集合中查找是否存在与当前登录账号匹配的第二选项卡，具体地，查找是否存在进行当前登录账号标识的第二选项卡。当选项卡集合中存在相匹配的第二选项卡时，服务器将第二选项卡替换为第一选项卡，从而只在选项卡集合中保留同一用户最新编辑的工作表，减少数据冗余存储。当选项卡集合中不存在相匹配的第二选项卡时，服务器直接将第一选项卡插入选项卡集合中，并根据当前登录账号对插入选项卡集合中的第一选项卡进行账号标识。
在本实施例中，通过设置在工作簿中设置选项卡集合，可以方便对多个用户编辑的多个版本的工作表进行存储和管理。
应该理解的是，虽然图2-3的流程图中的各个步骤按照箭头的指示依次显示，但是这些步骤并不是必然按照箭头指示的顺序依次执行。除非本文中有明确的说明，这些步骤的执行并没有严格的顺序限制，这些步骤可以以其它的顺序执行。而且，图2-3中的至少一部分步骤可以包括多个子步骤或者多个阶段，这些子步骤或者阶段并不必然是在同一时刻执行完成，而是可以在不同的时刻执行，这些子步骤或者阶段的执行顺序也不必然是依次进行，而是可以与其它步骤或者其它步骤的子步骤或者阶段的至少一部分轮流或者交替地执行。
在一个实施例中，如图4所示，提供了一种工作簿处理装置，包括：更新请求接收模块410、源文件夹查找模块420、编辑权限获取模块430、文件夹筛选模块440和工作簿更新模块450，其中：
更新请求接收模块410，用于接收用户终端发送的工作簿更新请求和待 更新工作表，工作簿更新请求携带工作簿标识和当前登录账号。
源文件夹查找模块420，用于查找与工作簿标识对应的源文件夹。
编辑权限获取模块430，用于获取当前登录账号对应的编辑权限。
文件夹筛选模块440，用于从源文件中筛选出与编辑权限匹配的第一文件夹。
工作簿更新模块450，用于根据待更新工作表对第一文件夹中工作簿标识对应的原工作簿进行更新。
在一个实施例中，工作簿处理装置还可以包括：
缩略图生成模块，用于接收用户终端根据待更新工作表生成的工作表缩略图和缩略图添加指令。
缩略图添加模块，用于根据缩略图添加指令将工作表缩略图添加至当前登录账号对应的个人文件夹中。
在一个实施例中，缩略图添加模块可以包括：
历史图查找模块，用于查找个人文件夹中是否存在与工作表缩略图对应的历史缩略图。
图合集生成模块，用于当查找到历史缩略图时，将历史缩略图与工作表缩略图生成缩略图合集，并将工作表缩略图设置为缩略图集合的显示图标。
在一个实施例中，工作簿处理装置还可以包括：
账号级别查找模块，用于当从工作簿更新请求中识别出隐藏标识时，查找当前登录账号对应的账号级别。
隐藏模块，用于根据账号级别对待更新工作表进行隐藏设置。
在一个实施例中，工作簿处理装置还可以包括：
查看请求接收模块，用于接收用户终端发送的工作表查看请求，工作表查看请求携带隐藏工作表标识。
管理账号查找模块，用于查找隐藏工作表标识对应的管理账号。
查看申请发送模块，用于根据工作表查看请求生成工作表查看申请，将工作表查看申请发送给管理账号对应的管理终端。
审批结果接收模块，用于接收管理终端对工作表查看申请进行审批后的查看审批结果。
显示模块，用于当审批结果为申请通过时，生成工作表显示指令发送给用户终端，工作表显示指令用于指示用户终端将隐藏工作表标识对应的隐藏工作表进行显示。
在一个实施例中，工作簿更新模块450可以包括：
选项卡生成模块，用于根据待更新工作表生成第一选项卡。
选项卡集合查找模块，用于获取待更新工作表标识，从原工作簿中查找 与待更新工作表标识对应的选项卡集合。
选项卡匹配模块，用于查找选项卡集合中是否存在与当前登录账号匹配的第二选项卡。
选项卡替换模块，用于当存在匹配的第二选项卡时，将选项卡集合中的第二选项卡替换为第一选项卡。
选项卡添加模块，用于当不存在匹配的第二选项卡时，将第一选项卡插入选项卡集合中。
关于工作簿处理装置的具体限定可以参见上文中对于工作簿处理方法的限定，在此不再赘述。上述工作簿处理装置中的各个模块可全部或部分通过软件、硬件及其组合来实现。上述各模块可以硬件形式内嵌于或独立于计算机设备中的处理器中，也可以以软件形式存储于计算机设备中的存储器中，以便于处理器调用执行以上各个模块对应的操作。
在一个实施例中，提供了一种计算机设备，该计算机设备可以是服务器，其内部结构图可以如图5所示。该计算机设备包括通过系统总线连接的处理器、存储器、网络接口和数据库。其中，该计算机设备的处理器用于提供计算和控制能力。该计算机设备的存储器包括非易失性存储介质、内存储器。该非易失性存储介质存储有操作系统、计算机可读指令和数据库。该内存储器为非易失性存储介质中的操作系统和计算机可读指令的运行提供环境。该计算机设备的数据库用于存储工作簿数据。该计算机设备的网络接口用于与外部的终端通过网络连接通信。该计算机可读指令被处理器执行时以实现一种工作簿处理方法。
本领域技术人员可以理解，图5中示出的结构，仅仅是与本申请方案相关的部分结构的框图，并不构成对本申请方案所应用于其上的计算机设备的限定，具体的计算机设备可以包括比图中所示更多或更少的部件，或者组合某些部件，或者具有不同的部件布置。
在一个实施例中，提供了一种计算机设备，包括存储器和处理器，存储器中储存有计算机可读指令，计算机可读指令被处理器执行时，使得一个或多个处理器执行以下步骤：接收用户终端发送的工作簿更新请求和待更新工作表，工作簿更新请求携带工作簿标识和当前登录账号；查找与工作簿标识对应的源文件夹；获取当前登录账号对应的编辑权限；从源文件中筛选出与编辑权限匹配的第一文件夹；根据待更新工作表对第一文件夹中工作簿标识对应的原工作簿进行更新。
在一个实施例中，处理器执行计算机可读指令时还实现以下步骤：接收用户终端根据待更新工作表生成的工作表缩略图和缩略图添加指令；根据缩略图添加指令将工作表缩略图添加至当前登录账号对应的个人文件夹中。
在一个实施例中，处理器执行计算机可读指令时实现根据缩略图添加指令将工作表缩略图添加至当前登录账号对应的个人文件夹中时还用于：查找个人文件夹中是否存在与工作表缩略图对应的历史缩略图；当查找到历史缩略图时，将历史缩略图与工作表缩略图生成缩略图合集，并将工作表缩略图设置为缩略图集合的显示图标。
在一个实施例中，处理器执行计算机可读指令时还实现以下步骤：当从工作簿更新请求中识别出隐藏标识时，查找当前登录账号对应的账号级别；根据账号级别对待更新工作表进行隐藏设置。
在一个实施例中，处理器执行计算机可读指令时还实现以下步骤：接收用户终端发送的工作表查看请求，工作表查看请求携带隐藏工作表标识；查找隐藏工作表标识对应的管理账号；根据工作表查看请求生成工作表查看申请，将工作表查看申请发送给管理账号对应的管理终端；接收管理终端对工作表查看申请进行审批后的查看审批结果；当审批结果为申请通过时，生成工作表显示指令发送给用户终端，工作表显示指令用于指示用户终端将隐藏工作表标识对应的隐藏工作表进行显示。
在一个实施例中，处理器执行计算机可读指令时实现根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新时还用于：根据待更新工作表生成第一选项卡；获取待更新工作表标识，从原工作簿中查找与待更新工作表标识对应的选项卡集合；查找选项卡集合中是否存在与当前登录账号匹配的第二选项卡；当存在匹配的第二选项卡时，将选项卡集合中的第二选项卡替换为第一选项卡；当不存在匹配的第二选项卡时，将第一选项卡插入选项卡集合中。
一个或多个存储有计算机可读指令的非易失性计算机可读存储介质，计算机可读指令被一个或多个处理器执行时，使得一个或多个处理器执行以下步骤：接收用户终端发送的工作簿更新请求和待更新工作表，工作簿更新请求携带工作簿标识和当前登录账号；查找与工作簿标识对应的源文件夹；获取当前登录账号对应的编辑权限；从源文件中筛选出与编辑权限匹配的第一文件夹；根据待更新工作表对第一文件夹中工作簿标识对应的原工作簿进行更新。
在一个实施例中，计算机可读指令被处理器执行时还实现以下步骤：接收用户终端根据待更新工作表生成的工作表缩略图和缩略图添加指令；根据缩略图添加指令将工作表缩略图添加至当前登录账号对应的个人文件夹中。
在一个实施例中，计算机可读指令被处理器执行时实现根据缩略图添加指令将工作表缩略图添加至当前登录账号对应的个人文件夹中时还用于：查找个人文件夹中是否存在与工作表缩略图对应的历史缩略图；当查找到历史 缩略图时，将历史缩略图与工作表缩略图生成缩略图合集，并将工作表缩略图设置为缩略图集合的显示图标。
在一个实施例中，计算机可读指令被处理器执行时还实现以下步骤：当从工作簿更新请求中识别出隐藏标识时，查找当前登录账号对应的账号级别；根据账号级别对待更新工作表进行隐藏设置。
在一个实施例中，计算机可读指令被处理器执行时还实现以下步骤：接收用户终端发送的工作表查看请求，工作表查看请求携带隐藏工作表标识；查找隐藏工作表标识对应的管理账号；根据工作表查看请求生成工作表查看申请，将工作表查看申请发送给管理账号对应的管理终端；接收管理终端对工作表查看申请进行审批后的查看审批结果；当审批结果为申请通过时，生成工作表显示指令发送给用户终端，工作表显示指令用于指示用户终端将隐藏工作表标识对应的隐藏工作表进行显示。
在一个实施例中，计算机可读指令被处理器实现根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新时还用于：根据待更新工作表生成第一选项卡；获取待更新工作表标识，从原工作簿中查找与待更新工作表标识对应的选项卡集合；查找选项卡集合中是否存在与当前登录账号匹配的第二选项卡；当存在匹配的第二选项卡时，将选项卡集合中的第二选项卡替换为第一选项卡；当不存在匹配的第二选项卡时，将第一选项卡插入选项卡集合中。
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程，是可以通过计算机可读指令来指令相关的硬件来完成，所述的计算机可读指令可存储于一非易失性计算机可读取存储介质中，该计算机可读指令在执行时，可包括如上述各方法的实施例的流程。其中，本申请所提供的各实施例中所使用的对存储器、存储、数据库或其它介质的任何引用，均可包括非易失性和/或易失性存储器。非易失性存储器可包括只读存储器(ROM)、可编程ROM(PROM)、电可编程ROM(EPROM)、电可擦除可编程ROM(EEPROM)或闪存。易失性存储器可包括随机存取存储器(RAM)或者外部高速缓冲存储器。作为说明而非局限，RAM以多种形式可得，诸如静态RAM(SRAM)、动态RAM(DRAM)、同步DRAM(SDRAM)、双数据率SDRAM(DDRSDRAM)、增强型SDRAM(ESDRAM)、同步链路(Synchlink)DRAM(SLDRAM)、存储器总线(Rambus)直接RAM(RDRAM)、直接存储器总线动态RAM(DRDRAM)、以及存储器总线动态RAM(RDRAM)等。
以上实施例的各技术特征可以进行任意的组合，为使描述简洁，未对上述实施例中的各个技术特征所有可能的组合都进行描述，然而，只要这些技 术特征的组合不存在矛盾，都应当认为是本说明书记载的范围。
以上所述实施例仅表达了本申请的几种实施方式，其描述较为具体和详细，但并不能因此而理解为对发明专利范围的限制。应当指出的是，对于本领域的普通技术人员来说，在不脱离本申请构思的前提下，还可以做出若干变形和改进，这些都属于本申请的保护范围。因此，本申请专利的保护范围应以所附权利要求为准。

Claims (20)

  1. 一种工作簿处理方法，包括：
    接收用户终端发送的工作簿更新请求和待更新工作表，所述工作簿更新请求携带工作簿标识和当前登录账号；
    查找与所述工作簿标识对应的源文件夹；
    获取所述当前登录账号对应的编辑权限；
    从所述源文件中筛选出与所述编辑权限匹配的第一文件夹；及
    根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新。
  2. 根据权利要求1所述的方法，其特征在于，所述方法还包括：
    接收所述用户终端根据所述待更新工作表生成的工作表缩略图和缩略图添加指令；及
    根据所述缩略图添加指令将所述工作表缩略图添加至所述当前登录账号对应的个人文件夹中。
  3. 根据权利要求2所述的方法，其特征在于，所述根据所述缩略图添加指令将所述工作表缩略图添加至所述当前登录账号对应的个人文件夹中，包括：
    查找所述个人文件夹中是否存在与所述工作表缩略图对应的历史缩略图；及
    当查找到历史缩略图时，将所述历史缩略图与所述工作表缩略图生成缩略图合集，并将所述工作表缩略图设置为缩略图集合的显示图标。
  4. 根据权利要求1所述的方法，其特征在于，所述方法还包括：
    当从所述工作簿更新请求中识别出隐藏标识时，查找所述当前登录账号对应的账号级别；及
    根据所述账号级别对所述待更新工作表进行隐藏设置。
  5. 根据权利要求4所述的方法，其特征在于，所述方法还包括：
    接收所述用户终端发送的工作表查看请求，所述工作表查看请求携带隐藏工作表标识；
    查找所述隐藏工作表标识对应的管理账号；
    根据所述工作表查看请求生成工作表查看申请，将所述工作表查看申请发送给所述管理账号对应的管理终端；
    接收所述管理终端对所述工作表查看申请进行审批后的查看审批结果；及
    当所述审批结果为申请通过时，生成工作表显示指令发送给所述用户终端，所述工作表显示指令用于指示所述用户终端将所述隐藏工作表标识对应 的隐藏工作表进行显示。
  6. 根据权利要求1所述的方法，其特征在于，所述根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新，包括：
    根据所述待更新工作表生成第一选项卡；
    获取待更新工作表标识，从所述原工作簿中查找与所述待更新工作表标识对应的选项卡集合；
    查找所述选项卡集合中是否存在与所述当前登录账号匹配的第二选项卡；
    当存在匹配的第二选项卡时，将所述选项卡集合中的第二选项卡替换为所述第一选项卡；及
    当不存在匹配的第二选项卡时，将所述第一选项卡插入所述选项卡集合中。
  7. 一种工作簿处理装置，装置包括：
    更新请求接收模块，用于接收用户终端发送的工作簿更新请求和待更新工作表，所述工作簿更新请求携带工作簿标识和当前登录账号；
    源文件夹查找模块，用于查找与所述工作簿标识对应的源文件夹；
    编辑权限获取模块，用于获取所述当前登录账号对应的编辑权限；
    文件夹筛选模块，用于从所述源文件中筛选出与所述编辑权限匹配的第一文件夹；及
    工作簿更新模块，用于根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新。
  8. 根据权利要求7所述的装置，其特征在于，所述装置包括：
    缩略图生成模块，用于接收所述用户终端根据所述待更新工作表生成的工作表缩略图和缩略图添加指令；及
    缩略图添加模块，用于根据所述缩略图添加指令将所述工作表缩略图添加至所述当前登录账号对应的个人文件夹中。
  9. 一种计算机设备，包括存储器及一个或多个处理器，所述存储器中储存有计算机可读指令，所述计算机可读指令被所述一个或多个处理器执行时，使得所述一个或多个处理器执行以下步骤：
    接收用户终端发送的工作簿更新请求和待更新工作表，所述工作簿更新请求携带工作簿标识和当前登录账号；
    查找与所述工作簿标识对应的源文件夹；
    获取所述当前登录账号对应的编辑权限；
    从所述源文件中筛选出与所述编辑权限匹配的第一文件夹；及
    根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新。
  10. 根据权利要求9所述的计算机设备，其特征在于，所述处理器执行所述计算机可读指令时还执行以下步骤：
    接收所述用户终端根据所述待更新工作表生成的工作表缩略图和缩略图添加指令；及
    根据所述缩略图添加指令将所述工作表缩略图添加至所述当前登录账号对应的个人文件夹中。
  11. 根据权利要求10所述的计算机设备，其特征在于，所述处理器执行所述计算机可读指令时实现所述根据所述缩略图添加指令将所述工作表缩略图添加至所述当前登录账号对应的个人文件夹中，还包括：
    查找所述个人文件夹中是否存在与所述工作表缩略图对应的历史缩略图；及
    当查找到历史缩略图时，将所述历史缩略图与所述工作表缩略图生成缩略图合集，并将所述工作表缩略图设置为缩略图集合的显示图标。
  12. 根据权利要求9所述的计算机设备，其特征在于，所述处理器执行所述计算机可读指令时还执行以下步骤：
    当从所述工作簿更新请求中识别出隐藏标识时，查找所述当前登录账号对应的账号级别；及
    根据所述账号级别对所述待更新工作表进行隐藏设置。
  13. 根据权利要求12所述的计算机设备，其特征在于，所述处理器执行所述计算机可读指令时还执行以下步骤：
    接收所述用户终端发送的工作表查看请求，所述工作表查看请求携带隐藏工作表标识；
    查找所述隐藏工作表标识对应的管理账号；
    根据所述工作表查看请求生成工作表查看申请，将所述工作表查看申请发送给所述管理账号对应的管理终端；
    接收所述管理终端对所述工作表查看申请进行审批后的查看审批结果；及
    当所述审批结果为申请通过时，生成工作表显示指令发送给所述用户终端，所述工作表显示指令用于指示所述用户终端将所述隐藏工作表标识对应的隐藏工作表进行显示。
  14. 根据权利要求9所述的计算机设备，其特征在于，所述处理器执行所述计算机可读指令时实现所述根据所述待更新工作表对所述第一文件夹中 所述工作簿标识对应的原工作簿进行更新，还包括：
    根据所述待更新工作表生成第一选项卡；
    获取待更新工作表标识，从所述原工作簿中查找与所述待更新工作表标识对应的选项卡集合；
    查找所述选项卡集合中是否存在与所述当前登录账号匹配的第二选项卡；
    当存在匹配的第二选项卡时，将所述选项卡集合中的第二选项卡替换为所述第一选项卡；及
    当不存在匹配的第二选项卡时，将所述第一选项卡插入所述选项卡集合中。
  15. 一个或多个存储有计算机可读指令的非易失性计算机可读存储介质，所述计算机可读指令被一个或多个处理器执行时，使得所述一个或多个处理器执行以下步骤：
    接收用户终端发送的工作簿更新请求和待更新工作表，所述工作簿更新请求携带工作簿标识和当前登录账号；
    查找与所述工作簿标识对应的源文件夹；
    获取所述当前登录账号对应的编辑权限；
    从所述源文件中筛选出与所述编辑权限匹配的第一文件夹；及
    根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新。
  16. 根据权利要求15所述的存储介质，其特征在于，所述计算机可读指令被所述处理器执行时还执行以下步骤：
    接收所述用户终端根据所述待更新工作表生成的工作表缩略图和缩略图添加指令；及
    根据所述缩略图添加指令将所述工作表缩略图添加至所述当前登录账号对应的个人文件夹中。
  17. 根据权利要求16所述的存储介质，其特征在于，所述计算机可读指令被所述处理器执行时实现所述根据所述缩略图添加指令将所述工作表缩略图添加至所述当前登录账号对应的个人文件夹中，还包括：
    查找所述个人文件夹中是否存在与所述工作表缩略图对应的历史缩略图；及
    当查找到历史缩略图时，将所述历史缩略图与所述工作表缩略图生成缩略图合集，并将所述工作表缩略图设置为缩略图集合的显示图标。
  18. 根据权利要求15所述的存储介质，其特征在于，所述计算机可读指 令被所述处理器执行时还执行以下步骤：
    当从所述工作簿更新请求中识别出隐藏标识时，查找所述当前登录账号对应的账号级别；及
    根据所述账号级别对所述待更新工作表进行隐藏设置。
  19. 根据权利要求18所述的存储介质，其特征在于，所述计算机可读指令被所述处理器执行时还执行以下步骤：
    接收所述用户终端发送的工作表查看请求，所述工作表查看请求携带隐藏工作表标识；
    查找所述隐藏工作表标识对应的管理账号；
    根据所述工作表查看请求生成工作表查看申请，将所述工作表查看申请发送给所述管理账号对应的管理终端；
    接收所述管理终端对所述工作表查看申请进行审批后的查看审批结果；及
    当所述审批结果为申请通过时，生成工作表显示指令发送给所述用户终端，所述工作表显示指令用于指示所述用户终端将所述隐藏工作表标识对应的隐藏工作表进行显示。
  20. 根据权利要求15所述的存储介质，其特征在于，所述计算机可读指令被所述处理器执行时实现所述根据所述待更新工作表对所述第一文件夹中所述工作簿标识对应的原工作簿进行更新，还包括：
    根据所述待更新工作表生成第一选项卡；
    获取待更新工作表标识，从所述原工作簿中查找与所述待更新工作表标识对应的选项卡集合；
    查找所述选项卡集合中是否存在与所述当前登录账号匹配的第二选项卡；
    当存在匹配的第二选项卡时，将所述选项卡集合中的第二选项卡替换为所述第一选项卡；及
    当不存在匹配的第二选项卡时，将所述第一选项卡插入所述选项卡集合中。
PCT/CN2018/096906 2018-05-21 2018-07-24 工作簿处理方法、装置、计算机设备和存储介质 Ceased WO2019223091A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810490875.2A CN108763393B (zh) 2018-05-21 2018-05-21 工作簿管理方法、装置、计算机设备和存储介质
CN201810490875.2 2018-05-21

Publications (1)

Publication Number Publication Date
WO2019223091A1 true WO2019223091A1 (zh) 2019-11-28

Family

ID=64007482

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/096906 Ceased WO2019223091A1 (zh) 2018-05-21 2018-07-24 工作簿处理方法、装置、计算机设备和存储介质

Country Status (2)

Country Link
CN (1) CN108763393B (zh)
WO (1) WO2019223091A1 (zh)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110489155B (zh) * 2019-08-26 2024-01-09 北京达佳互联信息技术有限公司 数据文件管理方法、装置、电子设备及介质
CN113780964A (zh) * 2020-06-10 2021-12-10 珠海金山办公软件有限公司 一种实现数据处理的方法、装置、计算机设备及存储介质
CN112288609B (zh) * 2020-10-30 2025-01-03 深圳市普拉图科技发展有限公司 一种教学资源组织方法及装置
CN112508540A (zh) * 2020-12-28 2021-03-16 浪潮云信息技术股份公司 一种表单协同工具及其权限设计方法
CN114020700B (zh) * 2021-09-23 2025-10-28 联想(北京)有限公司 一种数据处理方法及装置

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20160019241A1 (en) * 2010-12-03 2016-01-21 Salesforce.Com, Inc. Social files
CN106484853A (zh) * 2016-10-09 2017-03-08 网易（杭州）网络有限公司 文档分析方法及装置
CN106605220A (zh) * 2014-07-02 2017-04-26 道库门特公司Ip信托单位 用于选择性文档修订的方法及系统
CN107506658A (zh) * 2017-07-10 2017-12-22 上海最会保网络科技有限公司 一种用户权限管理系统及方法

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10026083B1 (en) * 2014-05-11 2018-07-17 Square, Inc. Tab for a venue
US20170075528A1 (en) * 2015-09-11 2017-03-16 Samsung Electronics Co., Ltd. Method and electronic device for tab navigation and control
CN107992461A (zh) * 2017-11-23 2018-05-04 郑州云海信息技术有限公司 一种多人同时编辑同一文档的装置及方法

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20160019241A1 (en) * 2010-12-03 2016-01-21 Salesforce.Com, Inc. Social files
CN106605220A (zh) * 2014-07-02 2017-04-26 道库门特公司Ip信托单位 用于选择性文档修订的方法及系统
CN106484853A (zh) * 2016-10-09 2017-03-08 网易（杭州）网络有限公司 文档分析方法及装置
CN107506658A (zh) * 2017-07-10 2017-12-22 上海最会保网络科技有限公司 一种用户权限管理系统及方法

Also Published As

Publication number Publication date
CN108763393B (zh) 2023-04-18
CN108763393A (zh) 2018-11-06

Similar Documents

Publication Publication Date Title
CN108509400B (zh) 单据模板生成方法、装置、计算机设备和存储介质
US12124796B2 (en) Generating fillable documents and fillable templates in a collaborative environment
US11163906B2 (en) Adaptive redaction and data releasability systems using dynamic parameters and user defined rule sets
WO2019223091A1 (zh) 工作簿处理方法、装置、计算机设备和存储介质
WO2020186786A1 (zh) 文件处理方法、装置、计算机设备和存储介质
US8201079B2 (en) Maintaining annotations for distributed and versioned files
US20180075138A1 (en) Electronic document management using classification taxonomy
US7689578B2 (en) Dealing with annotation versioning through multiple versioning policies and management thereof
US11768999B2 (en) Collaborative in-line content item annotations
US9954935B2 (en) Enriching contact data based on content sharing history in a content management system
US8751535B1 (en) Systems and methods for securely storing, controlling and sharing personal information
US11644952B2 (en) Processing electronic signature data in a collaborative environment
WO2019134340A1 (zh) 薪资计算方法、应用服务器及计算机可读存储介质
CN111708971A (zh) 页面配置方法、装置、计算机设备和存储介质
US20200279004A1 (en) Building lineages of documents
US10922306B2 (en) Systems and methods for automated bulk user registration spanning both a content management system and any software applications embedded therein
JP7813439B2 (ja) プログラム、方法、情報処理装置、及びシステム
US12001388B2 (en) Information importing method and apparatus
WO2020258650A1 (zh) 页面信息显示方法、装置、计算机设备和存储介质
WO2020233014A1 (zh) 消息发送方法、装置、计算机设备和存储介质
TWM607639U (zh) 客戶資料管理系統
CN115526731A (zh) 任务批处理方法、装置、计算机设备及存储介质
US20250021676A1 (en) Systems and methods for providing content level privileges
WO2019210573A1 (zh) 生成电子订单的方法、装置、计算机设备和存储介质
HK40045090A (zh) 信息导入方法及装置

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18920042

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 18920042

Country of ref document: EP

Kind code of ref document: A1