text file to excel(*.txt to *.xls)

[sumanthsclsdc]

hello friends....

can any one let me know the python code for converting the text file to excel file.

i require a script to convert sample.txt to sample.xls

can any one share the code for this.


regards,
sumanth

[bartonc]

You can use pyExcelerator. There is on person that I know of who posts to this forum who is using it. You can get it here.
Or (if you have excel or open office installed) you can name a tab-delimited text file whatever.xls then

import os
os.startfile(whatever.xls)

Then use excel to save it (on Windows of course).

[fuffens]

You can also check this previous post:

http://www.thescripts.com/forum/thread555153.html

BR
/Fredrik

[true911m]

hello friends....

can any one let me know the python code for converting the text file to excel file.

i require a script to convert sample.txt to sample.xls

can any one share the code for this.


regards,
sumanth

I was tooling around with pyExcelerator a bit. There are a couple examples with it that are easily reused for simply getting the data into a sheet in a workbook.

My goal was to use the sheet as an output device that I could format and print from, as well as manipulate, sort of like reportlab for PDF, but not read-only, so more flexible.

However, if you are satisfied with just getting the data into the spreadsheet, I would also suggest using the CSV modules. I believe they are built-in to later Python versions, so they're more portable if you'll be moving the code around to others' machines. If you create a .CSV and double-click on it in XP, it will open in Excel.

I'm assuming Windows here, granted, but I would think it could work similarly on other platforms.