Method, apparatus, device and medium for table data verification

1 . A method of table data verification, comprising:

in response to setting being triggered by a user, obtaining, by an electronic device, a data verification condition set for a target cell, the data verification condition including a first format and a data range;

in response to inputting being triggered by the user, obtaining, by the electronic device, a target data input by the user in the target cell;

verifying, by the electronic device, a format of the target data and a value of the target data according to the data verification condition to obtain a verification result, the format of the target data being a second format corresponding to the target cell; and

rendering, on a display of the electronic device, the target cell according to the verification result and the target data, comprising:

in response to the first format being a data format and the verification result being invalid data, filling the target data into the target cell with a mark for prompting the user that the target data filled in the target cell mismatches with the data verification condition in terms of format and/or data range; or

in response to the first format being the data format and the verification result being valid data, filling the target data into the target cell.

2 . The method of claim 1 , wherein the first format includes the data format and a rendering format, the data format is used to indicate a type of data input in the target cell, and the rendering format is used to indicate a style presented by the target cell.

3 . The method of claim 2 , wherein the data format at least includes one or more of a numerical type, a date type, a currency type and a time type; and the rendering format includes a check box format and a progress bar format.

4 . The method of claim 2 , wherein verifying the format of the target data and the value of the target data according to the data verification condition to obtain the verification result comprises:

in response to the format of the target data mismatching with the data format in the data verification condition, and/or the value of the target data mismatching with the data range in the data verification condition, determining that the target data is invalid data.

5 . The method of claim 2 , wherein verifying the format of the target data and the value of the target data according to the data verification condition to obtain the verification result comprises:

in response to the first format being the rendering format and the data range of the target data mismatching with the data range in the data verification condition, determining that the target data is invalid data.

6 . The method of claim 4 , further comprising:

displaying, on the display of the electronic device, a prompt message for prompting that the target data is invalid data.

7 . The method of claim 1 , wherein rendering the target cell according to the verification result and the target data comprises:

in response to the first format being a rendering format and the verification result being valid data, rendering the target cell according to the rendering format and the target data; or

in response to the first format being the rendering format and the verification result being invalid data, filling the target data into the target cell with a mark for prompting the user that the target data filled in the target cell mismatches with the data verification condition in terms of format and/or data range.

8 . The method of claim 7 , wherein in response to the first format being the rendering format and the verification result being the valid data, rendering the target cell according to the rendering format and the target data comprises:

in response to the first format being a check box format, the verification result being the valid data and the target data being a first value, displaying a check box in the target cell, the check box being in a selected state; or

in response to the first format being the check box format, the verification result being the valid data and the target data being a second value, displaying a check box in the target cell, the check box being in an unselected state.

9 . The method of claim 7 , wherein in response to the first format being the rendering format and the verification result being the valid data, rendering the target cell according to the rendering format and the target data comprises:

in response to the first format being a progress bar format and the verification result being the valid data, rendering a progress bar in the target cell according to the target data, the length of the progress bar being related to the value of the target data.

10 . The method of claim 1 , wherein the first format has a higher priority than the second format.

11 . An electronic device, comprising:

a processor and a memory;

the memory configured to store instructions or computer programs;

the processor configured to execute the instructions or the computer programs stored in the memory to cause the electronic device to perform acts comprising:

in response to setting being triggered by a user, obtaining, by the electronic device, a data verification condition set for a target cell, the data verification condition including a first format and a data range;

in response to inputting being triggered by the user, obtaining a target data input by the user in the target cell;

verifying a format of the target data and a value of the target data according to the data verification condition to obtain a verification result, the format of the target data being a second format corresponding to the target cell; and

rendering, on a display of the electronic device, the target cell according to the verification result and the target data, comprising:

in response to the first format being a data format and the verification result being invalid data, filling the target data into the target cell with a mark for prompting the user that the target data filled in the target cell mismatches with the data verification condition in terms of format and/or data range; or

in response to the first format being the data format and the verification result being valid data, filling the target data into the target cell.

12 . The electronic device of claim 11 , wherein the first format includes the data format and a rendering format, the data format is used to indicate a type of data input in the target cell, and the rendering format is used to indicate a style presented by the target cell.

13 . The electronic device of claim 12 , wherein the data format at least includes one or more of a numerical type, a date type, a currency type and a time type; and the rendering format includes a check box format and a progress bar format.

14 . The electronic device of claim 12 , wherein verifying the format of the target data and the value of the target data according to the data verification condition to obtain the verification result comprises:

in response to the format of the target data mismatching with the data format in the data verification condition, and/or the value of the target data mismatching with the data range in the data verification condition, determining that the target data is invalid data.

15 . The electronic device of claim 12 , wherein verifying the format of the target data and the value of the target data according to the data verification condition to obtain the verification result comprises:

in response to the first format being the rendering format and the data range of the target data mismatching with the data range in the data verification condition, determining that the target data is invalid data.

16 . The electronic device of claim 14 , further comprising:

displaying, on the display of the electronic device, a prompt message for prompting that the target data is invalid data.

17 . A non-transitory computer-readable storage medium storing instructions, the instruction, when running on an electronic device, causing the electronic device to perform acts comprising:

in response to setting being triggered by a user, obtaining, by the electronic device, a data verification condition set for a target cell, the data verification condition including a first format and a data range;

in response to inputting being triggered by the user, obtaining, by the electronic device, a target data input by the user in the target cell;

verifying a format of the target data and a value of the target data according to the data verification condition to obtain a verification result, the format of the target data being a second format corresponding to the target cell; and

rendering, on a display of the electronic device, the target cell according to the verification result and the target data, comprising:

in response to the first format being a data format and the verification result being invalid data, filling the target data into the target cell with a mark for prompting the user that the target data filled in the target cell mismatches with the data verification condition in terms of format and/or data range; or

in response to the first format being the data format and the verification result being valid data, filling the target data into the target cell.