Ask Your Question

massimiliano manfren's profile - activity

2013-02-25 15:42:06 +0100 received badge  Famous Question (source)
2012-03-09 04:25:00 +0100 received badge  Notable Question (source)
2011-10-11 05:49:28 +0100 received badge  Popular Question (source)
2011-05-12 20:57:09 +0100 received badge  Supporter (source)
2011-05-06 14:43:33 +0100 asked a question import data .xls

Hi I would like to run this python script in sage (simple example):

def import_xls(filename, worksheet=1):
    import xlrd
    book = xlrd.open_workbook(filename)
    sh = book.sheet_by_index(worksheet - 1)     
    data = []
    for i in range(sh.ncols):
        data.append(sh.col_values(i))
    print 'Worksheet Names: %s; Rows: %s; Columns: %s'%(sh.name, sh.nrows, sh.ncols)
    return data

def export_xls(data, filename):
    import xlwt
    wb = xlwt.Workbook()
    ws = wb.add_sheet('Sheet1')
    for i in range(len(data)):
        for k in range(len(data[i])):
            ws.write(i,k,str(data[i][k]))
    return wb.save(filename)

from cvxopt import matrix
from cvxopt import solvers
from numpy import array
from numpy import zeros

A = import_xls('sample.xls', worksheet=1)
b = import_xls('sample.xls', worksheet=2)
c = import_xls('sample.xls', worksheet=3)

# linear programming model 
A = matrix(A)  
b = matrix(b)
c = matrix(c)
sol=solvers.lp(c,A,b) 
print sol['x']
x = sol['x']

But it returns the following error: ImportError: No module named xlrd Can you help me? Thanks a lot