Highlighted

Link Excel spreadsheet to web page

New Here ,
Nov 27, 2017

Copy link to clipboard

Copied

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

Adobe Community Professional
Correct answer by B i r n o u | Adobe Community Professional

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

TOPICS
Learn Dreamweaver

Views

566

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Link Excel spreadsheet to web page

New Here ,
Nov 27, 2017

Copy link to clipboard

Copied

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

Adobe Community Professional
Correct answer by B i r n o u | Adobe Community Professional

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

TOPICS
Learn Dreamweaver

Views

567

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Nov 27, 2017 0
Adobe Employee ,
Nov 27, 2017

Copy link to clipboard

Copied

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 27, 2017 1
Adobe Community Professional ,
Nov 27, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 27, 2017 1
New Here ,
Nov 27, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 27, 2017 0
Adobe Community Professional ,
Nov 27, 2017

Copy link to clipboard

Copied

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 27, 2017 1