Date format is applied to all columns (while only first column contains dates)

Issue #394 resolved
David Laudy created an issue

I have a problem when writing an excel file containing a date column and a value column as date format is applied to both column (instead of first one).


import datetime as dt
import openpyxl
import os
import os.path as osp

workbook = openpyxl.workbook.Workbook(optimized_write=True)
sheet = workbook.create_sheet()
sheet.title = u'hello'

rows = [(,1,1), 1),
        (,1,2), 2),
        (,1,3), 3),

for stamp, val in rows:
    sheet.append([stamp, val]), 'test.xlsx'))

Comments (2)

  1. Log in to comment