Import Simple Excel Tables Into Wikidot / discussion

This is the discussion related to the wiki page Import Simple Excel Tables Into Wikidot.

Problems with the excel function which gives ... #NAME?

gerdami 1189164020|%e %b %Y, %H:%M %Z|agohover

1. I tested this on Excel 2002/2003, not 2007.
2. PERSONAL.XLS : if you store the function in PERSONAL.XLS, which you have forced to be opened at startup , you have to specify the full name of the function "=personal.xls!MultiCat(B13:E13)"
3. You might also create an Excel Add-In
* create a new workbook multicat.xls (and put the code in the VBA project as described above)
* save the file multicat.xls
* save the file again as multicat.xla (choose type Msft Office Excel Add-In)
* with Tools, Add-Ins…, Browse and locate your multicat.xla
* at next Excel start-up the function will be available

Problems with the excel function which gives ... #NAME?

Phil Chett 1189164884|%e %b %Y, %H:%M %Z|agohover

problem proved to sticking the code in the wrong place.
Text in how:to slightly changed to make it more obvious.

Automatize Excel import of Tables to create new wiki site for each....

EVotingCC 1190194987|%e %b %Y, %H:%M %Z|agohover

Hi Phil!
Thank you once more for being so helpful.

I still have a question though: Is it possible to somehow automatize the import of my 200+ Tables into WikiDot but not as you describe it here in one large table.
What I want to do is to create a new page for each table. The whole thing should be included in a site structure where you can pick the different countries and then the various tables for the selected country as you can see here.

Looking forward to your reply!
Daniel

Re: Automatize Excel import of Tables to create new wiki site for each....

Helmuti_pdorf 1190212492|%e %b %Y, %H:%M %Z|agohover

Hi !
First I think the title is wrong!
You do not want an extra site for every table…

What I do not understand:
is it not easier to upload the excel files itself , WITH .xls as file extensions , for documentation purposes?
Even if some visitor has no MS-Excel in use, they can always open the files with (open source) Open Office.

But, sorry, I believe, you need to create the pages, page after page because of parenting (to the regions a.s.o.) and tagging too and to insert the table over the source- edit window.
I think it is easier and faster, to create for every table a second sheet with in the first columns copied the content from the first sheet in the manner Gerdami and Phill has described.
Than it is more a copy and paste drama.

Best regards and good luck
Helmut

last edited on 1190213011|%e %b %Y, %H:%M %Z|agohover by Helmuti_pdorf + show more

Latest vba version

Phil Chett 1194195133|%e %b %Y, %H:%M %Z|agohover

By heck, lad. You do be a clever bugger.

Theres a couple of quirks in that i have as yet to identify, but generally speaking, just as the multicat version does, this is an excellent way to save hours trying to code tables.
Just kick up your excell table the way you want it. Run the code.
Job done

Comp ID	Dates	Comp Detail	Venue
A	3-10 Jan	Forbes Flatlands (& Oz Nationals)	Forbes, NSW
B	13 - 19 Jan	Bogong Cup	Mt Beauty, Victoria
C	TBA	Bassano	Monte Grappa, Italy
D	TBA	Flytec Championship	Groveland, Florida - but dates & venue t.b.c.
E	3 - 5 May	British Open Series (Class 1 & 5)	Dates & Venue t.b.c.
F	23 - 27 May	British Open Series	Dates & Venue t.b.c.
G	7 - 21 June	European Championships	Greifenburg, Austria
H	24 June - 5 July	Chabre Open & 2009 Pre-Worlds	Laragne-Monteglin, France
I	TBA	British Open Series Reserve Meet	Dates & Venue t.b.c.
J	TBA	Bleriot Cup	UK - dates & venue t.b.c.
K	TBA	UK Class 1 (& 5?) Nationals	Dates & Venue t.b.c.
L	22 - 26 July	Open Series Final	Dates & Venue t.b.c.

Identified problems.

1: The first row of your table must not have blank cells in it.

Pilot

##

FF0000|AB

C

D

R

