Excel-Dna makes it easy to create high-performance (.xll) add-ins for Excel using .Net. Add-ins can expose user-defined functions (UDFs) and macros, and be created using C#, VB.NET, F# or other .Net languages. Excel-Dna is free for all use, and works with Excel '97 to Excel 2007.
NuGet Packages for NetOffice - http://netoffice.codeplex.com
NetOffice is a set of .NET Wrapper Assemblies for accessing MS Office applications such as Excel, Word, Outlook, PowerPoint, Access, Project, and Visio developed by Sebastian Lange.
Linq to ExcelUse LINQ to retrieve data from Excel spreadsheets!
View the introduction videoBasic Examplevar repo = new ExcelQueryFactory();
repo.FileName = "pathToExcelFile";
var peopleWithSiblings = from p in repo.Worksheet()
where p.Siblings > 0
... [More] select p;Linq to Excel assumes the property names on the Person class match the column names in the worksheet named "Sheet1".
What if your class property names don't match the column names or the spreadsheet you're using is not named Sheet1? Then see the CustomizingLinqToExcel page.
Go to the GettingStarted page for a tutorial on implementing Linq to Excel in your project.
Need help? Send questions to the Discussion Group [Less]
Bond investors, policy makers and the general public deserve transparent, objective and up-to-date government credit ratings. The issue of public debt is simply too important to be handled by traditional rating agency practices.
This is why we have launched the Public Sector Credit Framework
... [More] (PSCF). The framework allows an analyst to set up and run a budget simulation model in an Excel workbook. The analyst also specifies a default point in terms of a fiscal ratio. The framework calculates annual default probabilities as the proportion of simulation trials that surpass the default point in a given year. [Less]
This site uses cookies to give you the best possible experience.
By using the site, you consent to our use of cookies.
For more information, please see our
Privacy Policy