Electronic table introduction method, device, equipment and medium

Abstract

The present disclosure relates to an electronic table import method, device, equipment and medium, where the electronic table import method includes the steps of receiving an electronic table waiting to be imported (S101), and displaying the image object in a target table unit of a database table when a table object in the electronic table includes an image object (S102), where the target table unit is determined based on a cell position of a target cell, the target cell being a cell in the electronic table to which the image object belongs, and the cell position is determined based on a data area of ​​the electronic table. According to an embodiment of the present disclosure, when a table object in the electronic table includes an image object, the image object can be displayed or stored in the target table unit of the database table, ensuring the data integrity after the electronic table data is imported into the database table.

Description

[Technical Field]

[0001] This application claims priority to Chinese Patent Application No. 202110560039.9, filed on May 21, 2021, for the invention entitled "Electronic Table Introducing Method, Apparatus, Device and Medium," the entire contents of which are incorporated herein by reference.

[0002] The present disclosure relates to the technical field of data processing, and in particular to an electronic table implementation method, device, apparatus and medium. [Background technology]

[0003] When applying database table products, it may be necessary to import the contents of an electronic table such as Excel into a database table.

[0004] An electronic table can contain image objects. The image objects are not stored in the cells of the electronic table but are stored as attachments, and can be displayed in a floating format when displayed. In this case, when the electronic table is introduced into a database table, the image objects do not belong to the contents of the cells in the electronic table, so the database table simply ignores the image objects and does not introduce them, resulting in the loss of data content. Summary of the Invention [Problem to be solved by the invention]

[0005] To solve or at least partially solve the above technical problems, the present disclosure provides an electronic table introduction method, device, apparatus and medium. [Means for solving the problem]

[0006] According to a first aspect, the present disclosure provides an electronic table introduction method, the method comprising: receiving an electronic table awaiting introduction; If the table object in the electronic table includes an image object, displaying the image object in a target table unit of a database table; Here, the target table unit is determined based on the cell position of the target cell, which is the cell to which the image object belongs in the electronic table, and the cell position is determined based on the data area of ​​the electronic table.

[0007] According to a second aspect, the present disclosure provides an electronic table introduction method, the method comprising: receiving a file import request, the file import request carrying an electronic table waiting to be imported; if a table object in the electronic table includes an image object, determining a target cell to which the image object belongs, the target cell being a cell in the electronic table; determining a target table unit located in a database table based on a cell location of the target cell, where the cell location is determined based on a data field of the electronic table; storing the image object in the target table unit.

[0008] According to a third aspect, the present disclosure provides an electronic table introduction device, the device comprising: a first receiving unit configured to receive the electronic table awaiting introduction; an object display unit configured to display an image object in a target table unit of a database table if the table object in the electronic table includes the image object; Here, the target table unit is determined based on the cell position of the target cell, which is the cell to which the image object belongs in the electronic table, and the cell position is determined based on the data area of ​​the electronic table.

[0009] According to a fourth aspect, the present disclosure provides an electronic table introduction device, the device comprising: a second receiving unit configured to receive a file import request, the file import request carrying an electronic table to be imported; a first determination unit configured to determine a target cell to which an image object belongs when detecting that a table object in the electronic table includes an image object, the target cell being a cell in the electronic table; a second determination unit configured to determine a target table unit located in a database table according to a cell location of the target cell, wherein the cell location is determined according to a data field of the electronic table; an object storage unit configured to store the image object within the target table unit.

[0010] According to a fifth aspect, the present disclosure provides an electronic table introduction device, the device comprising: a processor; a memory for storing executable instructions; Here, the processor is used to implement the electronic table import method provided by the first or second aspect by reading the executable instructions from the memory and executing the executable instructions.

[0011] According to a sixth aspect, the present disclosure provides a computer-readable storage medium, the storage medium storing a computer program, which, when executed by a processor, causes the processor to implement the electronic table introduction method provided in the first or second aspect.

[0012] The technical solutions provided by the embodiments of the present disclosure have the following advantages over the prior art:

[0013] The electronic table import method, device, equipment, and medium provided by the present disclosure can display or store the image object in the target table unit of the database table when the table object in the electronic table includes an image object, and further prevent the image object from being deleted, and ensure the integrity of the data after the electronic table data is imported into the database table. [Brief explanation of the drawings]

[0014] These and other features, advantages, and aspects of examples of the present disclosure will become more apparent with reference to the following specific embodiments in conjunction with the accompanying drawings. Identical or similar reference numerals represent identical or similar elements throughout the drawings. It should be understood that the drawings are schematic and that actual objects and elements are not necessarily drawn to scale. [Figure 1] FIG. 1 is an architectural schematic diagram of an electronic table implementation. [Figure 2] 1 is a flowchart of an electronic table import method provided by an embodiment of the present disclosure. [Figure 3] FIG. 1 is a configuration diagram of an electronic table awaiting introduction provided by an embodiment of the present disclosure. [Figure 4] FIG. 2 is a schematic diagram of a database table displayed by an embodiment of the present disclosure. [Figure 5] FIG. 10 is a configuration diagram of an electronic table awaiting introduction provided by another embodiment of the present disclosure. [Figure 6] FIG. 10 is a schematic diagram of a database table displayed according to another embodiment of the present disclosure. [Figure 7] FIG. 10 is a block diagram of an electronic table awaiting introduction provided by yet another embodiment of the present disclosure. [Figure 8] FIG. 10 is a schematic diagram of a database table displayed according to yet another embodiment of the present disclosure. [Figure 9] FIG. 10 is a block diagram of an electronic table awaiting introduction provided by yet another embodiment of the present disclosure. [Figure 10] FIG. 10 is a schematic diagram of a database table displayed according to yet another embodiment of the present disclosure. [Figure 11] FIG. 10 is a block diagram of an electronic table awaiting introduction provided by yet another embodiment of the present disclosure. [Figure 12] FIG. 10 is a schematic diagram of a database table displayed according to yet another embodiment of the present disclosure. [Figure 13] FIG. 10 is a block diagram of an electronic table awaiting introduction provided by yet another embodiment of the present disclosure. [Figure 14] FIG. 10 is a schematic diagram of a database table displayed according to yet another embodiment of the present disclosure. [Figure 15] 1 is a flowchart of another electronic table import method provided by an embodiment of the present disclosure. [Figure 16] 1 is a schematic diagram of the location of an electronic object in an electronic table according to an embodiment of the present disclosure. [Figure 17] 1 is a schematic configuration diagram of an electronic table introduction device provided by an embodiment of the present disclosure. [Figure 18] FIG. 10 is a schematic diagram of another electronic table introduction device provided by an embodiment of the present disclosure. [Figure 19] 1 shows a schematic configuration diagram of an electronic table introduction device provided by an embodiment of the present disclosure. [Explanation of symbols]

[0015] 110...electronic device, 120...server, 11...electronic table, 12...image object, 13...target cell, 14...database table, 15...target table unit, 1700...electronic table introduction device, 1701...first receiving unit, 1702...object display unit, 1800...electronic table introduction device, 1801...second receiving unit, 1802...first determination unit, 1803...second determination unit, 1804...object storage unit, 1901...processing device, 1902...ROM, 1903...RAM, 1904...bus, 1905...input / output (I / O) interface, 1906...input device, 1907...output device, 1908...storage device, 1909...communication device DETAILED DESCRIPTION OF THE INVENTION

