Markdown To Html


  • Markdown is a popular and easy to use format to add some simple styling to plain text. It supports things like bold, italics, underline, strike-through, bulleted and numbered lists, headings, paragraphs, etc.
  • SheetKraft's MarkdownToHtml function provides the ability to use this format to generate html. The resulting html can be used as the body of an email or as activity output.
  • There is a UI for MarkDown To HTML. This can be accessed as follows:
    More >> MarkDown To HTML

img1


Step 1:

Open UI, this dialogue box will appear:

img2


Step 2:

Type / paste markdown in the text area to the left.

img3


Alternatively, if you already have markdown in a cell, select the cell above the text area.

img4


NOTE: At any point hit F5 to see a preview of the generated html in the right pane.

img5


If you want to make some text variable, delete the text and replace it with {{some_name}}.

some_name

should be unique. The same name can appear multiple times in the markdown if you want the same text to show up at each of those places.

If you want to insert raw html, type {{{someothername}}} at the appropriate location. For example, this might be a table that you have already generated using TableToHtml.

img6


Step 3:

After you have entered all your variables, click Extract From Markdown. In the picture below, the names were automatically extracted from the markdown and I will just add the cell references for the values.

img7


Step 4:

Click on next and choose the cell where the output of the function is needed, This is how the output looks like:

img8