将Excel HTML转换为更干净的HTML(Convert Excel HTML to cleaner HTML)

将Excel HTML转换为更干净的HTML(Convert Excel HTML to cleaner HTML)

有没有一种简单的方法可以将Excel 2003的“保存到HTML”选项的输出转换为更“友好”的选项？ 我有一个包含大约20列和50行的Excel文档。

在整个保存的HTML文件中，我有过时的HTML（例如： <table x:str border=0 cellpadding=0 cellspacing=0 width=1366 style='border-collapse: collapse;table-layout:fixed;width:1025pt'> ） ，线条样式，以及遍布整个地方的空单元格。

我想要更少的'table-y'。 有没有办法强制Excel 2003使用更多的CSS和更少的表来保存它，或者比通过手工浏览HTML文件更容易将表转换为div ？

Is there an easy way to convert the output of Excel 2003's Save to HTML option to something more 'friendly'? I have an Excel document with about 20 columns and 50 rows.

Throughout the saved HTML file I have obsolete HTML (example: <table x:str border=0 cellpadding=0 cellspacing=0 width=1366 style='border-collapse: collapse;table-layout:fixed;width:1025pt'>), in line styles, and empty cells all over the place.

I'd like something less 'table-y'. Is there a way to either force Excel 2003 to save it using more CSS and less tables or a way to convert tables to divs more easily than going through the HTML file by hand?

最满意答案

如果你有Dreamweaver，你可以使用它的标记清理工具......我相信这是为这种事情而设计的。

在Dreamweaver中创建新的HTML文档，复制并粘贴代码并使用清理工具。

这是我找到的一个指南，但如果它没有帮助你可能会找到更好的指南：

http://www.articleonlinedirectory.com/656381/cleaning-up-unwanted-formatting-dreamweaver.html

祝你好运。

If you have Dreamweaver, you can use its markup cleaner tool...which I believe is designed for this kind of thing.

Create a new HTML document in Dreamweaver, copy and paste your code in and use the cleanup tool.

Here's one guide I find, but you could probably find better if it doesn't help:

http://www.articleonlinedirectory.com/656381/cleaning-up-unwanted-formatting-dreamweaver.html

Good luck.