read dat file into python and convert it to xcel format?

[ravibantu]

Hi guys,

I am a newbie to python. Does anybody know how i can read a dat file into python and convert into xcel format?

Thank you
ravi

[bartonc]

Hi guys,

I am a newbie to python. Does anybody know how i can read a dat file into python and convert into xcel format?

Thank you
ravi

If you write a file that has tab separated (maybe coma serperated, too) data with the .xls file extention, you can then:

import os
os.startfile("theFile.xls")

Then use excel to save the file in excel format.

[fuffens]

For generation of advanced Excel forms there is a commercial alternative called SpreadScript.

http://www.greytrout.com/spreadscript.html

/Fredrik

[bartonc]

Hi guys,

I am a newbie to python. Does anybody know how i can read a dat file into python and convert into xcel format?

Thank you
ravi

Read Fredrik's post in the "Opening a word file in Python" and "webbrowser controls, manipulating javascript through Python" threads for discussion on the COM suport in the win32 extentions. Using COM you will aslo be able to save the file from python.