WebDevVote - Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project
3votes
voted
Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project
leniel leniel 1 year, 1 month ago
leniel.net — 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. original link
| 3092 views | get vote counter code
Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project
Tags: , , , , | add tag

new Add a live vote counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Vote it" text
  • "Vote it" Background
  • Vote count text
  • Vote count background
  • Border

Simply copy and paste this HTML into your blog post.

Users who voted this story

leniel leniel - jMan jMan - ctthang ctthang

Comments

ExcelT8 ExcelT8 1 month, 30 days ago
Hey there! Thanks for the excellent series of posts here. Hopefully, you did a great a job :)

<a href="link classes</a>
harrypeter86 harrypeter86 1 month, 24 days ago
I suggest to use a excel component, There are great 3rd party components in the market that do the same job (or even better). From a comparison testing I performed about a year ago Spire.XLS for .NET is the best from the following perspectives: 1. Read/Write of excel 2. Support of embedding images 3. Size of result Excel file is very small 4. Convenient API and very similar to Office's one 5. Multi-threaded and multi-process support

link



information Thank you for your visit. Please create an account to share and vote!

Login or Sign up to add your comment.
  • Web Dev Vote's Facebook Profile
  • Follow us on Twitter
  • RSS



Technorati Profile