Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I show an embedded excel file in a WebPage?

I want to allow an Excel report to be viewed embedded in a WebPage... is there a way?

  • I don't want to use an ActiveX, or OWC (Office Web Components), I just want to open an existing file from the internet explorer application.

  • I don't want users to download and then open it.

Using an iframe wouldn't be a problem, but my preliminary tests weren't successful

Any ideas? Is it at all possible?

like image 962
juan Avatar asked Oct 03 '08 18:10

juan


3 Answers

This has to do with the local person's browser set up and not really anything you can do on your end. If they click a link with the .xls(x) extension, the browser determines if it wants to open it itself or in a new window.

Here 2 microsoft pages on how to change these settings:

http://support.microsoft.com/.../how-to-configure-internet-explorer-to-open-office-documents-in-the-app

http://support.microsoft.com/.../embed-your-excel-workbook-on-your-web-page-or-blog-from-sharepoint-or-onedrive-for-business

like image 90
AaronS Avatar answered Oct 13 '22 21:10

AaronS


You should try using the Excel Web App Embed feature that lets you embed tables and charts from Excel directly on your Web Page. You can even let users interact with the spreadsheet so that they can sort and filter data and use your spreadsheets formulas to calculate make their own calculations all without altering the source.

The Excel Web App and storage is all free from Microsoft. Any data you embed on your Web page can be viewed by all the major destkop and mobile browsers and when you update your spreadsheet the data on your web pages is automatically updated as well.

like image 7
WebAppsGuy Avatar answered Oct 13 '22 21:10

WebAppsGuy


I think your best bet is going to be extracting the data out of the Excel file and displaying it in a regular HTML table. Excel isn't exactly safe to invoke from a web page and not everyone has it anyway.

like image 2
Neall Avatar answered Oct 13 '22 20:10

Neall