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...)




[Comments closed due to greek spammers.]

'nelix' on Sat, 21 Jul 2007 15:22:56 GMT, writes:

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)

URL: http://roll.nelix.id.au/



'Shreveport Mike' on Sun, 29 Apr 2007 20:25:06 GMT, writes:

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.

URL:



'Shreveport Mike' on Sun, 29 Apr 2007 20:20:37 GMT, writes:

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!

URL: http://robertmuench.de/projects/excel/



'Shreveport Mike' on Sun, 29 Apr 2007 19:58:07 GMT, writes:

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.




URL: http://www.devx.com/opensource/Article/27454



'Casey Marshall' on Mon, 20 Sep 2004 13:57:20 GMT, writes:

After the first paragraph I started looking for a download link. What a let-down! :)



'Mike Schinkel [Xtras.Net]' on Tue, 06 Jul 2004 08:04:09 GMT, writes:

Hey, what's the chance you couldn't build it quickly with FarPoint's Spread?


URL: http://www.xtras.net/products/fpspreadwinforms.asp



'Mike Schinkel [Xtras.Net]' on Tue, 06 Jul 2004 08:03:07 GMT, writes:

Hey, what's the chance you couldn't build it quickly with <a href="FarPoint's Spread?

http://www.xtras.net/products/fpspreadwinforms.asp

URL: http://www.xtras.net



'Sean' on Wed, 19 May 2004 05:18:42 GMT, writes:

Haha, our temp is still struggling with changing column widths and all the other "tricky things like that".

URL:



'JonR' on Fri, 30 Apr 2004 09:42:13 GMT, writes:

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"

URL: http://www.brock.ac.uk/blogs/jon/



Comments closed due to Greek Spammers.


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

Articles

Mind-boggling Demo of New Gaming Genre, aka Folder-Based Hangman, aka Fun with Recursion Mind-boggling Demo of New Gaming Genre, aka Folder-Based Hangman, aka Fun with Recursion
Got CSV in your javascript? Use agnes. Got CSV in your javascript? Use agnes.
I went to write down a book name and founded an internet empire instead. I went to write down a book name and founded an internet empire instead.
NimbleText: Origins NimbleText: Origins
The Windows 8 Mullet The Windows 8 Mullet
Cosby: spontaneous striped background generator Cosby: spontaneous striped background generator
Slides from WDCNZ: Live Coding Asp.net MVC3 Slides from WDCNZ: Live Coding Asp.net MVC3
MVC 3, MVC 3, "Third Times a Charm" references
Custom Errors in ASP.Net MVC: It couldn't be simpler, right? Custom Errors in ASP.Net MVC: It couldn't be simpler, right?
Anatomy of a Domain Hijacking, part 2: The Website Who Came In From The Cold Anatomy of a Domain Hijacking, part 2: The Website Who Came In From The Cold
Anatomy of a Domain Hijacking, part 1 Anatomy of a Domain Hijacking, part 1
secretGeek.net domain has been stolen. The site may go down. secretGeek.net domain has been stolen. The site may go down.
Boring article: 'untrusted domain' issue with SQL Server. Boring article: 'untrusted domain' issue with SQL Server.
Coding While You Commute Coding While You Commute
Test Driven Dentistry Is A Good Thing Test Driven Dentistry Is A Good Thing
The 'less crashy' release of NimbleText The 'less crashy' release of NimbleText
Rethinking Toolbars in Visual Studio (or any IDE) Rethinking Toolbars in Visual Studio (or any IDE)
Where shall we have lunch? Where shall we have lunch?
Setting up email for your microIsv Setting up email for your microIsv
The NO Visual Studio movement: Compiling .net projects in Notepad++ The NO Visual Studio movement: Compiling .net projects in Notepad++
ZeroOne: the editor for programmers who think in binary ZeroOne: the editor for programmers who think in binary
Mercurial workflow for personal projects (with a .net bias) Mercurial workflow for personal projects (with a .net bias)
I see you're using vim. Let me fix that for you. I see you're using vim. Let me fix that for you.
The worst recruitment spam I've ever read The worst recruitment spam I've ever read
A thank you I forgot to say A thank you I forgot to say
My new product, NimbleText, is live My new product, NimbleText, is live
Grabbing the free songs of Jonathan Coulton (with Powershell) Grabbing the free songs of Jonathan Coulton (with Powershell)
Using NimbleSet to compare lists Using NimbleSet to compare lists
Wanted: Wiki Lists (dot org) Wanted: Wiki Lists (dot org)
DOS on Dope: The last MVC web framework you'll ever need DOS on Dope: The last MVC web framework you'll ever need
JSON Query Languages: 5 special purpose editors JSON Query Languages: 5 special purpose editors
What then, is b? What then, is b?
SQLike: A simple editor SQLike: A simple editor
Yet Another BizPlan Generator. Yet Another BizPlan Generator.
HOT GUIDS: A hot or not site for guids HOT GUIDS: A hot or not site for guids
How does life get better? One tiny hack at a time. How does life get better? One tiny hack at a time.
24 things to do, and 100 things *not* to do (yet) for building a MicroISV 24 things to do, and 100 things *not* to do (yet) for building a MicroISV
Venture capital won't kill Jeff Atwood, it will only make him Jeffer. Venture capital won't kill Jeff Atwood, it will only make him Jeffer.
A handy workflow image for newbie mercurial users A handy workflow image for newbie mercurial users
Fractal Feedback, a diversion into recreational programming Fractal Feedback, a diversion into recreational programming
Hump-Jumping: How the Education of Computer Science can be Saved, err, maybe. Hump-Jumping: How the Education of Computer Science can be Saved, err, maybe.
Suggested User Experience Improvements for DiffMerge Suggested User Experience Improvements for DiffMerge
SQL Style Extensions for C# SQL Style Extensions for C#
The Movie Hollywood (And My Wife) Doesn't Want You To See: Weekend at Jacko's The Movie Hollywood (And My Wife) Doesn't Want You To See: Weekend at Jacko's
Sysi: the ultimate administrators toolkit Sysi: the ultimate administrators toolkit

Archives .: secretGeek :: Complete Archives
TimeSnapper -- Automated Screenshot Journal TimeSnapper.com    
Version 3.3: true productivity boost

Next Action NextAction
Managing the top of your mind

NimbleText -- World's Simplest Code GeneratorNimbleText -- World's Simplest Code Generator, Text Manipulator, Data Extractor

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
Universal Troubleshooting checklist Universal Troubleshooting Checklist
Top 10 SecretGeek articles Top 10 SecretGeek articles
ShinyPower (help with Powershell) ShinyPower
Now at CodePlex

Realtime CSS Editor, in a browser RealTime Online CSS Editor
Gradient Maker -- a tool for making background images that blend from one colour to another. Forget photoshop, this is the bomb. Gradient Maker


[powered by Google] 


How to be depressed How to be depressed
You are not inadequate.



Recommended Reading


the little schemer


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

Recommended blogs

Jeff Atwood
Joseph Cooney
Phil Haack
Scott Hanselman
Julia Lerman
Rhys Parry
Joel Pobar
Thomas White
OJ Reeves
Eric Sink

Aggregated Links

proggit
dzone
hacker news
dot net kicks

Human Link Machines

interesting finds
a continuous learner's weblog
arjan's world
weekly link post

LinkedIn profile
LogEnvy - event logs made sexy
Computer, Unlocked. A rapid computer customization resource
PC Smart Buys - Computer Hardware in Australia
 
home .: about .: sign up .: sitemap .: secretGeek RSS .: © Leon Bambrick 2003 .: privacy

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