Create an Excel like Autofilter using the DataGrid and WPF(www.jarloo.com)

submitted by Cryptik(155) 7 months, 14 days ago

Your users are probably used to Excel and how the filtering works, so why not mimic that style of filtering in your own applications? This tutorial shows how you can do it and includes the full source code. read more...

add a comment |category: Windows Presentation Foundation |Views: 38

tags: Excel WPF DataGrid another

Excel 2007 VSTO add-in tutorial(clear-lines.com)

submitted by brandewinder(530) 1 year, 11 months ago

A step-by-step tutorial on building an Excel 2007 VSTO add-in, using .Net, WPF and MVVM, the Ribbon and Custom Task Pane, to extend Office and create a friendly user interface to identify and highlight differences between two worksheets. read more...

add a comment |category: Other |Views: 138

tags: ribbon VSTO Excel add-in another

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

submitted by leniel(504) 2 years, 7 months 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: 361

tags: chart table Programming XLS NPOI another

Export to Excel with X code(patrikluca.blogspot.com)

submitted by Patrik(705) 2 years, 9 months ago

Every user of Microsoft Dynamics AX knows the possibility and the ease-of-use to copy-paste data from a Dynamics AX grid to a Microsoft Excel worksheet. However, as Dynamics AX developer, you can achieve the same through X++ code, with a lot of more possibilities. In this post, I show an example of such an export to Microsoft Excel. I am going to export the list of my customers to a first worksheet in my Excel file. For each customer, I’ll add a seperate worksheet through X++ code and I’ll export in that particular worksheet an overview of backorder lines with their quantity that has not yet been packing slip delivered. read more...

add a comment |category: Products |Views: 209

tags: Dynamics Excel another

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

submitted by leniel(504) 2 years, 10 months 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: 1870

tags: MVC OOXML safety thread Spreadsheet another

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

submitted by leniel(504) 2 years, 10 months 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: 1870

tags: MVC Programming OOXML NPOI safety another

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

submitted by leniel(504) 2 years, 10 months 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: 1870

tags: MVC Programming OOXML NPOI safety another

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

submitted by leniel(504) 2 years, 10 months 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: 1870

tags: MVC Programming OOXML NPOI safety another

Reading Excel Spread sheet as strongly typed objects(shashankshetty.wordpress.com)

submitted by sswp(10) 3 years ago

Tool to create and access data from excel (*.xls and *.xlsx) as a collection of strongly typed objects read more...

add a comment |category: C# |Views: 29

tags: Excel C# another

Exporting Data to Excel using ADO.Net(soulsolutions.com.au)

submitted by crpietschmann(11.3k) 3 years, 9 months ago

If you want to export some data into excel in ASP.Net without having Excel on your server a good way to do it is it use a GridView and ADO.Net to do this. There are a few little tricks/snags you can quickly hit, so I’m going to show a few I’ve found. read more...

add a comment |category: ADO.NET |Views: 81

tags: ASP.NET Excel Database ADO.NET another

Export DataSet to Excel Using An Array(kellychronicles.spaces.live.com)

submitted by scorpion53061(85) 3 years, 10 months ago

The example for writing the data to an array and sending it to a spreadsheet at http://support.microsoft.com/default.aspx?scid=kb;EN-US;306022 is great and where my thinking on this began. It was inadequate however to deal with datasets and the problems encountered in dynamic data. read more...

add a comment |category: VB.NET |Views: 279

tags: DataSet array VB.NET Excel another

Error Importing Excel Spreadsheet in SharePoint VPC(deepakkapoor.net)

submitted by deepakkapoor(430) 3 years, 10 months ago

While working with SharePoint VPC Image I got an error when I imported an Excel file for a custom list. The error says "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features." read more...

add a comment |category: Tips & Tricks |Views: 39

tags: Excel Tips SharePoint another

Applying column formulas in Excel(mycsharpcorner.com)

submitted by yousefla(675) 3 years, 10 months ago

How to copy a formula to the whole column values in Excel read more...

add a comment |category: Other |Views: 48

tags: Excel another

(Mis)Using IDisposable: beyond resource clean-up(blog.functionalfun.net)

submitted by samuel_d_jack(415) 4 years ago

Anybody who has ever done any work with files, databases and so on, in C#, has had it drummed into them that they must be good citizens and always tidy up after themselves. Usually that means using using. But did you know that the using statement has uses that go far beyond resource cleanup? read more...

5 comments |category: C# |Views: 35

tags: VSTO Excel C# another

Convet an excel graph to a dynamic graph in Silverlight (tutorial)(wpf-graphics.com)

submitted by abenedik(225) 4 years ago

See how to convert an excel graph with Paste2Xaml to a Silverlight application. To show the power of Silverlight we add a starup animation and a dynamicaly showing graph data on moving the mouse over graph's bars. The tutorial can be also used for WPF applications. read more...

add a comment |category: Silverlight |Views: 505

tags: .net3.5 Silverlight 3.5 Excel xaml another

Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters(aspnet.4guysfromrolla.com)

submitted by Moondusk(15) 4 years, 2 months ago

In this tutorial, learn how to import data from an Excel Spreadsheet to a Database by creating a tiered application architecture using Visual Studio's Typed DataSets and TableAdapters. read more...

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

tags: DataSet TableAdapter ASP.NET Excel another