pyxlsb

pyxlsb copied to clipboard

How to write back a pandas dataframe in one of the sheet of the workbook

1

I have a .xlsb file which I am able to read as dataframe using pyxslb libray but after doing what I needed to do with the dataframe, I need to...

punit-mahipal

Add basic writing of workbooks

4

This PR adds a basic capability to create and write sheets to XLSB workbooks. Examples added to the README.md demonstrate writing data from pandas.DataFrame, numpy.ndarray, or list-of-lists to new sheets...

applio

String columns are read as None

6

Hi, i am attempting to read a file (also as attachment in this ticket). The integer column (titled Site) is read correctly, but the fields containing string values are all...

jeffreykog

Python reports unclosed files

1

While running our project with `-W default` per the [recommendation of Python 3.9](https://docs.python.org/3/whatsnew/3.9.html#you-should-check-for-deprecationwarning-in-your-codel), we saw a few warnings about unclosed files which we traced to `pyxlsb`. Here's a simple demo...

osvenskan

It would be useful to have a way of checking which sheets are worksheets and which are chart sheets. Currently (1.0.8), both kinds of sheets appear in sheet_names and the...

ahawryluk

Pulling Named Range or ListObject (e.g. Table) Values Into DataFrame or Nested List

3

**Goal** 1. Read the values from an Excel named range into a nested list like [[1,2,3],[10,20,30]] or Pandas dataframe 2. Read the values from an Excel table into a nested...

pabloaperezfernandez

Allow me to see the Number Format for each cell, so that I can properly format the cell's contents, convert the cell to the proper type, and/or pass this along...

snoopyjc

Improve performance with large worksheets

5

This will serve as an umbrella issue for performance improvement. Currently there is a bit of copying which could potentially be avoided with BIFF record reading and there's also the...

willtrnr

how to differentiate float, date, time and datetime cells?

5

Thanks for this great library which fill up the gap in the world of python + excel. My question is: how to find out date and time fields among floats?...

chfw

How to read only visible sheets

2

I have a use case wher ei wanted to read the content only if the sheet is visible i shouldn't read the hidden values. Is there any parameter for this...

Kuramdasu-ujwala-devi