Export to Excel using SharePointPlus

[Spin35]

Hello ALex, I’m trying to use the export to CSV option in SPJS Charts. I’ve added the link to SharePointPlus.js in the master CEWP. The Export to Excel List has been created, the Export Label appears below the chart (a table in this case), but nothing happens when you click it.
Just wondering if I’ve missed something or need to configure something else to make it work. I wasn’t sure which version of SharePointPlus to use – I’ve got V3.14 which is from around the time you first released the CSV export feature.

• This topic was modified 4 years, 5 months ago by Spin35.

[Alexander Bautz]

Hi,
This was a solution I made for an older version of SPJS Charts 7 years ago and I don’t have that solution set up any longer so I cannot test it.

You find a “Copy to clipboard (CSV)” in version 6 and 7 – in the Options tab. This will let you paste it directly to Excel.

Alexander

[Spin35]

Hello ALex,
Thank you for getting back to me.
I need to get advice before moving up to V6/7.
I’ll fiddle with the script and versions to see if I can get it going.
Thanks for your work.

[Spin35]

Hello Alex, Success – It just needed some small changes in the Convert to CSV function to fix the call to $SP CreateFile.

[Alexander Bautz]

I’m glad you figured it out.

Alexander

[Author]

Posts