Adobe Community: Import Excel file into Dreamweaver CS5

Currently Being Moderated

1. mytaxsite.co.uk,

Apr 23, 2012 6:51 PM in reply to jacob.gonzales

Report

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:

3,731 posts
Oct 15, 2010

Currently Being Moderated

2. Sudarshan Thiagarajan,

Apr 23, 2012 10:36 PM in reply to jacob.gonzales

Report

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:

Currently Being Moderated

3. jacob.gonzales,

Apr 24, 2012 9:59 PM in reply to Sudarshan Thiagarajan

Report

This sounds more like a solution. I have worked with .csv files when importing data form spreedsheets into outlook. I am going to try this asap!!

THANKS

|

Mark as:

Currently Being Moderated

4. jacob.gonzales,

Apr 24, 2012 10:01 PM in reply to mytaxsite.co.uk

Report

As for the import command for excel/word files not being on a mac.. that is completely ridiculous. Adobe needs to get it together on that. I did spend my money on the last 3 versions of DM just so the mac edition doesn't have a seemingly essential tool that the Win verison does. Pretty Stupid.

|

Mark as:

3,731 posts
Oct 15, 2010

Currently Being Moderated

5. Sudarshan Thiagarajan,

Apr 24, 2012 10:46 PM in reply to jacob.gonzales

Report

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:

Currently Being Moderated

6. jacob.gonzales,

Apr 25, 2012 7:46 PM in reply to jacob.gonzales

Report

Thanks man... i really appreciate it

|

Mark as:

Currently Being Moderated

7. jacob.gonzales,

Apr 25, 2012 9:06 PM in reply to Sudarshan Thiagarajan

Report

HMMMMM

Well the table imported just fine. But it doesn't fit into the div tag that i have alloted for the table. In the importing options i change the table width to the appropiate size. But it ignores the change. I cannot save any formatting changes in the .csv file since it it stricly data orientated.

I am not sure why the dreamweaver import tool will not oexecute the changes set in the import tool.

Any help?

|

Mark as:

3,731 posts
Oct 15, 2010

Currently Being Moderated

8. Sudarshan Thiagarajan,

Apr 25, 2012 10:26 PM in reply to jacob.gonzales

Report

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

9. jacob.gonzales,

Apr 26, 2012 9:58 PM in reply to Sudarshan Thiagarajan

Report

I put the settings in. But they are ignored. I just want the sizing to fit in my div tag, which is at 600 px wide. As you can see, the table runs off the page to about 900 px.

Thanks again very much

|

Mark as:

Currently Being Moderated

10. John Waller,

Apr 26, 2012 10:18 PM in reply to jacob.gonzales

Report

The code says the table should be 600%.

I think it should read 600px.

|

Mark as:

Currently Being Moderated

11. jacob.gonzales,

Apr 26, 2012 10:45 PM in reply to John Waller

Report

hmmm the setup panel too... ive done this several times at 600px adn get the same result. i'll try again

|

Mark as:

Currently Being Moderated

12. jacob.gonzales,

Apr 26, 2012 10:59 PM in reply to jacob.gonzales

Report

when setting up 600 pixles in the setup panel, the code simply says 600. Its does cut the tabular data to that size, but it "cuts" in the manner that several columns are missing. Not sure if there are any options to format the table once it is in. the .csv file does not hold any formatting data.

|

Mark as:

3,731 posts
Oct 15, 2010

Currently Being Moderated

13. Sudarshan Thiagarajan,

Apr 27, 2012 12:52 AM in reply to jacob.gonzales

Report

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:

Dreamweaver

Import Excel file into Dreamweaver CS5

Apr 23, 2012 5:19 PM

More Like This

Bookmarked By (0)

Answers + Points = Status