Friday, October 10, 2014

edit excel file with vim 7.4 using vim plugin

1- download vim plugin and install
user1@localhost# wget https://github.com/friedrich/hans/archive/master.zip
user1@localhost# unzip master.zip
user1@localhost# cp plugin/excel.vim /usr/share/vim/vim74/plugin/

2- install dependency
root@localhost# pip install xlrd

3- create file ~/.vimrc and add the following content
let g:zipPlugin_ext = '*.zip,*.jar,*.xpi,*.ja,*.war,*.ear,*.celzip,*.oxt,*.kmz,*.wsz,*.xap,*.docx,*.docm,*.dotx,*.dotm,*.potx,*.potm,*.ppsx,*.ppsm,*.pptx,*.pptm,*.ppam,*.sldx,*.thmx,*.crtx,*.vdw,*.glox,*.gcsx,*.gqsx'


Note--- above is single line only

4- test edit excel file
its support file .xls,.xlam,.xla,.xlsb,.xlsx,.xlsm,.xltx,.xltm,.xlt , ect

user1@localhost# vim test-vim-excel.xls

No comments:

Post a Comment