Excel-Lite: Hey coder! This spreadsheet's for you!
secretGeek .:dotnuts about dotnet:.
home .: about .: sign up .: sitemap .: secretGeek RSS

Excel-Lite: Hey coder! This spreadsheet's for you!

Excel-Lite (XLL) has all the calculating power of regular Excel, but without the bloat, the baggage, the bulge, the.. the.. obligatory overheads, the albatrossicle accoutrements, the embarrasing encumbrances, the chaff.

For generating SQL statements, or HTML, or any sort of code, for manipulating raw data, you can't go past XLL.

There is no limit to the number of rows or columns you can use. No limit to the number of sheets.

XLL does not reformat your data. It won't drop the '0' from the front of a number. It won't alter the format of a field that happens to resemble a date. Currency symbols don't confuse it.

It has excellent support for Regular Expressions. Plus a genuinely comprehensive 'reveal-codes' mode to help you get to grips with your data.

Okay, there's no ability to set text colours or bold or italics or varying fonts or font-sizes, and there are no charting capabilities and even no printing (without plug-ins). But those features are outside the intended use of the product. The trade-off is a fast, versatile, bloat-free application, targeted at programmers and information-workers.

It's quick to load. And damn quick at performing calculations. It takes up about 100k of memory (excluding spreadsheets) and has a versatile undo/redo capability that appears to be unlimited.

Files are internally represented (and stored) as XML. Hence spreadsheet searches can be performed with XPath!

(continues...)

You can load data from most any format ever devised (Yes, VisiCalc too!). And there are plug-ins that allow you to define new custom input formats, too. (What else would you expect?)

You don't have to import from files either -- you can import from webservices, databases, ftp, smtp, streams ... you name it! Files can only be saved as XML (or compressed XML). But the package includes a wealth of XSL-templates, so you can transform your XML output for presentation, or into other formats, if you wish.

Keystroke Macros can be easily recorded, stored, edited or replayed. For more serious functionality extensions, you can write a plug-in in any .net language -- just implement the iXLLPlugIn interface.

There's already a vast wealth of plug-ins available for anything you might want to perform. Plug-ins exist for database access (it can act as a replacement for SQL query analyzer!), for manipulating XML in any way imaginable, for authoring XSLT, CSS, batch files, circuit design, statistical analysis, timetabling, reporting, scheduling, and more fractal-toolkits than you could ever know what to do with. There are some quite impressive plug-ins for integrating with numerous applications, such as Biztalk, Infopath, MS-CRM, Sharepoint and even that lame-elephant, SAP.

Only one real problem. Excel-Lite is not a Microsoft product. In fact, no-one has written it yet. It's just a figment of my imagination, dreamt up a few days ago thanks to a post by Dave Burke. But hopefully, i'll have my hands on it one day not too soooon.

Ahhh... dreaming of software...

as seen on the daily grind

Add or view comments about this page

Articles

Do they store the code for TFS in TFS? Do they store the code for TFS in TFS?
Sudden TimeSnapper Discount! Sudden TimeSnapper Discount!
How Can Microsoft Beat Google? How Can Microsoft Beat Google?
TimeSnapper 3.1: Attack of the the Red/Green Stripes TimeSnapper 3.1: Attack of the the Red/Green Stripes
21 tools used in our MicroISV 21 tools used in our MicroISV
Lost Treasures of the DOS World: tree! Lost Treasures of the DOS World: tree!
The Virtual Machine Machine and the Virtual Virtual Machine The Virtual Machine Machine and the Virtual Virtual Machine
Should Linq To Sql Go Should Linq To Sql Go "Open Source"?
Redux: New Synchronisation Idea Overlooked By Microsoft Redux: New Synchronisation Idea Overlooked By Microsoft
New Synchronisation Idea Overlooked By Microsoft Live team New Synchronisation Idea Overlooked By Microsoft Live team
Visual Studio UX Taskforce, Office UX Taskforce... etc. Visual Studio UX Taskforce, Office UX Taskforce... etc.
How to be Jeff Atwood How to be Jeff Atwood

Archives .: secretGeek :: Complete Archives :.
25 steps for building a Micro-ISV 25 steps for building a Micro-ISV
3 minute guides -- babysteps in new technologies: powershell, JSON, watir, F# 3 Minute Guide Series
Top 10 SecretGeek articles Top 10 SecretGeek articles

Downloads

TimeSnapper -- Automated Screenshot Journal TimeSnapper.com    
Version 3.1: instant productivity profiles

ShinyPower (help with Powershell) ShinyPower
Now at CodePlex

Next Action NextAction
Managing the top of your mind



[powered by Google] 


Thai Erawan, Brisbane Restaurant, delicious thai food in paddington Thai Erawan, Brisbane Restaurant
World's Simplest Code Generator (html edition) World's Simplest Code Generator
Gradient Maker -- a tool for making background images that blend from one colour to another. Forget photoshop, this is the bomb. Gradient Maker
How to be depressed How to be depressed
You are not inadequate.



Recommended Reading

The Best Software Writing I
The Business Of Software (Eric Sink)

Recommended blogs

Jeff Atwood
Reginald Braithwaite
Joseph Cooney
Phil Haack
Scott Hanselman
Julia Lerman
Joel Pobar
Eric Sink
Joel Spolsky
Des Traynor

Aggregated Links

programming.reddit.com
dzone
dot net kicks

Human Link Machines

interesting finds
a continuous learner's weblog
arjan's world
n links today
new and notable
morning coffee
learning .net
weekly link post
(my del.icio.us account)

LinkedIn profile
 
home .: about .: sign up .: sitemap .: secretGeek RSS .: © Leon Bambrick 2003 .: privacy

home .: about .: sign up .: sitemap .: RSS .: © Leon Bambrick 2003 .: privacy