Forum Moderators: open

Message Too Old, No Replies

Dreamweaver and Xcel Spreadsheets

Pasting an Excel spreadsheet into HTML

         

cdell100

12:47 am on Nov 20, 2003 (gmt 0)

10+ Year Member



I have a client who uses frontpage and apparently can simply cut and paste word docs and excel spreadsheets drectly into an html document. I use dreamweaver and am curious whether there is a way to do this in program.

Thanks in advance.

Reflection

12:59 am on Nov 20, 2003 (gmt 0)

10+ Year Member



I would be careful doing this as a word doc uses charecters that arent, for lack of a better term, 'web safe'. For instance quotation marks can cause problems. You need to convert the document to plain text before copy and pasting. Not sure about excel, will have to try and experiment :).

I dont use dreamweaver or frontpage but Im sure someone else will be able to help you out.

skipfactor

1:00 am on Nov 20, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



There's a "File", "Import", "Word HTML" on DW MX, never used it though. In Excel, you can "File", "Save as Web Page" with varying degrees of success.

henry0

1:58 am on Nov 20, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



beware
Yes you can save as an HTML doc
then upload the result

Good luck if you ever are concerned with file size
or need any editing!
out of curiosity save a simple 1 sheet XL doc as HTML
then look at the code.

regards

Henry

HocusPocus

2:11 am on Nov 20, 2003 (gmt 0)

10+ Year Member



A neat feature with dreamweaver is it's ability to import comma and text delimited data.

You could save the excel doc as a .csv or txt and import into dreamweaver using File-> Import, dreamweaver does a good job of formating the data into row and columns.

wickydoodah

2:48 am on Nov 20, 2003 (gmt 0)

10+ Year Member



FrontPage also has an 'import' command that will pull Word and Excel files into an HTML page. And it's MUCH leaner on code than doing the 'save as web page' thing from within Word or Excel. Importing these files into an FP HTML page (instead of doing 'save as') will not give you all that bloated proprietary code. Just nice clean text (Word) and tables (Excel).

When using FP, use the 'import' command for these files... and never the horrible 'save as web page' command.