I am trying to set the line of an openpyxl scatter chart to green: While this code does not cause any problems, it does not change the line color from the default. What is the correct way to change the line color? Interestingly I have no problem setting the style to dashed or dotted using: Answer As it turns …
Tag: openpyxl
PermissionError [errno 13] when running openpyxl python script in Komodo
I am having trouble using openpyxl scripts in Komodo edit 9 and python 3.4 on Windows 7. I copied some openpyxl code to learn, but it won’t execute from Komodo. I receive a permission error 13. I checked my path and python34 is present. The same script will run when I use IDLE or Command Prompt. My Komo…
Fill cells with colors using openpyxl?
I am currently using openpyxl v2.2.2 for Python 2.7 and i wanted to set colors to cells. I have used the following imports and the following is the code I tried using: but I get the following error: Any idea on how to set cell A1 (or any other cells) with colors using openpyxl? Answer I believe the issue is
Pandas: Looking up the list of sheets in an excel file
The new version of Pandas uses the following interface to load Excel files: but what if I don’t know the sheets that are available? For example, I am working with excel files that the following sheets Data 1, Data 2 …, Data N, foo, bar but I don’t know N a priori. Is there any way to get the…
Insert row into Excel spreadsheet using openpyxl in Python
I’m looking for the best approach for inserting a row into a spreadsheet using openpyxl. Effectively, I have a spreadsheet (Excel 2007) which has a header row, followed by (at most) a few thousand rows of data. I’m looking to insert the row as the first row of actual data, so after the header. My …
Is it possible to get an Excel document’s row count without loading the entire document into memory?
I’m working on an application that processes huge Excel 2007 files, and I’m using OpenPyXL to do it. OpenPyXL has two different methods of reading an Excel file – one “normal” method where the entire document is loaded into memory at once, and one method where iterators are used …