Skip to content

Converts the selected Excel range to a markdown table

Notifications You must be signed in to change notification settings

aslmx/excelToMarkdown

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 

Repository files navigation

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

About

Converts the selected Excel range to a markdown table

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Visual Basic .NET 100.0%