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)