Let’s face it - even though Tulip can do basically anything, sometimes you and/or your business are using excel for things. Wouldn’t it be nice if you could just get those charts from excel up onto your Tulip dashboards?
Well guess what - you definitely can!
The authorization process is the only ‘hard’ part to figure out (I’m not very good with those things - but luckily people on our team can help you if you have trouble!). Once you get that going you are ready to start playing around and having fun! Tulip as a front end to Excel… who would have thought?
I’m sure we could do all sorts of things to pull in and edit the data from Excel but at that point you might as well just be using Tulip tables and some slick Apps (admittedly, I am biased… but I work here because I love this platform, not the other way around).
5 Likes
Is this using the Tulip API to write to a tulip table? Need more details of your teaser
Nope! This is using microsoft’s graph api to snag an image of a chart (in base 64 format). Then we display that image in Tulip as an imageurl variable type.
Here is the get chart image API documentation
1 Like
hahah ok that is a big cheat! Love it! I can embed whole webpages as images that way…
1 Like
Hi,
you still can connect TULIP with excel by using TULIP API.
For this you need PowerQuery. You start by adding TULIP API as source. Then, use query to map the data.
1 Like
Is there any plan in the nearest future to provide a feature to export a table displayed in an app directly to excel (by assigning a trigger to a button)? I know there is a feature to export the entire table rows to csv from the table section, but I wouldn’t like the business user of the App to go into the table section.
2 Likes
Did you ever find a solution for this?
We also get these type of questions fairly often.
We get the export from an interactive table, but customers also want to work the other way around. Read out the CSV => write in SQL and show in Tulip.