public override void Execute()
{
var objSpace = (XPObjectSpace)Application.CreateObjectSpace();
var session = objSpace.Session;
var sortProps = new SortingCollection(null);
var cashFlows = session.GetObjects(session.GetClassInfo(typeof(CashFlow)),
null, sortProps, 0, false, true);
IWorksheet ws = Package.GetWorksheet("Data");
if (ws == null)
{
throw new UserFriendlyException("Worksheet 'Data' not found in workbook.");
}
ws.CopyObjectsToWorksheet(session, cashFlows);
session.CommitTransaction();
}
