How to keep format within HTML converted to Excel

Question

Hello,

I'm working with an HTML table, that contains numbers (formated) and when I export this to xls file (just change extension... hehe) I loss some of the formated data.

Example:

in html I have " 1,000.00 | 500.00 | 20.00 " and in excel it shows like: "1,000.00 | 500 | 20"

I want it to know if it is possible to show the very same format as in html.

THankyou :P

Answer 1

I've done this. The best way to tell is to create an .xls file (not .xlsx) and then save it as an html file.

Then look at the source of the html file. You'll see some css classes at the top and then if you look at the data below you'll see them being applied to the sheet.

So just a bit of reverse engineering...

FYI - if you try to open this up in 2007 or later, you'll get an initial warning but then all works OK.

Answer 2

You can open Excel and import it as data where it will ask you for your delimiter, and the data type of each column. You can also just manually choose the columns and add formatting.