[0016] Hereinafter, embodiments of the present disclosure will be described in more detail with reference to the accompanying drawings. Although several embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be realized in various ways and should not be construed as being limited to the embodiments described herein, but rather, these embodiments are provided to provide a more complete and thorough understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are used only for illustrative purposes and are not used to limit the scope of protection of the present disclosure.

[0017] It should be understood that the steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. Also, method embodiments may include additional steps and / or omit the performance of steps shown. The scope of the present disclosure is not limited in this respect.

[0018] As used herein, the term "comprises" and variations thereof are open inclusive, meaning "including, but not limited to." The term "based on" means "based at least in part on." The term "one embodiment" means "at least one embodiment," the term "another embodiment" means "at least one other embodiment," and the term "some embodiments" means "at least some embodiments." Definitions of other terms are provided below.

[0019] It should be noted that the concepts of "first," "second," etc. referred to in this disclosure are used only to distinguish between different devices, modules, or units, and do not define the order or interdependence of functions performed by these devices, modules, or units.

[0020] It will be appreciated by those skilled in the art that the modifications "one" and "multiple" referred to in the present disclosure are intended to be general rather than limiting and should be understood as "one or more" unless the context clearly indicates otherwise.

[0021] The names of messages or information exchanged between devices in the embodiments of the present disclosure are used for descriptive purposes only and are not used to limit the scope of these messages or information.

[0022] The present disclosure provides a method, device, equipment, and medium for importing an electronic table, where the electronic table is a table that displays an image object in a floating manner, such as an Excel table, an Access table, or a WPS table. The following describes the architecture of the electronic table importing method according to an embodiment of the present disclosure and the application scenarios of the related technologies, taking an Excel file as an example of the electronic table.

[0023] 1 is a schematic architecture diagram of the electronic table introduction. As shown in FIG. 1, the architecture of the electronic table introduction can include at least one electronic device 110 located on the client side and at least one server 120 located on the service side, where the server 120 establishes a communication connection with the electronic device 110 and exchanges information.

[0024] In practical applications, the electronic device can be a mobile phone, a tablet, a desktop computer, an all-in-one, an in-vehicle device, a wearable device, etc. The server can be a cloud server or a server cluster, and the server should be a server that can have database processing functions.

[0025] Based on the above architecture, after a user inputs an Excel-format electronic table into the electronic device 110, the electronic device transmits the electronic table to the server 120. After receiving the electronic table, the server 120 generates a new database table based on the electronic table and feeds the database table back to the electronic device 110. After receiving the database table fed back by the server 120, the electronic device 110 displays and outputs the database table on the output interface.

[0026] In another application of the present disclosure, the electronic table import architecture can include only one terminal device. After a user imports an Excel-format electronic table into the terminal, the terminal directly processes the electronic table to generate a new database table, and displays and outputs the generated database table.

[0027] Since such electronic tables have image objects independent of the table area, in normal applications, when the data of the electronic table is introduced into a database table, the image stored therein is directly deleted. However, storing an image when a user creates an electronic table means that the image object becomes part of the electronic table data, and directly deleting the image object will result in the loss of the data stored in the electronic table data.

[0028] To solve the above problems, the embodiments of the present disclosure provide an electronic table import method, device, apparatus, and medium that, when an electronic table has an image object, also imports the image object into a target table unit in a database table, thereby preventing the image object from being deleted.

[0029] 2 is a flowchart of an electronic table input method provided by an embodiment of the present disclosure. In some embodiments of the present disclosure, the electronic table input method shown in FIG. 2 is performed by the electronic device of FIG.

[0030] As shown in FIG. 2, the electronic table introduction method includes steps S101 to S102.

[0031] In step S101, an electronic table waiting to be introduced is received.

[0032] In an embodiment of the present disclosure, an electronic device can receive an electronic table that a user has installed in a specific application program. Specifically, the electronic device can receive the electronic table file itself that the user has selected through a file directory, and can also receive a portion of an area that the user has selected in the electronic table after opening the electronic table in an application program.

[0033] In step S102, if the table object in the electronic table includes an image object, the image object is displayed in the target table unit of the database table.

[0034] In practical applications, the table objects in an electronic table can be of various object types, such as image objects, numeric objects, text objects, and so on.

[0035] Among them, objects such as numeric objects and text objects can be stored directly in the data area of ​​the cells of the electronic table, and when the electronic table displays output, the numeric object or text object is directly displayed as output.Image objects can be stored as attachments to the electronic table, and the position of the electronic table relative to the cell is stored in the electronic table, and when the electronic table displays output, the image object is displayed above the cell in a floating manner according to the stored position.

[0036] In step S102, if the table object in the electronic table includes an image object, the image object is retained in the database table so that the image object is stored in the target table unit of the database table and the output is displayed in the target table unit.

[0037] In the embodiment of the present disclosure, the target table unit can be determined based on the cell position of the target cell, which is the cell to which the image object belongs in the electronic table. That is, in step S102, the target table unit corresponding to the target cell in the database table is determined based on the cell to which the image object belongs in the electronic table, and then the image object is displayed within the display area surrounded by the target table unit.

[0038] In the embodiment of the present disclosure, the cell position of the target cell can be determined based on the data area of ​​the electronic table, which is the area in the electronic table where the contents of the matrix are stored. Specifically, how to determine the cell position of the target cell based on the data area will be described with reference to the following specific example.

[0039] In the embodiment of the present disclosure, after receiving the introduced electronic table, the electronic device 110 transmits the electronic table to the server and receives the database table fed back by the server, which is the server 120 shown in FIG.

[0040] By adopting the electronic table import method provided in the embodiments of the present disclosure, if a table object in an electronic table includes an image object, the image object will be displayed in the target table unit of the database table to prevent the image object from being deleted and ensure the integrity of the data after the electronic table data is imported into the database table.

[0041] In the following, the electronic table introduction method provided by the embodiment of the present disclosure will be specifically analyzed in relation to the positional situations when various image objects appear in the electronic table.

[0042] 3 is a diagram illustrating the configuration of an electronic table awaiting introduction provided by an embodiment of the present disclosure. As shown in FIG. 3, in one embodiment of the present disclosure, the data area of ​​the electronic table awaiting introduction 11 is the area where data content exists in the rows and columns in the figure (specifically, the rectangular area surrounded by a thick solid line in the figure). As shown in FIG. 3, in this embodiment, the table object of the electronic table 11 includes an image object 12 located within the data area of ​​the electronic table 11, specifically within the area range of the second column of the electronic table 11.

[0043] The first image object 12 in the upper left corner shown in the corresponding Figure 3 is located in the second row and second column of the data area of ​​the electronic table 11, and the cell it belongs to is the cell whose code in the data area of ​​the electronic table 11 is displayed as the second row and second column, i.e., the corresponding target cell 13 is the cell whose row position is 2 and whose column position is 2 (both the row position and the column position are cell positions).

[0044] In an embodiment of the present disclosure, if the target cell is located in the data area, the target table unit is located at the cell position in the database table.

