sys.stderr.write(l+'\n') wb=Workbook(path+l) for ws in wb.sheets: dump_sheet(ws,wb.sheets[ws]) wb.save('test.xls') wb=Workbook('test.xls') for ws in wb.sheets: dump_sheet(ws,wb.sheets[ws]) except int, e: print e exit(0) ''' #wb=Workbook('/home/user/workspace/Queck/mso/poi-3.8/test-data/spreadsheet/StringContinueRecords.xls') wb=Workbook('test.xls') print wb.date1904 for ws in wb.sheets: dump_sheet(ws,wb.sheets[ws]) wb.save('test2.xls') wb=Workbook('test2.xls') dump_supbooks(wb) #for ws in wb.sheets: # dump_sheet(ws,wb.sheets[ws]) exit(0)
#!/usr/bin/env python # tries stress SST, SAT and MSAT import sys from time import * from poi import Workbook #style = XFStyle() wb = Workbook() ws0 = wb.sheets.add('0') colcount = 200 + 1 rowcount = 6000 + 1 t0 = time() print "\nstart: %s" % ctime(t0) print "Filling..." for col in xrange(colcount): print "[%d]" % col, sys.stdout.flush() for row in xrange(rowcount): #ws0.write(row, col, "BIG(%d, %d)" % (row, col)) ws0.cells(row, col).Value = "BIG" t1 = time() - t0 print "\nsince starting elapsed %.2f s" % (t1) print "Storing..." wb.save('big-16Mb.xls')
#!/usr/bin/env python # -*- coding: windows-1251 -*- # Copyright (C) 2005 Kiseliov Roman from poi import Workbook w = Workbook() ws = w.sheets.add('F') ws.cells(0, 0).Formula = "-(1+1)" ws.cells(1, 0).Formula = "-(1+1)/(-2-2)" ws.cells(2, 0).Formula = "-(134.8780789+1)" ws.cells(3, 0).Formula = "-(134.8780789e-10+1)" ws.cells(4, 0).Formula = "-1/(1+1)+9344" ws.cells(0, 1).Formula = "-(1+1)" ws.cells(1, 1).Formula = "-(1+1)/(-2-2)" ws.cells(2, 1).Formula = "-(134.8780789+1)" ws.cells(3, 1).Formula = "-(134.8780789e-10+1)" ws.cells(4, 1).Formula = "-1/(1+1)+9344" ws.cells(0, 2).Formula = "A1*$B1" ws.cells(1, 2).Formula = "A2*B$2" ws.cells(2, 2).Formula = "A3*$B$3" ws.cells(3, 2).Formula = "A4*B4*sin(pi()/4)" ws.cells(4, 2).Formula = "A5%*B5*pi()/1000" ############## ## NOTE: parameters are separated by semicolon!!! ############## ws.cells(