A method and device for deleting an excel worksheet

Abstract

The invention discloses an Excel work table deletion method and apparatus. The method comprises the steps of obtaining a work table name corresponding to at least one target work table selected in a name panel by a user, wherein the name panel is suspended in a non operation region of the current work table and comprises work name names of all work tables with operation behaviors in an Excel workbook, and each work table name establishes a link relationship with the work table; judging whether the target work table is in a hidden state or not, wherein the condition that the work table is in the hidden state represents that the user executes deletion operation of the work table and caches the work table in the Excel workbook; when the target work table is in the hidden state, setting the work table name corresponding to the target work table in the name panel to have a target color different from an original color; and in response to a command for storing the Excel workbook, deleting the target work table corresponding to the work table name set to have the target color. According to the Excel work table deletion method and apparatus, the convenience of deleting the work table can be improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for deleting an Excel worksheet. Background technique [0002] An Excel workbook consists of one or more worksheets. When there are a large number of worksheets in an Excel workbook, the user cannot view all the worksheets after opening the Excel workbook. To delete the target worksheet, you need to use the mouse to perform the following operations: [0003] First, select the target sheet. Specifically, see figure 1 One of the schematic diagrams of worksheet labels shown, first use the left mouse button to click the button in the left box, so that the name label of the target worksheet is displayed in the visible area of ​​the worksheet label bar, and use the left mouse button to Select the name tab of the target sheet in question; or, see figure 2 As shown in the second diagram of the worksheet label, first click the right mouse button on the lef...

AI Technical Summary

Problems solved by technology

[0005] To sum up, when the user wants to delete a worksheet, he needs to click the mouse four times at least to delete a worksheet. However, when there are a large number of worksheets in the Excel workbook, if the user needs to delete multiple worksheets, he needs to It takes multiple clicks to find and delete multiple worksheets from the Excel workbook. It can be seen that the existing operation of deleting worksheets is very cumbersome

Images