IPython in Excel | Hacker News Reader

IPython in Excel

datanitro.com

73 pointsvj4425 comments

I grok why you would want to replace VBA for Excel by Python. But once you've switched to an iPython way of working, your pretty much above and beyond the spreadsheet world?

iPython-way: Build or import nice functions, import them, get your (new) data, run your models and see nice graphs in iPython.

So what the niche is that this product focusses on? Empowering the finance-via-spreadsheet world where separate programmers are dying to be allowed to use Python instead of VBA?

As a heavy user of DataNitro in the finance world, I can attest to how much it has improved my life. It allows me to interact with my data providers' excel plugins in a much more expedient manner. I could use their direct data feeds, but testing things on those is a PITA.

Largely, though, I agree that DN isn't really necessary/useful but for a small niche... but when you need it, it's EXTREMELY necessary.

In a prior life I used a lot of VBA to process some scenario modeling Excel spreadsheets. Python would have been much better. Python is also becoming more and more common in Financial Services.

I haven't used DataNitro, but it would have helped me in the past, and it fills a very real need. I think the niche may be bigger than you give it credit for.

I think it's comparable to XMLSpy, in how powerful it is, how niche it is, how incredibly useful it is to some people, and how expensive it is. https://datanitro.com/pricing.html

The pricing actually isn't that high if the target is Finance. If anything it may be too low. These are folks who pay ~$20K per user per year for Bloomberg.

I meant in absolute terms. There are people who are happy to pay for XMLSpy, too. Ditto for AutoCAD.

I'm a financial analyst that uses VBA quite frequently (and sometimes unnecessarily, admittedly, I just like to program). I first learned to program in Python and I find VBA not as enjoyable to work with. However, I don't think I could justify going out and getting this product. Very small niche indeed, I'm not sure who would really need it.

Two jobs ago, I built reports and dashboards, mostly in Excel. It was a nightmare. After three years of that, I did some demonstration of Python's capabilities and ended up working on a web-based enterprise reporting system.

These days, I work almost 100% in Python. While I'm not doing analysis much, iPython is awesome for "exploratory programming" - I can quickly build a function to do what I want, thoroughly test it, then import the and its associated tests back into my "real" environment.

The ease of integration external datasources alone makes Python extremely attractive for Excel.

I can easily imagine using iPython to control a small cluster of Amazon instances, using them to process some offensively large dataset (e.g., US Census data), generating a usably small resultset, and dropping it into Excel at the end to make pretty charts that don't look (visually) out of place with the rest of the executive's presentation.

You'd end up with Excel being the GUI of an arbitrarily powerful network of computing resources.

I do like FRP though, it'd be nice to be able to automatically update cells in an iPython notebook when dependencies change their data. Also, a notebook is quite a linear structure, a grid (or tree, possibly just an acyclic graph) might be a better representation.

Good point. Excel then functions as the kind-of dashboard to lots of more powerful code.

Spreadsheet is more convenient way of visualizing a lot of numeric inputs and outputs at the same time.

My own job has some form requirements, one of which is a spreadsheet in Excel. Looks like I just found a way to automate that...

Python also has excellent Excel libraries for reading and writing Excel documents natively. http://www.python-excel.org/

Why not just use VBA?

Well, I have an Excel version of this: [1]

When I order a part, I have to enter all of this data. Most of the parts I order are repeat orders; I have all of my previous ones on file. I have a program right now that makes a LaTeX document for another form I have to fill out; I put in the NSN, and it populates the form with all of the rest of the information.

Up until now, I'd thought that I wouldn't be able to do the same thing with an Excel spreadsheet, and I haven't been able to build a table like that in LaTeX. So, this extension to Python seems to be the best option.

[1] (PDF) http://www.dtic.mil/whs/directives/infomgt/forms/eforms/dd13...

so, you're willing to pay USD $500.00 just for that?

Damn it, I thought it was freeware. That throws a monkey wrench in there...

Look into xlrd3/xlwt3. They're free and platform independent, not as smooth interfacing as DataNitro though.

sincere question - what do you value your time at?

because there's a better, more powerful tool, which is also easier to use

* https://en.wikipedia.org/wiki/Tsort_(Unix)

* http://rosettacode.org/wiki/Topological_sort#Python

* http://rosettacode.org/wiki/Topological_sort#VBScript

All I want is for a good programmable spreadsheet on the Mac. Is that too much to ask?

(This is windows only)

I wonder if there is any spreadsheet like functionality written in Python that could be embedded in an iPython notebook.

Looks great - going to try it out.

Looks great!

Reply on news.ycombinator.com