Excel2Asciidoc

VBA macro that translate Excel to Asciidoc

Excel2Asciidoc

VBA macro that translate Excel to Asciidoc

Table of Contents

1. About The Project
2. Installation and Usage
3. License

About The Project

Excel is very useful calc software. Sometime, Excel is used to write a technical document, but that is not well received. Of course, if you write as document, it is better to use a word processor, word.

Now, we use Excel for writing technical document. Excel is good for making tables, and editing pictures. Especially, document, sentence.. table.. picture.. sentence.. picture. At that case, we think excel is best.

In the future, not only asciidoc but others markdown or textile etc.

This is only sample code, and there are many limitation.

Installation and Usage

1. Make new excel file.

2. Open VBE.

• Alt+F11 will open the VBE

3. Import files(*.bas, *.cls).

• import files from test/src

4. Once save as xlsm file.

• Save file as xlsm file. etc. excel2ascii.xlsm.

5. Make sample sheet.

• Alt + F8, and execute MakeSampleSheet.
• You get the sheet below.

6. Convert Excel to Asciidoc.

• Alt + F8, and execute MakeDocumentAndPic.
• You get a sheet1.adoc and a $B$31.png in the folder excel2ascii.xlsm exists.
• you can view the sheet1.adoc at some asciidoctor viewer.

License

Distributed under the MIT License. See LICENSE for more information.