[dba-Tech] Supercharge your excel spreadsheet

 Hi Jim --

<<<
I smell another business opportunity. :-)
>>>
As Stuart I'm rather skeptical about this "supercharge approach". I mean: AFAIU they use DLL(s) or COM Add-in to communicate with Python interpreter - that promise to be rather slow at runtime.

To "supercharge (excel/libra-calc) worksheets" I'd use something like OpenXML SDK with Python web services providing absent in MS Excel/libra-calc financial (modeling) packages functionality...

IMO the approach they propose is yet another potential source of very crappy, slow, having high support costs custom apps we've got so much with VB6 and VBA in 90-ies and 00-ies...

I can be wrong.

Thank you.

-- Shamil

Среда, 13 февраля 2013, 13:29 -08:00 от "Jim Lawrence" <accessd at shaw.ca>:
>Hi Stuart:
>
>Good point, Stuart. (Pyrthon ???) ...but how many users actually even
>understand VB script for that matter?
>
>I smell another business opportunity. :-)
>
>Jim 
>
>-----Original Message-----
>From:  dba-tech-bounces at databaseadvisors.com
>[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
>Sent: Wednesday, February 13, 2013 12:46 PM
>To: Discussion of Hardware and Software issues
>Subject: Re: [dba-Tech] Supercharge your excel spreadsheet
>
>How many "home users" can program in Pyrthon?
>
>On 13 Feb 2013 at 11:21, Jim Lawrence wrote:
>
>> Hi All:
>> 
>> We all know that Excel is the most common database in the world. It is
>> because it is so simple to use anyone can and almost anyone can visualize
>> how to manipulate the data. I even built a spreadsheet to do my income
>taxes
>> so you can see how simple it really is to design in.
>> 
>> Well, a company has taken this spreadsheet one step further and added
>Python
>> into the mix. This gives the spreadsheet the capability to pull data from
>> anywhere and build functions far more complex than what rudimentary VB
>> script can do.
>> 
>> For a single home user this program is free and the rates are reasonable
>for
>> small to large enterprises. They are even working on a Linux offering that
>> will work in Libra-calc and will work on the Microsoft Office Linux
>offering
>> that is scheduled to debut, in 2014. 
>> 
>>  https://www.datanitro.com/
>> 
>> Jim 
>> 
>