secretGeek.netExcel-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!
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...
Next →
← Previous
My book "Choose Your First Product" is available now.
It gives you 4 easy steps to find and validate a humble product idea.
JonR on April 30, 2004 05:42 sez:
get up off your arse and code it - this would rock.
there's nothing worse than handing a spreadsheet over to someone, then getting it back covered in some temp's idea of "prettification"
Sean on May 19, 2004 01:18 sez:
Haha, our temp is still struggling with changing column widths and all the other "tricky things like that".
Mike Schinkel [Xtras.Net] on July 06, 2004 04:03 sez:
Hey, what's the chance you couldn't build it quickly with <a href="FarPoint's Spread?
http://www.xtras.net/products/fpspreadwinforms.asp
Mike Schinkel [Xtras.Net] on July 06, 2004 04:04 sez:
Hey, what's the chance you couldn't build it quickly with FarPoint's Spread?
Casey Marshall on September 20, 2004 09:57 sez:
After the first paragraph I started looking for a download link. What a let-down! :)
Shreveport Mike on April 29, 2007 15:58 sez:
For Rebol, a great, fun language that also happens to be a (deparenthesized Scheme-ish variant of) Lisp, there is an awesome little freeware opensource application called "Nano-Sheets." Nano-Sheets is a full GUI spreadsheet engine written in less than 2K of Rebol code, and each cell in Nano-Sheets can independently contain and run any Rebol code within it! Tremendously powerful idea whose possibilities I'll leave to your imagination.
Of course, using it means learning a bit of Rebol, which in no way is a bad thing. A nice little project would be to port Nano-Sheets over to Scheme...hmmm.
Shreveport Mike on April 29, 2007 16:20 sez:
Regarding Nano-Sheets: I really should have said that you should learn a bit of Rebol to use Nano-Sheets TO ITS FULLEST EXTENT; one can use it as a typical spreadsheet without learning any Rebol.
One thing that's very cool about it is that because it's so small, if you wanted to e-mail a spreadsheet to someone, it's no big deal to send the data AND the application that runs it! It would still probably be significantly smaller than an Excel file.
Anyway, it's pretty cool; try it out!
Shreveport Mike on April 29, 2007 16:25 sez:
Whoops--that last link I sent was to something else. That was a link to another Rebol program by Robert Muench that allows you to control Excel. Very cool in itself, but not what I intended to send. (I was going to mention it initially, and change my mind.
Anyway, Rebol's a fun toy; if you haven't played with it yet, I recommend it. I just wish there was more documentation available for it.
nelix on July 21, 2007 11:22 sez:
class SpreadSheet:
_cells = {}
def __setitem__(self, key, formula):
self._cells[key] = formula
def getformula(self, key):
return self._cells[key]
def __getitem__(self, key ):
return eval(self._cells[key], globals(), self)