?
Solved

Dreamweaver - insert an Excel spreadsheet on the home page

Posted on 2010-08-29
7
Medium Priority
?
641 Views
Last Modified: 2013-11-28
Hi

Is it possible to put an Excel spreadsheet on the home page of a Dreamweaver site
0
Comment
Question by:Murray Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 10

Accepted Solution

by:
Kechka earned 668 total points
ID: 33554203
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
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 668 total points
ID: 33554987
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
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 664 total points
ID: 33555138
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
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

Author Closing Comment

by:Murray Brown
ID: 33556306
Thanks very much. All answers were equally useful
0
 
LVL 5

Expert Comment

by:SaigonJeff
ID: 33556545
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
 

Author Comment

by:Murray Brown
ID: 33557420
Thanks very much for the information
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33563198
;-)
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question