def test_write_and_read_view(self):
"""Tests that a python list can be inserted as a column (with xl.view), and then read
back. A header is expected"""
x = range(1, 10)
r = xl.view(x)
self.assertEqual(x, r.get())
v = self.workbook.get("A2").get()
self.assertEqual(1, v)
for i in range(len(x)):
val = r[i] # range index operator
self.assertEqual(val, x[i])
self.assertEqual(r[-1], x[-1]) # negative indices!
self.assertEqual(r[2:5], x[2:5]) # slice indexing
for i, val in enumerate(r): # iterating over range
self.assertEqual(val, x[i])
# Should be able to get the new workbook by name
wb2 = xl.Workbook('Book1')
self.assertEqual(1, wb2.range("A2").get())
# Basic map pattern
def MyDouble(x):
return x * 2
r2 = xl.map(MyDouble, r)
self.assertEqual(map(MyDouble, x), r2.get())
def getSelectionExcel(self,workbook_I=None):
###TODO
# read back data from the active selection of excel
# i.e. a column of data
if workbook_I:
#data_stage01_isotopomer_normalized.xlsx
wb = xl.Workbook(workbook_I).get();
data_O = [];
return data_O;
def viewQueryExcel(self,dataHeader,dataList):
# view the data in excel
wb = xl.Workbook();
xlColumns = [];
for j,dh in enumerate(dataHeader):
dataColumn = [];
for row in dataList:
dataColumn.append(row[dh]);
xlColumns.append(wb.view(dataColumn,dh));
#xlHeader = xlColumnNames[j] + str(1)+':'+xlColumnNames[j]+str(1);
#xlRange = xlColumnNames[j]+str(2)+':'+xlColumnNames[j]+str(len(dataList));
#wb.get(xlHeader).set(dh)
#wb.get(xlRange).set(dataColumn)
return xlColumns;
def main():
w = xl.Workbook(sample_workbook_path)
w.range("A1").set("Hello World!")
def doubled(x):
return 2 * x
def alpha(x):
return "abcdefgh"[int(x) - 1]
xl.map(doubled, w.get("Values"))
xl.map(alpha, w.get("doubled"))
print((w.range("C3:E7").get()))
def main():
"""Loads and modifies a sample spreadsheet in Excel."""
workbook_path = path.join(path.dirname(__file__), 'PyvotSample.xlsx')
workbook = xl.Workbook(workbook_path)
workbook.range("A1").set("Hello World!")
def doubled(val):
"""Returns double of value passed in."""
return 2 * val
def alpha(val):
"""Returns letter at specified position in alphabet."""
return "abcdefgh"[int(val) - 1]
xl.map(doubled, workbook.get("Values"))
xl.map(alpha, workbook.get("doubled"))
print(workbook.range("C3:E7").get())
def ensure_open_workbook():
if not xl.workbooks():
xl.Workbook()
assert xl.workbooks()
def setUpClass(cls):
if cls.workbook_path is None:
cls.workbook = xl.Workbook()
else:
cls.workbook = xl.Workbook(cls.workbook_path)
