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 07 Sep 2007 11:20

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

---

gerdami - Visit Handbook en Français - Rate this howto:import-simple-excel-tables-into-wikidot up!

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

Phil Chett 07 Sep 2007 11:34

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

---

.Goal NHGC

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

EVotingCC 19 Sep 2007 09:43

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 19 Sep 2007 14:34

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

---

Service is my success. My webtips:www.blender.org (Open source), Wikidot-Handbook.

Sie können fragen und mitwirken in der deutschsprachigen » User-Gemeinschaft für WikidotNutzer oder
im deutschen » Wikidot Handbuch ?

Last edited on 19 Sep 2007 14:43 by Helmuti_pdorf + Show more

Latest vba version

Phil Chett 04 Nov 2007 16:52

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

---

.Goal NHGC

Last edited on 04 Nov 2007 20:08 by Phil Chett + Show more

Re: Latest vba version

gerdami 05 Nov 2007 21:34

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!

---

gerdami - Visit Handbook en Français - Rate this howto:import-simple-excel-tables-into-wikidot up!

Last edited on 08 Nov 2007 12:23 by gerdami + Show more

Re: Latest vba version

Phil Chett 05 Nov 2007 23:38

_{(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 ??}

---

.Goal NHGC

Re: Latest vba version

gerdami 06 Nov 2007 06:57

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,} …

---

gerdami - Visit Handbook en Français - Rate this howto:import-simple-excel-tables-into-wikidot up!

Last edited on 06 Nov 2007 07:13 by gerdami + Show more

Re: Latest vba version

Phil Chett 06 Nov 2007 07:38

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

---

.Goal NHGC

Re: Latest vba version

Helmuti_pdorf 06 Nov 2007 14:50

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

---

Service is my success. My webtips:www.blender.org (Open source), Wikidot-Handbook.

Sie können fragen und mitwirken in der deutschsprachigen » User-Gemeinschaft für WikidotNutzer oder
im deutschen » Wikidot Handbuch ?

Re: Latest vba version

Phil Chett 06 Nov 2007 16:45

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

---

.Goal NHGC

Re: Latest vba version

gerdami 08 Nov 2007 12:19

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

Footnotes

1. demi, roger

---

gerdami - Visit Handbook en Français - Rate this howto:import-simple-excel-tables-into-wikidot up!

ROX

Gabrys 07 Jul 2008 17:21

Hey, this one really rocks.

Good job! Thanks!

---

Piotr Gabryjeluk
visit my blog

Re: ROX

gerdami 12 Jul 2008 08:34

Thanks Gabrys, but this i still a unfinished work…

---

gerdami - Visit Handbook en Français - Rate this howto:import-simple-excel-tables-into-wikidot up!

Re: ROX

erdraug 15 Oct 2008 11:08

Finished or not, THANK YOU!

Up until now i've imported the excel into word, mass replaced tabs with "space || space" and "space || break ||" and i don't even remember what else, what a tiring process and how silly i feel now that i just have to copy some code in to cell A1 !!

/me blushes

Re: Excel to wikidot

gerdami 08 May 2009 18:09

Can anyone rate this up since the forum-for-dummies is again before my howto ?

---

gerdami - Visit Handbook en Français - Rate this howto:import-simple-excel-tables-into-wikidot up!

Re: Excel to wikidot

RobElliott 08 May 2009 19:06

the forum-for-dummies is again before my howto

Shock horror. I've corrected that dreadful situation. In return I would like….

Rob

---

Rob Elliott - Strathpeffer, Scotland - Wikidot first line support & community admin team.
Strathview ~ Wikidot-based wikis, websites & intranets and online database development. For community groups, villages, charities, business and government.

Re: Excel to wikidot

Ed Johnson 08 May 2009 20:33

This is why we need a multiple point scale. I'd give you as many "stars" as available!

-Ed

---

Free Wikidot Applications · Your Shared Photo Gallery · Your Personal Blog

Excel to wikidot *****

rch 15 May 2009 10:00

I am very happy that this is available, I have some minor problems that I can solve manually,
but it deserves the "as many stars" isn't normally 5+

Thanks

Rocio