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

  • I ended up following this tutorial to create something for my Data view. ameyakawale.wordpress.com/2011/08/04/… – Ramana Viswanadha Apr 8 '16 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? – Fred A Apr 11 '16 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. – Ramana Viswanadha Apr 11 '16 at 13:16
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

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.