pyexcel

pyexcel copied to clipboard

To support column width when writing the data out to xls, xlsx and ods

4

https://github.com/pyexcel/pyexcel-xls/issues/22

chfw

I'm using the `get_data()` function from `pyexcel_xls` and `pyexcel_odsr` with .xls and .ods tables similar to this: One Two Three Four One Two and three Four `pyexcel_xls.get_data()` reads the table...

pedrohasantiago

Documentation - What are the keywords in get_data()

2

I recently ran into an issue where hidden rows/columns were nto being read. From this I stumbled upon https://github.com/pyexcel/pyexcel/issues/53 which gave me the answer to use `skip_hidden_row_and_column` like so: ```...

aneuway2

https://github.com/pyexcel/pyexcel/issues/53

chfw

By default in csv format, the float decimal separator is a dot : 1.005 But how can I change it to use comma instead ? : 1,005 I need it...

doudz

I'm trying to generate spreadsheets in different formats that contains formulas. However, different formats have produced different result. For example: ```python import pyexcel sheet = [['=HYPERLINK("https://www.google.com", "Google")']] pyexcel.save_as(array=sheet, dest_file_name="test.xlsx") pyexcel.save_as(array=sheet,...

jacky9813

I have 480kb .ods file that loads for over 10s on my relatively modern laptop (16GB RAM, SSD etc). Is it expected/normal? Manually exporting .ods file as csv and loading...

matkoniecz

With your PR, here is a check list: - [ ] Has test cases written? - [x] Has all code lines tested? - [ ] Has `make format` been run?...

matkoniecz

Does not work with Python 3.12 (Windows 11, Office 365)

1

I just upgraded from Python 3.11 to Python 3.12 on Windows 11 with Office 365 and there are several issues: **Error with Merged Cells** > File "C:\Python312\Lib\site-packages\pyexcel_xlsx\xlsxr.py", line 72, in...

BugByteMan

there is a cell in which information is around 3000 bytes of text. I replaced some parts of the text data twice and saved it as another file. However, I...

unique0ne0