<%@ Page Language="C#"%>

<%@ Import Namespace="System.IO" %>

<%@ Import Namespace="PagosSpreadSheet" %>

<script runat="server">

protected void Page_Load(object sender, EventArgs e)

{

//Create an instance of the application

Application app = new Application();

//Open retirement workbook

app.Workbooks.Open(Server.MapPath("Spreadsheets/Retirement/Retirement_chart.xls"));

//Load workbook

Workbook wb = app.Workbooks["Retirement_chart.xls"];

//Set input values

wb.Names["Monthly_savings"].Range.Value = int.Parse(Request.QueryString["Monthly_savings"]);

wb.Names["Annual_Investment_growth_rate"].Range.Value = float.Parse(Request.QueryString["Annual_Investment_growth_rate"]);

wb.Names["Annual_Salary_Increase_Rate"].Range.Value = float.Parse(Request.QueryString[

"Annual_Salary_Increase_Rate"]);

//Save chart to a temporary file for streaming

string fileName = Server.MapPath("Spreadsheets/Temp/RetirementChart" + Session.SessionID + ".gif");

wb.Worksheets[0].ChartObjects[0].Chart.SaveAs(fileName);

//Prepare response for streaming

Response.Clear();

Response.ContentType = "image/gif";

//Stream chart to response

Response.WriteFile(fileName, true);

//Delete temporary file

File.Delete(fileName);

//Close workbook

wb.Close();

Response.End();

}

</script>