The same problem occurred to me, and then I noticed the following: When I created the .xlsx file from file manager, by creating new document with .xlsx format, I had the same error. But when I created the file with some spreadsheet software (libreoffice-calc) in my case, it just worked fine. I hope this may … Read more
As of openpyxl version 1.5.7, I have successfully applied the following worksheet style options… from openpyxl.reader.excel import load_workbook from openpyxl.workbook import Workbook from openpyxl.styles import Color, Fill from openpyxl.cell import Cell # Load the workbook… book = load_workbook(‘foo.xlsx’) # define ws here, in this case I pick the first worksheet in the workbook… # NOTE: … Read more
What you want is openpyxl.utils.coordinate_from_string() and openpyxl.utils.column_index_from_string() from openpyxl.utils.cell import coordinate_from_string, column_index_from_string xy = coordinate_from_string(‘A4’) # returns (‘A’,4) col = column_index_from_string(xy[0]) # returns 1 row = xy[1]
Try this: import openpyxl wb = load_workbook(filename=”xxxx.xlsx”) ws = wb.worksheets[0] ws[‘A1’] = 1 ws.cell(row=2, column=2).value = 2 This will set Cells A1 and B2 to 1 and 2 respectively (two different ways of setting cell values in a worksheet). The second method (specifying row and column) is most useful for your situation: import openpyxl wb … Read more
I believe the issue is that you’re trying to assign a fill object to a style. ws[‘A1’].fill = redFill should work fine.
String.replace(substr) does not happen in place, change it to: string = string.replace(“http://”,””)
You can try the following implementation from openpyxl import load_workbook import csv def update_xlsx(src, dest): #Open an xlsx for reading wb = load_workbook(filename = dest) #Get the current Active Sheet ws = wb.get_active_sheet() #You can also select a particular sheet #based on sheet name #ws = wb.get_sheet_by_name(“Sheet1”) #Open the csv file with open(src) as fin: … Read more
For me this worked, together with version openpyxl==2.3.0-b2 wb = load_workbook(filename=”original.xlsm”, read_only=False, keep_vba=True) .. wb.save(‘outfile.xlsm’) It is also mentioend in the documentation here: http://openpyxl.readthedocs.org/en/latest/usage.html?highlight=keep_vba#write-a-workbook-from-xltm-as-xlsm
openpyxl 2.4 comes with a utility for converting Pandas Dataframes into something that openpyxl can work with directly. Code would look a bit like this: from openpyxl.utils.dataframe import dataframe_to_rows rows = dataframe_to_rows(df) for r_idx, row in enumerate(rows, 1): for c_idx, value in enumerate(row, 1): ws.cell(row=r_idx, column=c_idx, value=value) You can adjust the start of the enumeration … Read more
It depends upon the provenance of the file. data_only=True depends upon the value of the formula being cached by an application like Excel. If, however, the file was created by openpyxl or a similar library, then it’s probable that the formula was never evaluated and, thus, no cached value is available and openpyxl will report … Read more