openpyxl
openpyxl copied to clipboard
theorchard
How can I draw shapes using openpyxl? There seem to be some shape related classes like [PresetGeometry2D](https://openpyxl.readthedocs.io/en/3.1.2/_modules/openpyxl/drawing/geometry.html#PresetGeometry2D) and outdated classes like https://openpyxl.readthedocs.io/en/2.4/api/openpyxl.drawing.shapes.html However, I could not find an example on...
With code `blk = TextBlock font_bold = InlineFont(b=True) font_normal = InlineFont(b=False) wb = Workbook() ws = wb.active for r in data['requests']: rich_string = CellRichText( blk(font_normal, text='Заявка №'), blk(font_bold, text=str(r['id'])), blk(font_normal,...
https://github.com/theorchard/openpyxl/blob/b06d737937d6c04927d8cfe9758a78d94c023872/openpyxl/worksheet/worksheet.py#L261 I have been parsing some relatively complex excel files and the freeze_panes property has given me wrong values. However, if I use the: `sheet.sheet_view.pane.xSplit, sheet.sheet_view.pane.ySplit` And add a +1,...
Hi!, i dont know how to add this code on GitHub, so hope some can add this Code original: ``` def dataframe_to_rows(df, index=True, header=True): """ Convert a Pandas dataframe into...
When saving file with wb.save("sample.xlsx"), some cells with larger characters may lose some data, but the values of the cells in memory are correct. Some people analyze that the possible...
Hi there, i have an excel-sheet (.xslx) with more than 1.000.000 rows. Openpyxl reports max_row = 0 What is the maximum number openpyxl can handle? Thanks a lot! Andreas
The example given in the doc: ``` >>> from openpyxl.styles import Border, Side, PatternFill, Font, GradientFill, Alignment >>> from openpyxl import Workbook >>> >>> wb = Workbook() >>> ws =...
* I use openpyxl to generate a bar chart and save it on a sheet in an Excel file. * Then I read that Excel file and create a second...
My testing is issuing warnings about utcnow being deprecated. Are there plans to replace this in core.py? Here is a link where the issue is discussed: https://discuss.python.org/t/deprecating-utcnow-and-utcfromtimestamp/26221
