Click here to Skip to main content
13,897,554 members

Excel

Great Reads

by yuvalsol
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
by William Hey
Classical number theories
by JamesFaix
Get a collection of all running Excel interop Application objects (not just the active one)
by bradyguy
An end to end view of how to integrate Jira REST API's with Excel.

Latest Articles

by WhiskeyBeforeWater
A nodular Singely Linked List for VBA with some basic functions
by WhiskeyBeforeWater
An unbalanced basic recursive Binary Search Tree for Excel VBA with functions (insert, search, delete, in order, pre-order, post-order, minimum, and maximum)
by NewPast
Indent code, add line numbers, error handling, expose a .NET library and number to words to Microsoft Word, Excel, Power Point macros writers and Access VBA code
by NewPast
Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator

All Articles

Sort by Score

Excel 

23 May 2018
yuvalsol
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
12 Apr 2016
bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
31 May 2016
William Hey
Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.
25 Nov 2017
Daniel Carvalho Liedke
Project to generate Excel Spreadsheet from DataSet with auto size (AutoFit) columns, auto-filter, alternating light blue background color with Open XML using ASP.NET MVC
7 Apr 2018
John Simmons / outlaw programmer
An example of evolving code to fit new demands.
12 Sep 2017
The Zakies
question answer chatbot using natural language parsing and web scrapping
6 May 2018
Sam__Khan
Automated Craigslist parsing with Selenium using Node.js
1 Nov 2018
Bahrudin Hrnjica
Export options in ANNdotNET
2 Jan 2016
HadyAllam
Use Microsoft Excel to generate TFS reports and Create/Modify Work Items
21 Jun 2016
Dave “DWC” Curry
This tutorial will show you a good starting point for a WPF style framework which aims to make creating and maintaining Excel-worksheet-forms easier.
30 Mar 2016
koolprasadd
Read write Excel file without interop using OLEDB in C#
19 Sep 2018
Randy C Finch
A search for efficient algorithms to find Ruth-Aaron pairs
16 Jan 2019
NewPast
Indent code, add line numbers, error handling, expose a .NET library and number to words to Microsoft Word, Excel, Power Point macros writers and Access VBA code
9 May 2017
Muhammad_Faraz
Take Html structure of a table & export to a genuine Excel file - Sever side processing.
25 Nov 2016
JamesFaix
.NET library to access to any running instance of Excel.
5 May 2016
Alex Chirokov
This article shows how to implement Sudoku solver in Excel using C# and Excel-DNA
17 Aug 2016
Michael Ecklin
Very often, Excel spreadsheets are using to transfer data between applications. CSV files are also used for the same purposes.
3 May 2016
Alex Chirokov
Adding interpolation functions to the Excel using C# and Excel-DNA
26 Jun 2017
Roshan Choudhary
Creating ExcelSheet with dropdown containing pre populated dropdown data of its own excelsheet.
8 Jan 2019
NewPast
Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator
7 Nov 2018
Jeremy Likness
DocConverter is so powerful that it can convert millions of documents per day while it automatically encrypts, signs, emails, and FTPs documents after they are processed.
14 Jun 2018
paolo guccini
How to use the Microsoft Interop/Automation to implement parallel research of a Microsoft Office file password.
24 Feb 2019
WhiskeyBeforeWater
An unbalanced basic recursive Binary Search Tree for Excel VBA with functions (insert, search, delete, in order, pre-order, post-order, minimum, and maximum)


Advertise | Privacy | Cookies | Terms of Service
Web06 | 2.8.190306.1 | Last Updated 21 Mar 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid