Link Excel spreadsheet to web page

[shelleygroup]

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

[Kratika Agarwal]

Hi,

Did you try steps mentioned in below document

How to link files, documents, or specific elements within or across your web pages in Dreamweaver.

Thanks

[B i r n o u · Accepted solution]

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]

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

[BenPleysier]

Could this be a solution How to embed a live Google Docs spreadsheet into a webpage | BDNYC?