Best way of getting interactive/tabular data into wordpress?

[Messiah Khan]

What is the best (read easiest) way of getting interactive and/or tabular data onto a website/blog? I've got a load of data in excel that I want to include in a Wordpress blog entry. Some if it is plain tabular data, so what is the best way of including this in wordpress, while retaining formatting etc, and still being able to control the style sheets etc of the table? But also, what is the best way of using similar tabular data to make an interactive website/blog entry?

It basically is loads of numerical data that I want to use in combination with a range of formulas an expressions to output other numerical data. So if a user selected something from a dropdown box (which values are included in the excel sheet), it would highlight a row in a table. Is there an easy-ish way of doing this or something similar?

 

[Russinating]

In my usual bodge-job way of doing things, this is how I would get Excel data onto a website in a table:

1. Copy and paste all the Excel data into Notepad++, including 2 extra blank columns to the right of the your data
2. You'll notice there's 2 tabs at the end of each line. Highlight the end of one line, ctrl+H (replace) and replace it with "</td></tr>"
3. Do the same, but highlight a single tab (in between each column) and replace it with "</td><td>"
4. Edit -> Column Editor -> Insert "<tr><td>"

Then just stick the normal <table> tags at the top and bottom and you're good. As for the drop down box, not sure. For something like that you'd probably need the data to be in a database, so you may as well just import the excel via a SQL and output it straight from the database. Someone else may have some other ideas.

 

[Messiah Khan]

Thanks for the suggestion, but I'm not sure that is quite what I need, due to the formulas in the table etc. Any other ideas? I have a feeling I'm going to need to teach myself SQL/PHP.