The ExcelToXmlSamples library (written in C#) makes it easy to create XML sample files from Excel sheets. It takes an Excel workbook (.xlsx) as input and generates one or more XML samples based on data in the sheets.
ExcelToXmlSamples currently consists of a Class Library project (.dll) and a Console Application project, to call the library. A Windows Forms Application project may be added later.
The project relies on the...
this program consider to be data base of micro and mini uav's and allow to you to make matching between data and show the result in excel report
XLCALCRANGE(REFCELL,R,C,M,N) returns the full target range XLRANGE in Excel A1 notation to cover an array of size M rows & N columns and starting from an offset of R rows & C columns from REFCELL.
Any workbookworksheet prefix is...
VLOOKUP the function as vlookup in Excel
[content, index] = vlookup(m, e, column, lookcolumn) look for 'e' in the 'lookcolumn'-th column of 'm', and return the coresponding 'column'-th element of 'm' in the same row.
unprotecting a password protected sheet in excel, function requires a password to do that.
1) if sheets don't have password then it unprotects them without asking users.
2) if password protected it requires a password from user. it then...
this function provides embedded charts in excel from data already present and saved in excel.
HOW TO USE:
1) download the zip file here.
2) open test1.m and set the address of test1.xlsx accordingly.
3) run test1.m, DONE.
sql2excel is designed to provide a easy way to output mysql sql content in Excel Format & stream it on the user's browser directly
Excel Quick Reports is a set of tools intended for quick WYSWIG prototiping and publishing of quality Excel reports (in Excel XML format). Reports are rendered using automatically generated XSLT and XML data extracted from database.
Developer tools for Visual Basic for Applications in Excel. Import, export and delete modules using a user-friendly UI. These tools integrate as a "Dev Tools" menu into the Visual Basic Editor (VBE).
Function JKNIFE computes values of user-defined scalar-, vector- or matrix-valued statistics in the original sample, and in n leave-one-out samples, where n is the number of rows in X. Addressing limitations of JACKKNIFE (Statistics Toolbox, v....
Progressive Function Point Estimation Workbook in excel to provide Function Point Analysis with greater accuracy for real time project estimation.
Include ability to estimate both function point count, cost and schedule estimate...
This application reads the output of Web forms posted on your website (usually via email) and converts them to csv files for importing into a database, or managing in Excel
An SQL like query language for creating and querying graphs (the logical ones, not the pretty ones you find in excel).
Avicenna is an application for visualizing location data stored in excel or .csv table files on a map or in a table view. It provides several export functions (such as single pictures, database dumps and even a HTML-export that enables you to use...
OpenL implements Java-like languages allowing to use code snippets placed in Excel, XML, or DB. OpenL is a foundation for OpenRules http://openrules.com. Maintained from http://openl.org
Create Decision Tables in Excel and use them in Java application in a convenient type-safe manner. Use Data Tables in Excel for data setup and testing. Eclipse plugin controls validity of Excel tables. Use: Business Rules, BPM, Testing.
ExcelUtils, easy export report in excel by excelutils.It like velocity or freemarker, but it's script is written in excel to control excel format and data.
Often I get data to import in MS Excel files, and the column headers are not very useful for column names. They contain spaces, punctuation, and special characters that make a simple import difficult.
This script opens the file in...
This is a demo of MATLAB Builder for Excel. This demo explains how one can compile MATLAB code into an Excel based COM component using MATLAB Excel Builder and use the same in Excel VBA. This demo compiles a MATLAB code that depicts a curve...
This is a demo for MATLAB Excel Builder. This demo explains how one can compile MATLAB code into an Excel based COM component using MATLAB Excel Builder and use the same in Excel VBA. This demo compiles a MATLAB code that does basic matrix...