openpyxl
openpyxl copied to clipboard
theorchard
## Problem in output big float numbers I have some a weird situation trying to get the output in to_excel pandas function with openpyxl engine. I tried to read a...
I'm working in a python script to create reports based on a specific Excel template, but when I execute my script I get the following error: ```bash File "/usr/lib/python3/dist-packages/openpyxl/reader/excel.py", line...
I attempted to build an app using pyinstaller. The hidden imports were over 300mb in size. Something should be done about it
`=IFERROR(VLOOKUP(A8,temptb!$A$1:$Z$37,temptb!H$1,FALSE),"")` ```` def compute_cell_value(input: Union[Cell, Tuple]): if isinstance(input, Tuple): return tuple(map(compute_cell_value, input)) if not has_formula(input): return input.value func = formulas.Parser().ast(input.value)[1].compile() args = [] sheet = input.parent for key in func.inputs.keys():...
Japanese characters in sheet names produce a list index out of range error when trying to load the workbook
Steps to replicate : 1. Create a workbook with a protected sheet . 2. Make only certain cells of the worksheet protected . 3. Load this worksheet using openpyxl load_workbook...
I'm trying to create a new cell with: ```python new_cell = ws.cell(row=new_row, column=cell.col_idx, value=Translator(cell.value, origin=cell.coordinate).translate_formula(new_coordinate)) ``` which works for every other cell (and awesomely so for cells with formulae in...
Hello, First of all, thank you for your fantastic work on openpyxl. It's an incredibly useful library and has made working with Excel files in Python much easier and more...
```python wb = Workbook() ws = wb.active data_list = [['name', 'age', 'gender'],['xxx', 20, 'M'],['yyy', 22, 'F'], ['zzz', 19, 'M'], ...] # then how to write this data_list at one time...
Problem Description: When using the openpyxl library to process Excel files, we encounter issues in preserving existing formulas and formats. These problems occur during sheet deletion, number entry, and even...
