Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
135 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 3
Page Size: 10 · 25 · 50

Category filtered by:  Enterprise Systems [x] | Office Development [x] | Microsoft Excel [x]
Technical Blog 2 May 2013   license: CPOL
[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we’ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this … Continue reading →
Enterprise Systems » Office Development » Microsoft Excel
VBSQLWindowsCEOArchitectDBADevCOMCOM+ADO, +
Technical Blog 27 Apr 2013   license: CPOL
Introduction In this article I’ll show you how to create a UDF library for Excel in C# from scratch. By “from scratch” I mean without using Visual Studio, only low-level tools : a simple text-editor like Notepad and the C# … Continue reading →
Enterprise Systems » Office Development » Microsoft Excel
C#Excel
Technical Blog 2 Mar 2013   license: CPOL
Excel addins troubleshooting guide
Enterprise Systems » Office Development » Microsoft Excel
DevIntermediateSysAdminExcel
Tip/Trick 30 Jan 2013   license: CPOL
This tutorial gives you a complete overview on how to insert a Chart to an Excel file through Matlab
Enterprise Systems » Office Development » Microsoft Excel
ExcelMatlab
Tip/Trick 29 Jan 2013   license: CPOL
This tutorial gives you a complete overview on how to read from an Excel file through Matlab
Enterprise Systems » Office Development » Microsoft Excel
ExcelMatlab
Tip/Trick 28 Jan 2013   license: CPOL
This tutorial gives you a complete overview on how to write to an Excel file through Matlab.
Enterprise Systems » Office Development » Microsoft Excel
ExcelMatlab
Technical Blog 22 Jan 2013   license: CPOL
Multiple GridView into multiple worksheets.
Enterprise Systems » Office Development » Microsoft Excel
C#DevIntermediate
Tip/Trick 18 Jan 2013   license: CPOL
Export SQL table data into Excel and open the excel file on the client side.
Enterprise Systems » Office Development » Microsoft Excel
VBASP.NET.NETIntermediateExcel
Article 2 Jan 2013   license: CPOL
An easy way to deliver data with MS Excel
Enterprise Systems » Office Development » Microsoft Excel
VBSQLDBADevOfficeSysAdmin
Tip/Trick 17 Dec 2012   license: CPOL
This article describes how to export data to an Excel file from a GridView.
Enterprise Systems » Office Development » Microsoft Excel
.NET2.0C#2.0ASP.NETDevBeginnerC#.NET
Tip/Trick 21 Nov 2012   license: CPOL
Reading text or CSV file and saving it as an Excel file.
Enterprise Systems » Office Development » Microsoft Excel
C#.NETDevIntermediate
Tip/Trick 1 Nov 2012   license: CPOL
This article focuses on a Very simple and Robust way to export Data to EXCEL
Enterprise Systems » Office Development » Microsoft Excel
C#.NETOfficeBeginnerIntermediateAdvancedExcelOffice-AutomationOffice-Interopexport
Article 14 Oct 2012   license: CPOL
This article describes how to automate Excel 2007 and create charts using a C++ MFC application.
Enterprise Systems » Office Development » Microsoft Excel
C++WindowsDevIntermediate
Tip/Trick 4 Oct 2012   license: CPOL
This is an alternative for "Export DataTable to Excel with Formatting in C#".
Enterprise Systems » Office Development » Microsoft Excel
C#ASP.NETDevIntermediateExcelDataTablearray
Article 17 Aug 2012   license: CPOL
A framework for scanning a worksheet for headers, reading and validating data, providing feedback to the user, and displaying the data in a form with the results.
Enterprise Systems » Office Development » Microsoft Excel
C#.NETDevIntermediateExcel
Tip/Trick 14 Aug 2012   license: CPOL
Binding a database table to a GridView and exporting the GridView data to an Excel text file. An Excel file is used to store information.
Enterprise Systems » Office Development » Microsoft Excel
C#DevIntermediate
Tip/Trick 13 Aug 2012   license: CPOL
Addin Containg Useful Macros & Easily Accessible From Ribbon Menu
Enterprise Systems » Office Development » Microsoft Excel
OfficeExcelmacrosprogrammingVBAAddIn
Article 7 Aug 2012   license: CPOL
How to read an online Excel file and manage it in Microsoft SQL database
Enterprise Systems » Office Development » Microsoft Excel
C#SQLDBADevOfficeBeginner
Technical Blog 1 Aug 2012   license: CPOL
Localization in Excel.
Enterprise Systems » Office Development » Microsoft Excel
Excel
Article 29 Jul 2012   license: CPOL
IntroductionWhy would you  want to call an RTD from an XLL? Recall that the way to call an RTD is through the RTD function in Excel, so the user needs to somehow remember how many parameters your function takes and in what order to supply them and even what the function is called. Good luck explaini
Enterprise Systems » Office Development » Microsoft Excel
C++CWindowsDevCOMOfficeIntermediateAdvanced
Technical Blog 13 Jul 2012   license: CPOL
XLLs are significantly faster, and allow the developer to define the names/parameters of the functions.
Enterprise Systems » Office Development » Microsoft Excel
Windows
Tip/Trick 27 Jun 2012   license: CPOL
Sample code for parsing JSON with deep-nested schemas in VBA.
Enterprise Systems » Office Development » Microsoft Excel
VBScriptDevOfficeIntermediateJSONVBA
Article 20 Jun 2012   license: CPOL
Create an Excel file from data table without Excel using Report Viewer control.
Enterprise Systems » Office Development » Microsoft Excel
C#.NETVisual-StudioDevBeginnerExcelprogrammingfile
Tip/Trick 20 Jun 2012   license: CPOL
Export a DataTable to an Excel file and add format to the contents while writing the Excel file.
Enterprise Systems » Office Development » Microsoft Excel
C#DevIntermediateDataTable
Tip/Trick 31 May 2012   license: CPOL
Load data present in multiple Excel sheets to an Excel sheet or any other destination.
Enterprise Systems » Office Development » Microsoft Excel
DevIntermediateExcel
Article 29 May 2012   license: CPOL
Allows for inputting Excel tables into a DataSet.
Enterprise Systems » Office Development » Microsoft Excel
C#2.0C#.NETDevADO.NETBeginnerC#
Article 12 May 2012   license: CPOL
How to save data to excel file using Microsoft Excel
Enterprise Systems » Office Development » Microsoft Excel
.NET3.0.NET3.5C#ASP.NETDevIntermediate.NET
Article 12 May 2012   license: CPOL
How to generate excel file on the fly without using Microsoft Excel and download it in chunk chunk way?
Enterprise Systems » Office Development » Microsoft Excel
C#3.0ASP.NETDevBeginnerIntermediateAdvancedC#C#4.0
Tip/Trick 3 May 2012   license: CPOL
Configure Excel dynamically in for each loop container.
Enterprise Systems » Office Development » Microsoft Excel
DevIntermediateExcel
Article 26 Apr 2012   license: CPOL
Creating an MSN-like Stock Quotes add-in for Excel 2007 using User-Defined Functions and Ribbons.
Enterprise Systems » Office Development » Microsoft Excel
C#.NETDevCOMIntermediate
Tip/Trick 24 Apr 2012   license: CPOL
Different methods for converting between Excel and XML depending on different requirements.
Enterprise Systems » Office Development » Microsoft Excel
C#XML.NETOffice
Tip/Trick 21 Apr 2012   license: CPOL
Excel sheet to SQL DB
Enterprise Systems » Office Development » Microsoft Excel
C#ASP.NETADO.NETOfficeIntermediate
Article 17 Apr 2012   license: CPOL
Introduction to manipulating Excel with C#.
Enterprise Systems » Office Development » Microsoft Excel
.NET1.0Win2KWinXPWin2003VS.NET2002C#Windows.NETVisual-StudioDev, +
Tip/Trick 15 Apr 2012   license: CPOL
ASP.NET GridView to Excel conversion.
Enterprise Systems » Office Development » Microsoft Excel
C#ASP.NETOffice
Technical Blog 19 Mar 2012   license: CPOL
This post is about using standard MS Office icons on a custom VSTO Office AddIn. This can be achieved by setting up the “imageMso” property on a Ribbon designer.1) Create a simple Office AddIn project. This example is using Excel AddIn, but the approach is absolutely the same on Word, Po
Enterprise Systems » Office Development » Microsoft Excel
C#
Technical Blog 24 Feb 2012   license: CPOL
This might not be a ground breaking discovery but I was thinking I might be able to share this piece of code to someone who might need it.
Enterprise Systems » Office Development » Microsoft Excel
C#.NETDevIntermediate
Article 21 Feb 2012   license: CPOL
Comparison of the Excel Object Library and the native C# library NPOI to extract information from .xls files.
Enterprise Systems » Office Development » Microsoft Excel
.NETDevIntermediateC#C#4.0Excel
Article 15 Jan 2012   license: CPOL
Upload Excel Spreadsheet File to Server, then Display Record(s) in Gridview
Enterprise Systems » Office Development » Microsoft Excel
ASP.NETHTMLExcel
Article 7 Dec 2011   license: CPOL
ExcelXMLExport is a Microsoft Excel 2010 Add-in that generates XML data from Excel sheet.
Enterprise Systems » Office Development » Microsoft Excel
C#XMLWindows.NETVisual-StudioOfficeBeginnerIntermediateC#Visual-Studio, +
Article 3 Oct 2011   license: CPOL
This article presents an example to export tabular data through the web in CSV as well as Excel formats.
Enterprise Systems » Office Development » Microsoft Excel
C#.NETArchitectDevADO.NETIntermediateMVC
Article 29 Sep 2011   license: Ms-PL
Pull data directly from SQL Server to Excel using C# and VSTO.
Enterprise Systems » Office Development » Microsoft Excel
C#3.0.NET3.5VS2008DevCOMADO.NETIntermediateC#.NETVisual-Studio
Article 20 Sep 2011   license: CPOL
A simple description of LP and instructions to use Excel Solver for solving problems
Enterprise Systems » Office Development » Microsoft Excel
All-TopicsExcel
Technical Blog 7 Sep 2011   license: CPOL
In the previous article we developed a custom function in Excel using an Automation Add-in. It was fairly straightforward and didn’t take  long but performance isn’t one of it’s strengths and there is no way to properly document it within Excel for the user. The RTD is an automation add-
Enterprise Systems » Office Development » Microsoft Excel
Windows
Technical Blog 6 Sep 2011   license: CPOL
The Need for Speed: Excel Buffer Class
Enterprise Systems » Office Development » Microsoft Excel
C#
Technical Blog 22 Aug 2011   license: CPOL
Automation Add-In
Enterprise Systems » Office Development » Microsoft Excel
Windows
Technical Blog 17 Aug 2011   license: CPOL
Have you ever wanted to create your own functions in Excel? There are several ways to accomplish this goal, all have their strengths and weaknesses. The options for creating a custom function are listed in the table below. In  this post we’ll be looking at the easiest option that requires
Enterprise Systems » Office Development » Microsoft Excel
Windows
Article 28 Jul 2011   license: CPOL
This article will explain the basics of ODF format, and specifically its implementation in spreadsheet applications (OpenOffice.org Calc and Microsoft Office Excel 2007 SP2). Presented is a demo application which writes/reads tabular data to/from .ods files.
Enterprise Systems » Office Development » Microsoft Excel
C#XMLWindows.NETCEOArchitectDevOfficeIntermediateAdvanced, +
Article 22 Jun 2011   license: CPOL
A C# class to create Excel files without requiring Microsoft Excel.
Enterprise Systems » Office Development » Microsoft Excel
C#.NETDevIntermediate
Technical Blog 25 May 2011   license: CPOL
Converting Mind Map Plan into an Excel Table
Enterprise Systems » Office Development » Microsoft Excel
OfficeExcel
Technical Blog 13 Apr 2011   license: CPOL
How to add a persistent Excel sheet to your web page.
Enterprise Systems » Office Development » Microsoft Excel
JavascriptHTMLDevIntermediate
Page 1 of 3
1 2 3
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web01 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid