Datetime issue with xlrd & xlwt python libs?

You can write the floating point number directly to the spreadsheet and set the number format of the cell. Set the format using the num_format_str of an XFStyle object when you write the value https://secure.simplistix.co. Uk/svn/xlwt/trunk/xlwt/doc/xlwt.

Html#xlwt.Worksheet. Write-method The following example writes the date 01-05-2010. (Also includes time of 06:00:10, but this is hidden by the format chosen in this example.) import xlwt # d can also be a datetime object d = 40299.2501157407 wb = xlwt.Workbook() sheet = wb.

Add_sheet('new') style = xlwt.XFStyle() style. Num_format_str = 'DD-MM-YYYY' sheet. Write(5, 5, d, style) wb.

Save('test_new. Xls') There are examples of number formats (num_formats. Py) in the examples folder of the xlwt source code.

On my Windows machine: C:\Python26\Lib\site-packages\xlwt\examples You can read about how Excel stores dates (third section on this page): https://secure.simplistix.co. Uk/svn/xlrd/trunk/xlrd/doc/xlrd.html.

You can write the floating point number directly to the spreadsheet and set the number format of the cell. Set the format using the num_format_str of an XFStyle object when you write the value. Https://secure.simplistix.co.Uk/svn/xlwt/trunk/xlwt/doc/xlwt.

Html#xlwt.Worksheet. Write-method The following example writes the date 01-05-2010.(Also includes time of 06:00:10, but this is hidden by the format chosen in this example.) import xlwt # d can also be a datetime object d = 40299.2501157407 wb = xlwt.Workbook() sheet = wb. Add_sheet('new') style = xlwt.XFStyle() style.

Num_format_str = 'DD-MM-YYYY' sheet. Write(5, 5, d, style) wb. Save('test_new.

Xls') There are examples of number formats (num_formats. Py) in the examples folder of the xlwt source code. On my Windows machine: C:\Python26\Lib\site-packages\xlwt\examples You can read about how Excel stores dates (third section on this page): https://secure.simplistix.co.

Uk/svn/xlrd/trunk/xlrd/doc/xlrd.html.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.