Posting charts, sheets from Excel
-
How do I post charts or sheets from Excel? When I copy and paste a table from an Excel sheet, it doesn’t appear right. In blogspot, it was straight-forward. Can anyone help please?
-
What is the file type? Currently you can upload the following: jpg, jpeg, png, gif, pdf, doc, ppt, odt.
You may need to convert them http://www.granneman.com/webdev/coding/convertexceltotables/
-
Is this helpful? http://www.granneman.com/webdev/coding/convertexceltotables/
Convert Excel to Web Tables
You’ve got an Excel spreadsheet, and you want it to become a table in a Web page. How do you do it?
Whatever you do, do NOT export from Excel to HTML – the ‘HTML’ it produces is a godawful mess. In fact, it only works with Internet Explorer on Windows. There’s no technological reason for this; during the antitrust trial, Microsoft executives testified that they made this decision in order to further force people to use IE instead of alternative browsers.
There’s a much better way to do this.
1. Save the Excel file as a CSV (comma-delimited) file (or tab-delimited – whatever floats your boat). Excel will complain that you’re going to lose formatting. Go ahead and let it know that you are a human with a brain, and yes, you really want to do this.
2. Open Dreamweaver & go to the File menu > Import > Import Tabular Data.
3. Follow the instructions in the dialog box. Hit OK.
You’re done. Your Excel spreadsheet is now a table on a Web page. And, best of all, your HTML is not a godawful, proprietary mess.Alternatively you could make them into images. This may be helpful https://en.forums.wordpress.com/topic.php?id=801&page&replies=6#post-4403
- The topic ‘Posting charts, sheets from Excel’ is closed to new replies.