0

I have a data view list made using a linked data source of several SP lists. I tried to make it so that the data view list can be exported out as Excel, just like SP list. Is this possible?

I tried to follow the solution in here - Export a joined view but somehow it didn't work for me. Any other Javascript plugin that i can use to make this work? Or is there any way i can enable export function on data view using Sharepoint designer?

Thanks

Improve this question
3
  • I ended up following this tutorial to create something for my Data view. ameyakawale.wordpress.com/2011/08/04/… Commented Apr 8, 2016 at 13:31
  • @RamanaViswanadha thanks. I did followed that too, but didn't work with me. Not sure if i got the table ID right. Which one is the table ID that the code refers too? Is it the web part ID? Commented Apr 11, 2016 at 4:18
  • There should be an attribute called just "id" on the html tag of your table. But what I ended up doing was exporting my webpart, and then edited the exported file in notepad to add an Id attribute that i can use. After which i uploaded it back onto sharepoint. Commented Apr 11, 2016 at 13:16

1 Answer 1

Reset to default
0

xlsx.js is a nice plugin for JavaScript to Excel. xlsx export demo

allows you to make custom Excel files from custom data.

Source files and documentation: https://github.com/SheetJS/js-xlsx

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.