Re: [Tutor] Importing Excel sheet data

2007-09-06 Thread Kent Johnson
Ian Witham wrote: > HI Saradhi, > > I too am fairly new to Python, but I use the csv module successfully for > my work. Could you be a little more specific as to what your > requirements are and where you are finding difficulty? > > Ian. > > On 9/6/07, *saradhi dinavahi* <[EMAIL PROTECTED] >

Re: [Tutor] Importing Excel sheet data

2007-09-06 Thread Steve Willoughby
saradhi dinavahi wrote: > I am new to the Python Programming. I want to Import Excel sheet data > using Python. Can any one please provide me the code and explain the > basic steps and method of executing the code. If you can get your Excel data into CSV format, the csv module others have alrea

[Tutor] Importing Excel sheet data

2007-09-05 Thread János Juhász
Dear Saradhi, I am using COM on Win32 for this, based on the sample of Mark Hammond & Andy Robinson in the "Programing Python on Win32" book. That is a fairly simple way to do that. The code itself can be downloaded from http://examples.oreilly.com/pythonwin32/ppw32_samples.zip You can find s

Re: [Tutor] Importing Excel sheet data

2007-09-05 Thread Ian Witham
Hi Saradhi, The first step is to export your excel data to the .csv format. This is done in Excel from the file menu. CSV means "comma separated values". If you have exported the data correctly it may look something like this: "8803","16/9/2007","299000","BEO","13B Mandeville Crescent","Grenada

Re: [Tutor] Importing Excel sheet data

2007-09-05 Thread Ian Witham
HI Saradhi, I too am fairly new to Python, but I use the csv module successfully for my work. Could you be a little more specific as to what your requirements are and where you are finding difficulty? Ian. On 9/6/07, saradhi dinavahi <[EMAIL PROTECTED]> wrote: > > hi Ian , > > I have read the CS

Re: [Tutor] Importing Excel sheet data

2007-09-05 Thread Ian Witham
Hi, You should look at the 'csv' module in the Python Standard Library. If you export your excel data to csv format, you can easily import the data in to python using the csv module. Ian On 9/6/07, saradhi dinavahi <[EMAIL PROTECTED]> wrote: > > hello all, > > I am new to the Python Programming.

[Tutor] Importing Excel sheet data

2007-09-05 Thread saradhi dinavahi
hello all, I am new to the Python Programming. I want to Import Excel sheet data using Python. Can any one please provide me the code and explain the basic steps and method of executing the code. Thank You All ___ Tutor mail