(self)
| 852 | |
| 853 | @pytest.mark.vcr() |
| 854 | def test_get_all_values(self): |
| 855 | self.sheet.resize(4, 4) |
| 856 | # put in new values |
| 857 | rows = [ |
| 858 | ["A1", "B1", "", "D1"], |
| 859 | ["", "b2", "", ""], |
| 860 | ["", "", "", ""], |
| 861 | ["A4", "B4", "", "D4"], |
| 862 | ] |
| 863 | cell_list = self.sheet.range("A1:D1") |
| 864 | |
| 865 | cell_list.extend(self.sheet.range("A2:D2")) |
| 866 | cell_list.extend(self.sheet.range("A3:D3")) |
| 867 | cell_list.extend(self.sheet.range("A4:D4")) |
| 868 | for cell, value in zip(cell_list, itertools.chain(*rows)): |
| 869 | cell.value = value |
| 870 | self.sheet.update_cells(cell_list) |
| 871 | |
| 872 | # read values with get_all_values, get a list of lists |
| 873 | read_data = self.sheet.get_all_values() |
| 874 | # values should match with original lists |
| 875 | self.assertEqual(read_data, rows) |
| 876 | |
| 877 | @pytest.mark.vcr() |
| 878 | def test_get_all_values_title_is_a1_notation(self): |
nothing calls this directly
no test coverage detected