Posted by on 2017年5月25日

[隐藏]

Here are a few functions that I think might be a little bit helpful to handle office task on Windows, especially EXCEL.

1.Fuzzy string comparation

Computing Levenshtein and editor distances with use of Vagner-Fisher algorithm.

2.Data Manipulation

Use the following file to manipulate massive Excel files.

in which the Num2Cha and Cha2Num functions are my self-defined functions as follow:

Tags: ,
10 views
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Comments

  1. baoduge
    2017年6月20日

    终于解决了Code Box的滚动条的问题--代码太长就会占据太多篇幅。现在我使用的是Crayon Syntax Highlighter插件,可以自选主题,同时还有Scroll bar等工具选择,功能很强大。推荐!

Leave a Reply

返回顶部