8
shouts
spam Shout it Mute it

Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project
posted by lenielleniel 222 days, 2 hours, 29 minutes ago
Friday, July 03, 2009 2:12:08 AM GMT
Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project

Recently I had to implement some code to create an Excel spreadsheet/report using C#. The task was: given an Excel spreadsheet template - a .XLS file (with formulas, pivot tables, macros, etc) I had to fill some data in one of the sheets of the spreadsheet and send this modified spreadsheet back to the user requesting such an operation (Excel report). I had a great time while studying the possible ways of doing what the task asks for. In this article I present an ASP.NET MVC project that shows you how to create an .XLS file using NPOI and an .XLSX file using ExcelPackage.

category: ASP.NET | clicked: 145 | | source: www.leniel.net | show counter code
tags: ASP.NET MVC, C#, COM automation, ExcelPackage, Microsoft Excel, MVC, NPOI, OOXML