Main Area and Open Discussion > General Software Discussion

Converting Spreadsheet to Table in forum

<< < (2/9) > >>

app103:
if you replace every "," with this:


--- ---[/td][td]
and then manually edited and ended every line, except the last, with this:


--- ---[/td][/tr][tr][td]
added this before first line:


--- ---[tr][td]
and this after last line:


--- ---[/tr][/td]
and inserted the whole thing between this:


--- ---[table]
[/table]
It might work...but that's still a lot of manual editing.  :(

Hirudin:
I don't know how off hand, but I'm pretty sure AHK will read and write lines from a file. You could easily read a line, add the necessary characters to the beginning and end, do any find and replacing you need, and write the line back and go to the next.

This sounds like something I'd be capable of (with my very limited programming skillz) so I'm sure a lot of y'all would be too. I'm heading off for the weekend, but if someone hasn't made anything by the time I get back I'll take a stab at it.

kimmchii:
can try save as html in Excel.

app103:
can try save as html in Excel.
-kimmchii (May 12, 2007, 06:52 PM)
--- End quote ---

You have any idea what that code looks like? It's a mess. Possibly worse than OOo. :o

It wouldn't make it easier and most likely would make it more difficult.

tomos:
can try save as html in Excel.
-kimmchii (May 12, 2007, 06:52 PM)
--- End quote ---

You have any idea what that code looks like? It's a mess. Possibly worse than OOo. :o-app103 (May 12, 2007, 10:39 PM)
--- End quote ---

Yeah, OOo html is a pretty scary business :)

Navigation

[0] Message Index

[#] Next page

[*] Previous page