Feeds:
Posts
Comments

Archive for the ‘Python’ Category

JavaScript as an Excel scripting language via JSDB

Posted in BI, ETL, JavaScript, Python, SQLite, VBA, data, excel, xLite on June 4, 2010 | 4 Comments »

A few years back I posted about JavaScript as an Excel scripting language via ExcelDNA. That involved using JavaScript (in the guise of JScript.NET) as an ExcelDNA scripting language. It was purely an academic exercise to prove it could be done, I continued to use C# (or increasingly VB.NET) to build .NET user defined functions. This time however, [...]

Read Full Post »

SAX and Bugs and XBRuLe

Posted in BI, ETL, Python, SQLite, VBA, excel, xLite, tagged , , , on May 6, 2010 | 1 Comment »

Okay, the XBRuLe is a bit laboured, should be SAX & bugs & XBRL, but any excuse to play some Ian Dury Bugs (the programming type, not the creepy-crawlies), Simple API for XML and Extended Business Reporting Language;  these represented the trinity of my concerns for the last three weeks  or so. First, the bugs: [...]

Read Full Post »

Excel as a document-oriented NoSQL database

Posted in ETL, Python, SQLite, VBA, data, excel, xLite, tagged , , on March 2, 2010 | 1 Comment »

I’ve been a long time fan of CouchDB, one of the many NoSQL databases to appear in the last few years. CouchDB is a document-oriented database, which with solid B-tree indexing and easy replication, topped off by a MapReduce style view mechanism, puts it up there as a best-of-breed noSQL datastore. Now it may seem strange [...]

Read Full Post »

xLite Beta Updated – adds Python as an Excel Scripting Language

Posted in BI, ETL, Python, excel, xLite on February 7, 2010 | Leave a Comment »

I’ve updated the xLite Beta with bug fixes and added a new page introducing xLite’s Excel/VBA and Python extensions to SQLite. See http://www.gobansaor.com/xlite The u() function allows any VBA UDF (user defined functions) to be called from SQLite. The x() function allows an inbuilt function or indeed most any formula (but not a UDF, use [...]

Read Full Post »

Boy scratches Python…

Posted in Python, education, programming, tagged , on July 5, 2008 | 6 Comments »

I’ve written before about Scratch, a teaching platform developed by MIT to introduce kids to the art of programming. My son has been playing around with Scratch for over a year and although he still enjoys it, he’s showing signs of needing to move to the next level, a ‘real’ programming language.  I decided that [...]

Read Full Post »

Python to replace VB6 …

Posted in ETL, Python, VBA, excel, xLite, tagged , , on May 5, 2008 | 4 Comments »

… well at least for me. As I discussed previously I’ve been seriously investigating using Python as my primary datasmithing scripting language, in effect a new VBA. I also currently use VBA’s compiled cousin, VB6, for certain tasks such as building Excel RTD servers. The problem with VB6 is it depends on Visual Studio 6, [...]

Read Full Post »

Python the new VBA ?

Posted in BI, ETL, Palo, Python, Ruby, SQLite, VBA, Web2.0, data, excel, news, tagged , , , , on April 11, 2008 | 11 Comments »

These last two weeks, Python has been on my mind. First off, last week I decided to make time to fully investigate Picalo, an open-source Python-based data analysis tool, and then, this week, Google announced their long awaited cloud-computing offering, Google Apps Engine, with the language at its core. Python was the first of the [...]

Read Full Post »