spreadsheet directly into web design
I purchased a template site through www.9dx.com and need some assistance setting up tables in my pages. This site has a content management system for general web design but I do not understand how to add a table. I have for instance a profit and loss statement that I need to post for investors. It comes from excel and is a pretty large chart. Could someone direct me to a resource to understand how to add a spreadsheet directly into a web page?
webwiz posted this at 20:29 — 14th July 2008.
He has: 629 posts
Joined: May 2007
Not knowing any content management systems (CMS) beyond Wordpress and Textpattern, I am guessing you will need to convert the spreadsheet to an HTML table, and enter that into the CMS's "Publish" page.
My suggestion is to use the "Export as HTML" capability of Excel, then definitely clean out all the cruft by submitting the result to HTML Tidy before adding it for publication.
Sadly, I am unable to view the 9dx.com site for more information, as it uses 100% Flash, which is blocked here.
Cordially, David
--
delete from internet where user_agent="MSIE" and version < 8;
JeevesBond posted this at 23:36 — 14th July 2008.
He has: 3,956 posts
Joined: Jun 2002
Hi, welcome to TWF!
You could use the Export to HTML and HTML Tidy, as webwiz pointed out, but this might cause a mess. Excel really doesn't at creating Web pages.
Is there an 'Import from CSV' (or any other kind of import) option? Secondly, it's a bit hard to advise on a system we've never used, so have you asked the people that run the content management system for you? They might be able to help.
If you get stuck, it might be best to just export the figures as PDF. This has the bonus of preserving your formatting, and works on all platforms. It's not great for Web pages (too bulky, slow to download, needs an external reader), but for documents it works well.
Good luck.
a Padded Cell our articles site!
Megan posted this at 12:56 — 15th July 2008.
She has: 11,421 posts
Joined: Jun 1999
If it's a very large chart a PDF might be the way to go anyway. That way you can make sure it will print properly as well. (rather than trying to figure out print stylesheets for a web page).
Megan
Connect with us on Facebook!
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.