SpreadsheetGear 2012
ASP.NET
SpreadsheetGear 2012 > Tutorials > ASP.NET

Follow these steps to generate a simple Excel Report from ASP.NET using SpreadsheetGear 2012

Create a new ASP.NET Web Site

  1. Launch Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, Visual Studio 2013 or Visual Studio 2015.
  2. On the File menu, point to New and click Web Site. The New Web Site dialog box appears.
  3. Under Templates, click ASP.NET Web Forms Site in Visual Studio 2012, Visual Studio 2013 and Visual Studio 2015, or click ASP.NET Web Site in earlier versions of Visual Studio.
  4. Change the Location as desired and set the Language to Visual C#.
  5. Click OK to create the web site.

Add a reference to SpreadsheetGear 2012

  1. In Solution Explorer, select the web site you just created.
  2. On the Website menu, click Add Reference. The Add Reference dialog box appears.
  3. In the Add Reference dialog box, click the .NET tab. A list of .NET components appears.
  4. In the list of .NET components, select SpreadsheetGear 2012 Core Engine and SpreadsheetGear 2012 GDI+ Drawing Library for use with .NET 4.0+, or select SpreadsheetGear 2012 for .NET 2.0 for use with .NET 2.0+.
  5. Click OK to add the reference. 

Add code to create a workbook and return the workbook to Excel on the client

  1. In Solution Explorer, right click on Default.aspx and choose View Markup.
  2. Replace the Default.aspx markup with:
    Simple ASP.NET Excel Report using SpreadsheetGear 2012
    Copy Code 
    <%
@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE
html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html
xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>My First ASP.NET Excel Report</title>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e)
{
  // Create a new workbook.
  SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
  SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets["Sheet1"];
  SpreadsheetGear.IRange cells = worksheet.Cells;
  // Set the worksheet name.
  worksheet.Name = "2005 Sales";
  // Load column titles and center.
  cells["B1"].Formula = "North";
  cells["C1"].Formula = "South";
  cells["D1"].Formula = "East";
  cells["E1"].Formula = "West";
  cells["B1:E1"].HorizontalAlignment = SpreadsheetGear.HAlign.Center;
  // Load row titles using multiple cell text reference and iteration.
  int quarter = 1;
  foreach (SpreadsheetGear.IRange cell in cells["A2:A5"])
    cell.Formula = "Q" + quarter++;
  // Load random data and format as $ using a multiple cell range.
  SpreadsheetGear.IRange body = cells[1, 1, 4, 4];
  body.Formula = "=RAND() * 10000";
  body.NumberFormat = "$#,##0_);($#,##0)";
  // Stream the Excel spreadsheet to the client in a format
  // compatible with Excel 97/2000/XP/2003/2007/2010.
  Response.Clear();
  Response.ContentType = "application/vnd.ms-excel";
  Response.AddHeader("Content-Disposition", "attachment; filename=report.xls");
  workbook.SaveToStream(Response.OutputStream, SpreadsheetGear.FileFormat.Excel8);
  Response.End();
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
</form>
</body>
</html>

Run the web page

  1. Right click on the markup of Default.aspx and choose View in Browser.
  2. Internet Explorer will be launched and a "File Download" dialog box will ask whether you want to open or save the file.
  3. You may have different results with older versions of Internet Explorer or Excel, or if Internet Explorer or Excel settings have been changed.