Python workbook Examples

Example #1

File: demo.py Project: romualdofernandes/pyXLSX

from xlsx import workbook

Workbook = workbook("test.xlsx")

s = Workbook.Sheets.Sheet1
print "Total Formulas Tested: %s"%len(s.keys())
print "CELL:\tFunction,\t\tEval,\t\tOrig"

for c in s:
    cell = s[c]
    orig = cell.val
    cell.evaluate()
    if cell.fn:
        print "%s:\t%s,\t\t%s,\t\t%s"%(c,cell.fn if hasattr(cell, "fn") else "", cell.val, orig)

Example #2

from xlsx import workbook

Workbook = workbook(
    "C:\\Users\\Arif\\workspace\\PyWRFChemEmiss\\src\\res\\Data_Argis.xlsx")

s = Workbook.Sheets.Sheet1
#print "Total Formulas Tested: %s"%len(s.keys())
#print "CELL:\tFunction,\t\tEval,\t\tOrig"
print 'OK'
for i in xrange(1, 9):
    cell = "A{0}".format(i)
    print cell, ": ", s[cell]

print s.interpolate("A1:A9")

#for c in s:
#    cell = s[c]
#    orig = cell.val
#    cell.evaluate()
#    if cell.fn:
#        print "%s:\t%s,\t\t%s,\t\t%s"%(c,cell.fn if hasattr(cell, "fn") else "", cell.val, orig)

Example #3

File: test_xlsx.py Project: arifwn/pyWRFChemEmiss

from xlsx import workbook

Workbook = workbook("C:\\Users\\Arif\\workspace\\PyWRFChemEmiss\\src\\res\\Data_Argis.xlsx")

s = Workbook.Sheets.Sheet1
#print "Total Formulas Tested: %s"%len(s.keys())
#print "CELL:\tFunction,\t\tEval,\t\tOrig"
print 'OK'
for i in xrange(1,9):
    cell = "A{0}".format(i)
    print cell, ": ", s[cell]

print s.interpolate("A1:A9")

#for c in s:
#    cell = s[c]
#    orig = cell.val
#    cell.evaluate()
#    if cell.fn:
#        print "%s:\t%s,\t\t%s,\t\t%s"%(c,cell.fn if hasattr(cell, "fn") else "", cell.val, orig)
        

Example #4

File: visa_bulletin_generator.py Project: fallofleaf78/UCC

def getDateAt (position, fileName):
    Workbook = workbook(fileName)
    sheet = Workbook.Sheets.visa
    cell = sheet[position]
    return cell