0、介绍
有时候会遇到将xls格式的表格，转换为markdown格式的情况。手工转换，非常麻烦，这里在vim中通过一个自定义命令实现。
1、代码实现
vimrc中添加如下内容：
" convert a table copy from excel to makedown table format
" convert a column value list to a markdown format row
function! GenerateAMarkdownTableRowFunc(colValueList)
let resultStr = ''
let i = 0
for colValue in a:colValueList
let resultStr = resultStr . " | " . colValue
let i = i + 1
endfor
let resultStr = resultStr . " |"
" remove the space at the beginning
let resultStr = strpart(resultStr, 1, strlen(resultStr) - 1)
return resultStr
endfunction
" call GenerateAMarkdownTableRowFunc to convert xls table to markdown
function! GenerateMarkdownTable()
" read all lines into a list
let allLines = []
g/$/let line = getline(".") | call add(allLines, line)
let resultLines = []
" deal with the table head
let colValueList = split(allLines[0], '\t', 1)
call add(resultLines, GenerateAMarkdownTableRowFunc(colValueList))
" deal with the split line between table body and head
let colValueList = split(allLines[0], '\t', 1)
let tmpColSplitLineStr = ''
let i = 0
for colValue in colValueList
let tmpColSplitLineStr = tmpColSplitLineStr . " | " . "---"
let i = i + 1
endfor
let tmpColSplitLineStr = tmpColSplitLineStr . " |"
call add(resultLines, strpart(tmpColSplitLineStr, 1, strlen(tmpColSplitLineStr) - 1))
" deal with the table body
let index = 1
while index < len(allLines)
let curLine = allLines[index]
let valList = split(curLine, '\t', 1)
call add(resultLines, GenerateAMarkdownTableRowFunc(valList))
let index = index + 1
endwhile
" join all lines
let resultStr = join(resultLines, "\n")
" replace content of current buffer
let @u = resultStr
normal! ggdG
normal! 0"up
echo "Markdown table converted!"
endfunction
command GenerateMarkdownTable exec GenerateMarkdownTable()
重新启动vim即可生效。
2、使用
假设有表格从excel中粘贴到一个空的vim缓冲区中，是如下格式：
姓名 年龄 性别 描述
Tom 男 tom是一个好孩子
Jeff 41 男
Kate 33 女 Kate is a good girl.
执行前面自定义的vim命令，:GenerateMarkdownTable，即可将其转换为如下格式：
| 姓名 | 年龄 | 性别 | 描述 |
| --- | --- | --- | --- |
| Tom | | 男 | tom是一个好孩子 |
| Jeff | 41 | 男 | |
| Kate | 33 | 女 | Kate is a good girl. |
3、说明
这个例子中，除了实现了前面的需求，也可以学习到如何读取vim缓冲区中的内容进行变换，有很多灵活运用的空间。
