HTML to EXCEL -> simple question

Question

O have a ,,export to excel" function, I have some tables and it works fine, but I have one single problem.

For moving to the next line I use <br />, but what if I want to switch to the next column? What tag can I use to switch to the next column?

Thanks

Answer 1

If you use commas and make your file a .csv, that would be one way. If you use tabs, then have it read as a tab delimited file. Basically, you need to tell Excel what your delimiter (separator character) is, and it will handle it from there.

Answer 2

Simple HTML tags are supported on a limited basis by Excel. There used to be a list of supported HTML tags as well as some HTML extensions supported by Excel (from Excel 97 onwards), but I can't find it on MSDN anymore. Here's an alternate link:

http://www.code4lifesoftware.com/articles/msexcelreadme.htm

The new XML/HTML format supported from Excel 2000 onwards is a lot more complex, and requires more work:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffxml/html/ofxml2k.asp

Take a look at these links, hopefully you'll find the syntax you're looking for!