# -*- coding: utf-8 -*-
"""
Created on Tue Dec 22 10:27:00 2015

@author: Alexis
"""
import xlwt
from datetime import datetime

style0 = xlwt.easyxf('font: name Times New Roman, color-index red, bold on',
    num_format_str='#,##0.00')
style1 = xlwt.easyxf(num_format_str='D-MMM-YY')

#book = open_workbook('line V2.xlsx')    # ouverture du fichier 

wb = xlwt.Workbook()
ws1 = wb.add_sheet('A Test Sheet')

ws1.write(0, 0, 1234.56, style0)
ws1.write(1, 0, datetime.now(), style1)
ws1.write(2, 0, 1)
ws1.write(2, 1, 1)
ws1.write(2, 2, xlwt.Formula("A3+B3"))

wb.save('example V2.xls')