Pull data from excel spreadsheet

  • 1
  • Question
  • Updated 3 years ago
  • Answered
is it possible to pull data from an excel spreadsheet from our intranet?
Photo of Gartree High

Gartree High

  • 806 Points 500 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Shea

Shea, Official Rep

  • 5,188 Points 5k badge 2x thumb
Hi Gartree, 

I'm unaware of anyway to do this, but another Community member may have done something similar. 

Just out of curiosity, could you use a Google Spreadsheet for this? Or does the spreadsheet contain data that can't be public?

Thanks,
Shea
Photo of Gartree High

Gartree High

  • 806 Points 500 badge 2x thumb
Unfortunately i cant use google spreadhseets as it needs to be private if not i would use it like i do for other spreadsheets. 

Thanks
Photo of HSuarez

HSuarez

  • 11,896 Points 10k badge 2x thumb
Hi,

Are you looking at pulling data from Excel or embed Excel? Haven't looked into this myself but maybe others have.  However...

I came across this entry from Microsoft on embedding an Excel workbook but this requires working with OneDrive https://support.office.com/en-ca/article/Share-it-Embed-an-Excel-workbook-on-your-web-page-or-blog-f...

I also came across this YouTube video https://www.youtube.com/watch?v=7EXZ969x5iY which shows how to public Excel workbooks as interactive webpages.  In this video, the person is publishing locally from an Excel workbook to a .htm.

Thanks
Hannah
Photo of Shea

Shea, Official Rep

  • 5,188 Points 5k badge 2x thumb
Just to add to Hannah's suggestions I found this http://shancarter.github.io/mr-data-converter/ which will convert a CSV to HTML. You might be able to do that and embed it with the HTML widget.