import pyExcelerator, os, time, string, calendar, datetime
import smtplib, cgiutils, xldate, DateTime, EmailRecips

def ExcelToList(fname, worksheet=0, encoding='cp1251'):
	data = pyExcelerator.parse_xls(fname,encoding)
	sheet_name=data[worksheet][0].encode(encoding)
	values = data[worksheet][1]
	for each in sorted(data[0][1].items()):
		print str(each)[1:-1]
	vdict = {}
	row_idx_max = 0
	col_idx_max = 0
	for row_idx, col_idx in sorted(values.keys()):
		row_idx_max = max(row_idx,row_idx_max)
		col_idx_max = max(col_idx,col_idx_max)
		v = values[(row_idx, col_idx)]
		if isinstance(v, unicode):
			v = v.encode(encoding, 'backslashreplace')
		vdict[(row_idx,col_idx)] = v
	vlist = []
	for row in range(row_idx_max+1):
		vlist.append([])
		for col in range(col_idx_max+1):
			if (row,col) not in vdict:
				vdict[(row,col)]=None
			vlist[row].append(vdict[(row,col)])
	return vlist