Import Excel Spreadsheet into Wiki Format

[Juice Box]

Is it possible to convert a spreadsheet I did in excel to wiki format htm?

 

[zerocool1]

you can convert an excel file to an html file...

 

[Juice Box]

Originally posted by: zerocool1
you can convert an excel file to an html file...

but when I paste the HTML in the wiki, it just shows the code when I post it

 

[So]

Originally posted by: Juice Box
Is it possible to convert a spreadsheet I did in excel to wiki format htm?

can you define 'wiki format htm'?

 

[So]

Originally posted by: Juice Box

Originally posted by: zerocool1
you can convert an excel file to an html file...

but when I paste the HTML in the wiki, it just shows the code when I post it

I think what you may need to do is get it in comma seperated value format, then use a *good* text editor (like textpad or one of the many others) to replace the commas with whatever wiki uses for tabs...

 

[Juice Box]

Originally posted by: So

Originally posted by: Juice Box
Is it possible to convert a spreadsheet I did in excel to wiki format htm?

can you define 'wiki format htm'?

well, the format of the table that was there went something like this

{| border="1" cellpadding="2"
| '''Title A'''
| '''Title B'''
| '''Title C'''
|-
| Answer A
| Answer B
| Answer C
|}

when i save my excel doc as an html it puts a ton more code in than that

 

[HomeBrewerDude]

yeah what is wiki format htm?

 

[HomeBrewerDude]

paste special (as text or rtf) into word then save as html

 

[So]

Ah-hah!

http://area23.brightbyte.de/csv2wp.php

export your excel table to CSV and try this util.

Google is your friend

 

[Juice Box]

Originally posted by: So
Ah-hah!

http://area23.brightbyte.de/csv2wp.php

export your excel table to CSV and try this util.

Google is your friend

well looky there
Thanks buddy!! :beer:

 

[HomeBrewerDude]

Originally posted by: So
Ah-hah!

http://area23.brightbyte.de/csv2wp.php

export your excel table to CSV and try this util.

Google is your friend

neat utility