F

G

H

I

J

K

L

If i but a dot in the blank cell then i get

Pilot

.

A

B

C

D

R

F

G

H

I

J

K

L

of course, i can always hide the dot by changing the text color

Pilot

.

A

B

C

D

R

F

G

H

I

J

K

L

Merging the first two cells gives

Pilot

##

FF0000|AB

C

D

R

F

G

H

I

J

K

L

As long as the first row is right, then all following rows with blank spaces will work ok.

2 : Conditional formatting

Problem to be identified as yet, but it seems that as soon as it looks at a cell with conditional formating, the sode stops in its tracks with a runtime error (13) type mismatch. But then it does say

2.1.006 : now, also converts some conditional formatting

last edited on 1194206936|%e %b %Y, %H:%M %Z|agohover by Phil Chett + show more

Re: Latest vba version

gerdami 1194298496|%e %b %Y, %H:%M %Z|agohover

Problems

Problem 1

It is fixed in version 007

Problem 2

• From several Excel forum posts, it seems that there are some new features related to conditional formatting in Excel 12 (2007) and also some incompatibilities with VBA code from earlier versions (2002/2003).
• I used a code from Chip Pearson for Color Formatting … which led to a run-time error when no font.color or interior.color was set for a met condition. [added on 8.11.2007].

Phil Chess Board

	a	b	c	d	e	f	g	h
8	XX	YY	XX	YY	XX	YY	XX	YY	8
7	YY	XX	YY	XX	YY	XX	YY	XX	7
6	XX	YY	XX	YY	XX	YY	XX	YY	6
5	YY	XX	YY	XX	YY	XX	YY	XX	5
4	XX	YY	XX	YY	XX	YY	XX	YY	4
3	YY	XX	YY	XX	YY	XX	YY	XX	3
2	XX	YY	XX	YY	XX	YY	XX	YY	2
1	YY	XX	YY	XX	YY	XX	YY	XX	1
	a	b	c	d	e	f	g	h

Done with Excel, some conditional formatting … and ExcelToWikidot!

last edited on 1194524631|%e %b %Y, %H:%M %Z|agohover by gerdami + show more

Re: Latest vba version

Phil Chett 1194305915|%e %b %Y, %H:%M %Z|agohover

_{(wisper very softly, so not as to disturb … cos we don't want to upset this guy gerdarmi, who has saved me hours and hours of potential going madness by writing this code….. )}

^{where the hell is version 0.00000000000007 ??}

Re: Latest vba version

gerdami 1194332233|%e %b %Y, %H:%M %Z|agohover

Please spell gerdami correctly! ;-)
007 is still an unpublished Fleming's.

And do not forget to click on Rating +.
If rating stucks to zero ^{no interest from the Community,} …

last edited on 1194333218|%e %b %Y, %H:%M %Z|agohover by gerdami + show more

Re: Latest vba version

Phil Chett 1194334731|%e %b %Y, %H:%M %Z|agohover

page ratings have been disabled. (and i dont know why, or how to fix that)

Re: Latest vba version

Helmuti_pdorf 1194360629|%e %b %Y, %H:%M %Z|agohover

Hi Phil!
I rated it now on my IE 7 - I cannot detect any error with the ratings module? -Helmut

Re: Latest vba version

Phil Chett 1194367527|%e %b %Y, %H:%M %Z|agohover

i fink sumwon has fixed it, cos i have bin trying to rate this wonderous piece of work for ages, now i can :-)

Re: Latest vba version

gerdami 1194524357|%e %b %Y, %H:%M %Z|agohover

sumwon was gerdami using sitemanager, page_ratings.
somedays aie learn moore¹ slang[uage] than wikidot features.

Footnotes

1. demi, roger

ROX

Gabrys 1215451292|%e %b %Y, %H:%M %Z|agohover

Hey, this one really rocks.

Good job! Thanks!

Re: ROX

gerdami 1215851668|%e %b %Y, %H:%M %Z|agohover

Thanks Gabrys, but this i still a unfinished work…