Python XLOut示例

示例#1

文件： HolidayHistory.py 项目： bondgeek/pythonhacks

#! /usr/bin/env python
from os import path

import bgpy.QL as QL

from bgpy.xldb import XLOut
from alprion import DROPBOX, SHAREDDATA

dt = QL.Date(1, 1, 1988)

fileout = XLOut(path.join(DROPBOX, "Analysis", "HolidayHistory.xls"))

calendars = (QL.USGovernmentBond, QL.USNYSE, QL.UnitedStates())

nullCal = QL.TARGET()

enddt = QL.Date(31, 12, 2049)

row_n = 1
while dt <= enddt:
    dt = nullCal.advance(dt, 1, QL.Days, QL.Following)

    fileout.write(QL.toPyDate(dt), row_n, 0, 0, format="date")

    for col_n in range(len(calendars)):
        fileout.write(calendars[col_n].isBusinessDay(dt), row_n, col_n + 1, 0)

    row_n += 1

print("\nNumber of rows: %s" % row_n)
fileout.save()

示例#2

文件： xltools.py 项目： bondgeek/pythonhacks

from bgpy.xldb import XLOut
from alprion import PathJoin, DROPBOX, DATADIR, HOMEPATH

fout = PathJoin(HOMEPATH, "sandbox/excelVBA", "linktothis.xls")

wkb = XLOut(fout, overwrite_ok=True)

wkb.write('a', 2, 0)

wkb.save()