[0045] 4 is a schematic diagram of a database table displayed in an embodiment of the present disclosure, where the database table 14 in FIG. 4 is generated and displayed based on the electronic table 11 provided in FIG. 3. As shown in FIG. 4, based on the cell position of the target cell 13, the target table unit 15 is determined to be the cell whose row position is 2 and whose column position is 2 in the database table 14. After the position of the target table unit 15 is determined, the image object 12 belonging to the target cell 13 in the second row and second column in the electronic table 11 is displayed and output in the second row and second column in the database table 14.

[0046] That is, in the embodiment shown in FIGS. 3 and 4, if the target cell 13 is located in the data area, the target table unit 15 is also located in a cell in the database table 14 .

[0047] 5 is a diagram illustrating the configuration of an electronic table awaiting introduction provided by another embodiment of the present disclosure. As shown in FIG. 5, in another embodiment of the present disclosure, the data area of ​​the electronic table awaiting introduction 11 is an area where data content exists in rows and columns in the figure (specifically, a rectangular area surrounded by a thick solid line in the figure).

[0048] 5, in this embodiment, the table object of the electronic table 11 includes an image object 12 located on the left side of the data area of ​​the electronic table 11. In the embodiment of the present disclosure, the cell in the upper left corner of the data area of ​​the electronic table 11 is the cell in the first row and first column, and the number of rows gradually increases from top to bottom and the number of columns gradually increases from left to right, so that the data area of ​​the electronic table 11 includes 5 rows and 4 columns. According to this rule, the cell position of the target cell 13 where the image object 12 is located is the second row and the -1st column, and the target cell 13 where the image object 12 is located is located outside the data area.

[0049] In the embodiment of the present disclosure, the display policy of the database table is that when the target cell 13 is located on the left or right side of the data area, the target table unit is located at the target row position of the newly created column in the database table, and the target row position is the row position of the cell position.

[0050] 6 is a schematic diagram of a database table displayed in another embodiment of the present disclosure. The database table 14 in FIG. 6 is generated and displayed based on the electronic table 11 provided in FIG. 5. As shown in FIG. 6, the first four columns in the database table 14 are generated based on the data field of the electronic table 11. In addition, a new column is added to the database table 14, and the new column is located in the fifth column on the right side. Since the cell position of the target cell 13 is row position 2, column position −1, according to the display policy in the previous paragraph, the target table unit 15 is determined to be the second row in the new column (the position of the second row is the target row position mentioned above).

[0051] After the position of the target table unit 15 is determined, the image object 12 belonging to the target cell 13 in the second row and the -1st column of the electronic table 11 is displayed in the second row and the fifth column of the database table 14 and output.

[0052] In the embodiment of the present disclosure, the newly created column is located at the rightmost position of the database table. In other embodiments, the newly created column may be set at the leftmost position of the database table according to the setting method in the electronic table. In some special cases, the electronic device may also provide a user setting interface for allowing the user to determine the relative position of the newly created column with respect to each column of the data area in the electronic table 11.

[0053] 7 is a diagram illustrating the configuration of an electronic table awaiting introduction provided in yet another embodiment of the present disclosure. As shown in FIG. 7, in yet another embodiment of the present disclosure, the data area of ​​the electronic table awaiting introduction 11 is an area in which data content exists in rows and columns in the figure (specifically, a rectangular area surrounded by a thick solid line in the figure). As shown in FIG. 7, in this embodiment, the table object of the electronic table 11 includes an image object 12 located below the data area of ​​the electronic table 11.

[0054] In the embodiment of the present disclosure, the cell at the top left corner of the data area of ​​the electronic table 11 is the cell in the first row and the first column, and the number of rows gradually increases from top to bottom and the number of columns gradually increases from left to right, so that the data area of ​​the electronic table 11 includes 5 rows and 4 columns. According to this rule, the cell position of the target cell 13 where the image object 12 is located is the 6th row and the 2nd column, and the target cell 13 where the image object 12 is located is located outside the data area.

[0055] In the embodiment of the present disclosure, the display policy of the database table is that when the target cell 13 is located above or below the data area, the target table unit is located at the target column position of the newly created row in the database table, and the target column position is the column position of the cell position.

[0056] 8 is a schematic diagram of a database table displayed in yet another embodiment of the present disclosure. The database table 14 in FIG. 8 is generated and displayed based on the electronic table 11 provided in FIG. 6. As shown in FIG. 8, the first five rows of the database table 14 are generated based on the data field of the electronic table 11. A new row is added to the database table 14, and the new row is located at the bottom, the sixth row. Based on the cell position of the target cell 13 and in accordance with the display policy in the previous paragraph, the target table unit 15 is determined to be the cell at row position 6 and column position 2 in the database table 14.

[0057] After the position of the target table unit 15 is determined, the image object 12 belonging to the target cell 13 at the sixth row and second column of the electronic table 11 is displayed at the sixth row and second column of the database table 14 and output.

[0058] In an embodiment of the present disclosure, the newly created row is located at the bottom of the database table. In another embodiment, if the target cell is located at the top of the data area of ​​the electronic table, the newly created row may be set to the top row of the database table according to the setting method in the electronic table. In some special cases, the electronic device may also provide a user setting interface for allowing the user to determine the relative position of the newly created row with respect to each row in the data area of ​​the electronic table.

[0059] 9 is a diagram illustrating the configuration of an electronic table awaiting introduction provided by another embodiment of the present disclosure. As shown in FIG. 9, in another embodiment of the present disclosure, the data area of ​​the electronic table awaiting introduction 11 is an area where data content exists in rows and columns in the figure (specifically, a rectangular area surrounded by a thick solid line in the figure).

[0060] 9, in this embodiment, the table object of the electronic table 11 includes an image object 12 located in the lower right side of the data area of ​​the electronic table 11. In the embodiment of the present disclosure, the cell in the upper left corner of the data area of ​​the electronic table 11 is the cell in the first row and the first column, and the number of rows gradually increases from top to bottom and the number of columns gradually increases from left to right, so that the data area of ​​the electronic table 11 includes 5 rows and 4 columns. According to this rule, the cell position of the target cell 13 where the image object 12 is located is the 6th row and the 5th column, and the target cell 13 where the image object 12 is located is located outside the data area.

[0061] In the embodiment of the present disclosure, if the target cell is located at either the top left or bottom right phase matrix position of the data area, the target table unit is located at a newly created matrix position corresponding to the database table.

[0062] Figure 10 is a schematic diagram of a database table displayed in yet another embodiment of the present disclosure. Database table 14 in Figure 10 is generated and displayed based on electronic table 11 provided in Figure 9. As shown in Figure 10, the first five rows and the first four columns of database table 14 are generated based on the data field of electronic table 11. In addition, a new row and a new column are added to database table 14, with the new row located in the sixth row from the bottom and the new column located in the fifth column from the right.

[0063] Based on the cell position of the target cell 13, the target table unit 15 is determined to be the cell at row position 6 and column position 5 in the database table 14. After the position of the target table unit 15 is determined, the image object 12 belonging to the target cell 13 at row 6, column 5 in the electronic table 11 is displayed and output at row 6, column 5 in the database table 14.

[0064] In each of the above-described embodiments, the image object 12 is located within an area where one cell of the electronic table 11 waiting to be introduced is determined, and therefore, this cell can be directly set as the target cell 13 to which the image object 12 belongs. In other embodiments of the present disclosure, the image object 12 may span an area where multiple cells of the electronic table 11 waiting to be introduced are determined, and in this case, one cell of the multiple cells of the electronic table 11 that are covered by the image object 12 needs to be selected as the target cell 13.

