Solved

Dreamweaver - insert an Excel spreadsheet on the home page

Posted on 2010-08-29
7
634 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:murbro
7 Comments
 
LVL 10

Accepted Solution

by:
Kechka earned 167 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 167 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 166 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Closing Comment

by:murbro
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:murbro
ID: 33557420
Thanks very much for the information
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33563198
;-)
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

808 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