Home

Bytescout.XLS for .NET
Screenshots

Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample Click to view sample

15% DISCOUNT ON ALL PRODUCTS Hurry! Only available until January 10th 2009
Just use the following COUPON CODE: WINTER2009


Bytescout.XLS library for .NET

Download Free Trial Buy Now More Information
Shop Safely: Bytescout XLS SDK comes with a 30-DAY UNCONDITIONAL MONEY-BACK GUARANTEE

How to generate Excel document report with data table using Bytescout.XLS library

This source code sample generates report with table and saves into .XLS document using Bytescout.XLS library

Download example source code: bytescoutxls_create_report_with_table_in_xls.zip (5 KB)

Simple report in Excel format generated using Bytescout.XLS library

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Text;
using Bytescout.XLS;

namespace Create_a_report_with_table_in_XLS
{
class Program
{
static void Main(string[] args)
{
// Create new XLSDocument
XLSDocument document = new XLSDocument();
// Add new worksheet
Worksheet worksheet = document.WorkBook.Worksheets.Add("SimpleReport");
// Set Values
worksheet.Cell(0, 0).Value = "Name";
worksheet.Cell(0, 1).Value = "Full Name";
// Set font bold for headers
worksheet.Cell(0, 0).Font = new Font("Arial", 12, FontStyle.Bold);
worksheet.Cell(0, 1).Font = new Font("Arial", 12, FontStyle.Bold);
worksheet.Cell(1, 0).Value = "Homer";
worksheet.Cell(1, 1).Value = "Homer Jay Simpson";
worksheet.Cell(2, 0).Value = "Marjorie";
worksheet.Cell(2, 1).Value = "Marjorie Marge Simpson (Bouvier)";
worksheet.Cell(3, 0).Value = "Bartholomew";
worksheet.Cell(3, 1).Value = "Bartholomew Jojo Bart Simpson";
worksheet.Cell(4, 0).Value = "Lisa";
worksheet.Cell(4, 1).Value = "Lisa Marie Simpson";
worksheet.Cell(5, 0).Value = "Margaret";
worksheet.Cell(5, 1).Value = "Margaret Maggie ";
// Save document
document.SaveAs("SimpleReport.xls");
}
}
}

Download example source code: bytescoutxls_create_report_with_table_in_xls.zip (5 KB)

Download Free Trial Buy Now More Information
Shop Safely: Bytescout XLS SDK comes with a 30-DAY UNCONDITIONAL MONEY-BACK GUARANTEE

Documentation online: view (separate window)

First steps tutorials:

Advanced Examples:

Products  |  Download  |  Purchase  |  Support  |  Contacts  |  Testimonials  |  News |  

Copyright © ByteScout, 2003-2008. Privacy Statement
Microsoft®, Windows®, Windows 2000®, Windows Server®, Windows Vista®, Internet Explorer®, .NET Framework®, ActiveX®, Visual Basic®, Visual C#®, ASP®, ASP.NET®, Excel®, PowerPoint®, are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Adobe®, Flash® and Acrobat® are registered trademarks of Adobe Systems, Incorporated. Mozilla®, Firefox® and the Mozilla and Firefox Logos are registered trademarks of the Mozilla Foundation. Other product names or brandnames used herein are for identification purposes only and might be trademarks or registered trademarks of their respective companies. We disclaim any and all rights to those marks.