[0065] 11 is a diagram illustrating the configuration of an electronic table awaiting implementation according to another embodiment of the present disclosure. As shown in FIG. 11, in this embodiment, an image object 12 covers two cells in an electronic table 11, and the two cells are located at row 2, column 2 and row 2, column 3 in the data area, respectively. At this time, one of the two cells needs to be determined as a target cell 13, and a target table unit 15 in a database table 14 needs to be determined based on the target cell 13.

[0066] In the embodiment of the present disclosure, when an image object covers multiple cells, one cell selected from the cells covered by the image object is set as the target cell.

[0067] 12 is a schematic diagram of a database table displayed in yet another embodiment of the present disclosure. The database table 14 in FIG. 12 is generated and displayed based on the electronic table 11 provided in FIG.

[0068] 12, in the embodiment of the present disclosure, the target table unit 15 is the cell in the second row and second column of the database table 14, that is, the target cell 13 is selected as the cell in the second row and second column of the electronic table 11. In the embodiment of the present disclosure, the position of the target cell 13 may be selected based on a reference point in the image object 12 (e.g., the upper left corner point of the image object 12), or based on the proportion of the image object 12 in each cell (specifically, when the proportion of the image cell in a certain cell is the largest, the cell is selected as the target cell 13).

[0069] In some applications of the embodiments of the present disclosure, the target table unit 15 needs to be determined based on the object type of the table object stored in the target cell group in addition to being determined based on the cell location of the target cell 13. Here, the target cell group is the cell group to which the target cell 13 belongs. In practical applications, the target cell group may be a row in the electronic table 11, a column in the electronic table, or a set of cells in multiple consecutive rows or columns selected by the user.

[0070] In one embodiment of the present disclosure, if the object types in a target cell group are all image types, the target table unit is determined based on the cell position only.

[0071] Specifically, refer to Figures 3 and 4. Among the cells in Figure 3, the cell group of the target cell 13 is in the second column. After examining all the cells in the second column of the electronic table 11, if it is determined that only the image object 12 and no other objects are stored in this cell group, then the target table unit 15 can be determined based solely on the cell position. In the example of Figures 3 and 4, the target table unit 15 is determined to be the cell whose row position is 2 and whose column position is 2 in the database table 14.

[0072] In one embodiment of the present disclosure, when the object type includes other object types than the image type, the target table unit is located at a target position within a newly created cell group in the database table, the newly created cell group is determined based on the cell group attributes of the target cell group, and the target position is determined based on the cell position.

[0073] 13 is a diagram illustrating the configuration of an electronic table awaiting introduction provided by another embodiment of the present disclosure. As shown in FIG. 13, in another embodiment of the present disclosure, the data area has 5 rows and 4 columns, and the image object 12 is located in the second row and second column of the data area, i.e., the target cell 13 is located in the second row and second column of the data area.

[0074] The cell group corresponding to this target cell 13 is the second column, and by continuing to look at the objects displayed in the second column, it is determined that in addition to the image object 12 displayed in the second row, second column, text objects are also displayed in the third row, second column and the fourth row, second column. In other words, at this time, the second column contains two types of objects. If the objects are introduced into the database table 14 according to the above-mentioned rules, the second column in the database table 14 will simultaneously store the text object and the image object 12, and the data attributes of the objects in one column will no longer be the same.

[0075] In an embodiment of the present disclosure, if the object type of the target cell group includes an object type other than an image type, the target table unit is located at a target position within a newly created cell group in the database table. Here, the newly created cell group is determined based on the cell group attributes of the target cell group, and the target position is determined based on the cell position. To avoid the problem described in the previous paragraph, in an embodiment of the present disclosure, if the cell group including the image object 12 in the electronic table 11 also includes other object types, a new cell group is created in the database table 14, and a target cell 13 group is set at the target position of the newly created cell group.

[0076] 14 is a schematic diagram of a database table displayed in yet another embodiment of the present disclosure. The database table 14 in FIG. 14 is generated and displayed based on the electronic table 11 provided in FIG. 13. As shown in FIG. 14, an image object 12 is stored in the second column. To avoid the simultaneous storage of a text object and an image object 12 in the second column, in this embodiment of the present disclosure, the five rows and four columns of the electronic table 11 are introduced into the database table 14, and one new column (i.e., the fifth column) is added to the database table 14. The image object 12 in the second row and second column of the electronic table 11 is stored in the second row and fifth column, i.e., the target table unit 15 is located in the second row and fifth column of the database table 14.

[0077] 15 is a flowchart of another electronic table import method provided by an embodiment of the present disclosure. In practical application, the electronic table import method may be performed by a server, which may be the server 120 in FIG. 1.

[0078] Referring to FIG. 15, in an embodiment of the present disclosure, the electronic table import method includes steps S201 to S204.

[0079] In step S201, a file import request is received, and the file import request carries an electronic table waiting to be imported.

[0080] In an embodiment of the present disclosure, after an electronic device receives an electronic table installed by a user, the electronic table is sent to a server as part of a file installation request, and after the server receives the file installation request, it can extract the electronic tables that are waiting to be installed.

[0081] In another embodiment of the present disclosure, the electronic device may be a device that both receives a file introduction request and processes the file introduction request, in which case the electronic device directly processes the file introduction request after receiving the file introduction request input by the user.

[0082] In step S202, if the table object in the electronic table includes an image object, determine the target cell to which the image object belongs.

[0083] In the embodiment of the present disclosure, the table objects stored in the electronic table include the following types: (1) Data objects stored in the cells of the electronic table, where the data objects may be text or numeric class data; (2) Image objects stored in the electronic table in the form of attachments, where the image objects are set in a floating manner above the cells when the electronic table is displayed; in actual applications, in addition to containing image objects, the electronic table may also store attribute information of the image objects, including the position coordinates of the image objects and the size of the image objects.

[0084] As before, image objects are not stored directly in the cells of an electronic table, but are stored in the electronic table in the form of attachments and set above the cells in the form of floating display, but in actual applications, the user will identify the image objects as the contents of the cells when setting up the electronic table.

[0085] In order to comply with the setting practice when actually creating an electronic table, in the embodiment of the present disclosure, when the electronic table is introduced into the database table, the image object is not deleted, but the target cell to which the image object belongs is determined. After the target cell to which the image object belongs is determined, in a subsequent step, how to store the image object in the database table is determined.

[0086] In step S203, a target table unit located in the database table is determined based on the cell location of the target cell.

[0087] After the target cell corresponding to the graphical object is determined, in the embodiment of the present disclosure, the attributes of the target cell are re-queried to determine the cell position of the target cell.

[0088] In the embodiment of the present disclosure, the cell position of the target cell is not the absolute table position of the target cell in the electronic table, but a relative position determined based on the data field of the electronic table.

[0089] For example, if the data area in the electronic table starts from the third row, third column of the electronic table, and the target cell is at the fourth row, fourth column of the electronic table, then based on the data area, the cell location of the target cell will be the second row, second column.

[0090] Determining the target table unit located in the database table based on the location of the target cell means determining which cell in the database is the target table unit corresponding to the target cell based on the storage situation in the actual electronic table.

