Try this:
from win32com.client import GetObject, constants
def GetExcelData(self, strFilePath):
""" Extract the data from the Excel sheet.
Returns tuple of tuples representing the rows and cells."""
# The following line extracts
# all the data from sheet 1 of the spreadsheet
return GetObject(strFilePath).Sheets(1).UsedRange.Value
N/A wrote:
> Hi,
> Is it possible to import data from Excel for doing numerical analysis in
> Python? If so how? Thank u!
--
Dale Strickland-Clark
Riverhall Systems - www.riverhall.co.uk
--
http://mail.python.org/mailman/listinfo/python-list
