Trouble handling html table in Excel

Hi,

I have some code that creates a html table on the fly. Ideally I would like to export this table from my webpage as an excel spreadsheet. I have tried saving the table from IE as a html file and then opening that file in Excel. It displays perfectly but no matter what I seem to do (including converting the cells to number format) I can not do maths operations on the cells i.e. I can't add a list of my cells together. Am I going about it the wrong way? Perhaps there's a bit of javascript that will export the table to something excel friendly or maybe there is a way to the math operations on html tables in excel?????

You can see one of the tables here.

What is the easiest way to get this table into excel and add the number column?

Please help with any suggestions. Thanks as always,

SD

Ok the answer seems to be this - save your webpage as a single html page. then open excel then go to Data>Import External data>Import data then browse to your saved html file and click on the table you want to import. the table is imported perfectly and you are then able to do maths operations on the numbers.

So happy i found the solution i thought i'd be nice and share it.

hope its useful for you!