[0091] For example, in one practical application, the cell location of the aforementioned target cell is the second row, second column, and the target table unit is the second row, second column in the database table.

[0092] In step S204, the image object is stored in the target table unit.

[0093] By adopting the electronic table import method provided in the embodiments of the present disclosure, when a table object in an electronic table includes an image object, the image object is displayed in the target table unit of the database table, and the image object cannot be deleted, thereby ensuring the integrity of the data after the electronic table data is imported into the database table.

[0094] In practical application, the method of determining the target cell to which the image object belongs in step S202 varies depending on the number of cells covered by the image object in the electronic table. Specifically, it includes the following (1) to (2):

[0095] (1) When an image object covers only one cell, the cell covered by the image object is set as the target cell.

[0096] Combining the experience of creating electronic tables such as Excel, when placing an image object in a cell, the image object will consist of a data tuple consisting of the cell's position attribute and other corresponding row data. In this case, the cell covered by the image object can be directly set as the target cell.

[0097] (2) When an image object covers multiple cells, one cell selected from the cells covered by the image object is set as the target cell.

[0098] Based on the experience of actually creating electronic tables such as Excel, when an image object covers multiple cells, the image is often large and the corresponding cell size is small, so in order to avoid blurring of the image due to the image size reduction, the image object covers multiple cells. When an image object covers multiple cells, the user creating the electronic table actually just wants the image object to be an element in one cell and to form a data tuple together with the data of other corresponding rows.

[0099] Therefore, in the embodiment of the present disclosure, when an image object covers multiple cells, one cell selected from the cells it covers is taken as the target cell.

[0100] In the embodiment of the present disclosure, when the above-mentioned (2) is specifically realized, it may be subdivided into a plurality of subcases.

[0101] In the first subcase, if the image object completely covers multiple cells, the cell where the reference point of the image object is located is taken as the target cell.

[0102] In the embodiments of the present disclosure, the reference point of the image object may be a corner point or a midpoint of the image object, and the corner point may be any of the upper left corner point, the lower right corner point, the lower left corner point, and the upper right corner point. In practical applications, the upper left corner point is often selected as the reference point.

[0103] If the image object completely covers multiple cells, there is a high probability that the user will set the image object according to the set reference point, for example, in many cases, the user will set the image object according to the upper left corner point of the image object, and the cell where the reference point of the image object is located will be the target cell.

[0104] If the image object completely covers multiple cells, there is a high probability that the image object will be set according to the reference point set by the user at this time. For example, in many cases, the user will set the image object according to the upper left corner point of the image object. At this time, the cell where the reference point of the image object is located is set as the target cell.

[0105] In the second subcase, if the image object does not completely cover multiple cells, the cell where the midpoint of the image object is located is taken as the target cell.

[0106] In the embodiment of the present disclosure, if an image object does not completely cover multiple cells, that is, if the corner points of the image object are misaligned with the corner points of the cells, it is not possible to clearly determine the target cell to which the image object belongs based on the corner points of the image object. In this case, the cell where the midpoint of the image object is located is first determined, and the cell where the midpoint of the image object is located is set as the target cell where the image object is located.

[0107] On the other hand, in the second subcase, the step of determining the cell in which the midpoint of the image object is located may be steps S301 to S303.

[0108] In step S301, the coordinate values ​​of the midpoint of the image object are calculated.

[0109] In the embodiment of the present disclosure, the coordinate value of the midpoint of an image object is calculated. The following situations may also exist: (1) The coordinate values ​​of two opposing corner points of the image object are obtained, and the average value is calculated as the coordinate value of the midpoint of the image object based on the coordinate values ​​of the two opposing corner points. In practical applications, the two opposing corner points are often the upper left corner and the lower right corner of the image object. (2) The coordinate value of one corner point of the image object is obtained, and the length and width of the image object are then obtained. Next, the coordinate value of the midpoint is calculated based on the coordinate value of the one corner point and half the length and width.

[0110] In step S302, based on the ratio occupied by the image object in each cell, the coordinate value is rounded to obtain a rounded coordinate value.

[0111] In a specific application, the ratio occupied by the image object in each cell can be determined, the coordinate value can be rounded, and the row coordinate and column coordinate can be rounded respectively.

[0112] In an embodiment of the present disclosure, the horizontal coordinate in the coordinate value may be rounded based on the ratio occupied by the image object in the two left and right cells, and the vertical coordinate in the coordinate value may be rounded based on the ratio occupied by the image object in the upper and lower cells.

[0113] In an embodiment of the present disclosure, the height of the row of the cell, the width of the column, and the vertical and horizontal of the image object may be represented in point values or emu unit systems. In either case, the dimensions are integer dimensions.

[0114] FIG. 16 is a schematic diagram of the position of an electronic object in an electronic table according to an embodiment of the present disclosure. Here, the horizontal offset of the upper left corner point with respect to the upper left corner point of the upper left cell (row0, col0) is cwoff0, and the vertical offset is rhoff0. The horizontal offset of the lower right corner point with respect to the lower right corner point of the lower right cell (row1, col1) is cwoff1, and the vertical offset is rhoff1. The row width of the upper left cell is cw0, the height is rh0, the row width of the lower right corner point is cw1, and the height is rh1.

[0115] As can be seen from the drawing, the sizes of the two cells on the left side in the image length direction are cw0 - cwoff0, and the sizes of the two cells on the right side are cw1 - cwoff1. When cw0 - cwoff0 ≥ cw1 - cwoff1, the row coordinate of the midpoint is truncated. On the other hand, when cw0 - cwoff0 < cw1 - cwoff1, the row coordinate of the midpoint is rounded up.

[0116] The sizes of the two upper cells in the image height direction are rh0 - rhoff0, and the sizes of the two lower cells are rh1 - rh0ff1. When rh0 - rhoff0 ≥ rh1 - rh0ff1, the column coordinate of the midpoint is truncated. If rh0 - rhoff0 < rh1 - rh0ff1, the column coordinate of the midpoint is rounded up.

[0117] Through the above - mentioned process, a rounded - off midpoint coordinate value can be obtained.

[0118] In step S303, based on the rounded - off coordinate value, determine the cell in which the midpoint of the image object is located among the cells covered by the image object.

[0119] In step S303, after the rounded - off midpoint coordinate value is determined, re - determine which cell the rounded - off midpoint coordinate value is in, that is, this cell can be determined as the cell in which the midpoint of the image object is located.

[0120] At this time, the cell in which the midpoint of the image object is located can be used as the target cell.

[0121] In the embodiments of the present disclosure, determining the target cell to which the image object belongs means that, in accordance with the Extensible Markup Language (XML) in the electronic table, determine the cells covered by the image object, and it is possible to determine the target cell from the cells covered by the image object. That is, in various realizable cases of step 202 described above, the target cell may be determined based on the coordinate data or dimension data in the Extensible Markup Language in the electronic table. In a specific application of the embodiments of the present disclosure, step S203 may specifically include steps S2031 and S2032.

[0122]

[0123] ​In step S2031, the object type of the table object stored in the target cell group is determined.

[0124] The target cell group is the cell group to which the target cell belongs. In practical applications, the target cell group may be the column in which the target cell is located or the row in which the target cell is located. In specific applications, the target cell group is often the column in which the target cell is located.

