Hi everyone! I have a question. I have seen some sites, both internet and intranet sites, that looks like it runs excel (ie pivot tables) and then data is pulled "on the fly" from a database. I am not too familiar with the correct terminology, but i was wondering if someone can help explain to me what it's called and how it's done Greatly appreciated! Thanks.
Can you provide any examples of such sites? I would investigate them, 'cause I'm interested too. The best I could think of for now is Zoho Viewer (viewer.zoho.com, see sample documents), but I'm not sure about data and database sync.
It's just the "look and feel" of a spreadsheet. In the faq, it is clearly stated that when you want to get the data, you will get it in csv or html format, so, it's basically text based like any other database. Just the skin is spreadsheet. and, of course with lots of lots of lots of ajax.