I readily and often admit that I’m a SharePoint novice.
OK, that’s out of the way, so to the point: Is there any built-in way to export from a SharePoint 2013 app, hosted in Office 365, into Excel? By “built-in” I mean without using .NET coding.
I have an app – a proof of concept – that I’ve built using Access 2013. It’s all of 5 little tables, and then it runs as a SharePoint app from Office365. I can’t for the life of me find how one could export the data to Excel. OK, I have found some posts that talk about .NET coding …and then call that. But I’d think with Jquery, html5, etc, there ought to be a way.
I’m certainly not giving up yet, but if anyone has any ideas / pointers as to where to look to figure this out, please do let me know!
Hello,
Your question is a little bit confusing. If I correctly understand, your data is stored in Access 2013? So, I think, you need to write code to read Access table not SharePoint list?
If talk about programming languages – there may be a trick to use data-url’s to create file with java script, but you could come int trouble with lager files, as data-url are somehow limited in length. Also you could have troubles/lots of coding to manage xlsx files, but you should be able to achieve some results creating excel-xml files or simple comma separated files.
One more way would be to use silverlight – that could help to avoid server side coding but not .NET …
