[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
rom 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
--
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
Hi,
Is it possible to import data from Excel for doing numerical analysis in
Python? If so how? Thank u!
--
http://mail.python.org/mailman/listinfo/python-list
