InfoQ Homepage Visual Studio Tools for Office Content on InfoQ
Articles
RSS Feed-
The Excel Formula Language Is Now Turing-Complete
The Excel team announced LAMBDA, a new feature that lets users define and name formula functions. LAMBDA functions admit parameters, can call other LAMBDA functions and recursively call themselves. With LAMBDA, the Excel formula language is Turing-complete: user-defined functions can thus compute anything without resorting to imperative languages (e.g., VBA, JavaScript).
-
Apache MetaModel – Providing Uniform Data Access Across Various Data Stores
MetaModel - an Apache Incubator project – is a Java library used to browse, query and update various types of data stores including traditional SQL databases, unusual stores such as CSV or Excel, or the more modern NoSQL stores in a uniform and programmatic way.