NPOI with Excel Table and dynamic Chart (www.leniel.net)

submitted by leniel(430) 4 months, 26 days ago

NPOI is a great open source project that enables us to create Excel spreadsheets in code using Microsoft .Net Framework. A reader of my blog commented on the post titled Creating Excel spreadsheets .XLS and .XLSX in C# about a problem he was having to get NPOI working with an Excel table bound to a chart. The chart should get updated whenever new data is inserted into the table. NPOI doesn't achieve what the user desires at first but in this post I experiment a workaround to the problem so that you can use NPOI to insert new data on a template spreadsheet that has a table bound to chart. Read on... read more...

add a comment | category: Open Source | Views: 44

tags: chart table Programming XLS NPOI another

Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project (www.leniel.net)

submitted by leniel(430) 8 months, 7 days ago

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. read more...

add a comment | category: ASP.NET | Views: 400

tags: MVC OOXML safety thread Spreadsheet another

Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project (www.leniel.net)

submitted by leniel(430) 8 months, 7 days ago

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. read more...

add a comment | category: ASP.NET | Views: 400

tags: MVC Programming OOXML NPOI safety another

Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project (www.leniel.net)

submitted by leniel(430) 8 months, 7 days ago

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. read more...

add a comment | category: ASP.NET | Views: 400

tags: MVC Programming OOXML NPOI safety another

Creating Excel spreadsheets .XLS and .XLSX in C# - ASP.NET MVC Project (www.leniel.net)

submitted by leniel(430) 8 months, 7 days ago

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. read more...

add a comment | category: ASP.NET | Views: 400

tags: MVC Programming OOXML NPOI safety another

ASP.NET Chart with MVC and Google Spreadsheet API (www.leniel.net)

published 1 year ago, submitted by leniel(430) 1 year, 1 month ago

Learn how to integrate ASP.NET charting controls with ASP.NET MVC and Google Spreadsheet Data API. It shows a sample ASP.NET MVC application that uses data retrieved from a Google Spreasheet to feed an ASP.NET charting control. read more...

add a comment | category: ASP.NET | Views: 434

tags: ASP.NET ASPNETMVC chart asp.netmvc Spreadsheet another