ExpertXls Excel Library ASP.NET Web Forms demo · C#

Cells and Ranges

Accesses cells and ranges with the A1 notation and with row and column indexes, defines named ranges at worksheet and workbook level and reads the used range of the worksheet.

Select the format and press the button: the workbook is created on the server and downloaded by the browser.

Workbook format   

Create, edit and read Excel workbooks in ASP.NET: the workbooks are created on the server and sent to the browser. The code of each workbook is in App_Code.

C# code of this sample

RangesAndCells.aspx.cs
using System;
using System.Data;
using System.IO;
using System.Web.UI;

using ExpertXls.ExcelLib;
using ExcelLibraryDemos;

/// <summary>
/// Cells and Ranges: the workbook code is in App_Code\RangesAndCellsDemo.cs.
/// </summary>
public partial class RangesAndCellsPage : Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    protected void buttonCreate_Click(object sender, EventArgs e)
    {
        ExcelWorkbookFormat format = radioXlsx.Checked ? ExcelWorkbookFormat.Xlsx_2007 : ExcelWorkbookFormat.Xls_2003;
        byte[] workbookBytes;
        try
        {
            // create the workbook in memory; the input files are in the folders of the web site
            using (MemoryStream stream = new MemoryStream())
            {
                RangesAndCellsDemo.CreateWorkbook(format, Server.MapPath("~"), stream);
                workbookBytes = stream.ToArray();
            }
        }
        catch (Exception ex)
        {
            labelError.Text = "The workbook could not be created: " + Server.HtmlEncode(ex.Message);
            return;
        }
        WorkbookDownload.Send(Response, workbookBytes, RangesAndCellsDemo.OutputName + DemoLayout.GetExtension(format), format);
    }
}