I would advice you to take hints from the existing tools and then devise a
module specific to your requirements. Working with excel depends a lot on
what you want to do with the data that you are working on and so a single
module is rarely all that you need.
If you are on a windows machine, win32co
and http://pypi.python.org/pypi/pyExcelerator/
On Wed, Sep 2, 2009 at 6:39 PM, Baiju M wrote:
> These tools looks very good to deal with Excel files:
>
> http://pypi.python.org/pypi/xlrd (read
> http://pypi.python.org/pypi/xlwt
> http://pypi.python.org/pypi/xlutils
>
> These are pure Python packag
These tools looks very good to deal with Excel files:
http://pypi.python.org/pypi/xlrd (read
http://pypi.python.org/pypi/xlwt
http://pypi.python.org/pypi/xlutils
These are pure Python packages and it works in all platforms.
Regards,
Baiju M
___
BangPyp
Check out win32com (I am assuming you want to do this from a Windows
machine). Here is a small snippet on reading the value from cell A1 in the
active sheet.
from win32com.client import Dispatch
flxls = "c:\\my\\file.xls"
xl = Dispatch ("Excel.Application")
xl.Visible = True
xl.Workbooks.Open(flxl
You have a module called csv which I think can be used to accomplish what
you want. It accepts a csv file, which is identical to .xls file. Try that.
#code snippet:
import csv
csvreader = csv.reader(open(csv_file), delimiter = ',')
for row in csvreader:
print 'row:%s' % row
Regards,
Nandaki
Hi,
I need a help in Python. I want to pass the inputs from Excel through
variables Which is declared in python script.
Example: I given parameter and Value in Excel as :
ParameterValue
Test 5
Test1 6
I used
