C# Corner

Resources  
  • Assemblies : The Ins and Out : Part IApr 13, 2001. In Part 1, I will cover what exactly an assembly is, and what an assembly contains.
  • Assemblies : The Ins and Out : Part IIApr 16, 2001. In this part, I will discuss both Private and Shared assemblies and how to create a "Shared Assembly".
  • Assemblies : The Ins and Out : Part IIIApr 20, 2001. In this part I will discuss in more detail than Part 2, the available utilities for manipulating assemblies.
  • cwTab - A Tab Control in C#May 18, 2001. cwTab is a control written in C# that gives you the ability to add Visual Studio.Net, Excel, and InterDev tabs to any application. The control is fully customizable.
  • Eater Game in C#Jul 31, 2001. This is a simple game written in C# in which the user moves a packman like player around the form and gobbles up red dots. The object is to get all the dots in as quick a time as you can.
  • Realtime Stock Quotes into Excel using .NETSep 03, 2001. I may seem a little Bullish on .NET, but I was able to create this application fairly quickly in C#.
  • A Quick View From C/C++ to C#Sep 10, 2001. This article provides a quick overview of the C/C++ and C# languages.
  • Abstract Classes And MethodsOct 08, 2001. This is a detailed analysis of Abstract classes and methods in C# with some concrete examples.
  • How To Open and Read an Excel Spreadsheet into a ListView in .NETNov 26, 2001. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel.
  • Data Transfer from SQL Server to ExcelDec 26, 2001. In this application, we will see how we can transfer data from Microsoft SQL Server into Excel spreadsheet.
  • Creating an Excel Spreadsheet ProgrammaticallyJan 22, 2002. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000.
  • Creating an Excel Spreadsheet ProgrammaticallyJan 22, 2002. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000.
  • Real-time Message Logging Utility - Part 1Apr 01, 2002. A message logger is a utility that helps in logging the messages thrown from functions/programs. It is useful in critical applications as it helps to know the time taken by a function to execute, the time that the function remained idle and any messages that the function wants to be logged for further analysis.
  • Editable GridView Control in C# and .NET - Part IV Exporting the GridView to ExcelJun 27, 2002. In this article we will take the contents of our GridView control and spill it into an Excel spreadsheet using this wrapper mechanism.
  • Recipe to Implement Threads Quick n Easy in C#Aug 28, 2002. In this tutorial type article, author shows how to write threading applications quick and easy in C#.
  • The "ins" and "outs" of Using Stored Procedures in C#Jan 27, 2003. This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
  • J2EE to .NET Migration: Quick TipsMar 26, 2003. Here are some Quick tips to get you started, in case you need to migrate a J2EE based application to a .NET based application.
  • Basics of Extending Your Working Environment in Visual StudioApr 10, 2003. All of us have used Macros in Microsoft Office and Add-ins in Visual Studio 6 and I am very sure all of us have been impressed as well by their power to control their own working environment.
  • Using C# .NET in Excel 2003May 08, 2003. This article shows how you can take advantage of Visual Studio 2003 tools to write .NET applications that work with Office 2003.
  • Talking to the Outside World in Excel 2003May 14, 2003. This code sample shows how to connect to the internet inside of Excel 2003. The idea is when the workbook opens the code behind the workbook searches for quotes on NASDAQ and then populates the spreadsheet with the data.
  • SmallPOP: Hackish Implementation of POP RFC in .NETJun 02, 2003. The attached source code and this article contains the details for the C# version of SmallPOP, a quick and dirty component for retrieving e-mail from POP servers.
  • Export ASP.NET DataGrid to ExcelSep 08, 2003. Export to Excel is one of the most common functionality required in ASP.NET pages. Users can download the data from the DataGrid into an Excel spreadsheet for offline verification and/or computation.
  • Stock Paper Trader in C# and .NETNov 11, 2003. The attached source code project is a paper trading application that allows you to place imaginary trades on real data. I thought this would be fairly easy to duplicate having already written a stock capturing program into Excel.
  • Office11 Solution using .NET - A White PaperNov 25, 2003. This detailed white paper contains the information about Office 11 support for Microsoft .NET. It also explains Office 11 object model and how to access Word and Excel documents using Visual Studio .NET.
  • Fundamentals of Function Point Analysis Part IFeb 17, 2004. Function points are a unit measure for software much like an hour is to measuring time, miles are to measuring distance or Celsius is to measuring temperature.
  • Fundamentals of Function Point Analysis Part IIFeb 18, 2004. Function points are a unit measure for software much like an hour is to measuring time, miles are to measuring distance or Celsius is to measuring temperature.
  • Generating Microsoft Excel Reports in .NETMar 01, 2004. Microsoft Excel is installed on most computers these days since it is part of Microsoft office, and you can create detailed reports with Excel, but it will take some doing. I will attempt to show you how to create a simple report in Excel and some of the problems you may encounter along the way, this will work with Excel 97-2000.
  • Accessing Excel Spreadsheet in C#Jun 01, 2004. Most of the time you will use SQL, Oracle, Access or some other database to store data. But it is possible to use Excel spreadsheet much like a database to stored data. This article and code will explain how to do this in C#.
  • Microsoft Enterprise Instrumentation Framework(EIF) - Quick GuideJul 02, 2004. The Microsoft EIF is a bunch of assemblies for .Net that make your life easy when it comes to instrumenting your program, by this I mean tracing facilities, writing to the event log, and many other things.
  • Microsoft Enterprise Instrumentation Framework(EIF) - Quick GuideJul 02, 2004. The Microsoft EIF is a bunch of assemblies for .Net that make your life easy when it comes to instrumenting your program, by this I mean tracing facilities, writing to the event log, and many other things.
  • Query Tool to Excel using C# and .NETFeb 03, 2005. This article show how to use .NET's interoperability feature to pull the data directly into the spreadsheet.
  • Mapping Microsoft Excel columns with XML data (XML data integration) programmatically using a .Net Application.Apr 21, 2005. Using this program you can map Excel columns programmatically and generate an XML file containing the cell values that you had in your Excel document. After generating the XML file we can read it into a dataset.
  • Language Extensions in C# 2.0Apr 21, 2005. This article intends to the C# 1.x developers and covers what-why-how the new enhancement .The philosophy behind the document is to have quick update on C# 2.0 and leverage this in your day to day development work.
  • Learning Visual Studio 2005 IDE - Quick Access to Active Tool Windows and FilesJul 31, 2005. One of the coolest feature in Visual Studio 2005 I like is quick access to all active Windows and Files and switing control between them.
  • Windows Forms 2.0 ActiveDocumentHost ControlNov 10, 2005. The ActiveDocumentHost control provides the ability to host OLE Documents within your application. This enables you to create applications that allow in-place editing of documents such as Microsoft Word and Excel.
  • Generating Excel Reports using ASP.NET and C#Dec 29, 2005. This article and code snippet shows how to generate Excel reports from ASP.NET using Excel objects in .NET Framework.
  • Security Setting for ExcelJan 04, 2006. To run the excel report, security settings are required for excel application because while working with the excel application we are going to use some of the classes for manipulating the data inside the file. This article shows how to grant access or rights to those files.
  • Writing Dataset to Excel in ASP.NETMar 01, 2006. This article is helpful for those who would like to write dataset contents to a excel file and try to display it in the browser.
  • Play with the Excel Object Library using .NETMar 02, 2006. In this article we will see usage of several things like how to use WebBrowser control, manipulating Excel object libarary.
  • Data mining and SQL Server 2005Apr 11, 2006. Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means, which can be explored for valuable information. It is about learning the characteristics of data set, which are not possible to discover by simple seeing.
  • Nullable Types in C#: Basic IntroductionMay 02, 2006. This article gives a quick view in to the problems faced with the value type objects and the solution to the problems. This beautiful facility is introduced by Microsoft as an concept called “Nullable Types” in the C# 2.0.
  • A quick start with C# and Websphere MQJul 11, 2006. This article is trying to help the developers who want to start integrating .NET applications with Websphere Message Queue.
  • Introduction to NJDX OR MapperJul 17, 2006. This article provides a quick walkthrough to Software Tree's NJDX OR Mapper.
  • 10 Measures to Reduce Credit Card Fraud for Internet MerchantsJul 27, 2006. The purpose of this document is to introduce 10 preventative measures that merchants can take in order to minimize credit card fraud. In addition, we would like to take this opportunity to introduce a complete suite of FraudLabs™ Web Services specializing in the analysis of credit card fraud risk for Internet merchants.
  • Flashing Stock Alert Application using C# and the Basic Stamp IISep 15, 2006. This article describes an application for reading stock quotes into an excel spread sheet and alerting the user when the stock quotes have exceeded or dropped below a certain price threshold. The project uses the SerialPort class to send commands to the Parallax Basic Stamp Microcontroller.
  • Read and write Open XML files (MS Office 2007)Sep 22, 2006. This article shows how to read and write Open XML files (MS Office 2007).
  • ASP.Net 2.0: Export GridView to Excel Nov 06, 2006. This article describes how to Export an ASP.Net 2.0 GridView to Excel.
  • Flash Player Custom Control for ASP.NET 2.0Dec 05, 2006. This article describes a quick and simple approach to creating a custom web control used to display shockwave flash files within an ASP.NET page. Whilst the article and demonstration project are focused upon displaying a shockwave flash (SWF) file, the basic idea is applicable to any sort of object that you may wish to embed within an ASP.NET 2.0 page.
  • Gradient Background Tab Custom ControlDec 06, 2006. This article describes a quick and simple approach to creating a tabbed custom control with a gradient background.
  • Gradient Panel Custom ControlDec 07, 2006. This article describes a quick and simple approach to creating gradient panel custom control.
  • Monitor and Display CPU State InformationDec 18, 2006. This article describes a quick and simple approach to displaying information about the state of the CPU or CPUs on a targeted machine.
  • Excel Automation in .NetJan 08, 2007. This article explains how to achieve excel automation in .Net.
  • ASP.NET 2.0 Visio Custom ControlJan 15, 2007. This article describes a quick and simple approach to creating a custom web control used to display Microsoft Visio files within an ASP.NET page using Internet Explorer.
  • Import data from Excel to Access using ADO.netMar 05, 2007. Data interoperability with Microsoft office applications has become easier with ADO.net.
  • Add a Quick Map to a Windows ApplicationMar 15, 2007. This project demonstrates a quick and easy way to add mapping to a windows desktop application (with an available internet connection) using Google Maps as the basis and source for the map.
  • How to Create a Scrollable DataGrid?Mar 29, 2007. This quick tip shows how to create a scrollable ASP.NET DataGrid.
  • ASP.Net 2.0: Export GridView to Excel - Part IIApr 04, 2007. In this version of the article, we will include the handling the Hyperlink columns in the GridView export to Excel and also re-factor our original logic to use more general features of Reflection.
  • Programming XAML - A Quick StartApr 10, 2007. XAML is a new descriptive programming language that is used to define user interfaces in WPF, Silverlight and Windows 8 Metro Style Apps. This article is an introduction to XAML.
  • Spell check enabled RichTextBox custom controlMay 16, 2007. This article describes a quick and simple approach to applying a spell check function to the rich text box control and bundling both features into a single custom control. Of course there is nothing novel or particularly interesting about performing spell checking upon a selection of text using the Word.DLL.
  • Fill in PDF Form Fields Using the Open Source iTextSharp DLLJun 18, 2007. This article describes a quick and simple approach to programmatically completing a PDF document through the use of the iTextSharp DLL.
  • Creating a Dynamic Excel Using HTMLAug 30, 2007. This article includes some sample programs to show how to implement various excel functionalities with the help of HTML.
  • Introduction to Building a Plug-In Architecture Using C#Sep 10, 2007. In this article we'll take another look at how we can use the state pattern to build a plug-in architecture that will allow us to change the behavior of our application by placing differnt plug-ins into a folder.
  • Managed Static Code Analysis in VSTS: Part ISep 24, 2007. This article attempts to explain the concept of static code analysis and tools that can be used to realize it with a focus on managed code analysis.
  • Using DLL files in Visual Studio 2005 using C#Nov 14, 2007. This article explains the procedure of creating DLL files using visual studio 2005. It is very quick and easy to learn.
  • How to Convert XLS File into CSV File in C#Feb 27, 2008. The article shows you a simple way to convert an XLS file into a CSV file by using a small C# program
  • Connect to an Excel file as a data source via OBDCJun 30, 2008. This article provides answer to questions asked about how to connect to an excel file as a data source for a given application, I provide the solution via this ten steps walkthrough.
  • Integrate WPF Control in your Excel SolutionsAug 11, 2008. In this article, I will show that it is possible to host a WPF control in a excel solution even that Visual studio and the .Net framework doesn’t provide us a way to host directly a given WPF control in an Excel application. To know how to realize such task, then follow this walkthrough.
  • (WPF) Windows Presentation Foundation - FAQJan 02, 2009. In this section we will make a quick walkthrough of WPF which will help you understand WPF instantly.
  • Agile Development: Part IJan 07, 2009. This article is a quick FAQ of Agile. By reading this you will understand fundamentals of Agile and different ways of implementing Agile.
  • Agile Development: Part IIJan 09, 2009. This article is a quick FAQ of Agile. By reading this you will understand fundamentals of Agile and different ways of implementing Agile.
  • SharePoint Quick Start FAQ: Part IJan 13, 2009. Below is quick start FAQ for people who are new to share point. We will warm up some theory in the first two articles and then do some practical on the same lines.
  • SharePoint Quick Start FAQ: Part IIJan 14, 2009. In the previous session of SharePoint article we had discussed about the basics of SharePoint. In this session we will - create site / site collection, understand the ready made functional reusable modules, learn how we can display a simple page and later apply master pages of SharePoint, host a Inline code and behind code page in SharePoint, understand the concept of features and understand step by step how to enable / disable a feature, how do display a feature in Admin.
  • SharePoint Quick Start FAQ: Part IIIJan 15, 2009. This is my third series of SharePoint Quick Start FAQ. We will cover page templates , page instances , WSS model , understand safe mode processing , deploy custom controls and understand WebParts. So let’s drink the SharePoint wine series by series, slowly , maintain the hangover and enjoy this great product.
  • Import Data from Excel to a SQL Server databaseJan 16, 2009. This article mainly describes about how to import the data from Excel sheet to the SQL Server database.
  • Architecture FAQ for Localization and Globalization: Part IFeb 02, 2009. In this article we will go through a series of FAQ which will give you a quick start on making application multi-language based.
  • Architecture FAQ for Localization and Globalization: Part IIFeb 03, 2009. This article is Part 2 of "Localization and Globalization" in this we will go through a series of FAQ which will give you a quick start on making application multi-language based.
  • Ajax Quick Start FAQ Feb 04, 2009. This FAQ is like a starter kit. It will help you understand the main aspects of Ajax in a rapid fashion....
  • Six SigmaFeb 05, 2009. Below is a quick revision which will give you a decent understanding of Six sigma from interview point of view.
  • SharePoint Quick Start FAQ - Part 4Feb 07, 2009. This is my fourth series of SharePoint Quick Start FAQ. In this series the theme is WebPart , WebPart and WebPart J.  So let’s enjoy the WebPart bonanza.
  • Creating Excel/Word/HTML Document Using C#Feb 24, 2009. This article describes a simple approach to create Excel/Word/HTML document using C#, ADO.Net dataset without using interop/excel assemblies reference.
  • Introduction to Visual Studio Add-insMar 03, 2009. This article explains about Visual Studio 2008 Add-ins.
  • Introduction to Interfacing Win Forms with VS Add-insMar 04, 2009. This article explains about integration of Windows Forms with Visual Studio Add-ins.
  • An easy way to view reports through Excel Mar 09, 2009. In this article, we are going to see an easy way to generate report using c# and view it through excel
  • Office automation with VS 2008Mar 17, 2009. Outlook automation has become integral part of any LOB application. MS Excel, work, outlook are getting used by most of the enterprise applications today. This article provides quick view on how to integrate outlook with .net application
  • Paging and Sorting ListViews with ASP.NET MVC and jQueryMar 23, 2009. This article provides a simple example of using jQuery along with the jQuery tablesorter and tablesorter.pager plug-ins to provide sorting and paging support for a listview within the context of an ASP.NET MVC application. JQuery has partnered with Microsoft and is now integrated within the IDE to include the availability of intellisense support.
  • Query Analyzer for OracleMar 23, 2009. Query Analyzer allows you to connect to an Oracle database and create any query, see the results, and import results to text or excel files.
  • Crystal and Reporting Services Interview Questions - Part 1Apr 02, 2009. This Interview Questions will give you a quick start for two report giant’s crystal and reporting services.
  • Crystal and Reporting Services FAQ - Part 2Apr 03, 2009. This article is the continuation of Crystal and Reporting Services FAQ - Part 1. This FAQ will give you a quick start for two giant reports on Crystal and Reporting Services.
  • SharePoint Quick Start FAQ: Part VApr 09, 2009. This is the 5th tutorial of SharePoint FAQ series. This series will mainly concentrate on custom columns, content types and document list library. I am sure once your read this article your thinking of how SharePoint organizes document centralization will change.
  • Project Management Schedule Management FAQ seriesApr 13, 2009. In this article we will run through a quick FAQ for schedule management of software projects.
  • Windows Communication Foundation FAQ: Part IIApr 16, 2009. In this article, we will run through a quick FAQ for WCF. I am sure after reading this you will get a good understanding of the fundamentals of WCF.
  • Import Data from SQL Server 2005 to Excel Sheet and ViceversaMay 11, 2009. This Article Shows How to Use SQL Server to Export Data from SQL Server to Excel Sheets and Viceversa.
  • How to Preserve Password in a TextBox between Page PostbacksMay 15, 2009. This quick tip shows how you can preserve a password in a TextBox between page postbacks.
  • Microsoft Technology OverviewMay 21, 2009. In today’s fast changing technology, keeping up with technological changes is a challenge. Every time we try to keep up with technology changes, technology changes again. It is never ending chase to catch up with technology and that is what makes software development even more interesting. Focus of this article is to give developers, project managers a quick view of many of new Microsoft technologies out there and help them realize the value of these new technologies. To be frank, technologies covered here are not new and some of them were introduced to IT world, 3 to 4 year ago. But in relative terms, these are still new technologies in Microsoft world as real-world projects and products might take some time to adapt to these changes in technology.
  • Analizing data to best customers using Crystal ReportsMay 22, 2009. In the sales analysis, there is a principle named the Pareto principle also known as the 80-20 rule. The 80-20 rule states that 80% of the effects come from the 20% of the causes and then the remaining 20% effects come from 80% of the causes. Pareto observed that 80% of the land in Italy was owned by 20% of the population. One example in the IT world is that Microsoft has noted that 20% of the most reported bugs are the causes of the 80% of the errors or crashes of the systems. After Pareto observed this principle, a lot of application appeared. One of the most common applications of the Pareto principle is in the sales analysis. Companies perform analysis in their sales orders in order to discover the best customers, that is, the 80% of the sales come from the 20% of the customers. In this article, I will show how to perform a sales analysis using Crystal Reports. For this example, we will use the AdventureWorks database shipped with SQL Server 2005.
  • Windows Vista Security, Review of Data Execution Prevention Jun 03, 2009. Windows Vista introduces a range of new technologies that make the most secure desktop version of Windows to date. The following article provides an objective analysis of one of these improvements. Our goal is to help people better understand the true security climate that awaits them with Windows Vista, in this case with DEP (Data Execution Prevention).
  • WCF FAQ Part 3 - 10 Security Related FAQJun 23, 2009. In this article we will start with transport and message security understanding. We will then see simple code samples of how to implement transport and message security using WsHTTP bindings. We will also see what is the difference between ‘BasicHttpBinding’ and ‘WsHttpBinding’ with the help of a simple source code. WCF security is a huge topic by itself, but we are sure with this article you will get a quick start of how to go about WCF security.
  • Export Data Grid in Excel Word And Text FileJul 03, 2009. In this article I am going to show how we can export data grid in excel, word and notepad file.
  • Installing Silverlight 3-A Quick PrimerJul 17, 2009. In this atticle you will learn how to install Silverlight 3.
  • Using Prism Quick Start Kit for Silverlight 3: Part IJul 23, 2009. In this article we will see how to use Prism Quick Start Kit for Silverlight 3.

About quick-analysis-in-Excel-2013

NA

SPONSORED BY

C# Corner Chandigarh DevCon16
Chandigarh DevCon16 is a one-day Developer Conference where programmers, technologists, authors, and members meet, demonstrate, plan, and hang out.
Visual Studio Live - Redmond 2016