Not logged in. · Lost password · Register
Forum: General Help and Support Syntax and Usage RSS
Excel2DokuWiki v4
further enhancements (I hope)
Avatar
Taggic (Moderator) #1
Member since Jan 2011 · 777 posts · Location: Gilching, Germany
Group memberships: Global Moderators, Members
Show profile · Link to this post
Subject: Excel2DokuWiki v4
Hi,

some time ago I found the Excel2DokuWiki makro. We use it and I did some adds to the functions. It is written for MS Excel 2007 so it possibly does not work with former Excel Versions. Basic usage is the same, mark the cells you want to translate into DW syntax and run the makro (makro feature to be enabled within excel). Probably somebody else need this to ...

However, attached is the xlsm file with configurable options
best regards
Taggic
f-con wiki: http://www.fristercons.de/fcon/
This post was edited on 2011-05-13, 11:24 by Taggic.
Avatar
lupo49 (Moderator) #2
Member since Jul 2009 · 1399 posts · Location: Warstein, Germany
Group memberships: Global Moderators, Members, Super Mods
Show profile · Link to this post
Could you also place the info on this page: https://www.dokuwiki.org/tips:excel_macro ?
Would be nice, to have the new one aggregated with the former ones.
Avatar
Taggic (Moderator) #3
Member since Jan 2011 · 777 posts · Location: Gilching, Germany
Group memberships: Global Moderators, Members
Show profile · Link to this post
Subject: new Excel2DokuWiki
herewith a new version with some add features. I will link it with https://www.dokuwiki.org/tips:excel_macro (similar to lupo's proposal).

Parameter effects in DokuWiki:
 - defines if Bold, Italic, Undeline will be considered (little bug fix)
 - use same horizontal cell alignment (left, center, right)
 - text will be colored as in Excel
 - cell color will be used as text background color (do not mixed up with cell color at the wiki)
 - colors the background first row light blue
 - colors the background first column light blue
 - display the hyperlink only by its real link address (no: use cell text as caption and put the link behind)
 - cell comments will be inserted as footnotes
 - table and columns will be defined in their width (tablewidth plugin needed at DW)

Beside that the detection of merged cells is now corrected.

Consider:
A German excel version is throwing errors caused by “ThisWorkbook.Sel2Wiki” due to a string is handed over and no function is used. But my Excel understands following:

myButton.OnAction = "DieseArbeitsmappe.Sel2Wiki"

Therfore I changed the AddIn Button providing now two buttons to overcome the language dependency. If you have a German Excel then use the (German) button or the other if your Excel is an English version. Everybody who knows how to get rid of this is invited to share the solution here and I will implement it asap.

PS:
There are other methods provided by MS Excel to run a macro, not that comfortable but working independently of the language. Use those if you have neither German nor English version.
best regards
Taggic
f-con wiki: http://www.fristercons.de/fcon/
The author has attached one file to this post:
Excel2Dokuwiki_v4-02.zip 30.6 kBytes
You have no permission to open this file.
This post was edited 6 times, last on 2011-05-13, 13:26 by Taggic.
Edit reason: correction for merged cells
Avatar
slownoise #4
Member since Jun 2011 · 1 post
Group memberships: Members
Show profile · Link to this post
great! thanks a lot!
Close Smaller – Larger + Reply to this post:
Verification code: VeriCode Please enter the word from the image into the text field below. (Type the letters only, lower case is okay.)
Smileys: :-) ;-) :-D :-p :blush: :cool: :rolleyes: :huh: :-/ <_< :-( :'( :#: :scared: 8-( :nuts: :-O
Special characters:
Go to forum
Imprint
This board is powered by the Unclassified NewsBoard software, 20150713-dev, © 2003-2015 by Yves Goergen
Current time: 2020-02-17, 07:16:28 (UTC +01:00)