Skip to main content
shelleygroup
Participant
November 27, 2017
Answered

Link Excel spreadsheet to web page

  • November 27, 2017
  • 3 replies
  • 1089 views

I am trying to link an excel spreadsheet (magazine index) to a web page so that users just see the link and not the whole spreadsheet until they click on it. They need to be able to sort and filter the information and crucially the spreadsheet needs to be accessible to an on site search engine Freefind. I have tried copying the spreadsheet (xlsx format) to our website and then creating a link from the appropriate web page and this seems to display well but  the spreadsheet doesn't feature in the search engine or in SEO tool Screaming Frog. The search engine says that the page header is Content-Type: text/plain. On advice I have tried to correct this in the .htaccess file on the website using -AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet - but this just seems to corrupt the whole website.

I have read about Excel on line but I don't want to display the spreadsheet on the web page because the sheet is too wide to fit without scrolling and linking to a separate page is neater.  May be I am looking for too simple a solution but I have reached the limit of my limited knowledge and would appreciate help from anyone who can assist me. Thanks

PS Many users access the website from an Ipad

I am using Dreamweaver CS6 on Windows 10 Creative Fall Edition

This topic has been closed for replies.
Correct answer B i r n o u

if you talk about XLSX you first should add the appropriate type mime (you've adedd one that seems truncated)

so
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx

then will it be possible to have the page on line including the link to see what's going on...  here is an exemple...

Test Link XLS – Puce et Média

3 replies

BenPleysier
Community Expert
Community Expert
November 27, 2017
Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!
B i r n o u
B i r n o uCorrect answer
Legend
November 27, 2017

if you talk about XLSX you first should add the appropriate type mime (you've adedd one that seems truncated)

so
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx

then will it be possible to have the page on line including the link to see what's going on...  here is an exemple...

Test Link XLS – Puce et Média

shelleygroup
Participant
November 27, 2017

Thanks for your very speedy reply. This has solved my problem perfectly. I thought the original script looked odd but I used it as given.

Brilliant !!  Thanks again

Community Manager
November 27, 2017