Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have created a joined view (with a Data View Web Part in SharePoint Designer), how can I export it (ideally to Excel)?

share|improve this question
    
Is JavaScript/jQuery a credible option to use for your solution? –  iOnline247 May 2 '12 at 18:46
    
Well, tell me more! I need this to work in IE 8, so no html5 allowed. And we are talking about hundreds of list items. –  Christophe May 2 '12 at 18:52
add comment

3 Answers

There isn't way for that to directly export to Excel. However, as iOnline247 mentioned, you can use jQuery to convert the HTML table on the page to CSV. Then you can save that and open it with Excel: http://www.kunalbabre.com/projects/table2CSV.php

share|improve this answer
    
I've used that library many times, works well. –  PirateEric May 2 '12 at 19:34
    
Interesting... Does this work when the table contains other tables (which would obviously be the case with joined views)? Also, it doesn't address the save step. –  Christophe May 2 '12 at 19:49
add comment

John Chapman is spot on with deciphering my comment. With a php solution, you'd have to have those bits on the server for it to work. I'm more familiar with datatables and the export options that exist with this library.

Datatables TableTools

If I remember correctly, we've done some very funky reporting --> export using this library. I'll ping Mark Rackley and get a definitive answer on the nested table question.

share|improve this answer
    
thx Matt. It seems that the TableTools rely on Flash, like what I have on my user toolkit. Same concern, does it work with multiple layers of tables, not just a datagrid? –  Christophe May 3 '12 at 6:43
    
Mark will have a definitive answer. He'll be able to set this straight. It's been a while since I've worked with the codebase on that project. I thought we did though. –  iOnline247 May 3 '12 at 12:51
add comment

What I did was to:

  1. Create and Web Query in Excel (How to create a Web Query in Excel),
  2. save the query (*.iqy),
  3. uploaded the web query file to the site
  4. and just added "Export to Excel" linked to the query file.
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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