C# - Aspose.Cells - Create Excel files without Excel

Hello Devz,

It is common to have to export data to an Excel file. But sometimes the code have to run on a server where Excel is not or can’t be installed. And anyway, to be honest the Excel Interop is a real piece of crap to use…

So Aspose did a good work by redoing it completely without the need of Excel or its Interop. Easy to use and fast, what else…

There is a free version available on NuGet which will add an extra worksheet saying it’s an evaluation version, but you will have all the functionalities and with no time limitation.

using Aspose.Cells;
using System.Diagnostics;
using System.Drawing;

namespace AsposeExportToExcel
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create the workbook and the worksheet
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets.Add("My new sheet");
            sheet.Name = "Renamed Sheet";

            //Set a title and format its style
            var cell = sheet.Cells["A1"];
            cell.PutValue("This is my column title");

            Style style = cell.GetStyle();
            style.HorizontalAlignment = TextAlignmentType.Center;
            style.Font.Size = 15;
            style.Font.IsBold = true;
            style.ForegroundColor = Color.AliceBlue;
            style.Pattern = BackgroundType.Solid;
            cell.SetStyle(style);

            //Put some values and format the number with 2 digits
            cell = sheet.Cells["A2"];
            cell.PutValue(123.456);

            style = cell.GetStyle();
            StyleFlag flag = new StyleFlag { NumberFormat = true };
            style.Custom = "0.00";  //round the value to 2 digits
            cell.SetStyle(style, flag);

            //Set the columns to fit the size of their content
            sheet.AutoFitColumns();

            //Save the Excel workbook
            var fileName = "test.xlsx";
            workbook.Save(fileName, SaveFormat.Xlsx);

            //Display the Excel file
            Process.Start(fileName);
        }
    }
}

Happy coding! 🙂

C# – Aspose.Cells – Create Excel files without Excel

Related posts: