5

Trying to build a 'generate report' link with various options. I would have three links, each with different list filtration criteria. The idea is then that whilst people are on that page, they can click any of the three links, a report will be generated based on the criteria given, and an excel spreadsheet download will pop up on their PC.

So basically near instant excel exports based on specific criteria, which download when a link within a page is clicked.

Any pointers? Thanks.

  • Is this for SharePoint? -There's an Export to Excel button in the tab bar on each List View. – Paul Leigh Nov 29 '13 at 9:39
  • @PaulLeigh I know; and that's exactly what I need - except ideally I'd like to have three links which are pre-defined to do this with different filters. – Henry Cole Nov 29 '13 at 9:47
5

You can use the Excel URL Protocol described here: http://msdn.microsoft.com/en-us/library/ms478653.aspx

With it you can create your three links and generate the excels on the fly, example:

 http://Server_Name/[sites/][Site_Name/]_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=GUID&View=GUID&CacheControl=1
  • 1
    this helped a huge amount, thanks. I've now got it set up and working exactly as I want, however I'm hitting one problem in particular. Whilst this works perfectly in Internet Explorer, if I try it in Chrome or Safari I get the following error: dropbox.com/s/nj99eu2ki1isg5b/… – Henry Cole Nov 29 '13 at 11:53
  • 1
    ^ Obviously it's not a colossal issue as I can persuade staff to use IE for this site, but it'd be easier if all could use on anything. – Henry Cole Nov 29 '13 at 11:54
  • 1
    The office integration with other browser do not work very often - least effort is to use IE. – Max Melcher Nov 29 '13 at 12:15
  • 1
    Yeah, I'll stick a note on the site to let people know they'll need IE for that feature. Thanks very much for your help. – Henry Cole Nov 29 '13 at 13:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.