Set_column not working until manually activatiing each cell
<p>Been trying to get the set_column to work still. Having problems getting Pandas to work, so have been doing it just in xlsxwriter.  Right now am using:
'worksheet.set_column('D:D',None,format4)'  - this only seems to work when I go into the xlsx file and actually activate each cell in the "D" column.  Is there some way of activating each cell so that I wouldn't have to do it manually?</p>

<p>Thanks in advance.</p>

<pre><code>import xlsxwriter,os,sys,datetime
now=datetime.datetime.now()
def main():
    platform=sys.platform
    if platform.find('win')&gt;=0:
        TheSlash='\\'
    else:
        TheSlash='/'
    output = '%s-%s.xlsx' % ('XlsxSample',now.strftime("%m%d%Y-%H%M"))
    workbook = xlsxwriter.Workbook(output, {'strings_to_numbers':True,'default_date_format':'mm/dd/yy hh:mm'})
    worksheet = workbook.add_worksheet()
    count=0
    counter=0
    format=workbook.add_format({'font_size':'8','border':True})
    formatdict={'num_format':'mm/dd/yy hh:mm'}
    format4=workbook.add_format(formatdict)
    cur =('Pole1','33.62283963','-90.54639967','4/20/16 11:43','-90.54640226','33.62116957','5207069','25-04','50','3','PRIMARY','PGC')
    for name in cur:
        worksheet.write(counter, count, name,format)
        count+=1
    counter+=1
    worksheet.set_column('D:D',None,format4)
    workbook.close()
if __name__ == "__main__":
    main()
</code></pre>

<p>as stated above - date format only seems to activate if you get into the "D" cell itself with the cursor.</p>