Hyperlink appears in wrong cell
Created originally on Bitbucket by Nick Pellegrino
The file created by the following code is missing a hyperlink in cell B1, and instead has a hyperlink in cell A1.
from openpyxl import Workbook
from openpyxl.worksheet.write_only import WriteOnlyCell
workbook = Workbook(write_only=True)
sheet = workbook.create_sheet()
cells = [WriteOnlyCell(sheet, 'should not have hyperlink'), WriteOnlyCell(sheet, 'should have hyperlink')]
cells[1].hyperlink = 'http://bbc.co.uk'
sheet.append(cells)
workbook.save('hyperlink_in_wrong_cell.xlsx')
This is using version 2.6.0a1.
Attachments: hyperlink_in_wrong_cell.xlsx