Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • Last Modified:

Dreamweaver - insert an Excel spreadsheet on the home page

Hi

Is it possible to put an Excel spreadsheet on the home page of a Dreamweaver site
0
Murray Brown
Asked:
Murray Brown
3 Solutions
 
KechkaCommented:
You can only import data from Excell. Take a look at:
http://www.ipowerweb.com/iboost/build/software/dw/delimited/10005.htm
I hope that is what you need.
0
 
Jeffrey CoachmanMIS LiasonCommented:
1. In Excel you can select the "Save as WebPage" option and insert the resulting html file.
This will be a "Static" page.

2. You can also select the "Save as WebPage" option and check ON the box for "Add interactivity"
However, there are catches with doing this:
a. The spreadsheet will only be viewable in IE (Not Firefox, or other popular browsers)
b. You may get an "Active-X" popup warning"
c. The changes made on the site will not be saved.  You will have to click the "Export To Microsoft Excel" Icon/button to save a local copy.

;-)

JeffCoachman
0
 
Jason C. LevineNo oneCommented:
You can also just copy the data in Excel and do "paste special" into DW.  Any option except the first in the resulting menu will create a table.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much. All answers were equally useful
0
 
SaigonJeffCommented:
Just FYI

You might also want to try using PHP and the Excel reader library which will not only allow you to display the worksheet but also will allow you to convert data into SQL statements which you can use to insert new data.

There is a good Article/Tut on this here;
http://amiworks.co.in/talk/readingparsing-excel-spreadsheet-using-php/

You can get the Spreadshet Excel Reader library from Sourceforge;
http://sourceforge.net/projects/phpexcelreader/files/Spreadsheet_Excel_Reader/

Good luck...
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much for the information
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now