List of Free code Excel
AutoHistory for Word 2007, Word 2010 and Excel 2010
AutoHistory for Word 2007, Word 2010 and NEW Excel 2010 provides a local history for documents. You can view and restore each version you've ever saved.
Creates automaically backups on every save.
Big Data Twitter Demo
This demo analyzes tweets in real-time, even including a dashboard. The tweets are also archived in Azure DB/Blob and Hadoop where Excel can be used for BI!
CDR to SQL
My ugly code for import CDR call stats into MSSQL database and simply analyze data. It also support export to Excel.
ClosedXML - The easy way to OpenXML
ClosedXML makes it easier for developers to create Excel 2007/2010 files. It provides a nice object oriented way to manipulate the files (similar to VBA) without dealing with the hassles of XML Documents. It can be used by any .NET language like C# and Visual Basic (VB).
A personal project that takes formatted Excel show logs, parses them and uploads them to small local database for analytics.
CRM 2011 Metadata Browser
The CRM 2011 Metadata Browser allows you to view metadata including Entities, Attributes and Relationships.. The tool also allows you to export to excel.
CSV Report Generator for SQL
C# application for exporting SQL queries into a CSV file for easy importing into Excel, Access, and any other programs that support CSV file importing. This application is handy for extraordinarily large query results that typically cause stability issues for other programs.
A collection of tools that extend Excel for analytical and rapid development purposes.
DataExporter is a module for DotNetNuke. It allows to export Data from the DotNetNuke database. Module supports Excel, XML and CSV formats for export. Users interface allows to select source of Data: Tables, Views or Custom Query. It simple, easy and fast tool for DNN Admins.
DataFromFile is a small class (written in C#) which makes it easy to deal with data files such as Excel (xls or xlsx) or CSV.
Environment Settings Manager
Easy-to-use tools for software projects that have dynamic configuration settings where values may vary per deployment environment (dev, test, production, etc.). Includes Excel workbook and export tool that writes to various XML formats.
EPPlus-Create advanced Excel 2007 spreadsheets on the server
EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
EPPlus supports ranges, cell styling, charts, pictures, shapes, comments, tables, protection, encryption and a lot of other stuff.
Excel Reader simplified! Using OpenXML SDK 2.5 (Production Ready)
Excel and PowerPivot Refresh Suite
A command line utility for refreshing Excel data, as well as a Windows service which monitors and periodically refreshes a folder of Excel files.
Excel Comparator is an add-in for Microsoft Excel that allows the user to compare a range between two sheets.
Excel Data Reader - Read Excel files in .NET
Lightweight and fast library written in C# for reading Microsoft Excel files ('97-2007).
- Windows with .Net Framework 2
- Windows Mobile with Compact Framework
- Linux, OS X, BSD with Mono 2+
Excel File Cleaner
This tool is designed to reduce the size and speed up Excel 2007/2010 workbooks. It will only work for the new XML File formats (XLSX and XLSM). It cleans the files by reducing the number of styles in use and the number of activated cells. See Microsoft KBs: KB213904 & KB244435.
Provides methods to query an Excel spreadsheet as well as update the spreadsheet cells.
Excel Spreadsheet C# Import Using Typed Datasets and TableAdapters
We will examine how to import data from a Microsoft Excel spreadsheet into a database from a web page. Specifically, we will build a tiered application architecture using Typed DataSets and TableAdapters. This version is in C#.
Step by step tutorials included.
Excel to Dynamics CRM
Excel to Dynamics CRM for Microsoft Dynamics CRM 2011 makes it easier to the CRM users to upsert (update and/or insert) data from an Excel file.
Excel Viewer is a .net component that allows programmers to load excel application and also excel spreadsheets in our windows form.
This component is useful for viewing excel reports in applications.
This component is written in C# 2.0.
Excel-DNA makes it easy to create high-performance Excel add-ins with user-defined functions, ribbons and real-time data streams using .Net - C#, VB.NET or F#.
Excel2SapBom - Transfer Bill of Materials from Excel to SAP
With Excel2SapBom you can transfer BOM from Excel to SAP via Remote Function Call.
ExcelExportLib is a simple data export library wich creates an .xml file. This file can be opened in Excel. Unlike .csv files this format contains formatting information. Main goal of project is to export data in excel format without running Excel.
ExcelPackage: Office Open XML Format file creation
ExcelPackage provides server-side generation of Excel 2007 spreadsheets.
It is a set of classes and wrappers around the .NET 3.0 System.IO.Packaging API and the new Office Open XML file format. It extracts away the complexity of dealing with the individual XML components maki...
Fork of ExcelPackage which continues development where the original developer left off. Main goals are to replicate the ease of use of the COM API for older Excel versions. Easy to use styles!
Export Test Cases From TFS
This project lets the users to export the test cases present in form Work items in TFS 2010 to MS Excel.
IFSS Gradebook Generator
Populates an Excel gradebook template for teachers using an Access database of students
Kalitte CSV to Excel Tool
Use Kalitte CSV to Excel Tool to export CSV (Comma Seperated Values) files to Excel automatically.
KDATFFS - A Key-words Driver Automated Test Framework For selenium
This is a key-word driver framework for selenium2. contains KDATFFS,KDATFFSRunner and KDATFFSRecorder. KDATFFSRunner allows user to ctreate automated tests using excel,Csv; KDATFFSRecorder allow user to record operation into excel,Csv.
A Wrapper to use Microsoft Excel from a managed .NET Environment.
It works with any Microsoft Excel versions, means version independent.
Lexalytics plugin for Excel 2010
This project builds an add-in for Excel 2010 that exposes the text analytics functionality for Lexalytics' Salience Engine. The add-in requires a local installation of Salience Five, and uses Salience to perform entity and theme extraction with sentiment analysis.
Linkrot scans a site for inaccessible links (http error 404, 500, etc.) and saves a log with bad links that you can open in Excel. It's a Windows console application developed in C# (.NET 2.0 stack). Simple, single thread crawling for dead links, broken links, dangling links.
Load Excel Files Into SQL Server. No schema changes requiered!
Load Excel files into SQL Database for further processing, analysis and validation. Without schema changes!
mana Data Access
mana Data Access provides classes to easily access and work with data stored in different sources: Windows Azure Storage, SQL Server, SQL Azure and Excel.
A parser and compiler for a small EXCEL like expression language for .NET applications.
NodeXL: Network Overview, Discovery and Exploration for Excel
NodeXL is an Excel 2007/2010/2013 template for viewing network graphs, with a set of .NET Framework 3.5 class libraries that can be used to add network graphs
OLAP PivotTable Extensions
An Excel 2007, Excel 2010, and Excel 2013 add-in which extends the functionality of PivotTables on Analysis Services cubes.
This is a simple, light-weight and open source OOXML library supports creating and parsing back word and excel documents.
OpenXmlPackaging is a tool written in C# to create Open Xml Excel files from scratch.
A c# console application which is very similar to the ping.exe operating system command, but it outputs to a csv file. The csv file can then be used to produce a report including a line graph in Microsoft Excel. This makes it easier to report on network bandwidth to management.
Polymod.NET is an non-intrusive framework written in C# that gives you excel-like ability to add 'Formulas' to existing domain objects. Polymod.NET will wrap POCO into self-updating and self-validating models so you don't have to wire up INotifyPropertyChanged or IDataErrorInf...
RESX Manager consolidates, synchronizes and translates .NET resources (*.resx, *.wxl), supports export to Excel (*.xlsx) and automating translation.
A tool to process project settings of multiple VS2008 and VS2010 C# projects in Excel. The tool scans the project files and exports some settings into a CSV file which can be edited and written back into the project files. This is usefull in solutions with many project files.
Simple OOXML makes the creation of Open Office XML documents easier for developers. Modify or create any .docx or .xlsx document without Microsoft Word or Microsoft Excel. Uses the Open Office SDK v 2.0.
Simple WPF Spreadsheet
A simple Excel-like spreadsheet with only basic functionalities
SoftwareBotany.Ivy String Utils w/ Quoted Delimited (CSV) & Fixed-Width Parsers
The Software Botany Ivy project is a library containing various string utilities. Included in the library are fluent APIs for parsing and creating quoted delimited and fixed-width positional text. For example, quoted CSV such as that used by Microsoft Excel is supported. The ...
This library is a port of the Excel spreadsheet found at NOAA to calculate the sunrise and sunset for a given date.
The SurveyHost.MVC project is a flexible online survey hosting website. Its main goals are the ability to make creating and hosting a professional online survey easy.
SurveyHost.MVC includes participant consent and validation, multiple measures, and exporting data to Excel.
Test Case Import Utilities for Visual Studio 2012 and Visual Studio 2010
Utilities for importing test cases, requirements, bugs from excel and word formats into work items on the Visual Studio Team Foundation Server 2010 or 2012.
Using Rijndael Security within Excel/Word 2007
Using Rijndael Security within Excel/Word 2007 increasing your data security.
It?s ease to use an Excel or Word 2007 VBA macro as client app of an C# DLL,
that is encharged for encripting/decripting your data, in order to improve security.
Wax allows users to create automated WatiN tests using Microsoft Excel
WCF Data Service (OData) Regression & Load Testing Tool
This is a tool that is especially being developed to regress OData Services. Current release only support few test like ($select, Top, etc ), more test will be added over the time.
It is a Multithreaded Regression Test Tool that can generate result in Excel format including...
WiiWatcher records Wiimote input into Excel and allows you to graph the results for easy analytics. This allows you to understand what motions translate to what inputs to then handle in your program. Screenshots and more information:
Word Frequency Counter
Word Frequency Counter calculates how many times a word appears in a document as well as in a list of given documents. Omits user-defined stopwords. Data may be easily copied to MS Office Excel. The application is developed in C# 3.0.
XlsxDataBinder ease the build of simple Excel report.