[0125] In some applications, the target cell group stores only image objects. In other applications, the target cell group stores both image objects and data objects, where the data objects may be text or numeric data. If we continue to introduce objects into the database table according to the above rules, the second column of the database table will store both text objects and image objects, and the data attributes of the objects in one column will no longer be the same.

[0126] In step S2032, it is determined to be located in the target table unit of the database table based on the cell location and the object type.

[0127] If the target cell group only stores image objects, the target table unit can be determined based on the cell position only, i.e., as shown in Figures 3 and 4, the target table unit is determined to be the cell with row position 2 and column position 2 in the database table.

[0128] If the target cell group stores not only an image object but also other objects, then if the image object is directly introduced into a cell at the same cell position as the target cell, two types of objects will be stored simultaneously in one column or one row of the database table, and the data attributes of the objects in one column or one row will no longer be the same.

[0129] To avoid the above problem, in an embodiment of the present disclosure, when data in a data field in an electronic table is introduced into a database table according to its cell position, a new column (or row) is created in the database table, and a target table unit is set at a target position in the newly created cell group of the database table. As shown in Figures 13 and 14, an image object is stored in the second column, and to avoid the simultaneous storage of a text object and an image object in the second column, in an embodiment of the present disclosure, five rows and three columns of the electronic table are introduced into the database table, and one column (i.e., the fourth column) is created in the database table, and the image object in the second row and second column of the electronic table is stored in the second row and fourth column, that is, the target table unit is located in the second row and fourth column of the database table.

[0130] Besides providing the above-mentioned electronic table introduction method, an embodiment of the present disclosure further provides an electronic table introduction device.

[0131] 17 is a schematic diagram of an electronic table introduction device provided in an embodiment of the present disclosure. In some embodiments of the present disclosure, the electronic table introduction device may be disposed in an electronic device such as the electronic device 110 shown in FIG. 1. The electronic device may be a device with a communication function, such as a mobile phone, a tablet, a desktop computer, an all-in-one device, an in-vehicle device, or a wearable device.

[0132] As shown in FIG. 17, the electronic table introducing device 1700 includes a first receiving unit 1701 and an object display unit 1702.

[0133] The first receiving unit 1701 is used to receive the electronic table waiting to be introduced.

[0134] The object display unit 1702 is used to display the image object in the target table unit of the database table when the table object in the electronic table includes an image object.

[0135] In the embodiment of the present disclosure, the target table unit is determined based on the cell position of the target cell, and the target cell is the cell to which the image object in the electronic table belongs. That is, the object display unit 1702 determines the target table unit corresponding to the target cell in the database table based on the cell to which the image object in the electronic table belongs, and then displays the electronic table object as an image object within the display area surrounded by the target table unit.

[0136] By adopting the electronic table import device 1700 provided in the embodiment of the present disclosure, if a table object in an electronic table includes an image object, the image object will be displayed in the target table unit of the database table, and the image object will not be deleted, thereby ensuring the integrity of the data after the electronic table data is imported into the database table.

[0137] In some embodiments of the present disclosure, the target table unit is determined based on the location of the target cell relative to the data region.

[0138] In some embodiments of the present disclosure, the object display unit 1702 determines that the target table unit is located at a cell position in a database table if the target cell is located within a data region.

[0139] In some embodiments of the present disclosure, the object display unit 1702 determines that if the target cell is located on the left or right side of the data area, the target table unit is located at a target row position in a newly created column in the database table, and the target row position is a row position in a cell position.

[0140] In some embodiments of the present application, the object display unit 1702 determines that if the target cell is located above or below the data area, the target table unit is located at the target column position in the newly created row in the database table, and the target column position is the column position in the cell position.

[0141] In some embodiments of the present disclosure, the object display unit 1702 determines the target table unit based on the cell position of the target cell and the object type of the table object stored in the target cell group.

[0142] In some embodiments of the present disclosure, the object display unit 1702 determines based on the cell position of the target cell and the object type of the table object stored in the target cell group, where the target cell group is the cell group to which the target cell belongs.

[0143] Specifically, when the object types in the target cell group are all image types, the object display unit 1702 determines the target table unit based on the cell position. On the other hand, when the object types in the target cell group include object types other than image types, the object display unit 1702 determines the cell where the target position in the newly created cell group in the database table is located as the target table unit, where the newly created cell group is determined based on the cell group attribute of the target cell group, and the target position is determined based on the cell position.

[0144] The electronic table introduction device 1700 shown in Figure 17 can execute each step of the method embodiments shown in Figures 3 to 14 and realize each process and effect of the method embodiments shown in Figures 2 to 14, so they will not be described here.

[0145] 18 is a schematic diagram of another electronic table introduction device provided by an embodiment of the present disclosure. In some embodiments of the present disclosure, the electronic table introduction device may be located in a server such as server 120 shown in FIG. 1. Here, the server may be a device having storage and computing capabilities, such as a cloud server or a server cluster.

[0146] As shown in FIG. 18, the electronic table introduction device provided by the embodiment of the present disclosure includes a second receiving unit 1801, a first determining unit 1802, a second determining unit 1803, and an object storing unit 1804.

[0147] The second receiving unit 1801 is used to receive a file import request, which carries an electronic table waiting to be imported.

[0148] When the first determining unit 1802 detects that the table object in the electronic table includes an image object, it is used to determine a target cell to which the image object belongs, and the target cell is a cell in the electronic table.

[0149] The second determining unit 1803 is used to determine a target table unit located in the database table according to the cell location of the target cell, and the cell location is determined according to the data field of the electronic table.

[0150] The object storage unit 1804 is used to store image objects in the target table unit.

[0151] By adopting the electronic table import device provided in the embodiments of the present disclosure, if a table object in an electronic table includes an image object, the image object is imported into the target table unit of the database table, and the image object is not deleted, thereby ensuring the integrity of the data after the electronic table data is imported into the database table.

[0152] In some applications of the embodiments of the present disclosure, the first determining unit 1802 specifically determines the target cell to which the image object belongs based on the number of cells that the image object covers.

[0153] In some applications of the embodiments of the present disclosure, if the image object covers one cell, the first determining unit 1802 determines the cell covered by the image object as the target cell. If the image object covers multiple cells, the first determining unit 1802 determines a cell selected from the cells covered by the image object as the target cell.

[0154] In some applications of the embodiments of the present disclosure, the first determination unit 1802 is specifically used to determine the cell in which the target point of the image object is located as the target cell based on the case where the image object covers multiple cells.

[0155] Specifically, if the image object completely covers multiple cells, the first determination unit 1802 determines the cell where the reference point of the image object is located as the target cell. If the image object does not completely cover multiple cells, the first determination unit 1802 determines the cell where the midpoint of the image object is located as the target cell.

[0156] When the image object completely covers multiple cells, the first determination unit 1802 further calculates the coordinate value of the midpoint of the image object, rounds the coordinate value according to the occupancy rate of the image object in each cell, and uses the rounded coordinate value to determine the cell where the midpoint of the image object is located in the cells covered by the image object, so as to determine the cell where the midpoint of the image object is located as the target cell.

[0157] In some applications of the embodiments of the present disclosure, the first determining unit 1802 determines the cells covered by the image object through extensible markup language in the electronic table, and determines the target cell in the cell covered by the image object.

[0158] In some applications of the embodiments of the present disclosure, the first determining unit 1802 determines the object type of the table object stored in the target cell group, and then determines the target table unit located in the database table based on the cell position and the object type. The target cell group is the cell group to which the target cell belongs.

[0159] An embodiment of the present disclosure further provides an electronic table introduction device, which may include a processor and a memory in which the processor stores executable instructions, wherein the processor may be used to read the executable instructions from the memory and execute the instructions to implement the electronic table introduction method in the above embodiment.

[0160] The electronic table introduction device shown in Figure 18 can execute each step of the method embodiments shown in Figures 3 to 16 and realize each process and effect of the method embodiments shown in Figures 2 to 16, so they will not be described here.

[0161] 19 shows a schematic diagram of the configuration of an electronic table introduction device provided in an embodiment of the present disclosure. In the following, reference is made to FIG. 19, which specifically shows a configuration diagram suitable for use in realizing an electronic table introduction device 1900 in an embodiment of the present disclosure.

[0162] The electronic table introduction device 1900 in the embodiment of the present disclosure is an electronic device or a server.

[0163] Here, electronic devices include mobile phones, laptops, digital broadcast receivers, PDAs (Personal Digital Assistants, Personal Digital Assistants, This may include, but is not limited to, mobile terminals such as Digital Assistants (Digital Assistants), PADs (Tablets), PMPs (Portable Multimedia Players), and in-vehicle terminals (e.g., car navigation terminals), as well as fixed terminals such as digital TVs and desktop computers. A server may also be a device with storage and computing capabilities, such as a cloud server or server cluster.

[0164] It should be noted that the electronic table introduction device 1900 shown in FIG. 19 is merely an example and should not limit the functions and scope of use of the embodiments of the present disclosure.

[0165] 19, electronic table introduction device 1900 may include a processing unit (e.g., a central processor, a graphics processor, etc.) 1901 that can perform various appropriate operations and processes in accordance with programs stored in read-only memory (ROM) 1902 or loaded from storage device 1908 into random access memory (RAM) 1903. RAM 1903 also stores various programs and data necessary for the operation of electronic table introduction device 1900. Processing unit 1901, ROM 1902, and RAM 1903 are connected via a bus 1904. An input / output (I / O) interface 1905 is also connected to bus 1904.

[0166] Typically, the following devices can be connected to the I / O interface 1905: input devices 1906, including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 1907, including, for example, a liquid crystal display (LCD), speaker, vibrator, etc.; storage devices 1908, including, for example, a magnetic tape, hard disk, etc.; and communication devices 1909. The communication devices 1909 can enable the electronic table introduction device 1900 to communicate wirelessly or via wires with other devices to exchange data. While FIG. 19 illustrates the electronic table introduction device 1900 with various devices, it should be understood that it is not necessary to implement or include all of the devices shown. Alternatively, more or fewer devices can be implemented or included.

[0167] The embodiment of the present disclosure further provides a computer-readable storage medium, which stores a computer program for executing the electronic table import method in the above embodiment.

[0168] In particular, according to an embodiment of the present disclosure, the processes described above with reference to the flowcharts can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product including a computer program embodied on a non-transitory computer-readable medium, the computer program including program code for performing the methods illustrated in the flowcharts. In such an embodiment, the computer program may be downloaded and installed from a network via the communication device 1909, installed from the storage device 1908, or installed from the ROM 1902. When the computer program is executed by the processing device 4101, the functions described above, which are specific to the electronic table introduction method according to an embodiment of the present disclosure, are performed.

[0169] It should be noted that the computer-readable medium described above in this disclosure can be a computer-readable signal medium or a computer-readable storage medium, or any combination of both. A computer-readable storage medium can include, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media can include, but are not limited to, an electrical connection having one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical memory device, a magnetic memory device, or any suitable combination of the above. In this disclosure, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in connection with an instruction execution system, apparatus, or device. In contrast, in this disclosure, a computer-readable signal medium can include a data signal propagating in baseband or as part of a carrier. Such propagated data signals may take a variety of forms, including, but not limited to, electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. Program code contained on a computer-readable medium may be transmitted over any suitable medium, including, but not limited to, wire, optical cable, RF (radio frequency), etc., or any suitable combination of the above.

[0170] In some embodiments, the client and server communicate using HTTP (HyperText Markup Language). The network may communicate using any network protocol now known or later developed, such as the Network Transfer Protocol (NTTP), Hypertext Transfer Protocol (HTP), and may interconnect any method or medium of digital data communication (e.g., a communications network). Examples of communications networks include local area networks ("LANs"), wide area networks ("WANs"), networks of networks (e.g., the Internet), end-to-end networks (e.g., ad-hoc end-to-end networks), and any other networks now known or later developed.

[0171] The computer-readable medium may be included in the electronic table introduction device, or may be a separate entity not incorporated into the electronic table introduction device.

[0172] The computer-readable medium carries one or more programs that, when executed by the electronic table introduction device, cause the electronic table introduction device to operate.

[0173] An electronic table is received to be introduced, and if a table object in the electronic table includes an image object, the image object is displayed in a target table unit of a database table, where the target table unit is determined based on a cell position of a target cell, the target cell being a cell in the electronic table to which the image object belongs, and the cell position is determined based on a data area of ​​the electronic table.

[0174] Alternatively, an electronic table waiting to be imported is received, and if the file import request carries the electronic table waiting to be imported and a table object in the electronic table includes an image object, a target cell to which the image object belongs is determined, the target cell being a cell in the electronic table, and a target table unit located in a database table is determined based on the cell position of the target cell, the cell position being determined based on the data area of ​​the electronic table, and the image object is stored in the target table unit.

[0175] In embodiments of the present disclosure, program code for performing the operations of the present disclosure may be written in one or more programming languages, or a combination thereof, including, but not limited to, object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as "C." The program code may run entirely on the user computer, partially on the user computer, as a separate software package, partially on the user computer, partially on a remote computer, or entirely on a remote computer or server. When referring to a remote computer, the remote computer may be connected to the user computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer, such as via the Internet using an Internet Service Provider.

[0176] The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation that can be implemented in accordance with systems, methods, and computer program products according to several embodiments of the present disclosure. In this regard, each block in the flowcharts or block diagrams may represent a module, program segment, or portion of code, including one or more executable instructions for implementing a given logical function. It should be noted that, in alternative implementations, the functions displayed in the blocks may occur in a different order than the order displayed in the figures. For example, depending on the functionality involved, two successively shown blocks may actually execute essentially in parallel, or they may also be executed in the reverse order. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, may be implemented in a dedicated hardware-based system that performs a given function or operation, or in a combination of dedicated hardware and computer instructions.

[0177] The described units according to the embodiments of the present disclosure may be implemented by software or hardware, and the names of the units may not necessarily constitute limitations on the units themselves.

[0178] The functions described herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), etc.

[0179] In the context of this disclosure, a machine-readable medium may be a tangible medium that contains or can store a program for use by or with an instruction execution system, device, or apparatus. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable storage medium may include, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of machine-readable storage media include an electrical connection by one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical memory device, a magnetic memory device, or any suitable combination of the above.

[0180] The above description merely describes preferred embodiments of the present disclosure and the technical principles applied thereto. Those skilled in the art will understand that the scope of the present disclosure is not limited to a technical solution consisting of a specific combination of the above technical features, but should also cover other technical solutions consisting of any combination of the above technical features or their equivalent features without departing from the idea of ​​the above disclosure. For example, a technical solution formed by mutually substituting the above features with technical features having similar functions disclosed in the present disclosure (but not limited to these).

[0181] Additionally, although operations are shown in a particular order, this should not be understood as requiring that these operations be performed in the particular order shown, or that they be performed sequentially. In some environments, multitasking or parallel processing may be advantageous. Similarly, although several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the present disclosure. Some features that are described in the context of separate embodiments may also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment may also be implemented in multiple embodiments separately or in any suitable subcombination.

[0182] Although the present subject matter has been described in language specific to structural features and / or methodological logical operations, it should be understood that the subject matter defined in the claims is not necessarily limited to the specific features or operations described above. Rather, the specific features and operations described above are merely example forms of implementing the claims.

Claims

1. An electronic table introduction method executed by an electronic device, comprising: receiving an electronic table awaiting introduction; If the table object in the electronic table includes an image object, displaying the image object in a target table unit of a database table; Wherein, the target table unit is determined based on a cell position of a target cell, the target cell being a cell to which the image object belongs in the electronic table, and the cell position is determined based on a data area of ​​the electronic table; The step of determining the target table unit based on the cell position of the target cell includes: the target table unit is determined based on a position of the target cell relative to the data area; determining the target table unit based on the position of the target cell relative to the data area, If the target cell is located on the left or right side of the data area, the target table unit is located at a target row position in a newly created column in the database table, and the target row position is a row position in the cell position; If the target cell is located above or below the data area, the target table unit is located at a target column position in a newly created row in the database table, and the target column position is a column position at the cell position.

2. determining the target table unit based on the position of the target cell relative to the data area, 2. The method of claim 1, further comprising the step of: if the target cell is located within the data region, the target table unit is located at the cell location in the database table.

3. The step of determining the target table unit based on the cell position of the target cell includes:

2. The method of claim 1, further comprising: determining the target table unit based on the cell position of the target cell and the object type of the table object stored in the target cell group, wherein the target cell group is the cell group to which the target cell belongs.

4. 4. The method of claim 3, wherein if the object types are both image types, the target table unit is determined based on the cell location.

5. If the object type includes other objects than an image type, the target table unit is located at a target position within a newly created cell group in the database table; The method of claim 3, wherein the newly created cell group is determined based on cell group attributes of the target cell group, and the target location is determined based on the cell location.

6. A method for introducing electronic tables executed by a server, comprising: receiving a file import request, the file import request carrying an electronic table waiting to be imported; if a table object in the electronic table includes an image object, determining a target cell to which the image object belongs, the target cell being a cell in the electronic table; determining a target table unit located in a database table based on a cell location of the target cell, where the cell location is determined based on a data field of the electronic table; storing the image object in the target table unit; The step of determining a target cell to which the graphical object belongs includes: determining a target cell to which the graphical object belongs based on the number of cells covered by the graphical object; determining a target cell to which the graphical object belongs based on the number of cells covered by the graphical object, If the image object covers a cell, the cell covered by the image object is set as the target cell; If the image object covers a plurality of cells, a step of selecting one cell from among the cells covered by the image object as the target cell is included; The step of selecting one cell from among the cells covered by the image object as the target cell includes: determining a cell in which a target point of the image object is located as the target cell based on a case in which the image object covers a plurality of cells; The step of determining a cell in which a target point of the image object is located as the target cell based on the case where the image object covers a plurality of cells includes: If the image object completely covers a plurality of cells, the target cell is determined to be a cell in which a reference point of the image object is located; if the graphical object does not completely cover a plurality of cells, determining a cell in which a midpoint of the graphical object is located as the target cell; Before determining the cell in which the midpoint of the graphical object is located as the target cell, the method includes: calculating the coordinate values ​​of the midpoint of the image object; rounding the coordinate values ​​based on the proportion of the image object in each of the cells to obtain rounded coordinate values; determining a cell in a cell covered by the graphical object in which a midpoint of the graphical object is located based on the rounded coordinate values.

7. The step of determining a target cell to which the graphical object belongs includes: determining cells covered by the graphical object based on an extensible markup language of the electronic table; and determining the target cell in a cell covered by the graphical object.

8. determining a target table unit located in the database table according to the cell location of the target cell, determining an object type of a table object stored in a target cell group, the target cell group being the cell group to which the target cell belongs; determining the target table unit located in the database table based on the cell location and the object type.

9. An electronic table introduction device, a first receiving unit configured to receive the electronic table awaiting introduction; an object display unit configured to display an image object in a target table unit of a database table if the table object in the electronic table includes the image object; Wherein, the target table unit is determined based on a cell position of a target cell, the target cell being a cell to which the image object belongs in the electronic table, and the cell position is determined based on a data area of ​​the electronic table; The object display unit is further configured such that when the target cell is located on the left or right side of the data area, the target table unit is located at a target row position in a newly created column in the database table, and the target row position is the row position at the cell position; and when the target cell is located above or below the data area, the target table unit is located at a target column position in a newly created row in the database table, and the target column position is the column position at the cell position.

10. An electronic table introduction device, a second receiving unit configured to receive a file import request, the file import request carrying an electronic table to be imported; a first determination unit configured to determine a target cell to which an image object belongs when detecting that a table object in the electronic table includes an image object, the target cell being a cell in the electronic table; a second determination unit configured to determine a target table unit located in a database table according to a cell location of the target cell, wherein the cell location is determined according to a data field of the electronic table; an object storage unit configured to store the image object within the target table unit; The first determining unit is also configured to determine a target cell to which the graphical object belongs based on the number of cells covered by the graphical object; Determining the target cell to which the graphical object belongs based on the number of cells covered by the graphical object includes: If the image object covers a cell, determining the cell covered by the image object as the target cell; If the image object covers a plurality of cells, selecting one cell from among the cells covered by the image object as the target cell; The step of selecting one cell from among the cells covered by the image object as the target cell includes: determining a cell in which a target point of the image object is located as the target cell based on a case in which the image object covers a plurality of cells; When the image object covers a plurality of cells, the target cell is determined to be a cell in which a target point of the image object is located, If the image object completely covers a plurality of cells, the cell in which the reference point of the image object is located is set as the target cell; If the graphical object does not completely cover a plurality of cells, determining a cell in which a midpoint of the graphical object is located as the target cell; Before determining the cell where the midpoint of the image object is located as the target cell, the first determination unit is also configured to calculate the coordinate value of the midpoint of the image object, round the coordinate value based on the proportion of the image object occupying each of the cells to obtain rounded coordinate values, and determine the cell where the midpoint of the image object is located in the cells covered by the image object based on the rounded coordinate values.

11. An electronic table introduction device, a processor; a memory for storing executable instructions; Here, the processor is used to realize the electronic table introduction method described in any one of claims 1 to 8 by reading the executable instructions from the memory and executing the executable instructions.

12. A computer-readable storage medium storing a computer program, the computer program causing the processor to implement the electronic table introduction method according to any one of claims 1 to 8, when executed by the processor.

Images