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,
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
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,
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(flxls)
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
___
and http://pypi.python.org/pypi/pyExcelerator/
On Wed, Sep 2, 2009 at 6:39 PM, Baiju Mmba...@zeomega.com 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