excelToMarkdown2

Forked from https://github.com/apfernandes/excelToMarkdown and added a few improvements

Converts the selected Excel range to a markdown table

• On Excel for MAC activate the Developer option on the Ribbon & Toolbar
  • Goto the Menu Excel -> Preferences -> Ribbon & ToolBar and select Developer
  • On the Ribbon select the Developer Tab
  • Open the Visual Basic editor
  • Copy the code
  • Select the range/table
  • Text will be copied into Clipboard

Improvements

• Remove Linebreaks from cells and replace them with space. This way it does not break the Markdown
• Instead of writing to debug.print where no one will find it, it puts it directly to clipboard

Preconditions

• Needs Microsoft Forms 2.0 library to be enabled/added to project in order to be able to write into Clipboard

Potential improvements

• Cell alignment could be handled by prasing cell.HorizontalAlignment