public void ExportToExcel(string m_exportFileName) { WorkbookGenerator workbookGenerator = new WorkbookGenerator(); workbookGenerator.AddWorksheet(Indices); workbookGenerator.AddWorksheet(Positions); workbookGenerator.AddWorksheet(AccountData); workbookGenerator.SaveWorkbook(m_exportFileName); }
public void ExportToExcel(string m_exportFileName) { AccountDataSet.StressTestSummaryDataTable summaryTable = new AccountDataSet.StressTestSummaryDataTable(); summaryTable.AddStressTestSummaryRow(RiskFreeInterestRate, ChangeInMarket, ChangeInVolatility, CurrentEquity, CurrentMarketValue, NewMarketValue, NewMarketValue - CurrentMarketValue, PercentPandL); WorkbookGenerator workbookGenerator = new WorkbookGenerator(); workbookGenerator.AddWorksheet(Indices); workbookGenerator.AddWorksheet(StressTestDataTable); workbookGenerator.AddWorksheet(summaryTable); workbookGenerator.SaveWorkbook(m_exportFileName); }