[Dale Strickland-Clark]
| 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 she
Hi,
> Is it possible to import data from Excel for
> doing numerical analysis in Python? If so how?
use John Machins glamouros 'xlrd'
http://www.lexicon.net/sjmachin/xlrd.htm
form his documentation:
import xlrd
book = xlrd.open_workbook("myfile.xls")
print "The number of worksheets
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
sorry, can you say it more clearly?
In Matlab, I can easily import data from Excel just simply use 'xlsread'
command. How to do that in Python environment? thank u!
Paddy wrote:
> The CSV module?
>
--
http://mail.python.org/mailman/listinfo/python-list
The CSV module?
--
http://mail.python.org/mailman/listinfo/python-list
