Converting Excel in HTML

Quote: Originally Posted by Louise06 Hi All, I would like to convert some Excel spreadsheets (related to KPIs) into an HTML format. The spreadsheets contain tables, graphs and pivot tables. OS: Windows XP Thanks for your advice. Louise

Excel has HTML export options.

Go to File, Save as, HTML or Export as HTML

This will send all the images and text into folders and set them up as a web page.

Once you are at that point you can edit the web pages as needed, or continue the process of the export manually each time the graphs are updated.

Is this what you needed?

Hi jeffstl

Thanks.

Actually, I need this convertion in a Content Management Systemwhich has an HTML editor.

I have some Excel spreadsheets related to Performance Indicators and I would like them to appear on our future Intranet.

The option "Save as web page" does not sort out the issue.

Thanks for your advice.

Louise

Quote: Originally Posted by Louise06 Hi jeffstl Thanks. Actually, I need this convertion in a Content Management Systemwhich has an HTML editor. I have some Excel spreadsheets related to Performance Indicators and I would like them to appear on our future Intranet. The option "Save as web page" does not sort out the issue. Thanks for your advice. Louise

You are talking about reading the excel data and displaying graphs in a seperate application in real time?

Yes that would be involved probably. Your best bet would be to create a macro in Excel itself to run that would refresh the web content.

thanks.

Do you have the code for the macro?

Thanks
Louise

Hi... Html isn't used for this.... xls format is a format used by excel to open and display the content in that program.

You need to save all the graphs as images... and the data (tables and such) in to (possibly) xml format... then parse that using a server side language... or javascript.

Personally if time is an issue export to a web page and then tweek the generated markup.

Quote: Originally Posted by Personally if time is an issue export to a web page and then tweek the generated markup

I think she wants to be able to read from excel and have the data display on a web page as a graph. That is to say the least amount of manual "action steps" possible to refresh a web directory with updated graph images.

You can do this in excel by setting up a macro to do the export out to the web page directories.

This still requires someone to manually open the .xls file and run the macro to refresh the web page content whenever the data is changed for the graphs.

You are essentially uploading new data to the web page to display by running a macro which then in turn exports the images and\or HTML to a stated directory

Quote: Originally Posted by Louise06 thanks. Do you have the code for the macro? Thanks Louise

This would be a fair amount of specific code related to the web directories and how many sheets there are, where the data cells are (coordinates), etc.

Please post what you have so far and we can work out whats missing.

Quote: Originally Posted by jeffstl This would be a fair amount of specific code related to the web directories and how many sheets there are, where the data cells are (coordinates), etc. Please post what you have so far and we can work out whats missing.

Hi All,

Thanks for your reply.
This task has been put on hold by my organisation.
I will consider all your feedback and get back to you if I have other queries.

Thanks

Louise

you could write a macro from excel to export updated info to html. that would be best if there is a large vol of information.

if there is just a few pages/tables/graphs that only occasionally need to be refreshed, and you just want to share information (not manipulate it) then PRINTSCREEN saved as a jpg will allow you to easily convey the information, if that is all you want to do.