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
-Microsoft 2008 (mac)
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.
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!
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.
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.
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.