Skip navigation
Currently Being Moderated

Import Excel file into Dreamweaver CS5

Apr 23, 2012 5:19 PM

Tags: #dreamweaver_cs5 #excel

I am trying to import an excel document into dreamweaver.

 

If i drag and drop form the files panel on the left it gives a highlighted text like a link. I do not want a link, I want to insert the data within the page and keep its tabular data. I do not see any excel option in the file>import menu.

 

The excel file is a simple table of lists of companies, in a dictionary type fashion. I just want to get the data into a div tag and make the content scrollable (if i saved the excel file into a pdf it is about 9 pages long).

 

ANY help with this is greatly appreciated

 

Using:

 

-Mac

 

-Dreamweaver CS5

 

-Microsoft 2008 (mac)

 
Replies
  • Currently Being Moderated
    Apr 23, 2012 6:51 PM   in reply to jacob.gonzales

    The import facility of Excel or Word Document is only on a PC system of Dreamweaver.

     

    File >> Import >> Excel Document

    File >> Import >> Word Document

     

    For mac system I understand this facility isn't there.  What can you do about this?

     

    1) Get hold of a PC and download a trial version of DW and import the file(s) and you are done;

    2) Ask a friend to do it for you;

    3) Post your excel file online and some nice guy like Nancy, john or Murray will help you out.

     

    Good luck and let us know if this has given you some more ideas to explore.

     

    Good Guy

    Website: http://mytaxsite.co.uk

    Website: http://html-css.co.uk

    Forums: http://mytaxsite.boardhost.com

    Email: http://mytaxsite.co.uk/contact-us

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 23, 2012 10:36 PM   in reply to jacob.gonzales

    You could definitely import from Excel into DW CS5, retaining all editing functionalities for your cells even on a Mac.

     

    Save your file from Excel not as .xlsx or .xls, but as .csv

     

    Open DW, File > Import > Tabular Data > Choose your CSV file, Delimiter as Comma, Table width - you could choose to customize if you want or DW will by default fit the rows/ cells to the data length, choose other styling such as Padding, Spacing, Border, etc.. Hit OK. You're done!

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 24, 2012 10:46 PM   in reply to jacob.gonzales

    What you could do for Word files is to copy the content of your Word document and hit Cmd + Shift + V (Paste Special) to retain all your Word doc's formatting into DW.

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 25, 2012 10:26 PM   in reply to jacob.gonzales

    Can you post a screenshot of how it looks like after importing?

     

    Also, send us your CSS and HTML. I'll see how I can help.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 26, 2012 10:18 PM   in reply to jacob.gonzales

    The code says the table should be 600%.

     

    I think it should read 600px.

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 27, 2012 12:52 AM   in reply to jacob.gonzales

    Can you change line 106 of your product_page.html to say:

     

    <table width="600px" border="1">

    This should set it to 600px. And what is the width you've specified in your CSS file for product_linecard?

     

    After setting to 600px, if your columns get chopped, set width for each of your <td> to 150px if you have 4 columns. 120 if you have 5 and so on.. This should give equal column widths for all columns.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points