Based on an initial post at DokuWiki I've developed a lot of further enhancements. Meanwhile the code
was also published on DW homepage. However, here you find the tool itself making all easier. You may want
to contact me in the event of questions or ask for further improvements.
The tool contains parameters on first worksheet to allow the user some customization.
Paste your table into another worksheet, select the cells as usual and run the makro.
The tool was written and tested with MS Excel 2007 but should work with 2010 also.
Configuration Parameter | Options | Effect in DokuWiki |
text formatting | yes/no | defines if Bold, Italic, Underline will be considered |
horizontal Alignment | yes/no | use horizontal cell alignment
(left, center, right) |
Detect and use text color | yes/no | text will be colored as in Excel |
Detect and use cell color | yes/no | cell color will be used as text background color
(do not mix it up with cell color at the wiki) |
Use first Line as Table Header | yes/no | colors the background first row light blue
(or whatever your template css defined as header background color) |
Use first Column as Table Header | yes/no | colors the background first column light blue
(or whatever your template css defined as header background color) |
Hyperlinks only as address | yes/no | display the hyperlink only by its real link address (no: use cell text as caption and put the link behind) |
turn comments into footnotes | yes/no | cell comments will be inserted as footnotes |
defined table width | yes/no | table and columns will be defined in their width
(Note: tablewidth plugin needed at DW) |
A German excel version were throwing errors caused by “ThisWorkbook.Sel2Wiki” due to a string is handed over and no excel function is used.
Therfore I extended the AddIn Button providing now two of them to overcome the language dependency. It is using following function call.
myButton.OnAction = “DieseArbeitsmappe.Sel2Wiki”
If you have a German Excel then use the (German) button or the other if your Excel is an English version.
Access | Aliases | | Sec. | AuthLib | EnvdumpUrls |
AuthMethod | Description | Level | Design | Java | Akr. | 1c | Factor | Level | Native | (eq) | (eq or gt) |
xxxx | dddddd | 1 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |
xxxx | dddddd | 2 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |
xxxx | dddddd | 3 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |
xxxx | dddddd | 4 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |
xxxx | dddddd | 5 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |
xxxx | dddddd | 6 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |
xxxx | dddddd | 7 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |
xxxx | dddddd | 8 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |
xxxx | dddddd | 9 | sdgfsdf | sdf | df | e | | | asdads | sadasd | asdasda |