Ejemplo n.º 1
0
    def test_load(self):
        obj = XLSXObject(data_path("data.xlsx"), encoding="latin1")
        self.assertEqual(["id", "name", "amount"], obj.fields.names())

        rows = list(obj.rows())
        self.assertEqual(4, len(rows))
        self.assertEqual(4, len(obj))

        self.assertSequenceEqual([1, "Adam", 10], rows[0])
Ejemplo n.º 2
0
    def test_skip(self):
        obj = XLSXObject(data_path("data.xlsx"), FieldList("number", "name"),
                        skip_rows=2)
        self.assertEqual(["number", "name"], obj.fields.names())

        rows = list(obj.rows())
        self.assertEqual(2, len(obj))
        self.assertEqual(2, len(rows))

        self.assertSequenceEqual([3.0, "Cecil"], rows[0])