[chanshe112]

Hello I downloaded the xwlt module, but how to write and read from a text to excel for example
3101 Ms. Leanne Jones 278 High Street Blackwood Gwent NP12 2BN United Kingdom 1495225229. this is the data what I have in notepad.
I want to put this data in excel like this.

Sr. No. Title First name Middle Name Last Name Company Job Title Address City State/Province Zip/Postal Code Country Region primary Phone Mobile Phone Email address


Can anyone help me.

[atraub]

Can you show us the code you have so far and a detailed error explaining why it doesn't work.

This post has been edited by atraub: 08 August 2012 - 08:20 AM

[chanshe112]

So far, I have not started it.
What I did was I used file object and read the file but I don't know how to proceed from there.

Regards,
Shekar

[FamiHug]

You may write your data into CSV format
A, B, C, D

then use your excel program, import that csv file, then you will get a excel file

CSV http://en.wikipedia....eparated_values

This post has been edited by atraub: 08 August 2012 - 12:30 PM
Reason for edit:: Changed cvs to csv

[atraub]

Until you show some miniscule attempt at solving it, I will not help you. That would be violating the #1 fundamental rule of Dream In Code. Please, show us something.

This post has been edited by atraub: 08 August 2012 - 12:32 PM

[jon.kiparsky]

@FamiHug is correct, csv is the easiest way to do this. For each row of data, construct a string containing the values in the order you want them, separated by commas.
Technically, you don't have to use commas, any single character will do, so you might want to use, for example, tabs ("\t") or vertical bars ("|") if there's a chance you'll have commas in your data (for example, in the address field).

It would be wise to ensure that your data fields don't contain your separator character, in any case, because that would cause an annoying misalignment of your data.

But, as Adam says, if you want help with the code you'll have to start by writing it.