Excel macros can retrieve data from websites, although built-in support is primitive (HTML or XML). So you'd use web2py as a webservice basically (as documented in the book). This is the quickest and dirtiest way, I think. Stackoverflow has example of fetching json via VBA.
Then your spreadsheet would draw its charts based on this raw data which is saved to a data tab. I do this a fair bit, although to be honest mainly with SQL sent to server. You can also generate spreadsheets in python, although for spreadsheet where you want to encourage manipulation and charting I think it's better just to import data via a macro (see above). There are also web-clients ways to draw charts (I wrote a plugin for google charts, on web2pyslices), but these may be too static. There are javascript libraries for data manipulation and charting (d3.js). Depends on how long you want to spend learning new things. If you're going to be doing this a bit, a javascript client approach seems much better. On Thursday, November 28, 2013 8:32:12 PM UTC+11, Ykä Marjanen wrote: > > I don't think you can use a web based application without a server. > However, the local server is already there without additional installation, > so if you want an application that has a browser interface, then you don't > need to do any extra. > > You can use the webpy current architecture directly and just generate the > excel file in a controller and pass it to view (or generate it in the > view). I think you can even view/edit the xls file in the browser with a > browser plugin, or then let it automatically open the results in excel. > > I think you can use DAL in your local script without server and do the > controller-part also in normal Python functions, but then you wouldn't have > browser UI or web support. > > Ykä > > On Wednesday, November 27, 2013 6:22:25 PM UTC+2, Py Dev wrote: >> >> Hi, >> >> the combination web2py-DAL with python code (controller) and Excel to >> manipulate and chart table data would be wonderful. >> >> That would mean rapid prototyping with a lot of databases and the option >> to go to web later. >> >> So, is it possible to use „only“ the model and controller level from >> web2py and use Mircosoft Excel as view with for example pyxll or datanitro? >> >> (see http://www.pyxll.com and https://datanitro.com ) >> >> Is it possible to use web2py-DAL locally without a webserver? >> >> Would it be possible to use a debugger with this combination? >> >> Cheers! >> >> pd >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
