sxl

sxl copied to clipboard

changing column names

1

Hi! Is it possible to change the column names without loading the whole excel file into the memory with this package?

isiktopcu

Is it possible to read files by chunk (read file from flask stream)

4

Hello, Thanks for your work. I want to parse a excel file by chunk on my Flask web server (I want to read the first 1000 lines). I read the...

MohamedLEGH

closing filedescriptor

1

After reading an xls file os.stat doesnt return any file changes. manually calling close() on wb.xls (with wb: Workbook(file)) fixes the problem. Maybe a problem of ZipFile, too? Best Martin

martinbock

See commit 543682d0d9cfd3c3f66c47844c8e3d023d9dc8df which already (hopefully) fixes this.

ktr

Trying to only return 1 row from 'rows' returns list of list, but should probably return just a list.

4

I think when you try to grab 1 row (e.g., ''ws.rows[1]'' to grab the 1st row of a worksheet), it should simply return that row.

ktr