设计模式实践-命令模式

场景

向仪表发送采集命令

实现代码

仪表命令接口

1
2
3
4
5
6
7
8
9
10
11
12
13
namespace DesignPatterns.Command
{
    /// <summary>
    /// 仪表命令接口
    /// </summary>
    public interface IMeterCommand
    {
        /// <summary>
        /// 执行命令
        /// </summary>
        void Execute();
    }
}

采集命令

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
namespace DesignPatterns.Command
{
    /// <summary>
    /// 采集命令
    /// </summary>
    public class CollectCommand : IMeterCommand
    {
        /// <summary>
        /// 命令接受对象
        /// </summary>
        private readonly Receiver _receiver;

        /// <summary>
        /// Initializes a new instance of the <see cref="CollectCommand" /> class
        /// </summary>
        /// <param name="receiver">命令接受对象</param>
        public CollectCommand(Receiver receiver)
        {
            this._receiver = receiver;
        }

        /// <summary>
        /// 执行命令
        /// </summary>
        public void Execute()
        {
            this._receiver.Action("采集命令");
        }
    }
}

调用者对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
namespace DesignPatterns.Command
{
    /// <summary>
    /// 命令发送者
    /// </summary>
    public class Invoker
    {
        /// <summary>
        /// 命令对象
        /// </summary>
        private readonly IMeterCommand command;

        /// <summary>
        /// Initializes a new instance of the <see cref="Invoker" /> class
        /// </summary>
        /// <param name="command">命令对象</param>
        public Invoker(IMeterCommand command)
        {
            this.command = command;
        }

        /// <summary>
        /// 调用命令
        /// </summary>
        public void Call()
        {
            this.command.Execute();
        }
    }
}

接收者对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
namespace DesignPatterns.Command
{
    /// <summary>
    /// 命令发送者
    /// </summary>
    public class Invoker
    {
        /// <summary>
        /// 命令对象
        /// </summary>
        private readonly IMeterCommand command;

        /// <summary>
        /// Initializes a new instance of the <see cref="Invoker" /> class
        /// </summary>
        /// <param name="command">命令对象</param>
        public Invoker(IMeterCommand command)
        {
            this.command = command;
        }

        /// <summary>
        /// 调用命令
        /// </summary>
        public void Call()
        {
            this.command.Execute();
        }
    }
}

相关调用

1
2
3
4
Receiver receiver = new Receiver();
IMeterCommand command = new CollectCommand(receiver);
Invoker invoker = new Invoker(command);
invoker.Call();

Out

1
发送数据：采集命令

展开全文 >>

设计模式实践-组合模式

场景

站点和仪表目录。

实现代码

组合抽象类：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
namespace DesignPatterns.Composite
{
    /// <summary>
    /// 站点组合抽象
    /// </summary>
    public abstract class SiteComponent
    {
        /// <summary>
        /// 组合名称
        /// </summary>
        protected string Name;

        /// <summary>
        /// Initializes a new instance of the <see cref="SiteComponent" /> class.
        /// </summary>
        /// <param name="name">组合名称</param>
        protected SiteComponent(string name)
        {
            this.Name = name;
        }

        /// <summary>
        /// 添加组合
        /// </summary>
        /// <param name="siteComponent">组合对象</param>
        public abstract void Add(SiteComponent siteComponent);

        /// <summary>
        /// 移除组合
        /// </summary>
        /// <param name="siteComponent">组合对象</param>
        public abstract void Remove(SiteComponent siteComponent);

        /// <summary>
        /// 显示组合下的所有元素
        /// </summary>
        /// <param name="depth">本节点深度</param>
        public abstract void Display(int depth);
    }
}

站点类

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
namespace DesignPatterns.Composite
{
    /// <summary>
    /// 站点组合类
    /// </summary>
    public class Site : SiteComponent
    {
        /// <summary>
        /// 子站点列表
        /// </summary>
        private readonly List<SiteComponent> _sublist = new List<SiteComponent>();

        /// <summary>
        /// Initializes a new instance of the <see cref="Site" /> class.
        /// </summary>
        /// <param name="name">站点名称</param>
        public Site(string name) : base(name)
        {
        }

        /// <summary>
        /// 添加子站点组合
        /// </summary>
        /// <param name="siteComponent">组合对象</param>
        public override void Add(SiteComponent siteComponent)
        {
            this._sublist.Add(siteComponent);
        }

        /// <summary>
        /// 删除子站点组合
        /// </summary>
        /// <param name="siteComponent">组合对象</param>
        public override void Remove(SiteComponent siteComponent)
        {
            this._sublist.Remove(siteComponent);
        }

        /// <summary>
        /// 显示组合下的所有元素
        /// </summary>
        /// <param name="depth">本节点深度</param>
        public override void Display(int depth)
        {
            Console.WriteLine(new string('-', depth) + this.Name);

            foreach (var site in this._sublist)
            {
                site.Display(depth + 2);
            }
        }
    }
}

仪表类

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
namespace DesignPatterns.Composite
{   
    /// <summary>
    /// 仪表组合类
    /// </summary>
    public class Meter : SiteComponent
    {
        /// <summary>
        /// Initializes a new instance of the <see cref="Meter" /> class.
        /// </summary>
        /// <param name="name">仪表名称</param>
        public Meter(string name) : base(name)
        {
        }

        public override void Add(SiteComponent siteComponent)
        {
            throw new NotImplementedException();
        }

        public override void Remove(SiteComponent siteComponent)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 显示本节点
        /// </summary>
        /// <param name="depth">本节点深度</param>
        public override void Display(int depth)
        {
            Console.WriteLine(new string('-', depth) + this.Name);
        }
    }
}

相关调用

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SiteComponent rootSite = new Site("总站");
SiteComponent otherSite01 = new Site("分站1");
otherSite01.Add(new Meter("仪表1"));
otherSite01.Add(new Meter("仪表2"));
rootSite.Add(otherSite01);
rootSite.Add(new Site("分站2"));
rootSite.Add(new Site("分站3"));
SiteComponent otherSite02 = new Site("分站4");
otherSite02.Add(new Meter("仪表1"));
otherSite02.Add(new Meter("仪表2"));
otherSite02.Add(new Meter("仪表3"));
otherSite02.Add(new Meter("仪表4"));
otherSite02.Add(new Meter("仪表5"));
rootSite.Add(otherSite02);
rootSite.Display(1);

Out：

1
2
3
4
5
6
7
8
9
10
11
12
-总站
---分站1
-----仪表1
-----仪表2
---分站2
---分站3
---分站4
-----仪表1
-----仪表2
-----仪表3
-----仪表4
-----仪表5

展开全文 >>

设计模式实践-外观模式

场景

解析协议接口，集中验证数据、解析数据头，解析数据体

实现代码

解析数据外观对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
namespace DesignPatterns.Facade
{
    /// <summary>
    /// 解析数据外观对象
    /// </summary>
    public class ParserFacade
    {
        /// <summary>
        /// 解析数据
        /// </summary>
        /// <param name="data">数据头</param>
        public void Parser(string data)
        {
            var verify = new VerifyData();
            var headerParser = new HeaderParser();
            var bodyParser = new BodyParser();

            verify.Do(data);
            headerParser.Do(data);
            bodyParser.Do(data);
        }
    }
}

验证数据对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
namespace DesignPatterns.Facade
{
    /// <summary>
    /// 验证数据对象
    /// </summary>
    internal class VerifyData
    {
        /// <summary>
        /// 验证数据
        /// </summary>
        /// <param name="data">数据对象</param>
        internal void Do(string data)
        {
            Console.WriteLine("验证数据");
        }
    }
}

解析数据头对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
namespace DesignPatterns.Facade
{
    /// <summary>
    /// 解析数据头对象
    /// </summary>
    internal class HeaderParser
    {
        /// <summary>
        /// 解析数据头
        /// </summary>
        /// <param name="data">数据对象</param>
        internal void Do(string data)
        {
            Console.WriteLine("验证数据头");
        }
    }
}

解析数据体对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
namespace DesignPatterns.Facade
{
    /// <summary>
    /// 解析数据体对象
    /// </summary>
    internal class BodyParser
    {
        /// <summary>
        /// 解析数据对象
        /// </summary>
        /// <param name="data">数据对象</param>
        internal void Do(string data)
        {
            Console.WriteLine("解析数据");
        }
    }
}

相关调用

1
2
var parser = new ParserFacade();
parser.Parser("test data");

Out

1
2
3
验证数据
验证数据头
解析数据

展开全文 >>

设计模式实践-装饰器

场景

使用HongDian DTU后需要在原本发送的逻辑前先发送HongDian规定的内容

实现代码

DTU组件接口：

1
2
3
4
5
6
7
8
9
10
11
12
13
namespace DesignPatterns.Decorator
{
    /// <summary>
    /// DTU组件接口
    /// </summary>
    public interface IDtuComponent
    {
        /// <summary>
        /// 向DTU发送数据
        /// </summary>
        void SendData();
    }
}

标准DTU组件实现：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
namespace DesignPatterns.Decorator
{
    /// <summary>
    /// 标准DTU组件
    /// </summary>
    public class StandDtuComponent : IDtuComponent
    {
        /// <summary>
        /// 向标准DTU发送数据
        /// </summary>
        public void SendData()
        {
            Console.WriteLine("发送透明DTU数据");
        }
    }
}

宏电DTU组件实现：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
namespace DesignPatterns.Decorator
{
    /// <summary>
    /// 宏电DTU组件
    /// </summary>
    public class HongDianDtu : IDtuComponent
    {
        /// <summary>
        /// dtu组件
        /// </summary>
        private readonly IDtuComponent _dtuComponent;

        /// <summary>
        /// Initializes a new instance of the <see cref="HongDianDtu" /> class.
        /// </summary>
        /// <param name="dtuComponent">DTU组件</param>
        public HongDianDtu(IDtuComponent dtuComponent)
        {
            this._dtuComponent = dtuComponent;
        }

        /// <summary>
        /// 向宏电DTU发送数据
        /// </summary>
        public void SendData()
        {
            Console.WriteLine("发送宏电Dtu数据");

            // some action

            this._dtuComponent.SendData();
        }
    }
}

相关调用

1
2
3
IDtuComponent standDtu = new StandDtuComponent();
IDtuComponent hongDianDtu = new HongDianDtu(standDtu);
hongDianDtu.SendData();

Out：

1
2
发送宏电Dtu数据
发送透明DTU数据

展开全文 >>

pip使用豆瓣源和代理

安装jupyter的时候卡在notebook一动不动,

1
2
3
4
5
6
7
8
9
10
11
12
λ pip install jupyter
Collecting jupyter
  Downloading jupyter-1.0.0-py2.py3-none-any.whl
Collecting qtconsole (from jupyter)
  Downloading qtconsole-4.3.1-py2.py3-none-any.whl (108kB)
    100% |████████████████████████████████| 112kB 12kB/s
Collecting ipywidgets (from jupyter)
  Downloading ipywidgets-7.0.5-py2.py3-none-any.whl (68kB)
    100% |████████████████████████████████| 71kB 6.8kB/s
Collecting notebook (from jupyter)
  Downloading notebook-5.2.2-py2.py3-none-any.whl (8.0MB)
    17% |█████▌                          | 1.4MB 11kB/s eta 0:10:02

pip代理

本机装了ss，所以直接用--proxy http://ip:port,

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
λ pip install --proxy http://127.0.0.1:2080 jupyter
Collecting jupyter
  Using cached jupyter-1.0.0-py2.py3-none-any.whl
Collecting nbconvert (from jupyter)
  Downloading nbconvert-5.3.1-py2.py3-none-any.whl (387kB)
    100% |████████████████████████████████| 389kB 1.8MB/s
Collecting notebook (from jupyter)
  Downloading notebook-5.2.2-py2.py3-none-any.whl (8.0MB)
    100% |████████████████████████████████| 8.0MB 150kB/s
Collecting ipywidgets (from jupyter)
  Using cached ipywidgets-7.0.5-py2.py3-none-any.whl
Collecting qtconsole (from jupyter)
  Using cached qtconsole-4.3.1-py2.py3-none-any.whl
Collecting ipykernel (from jupyter)
  Downloading ipykernel-4.7.0-py3-none-any.whl (106kB)
    100% |████████████████████████████████| 112kB 1.7MB/s
Collecting jupyter-console (from jupyter)
  Downloading jupyter_console-5.2.0-py2.py3-none-any.whl
Collecting jinja2 (from nbconvert->jupyter)
  Downloading Jinja2-2.10-py2.py3-none-any.whl (126kB)
    100% |████████████████████████████████| 133kB 161kB/s
Collecting testpath (from nbconvert->jupyter)
  Downloading testpath-0.3.1-py2.py3-none-any.whl (161kB)
    100% |████████████████████████████████| 163kB 74kB/s
Collecting mistune>=0.7.4 (from nbconvert->jupyter)
  Downloading mistune-0.8.3-py2.py3-none-any.whl
Collecting nbformat>=4.4 (from nbconvert->jupyter)
  Downloading nbformat-4.4.0-py2.py3-none-any.whl (155kB)
    100% |████████████████████████████████| 163kB 311kB/s
Collecting pygments (from nbconvert->jupyter)
  Downloading Pygments-2.2.0-py2.py3-none-any.whl (841kB)
    100% |████████████████████████████████| 849kB 1.2MB/s
Collecting traitlets>=4.2 (from nbconvert->jupyter)
  Downloading traitlets-4.3.2-py2.py3-none-any.whl (74kB)
    100% |████████████████████████████████| 81kB 263kB/s

pip豆瓣源

国内使用豆瓣源也是一个很好的选择,

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
λ  pip install -i http://pypi.douban.com/simple/ requests --trusted-host pypi.douban.com
Collecting requests
  Downloading http://pypi.doubanio.com/packages/49/df/50aa1999ab9bde74656c2919d9c0c085fd2b3775fd3eca826012bef76d8c/requests-2.18.4-py2.py3-none-any.whl (88kB)
    100% |████████████████████████████████| 92kB 2.6MB/s
Collecting chardet<3.1.0,>=3.0.2 (from requests)
  Downloading http://pypi.doubanio.com/packages/bc/a9/01ffebfb562e4274b6487b4bb1ddec7ca55ec7510b22e4c51f14098443b8/chardet-3.0.4-py2.py3-none-any.whl (133kB)
    100% |████████████████████████████████| 143kB 4.7MB/s
Collecting idna<2.7,>=2.5 (from requests)
  Downloading http://pypi.doubanio.com/packages/27/cc/6dd9a3869f15c2edfab863b992838277279ce92663d334df9ecf5106f5c6/idna-2.6-py2.py3-none-any.whl (56kB)
    100% |████████████████████████████████| 61kB 5.8MB/s
Collecting urllib3<1.23,>=1.21.1 (from requests)
  Downloading http://pypi.doubanio.com/packages/63/cb/6965947c13a94236f6d4b8223e21beb4d576dc72e8130bd7880f600839b8/urllib3-1.22-py2.py3-none-any.whl (132kB)
    100% |████████████████████████████████| 133kB 5.7MB/s
Collecting certifi>=2017.4.17 (from requests)
  Downloading http://pypi.doubanio.com/packages/29/9b/25ef61e948321296f029f53c9f67cc2b54e224db509eb67ce17e0df6044a/certifi-2017.11.5-py2.py3-none-any.whl (330kB)
    100% |████████████████████████████████| 337kB 17.1MB/s
Installing collected packages: chardet, idna, urllib3, certifi, requests
Successfully installed certifi-2017.11.5 chardet-3.0.4 idna-2.6 requests-2.18.4 urllib3-1.22

展开全文 >>

入手vultr

bandwagon->vultr

在gmail里看到bandwagon的邮件后想起vps的租期要到了，正好想起GO神之前在群里安利，于是注册vultr的账号充了5$。网上找了优惠码，送了50$，心想着可以好好用半年，到账后马上开了一个东京机房的vps并装了SS。

SS安装

用了go版的一件安装包,下载安装包：

1
wget --no-check-certificate https://raw.githubusercontent.com/teddysun/shadowsocks_install/master/shadowsocks-go.sh

设置权限：

1
chmod +x shadowsocks-go.sh

安装：

1
./shadowsocks-go.sh 2>&1 | tee shadowsocks-go.log

安装过程会提示输入ss服务器的密码和端口，也可以通过编辑 /etc/shadowsocks/config.json 设置ss服务器的参数。

常用命令：

启动：/etc/init.d/shadowsocks start
停止：/etc/init.d/shadowsocks stop
重启：/etc/init.d/shadowsocks restart
状态：/etc/init.d/shadowsocks status

vps评价

刚开始用vultr的东京路线吓到我了，看youtube的720p很流畅。上班后在公司发现很慢，ping值也很高，上网查了才发现东京路线对中国移动的宽带比较友好。由于赠送的$50要在六个月内用完，于是再开了一个洛杉矶机房的vps。就性价比来说，完全没问题，就是不知道为什么，对电信路线不是很友好，联通未测。

展开全文 >>

当前的工作流优化

开发环境

使用前后端分离开发，前端使用nginx将指定路由指向前端开发目录：

1
2
3
location /gw {
    alias C:\Project\html\web_page_gw;
}

后端使用python开发，web api端口为5000，使用nginx重定向/api的路由：

1
2
3
location /api {
    proxy_pass http://127.0.0.1:5000/api;
}

这样，在前端调用web api时，只需设置/api/xxx即可。

前端

优化之前，前端的主要工具为webpack，如果要实现实时刷新，需要使用webpack-dev-server，因此再开发中需要指明web api的全路径。原先使用全局变量保存web api的地址，像这样：

1
const baseUrl = '127.0.0.1:5000/api/gw';

在发布的时候将地址改回：

1
const baseUrl = '/api/gw';

略微有点繁琐，某天端神问我关于Browsersync的事情，我突然豁然开朗。弃用webpack-dev-server，使用browser-sync-webpack-plugin，配置如下：

1
2
3
4
5
6
7
8
9
    ...
plugins: [        
        new browserSyncPlugin({
            host: 'localhost',
            port: 3000,
            proxy: 'http://localhost/gw'
        })
    ]
    ...

借助BrowserSync的代理模式，即实现了实时刷新技术，同时保证开发和部署无差异化。

后端

后端使用Flask开发，为了方便部署，使用独立的virtualenv.py文件，将源码分发到远程服务器上，只需要执行

1
python virtualenv.py ENV
1
pip install -r requirements.txt

即可完成安装

远程部署

最近新功能上线，偶尔会遇到一些小bug和小功能调整，一天会更新数次服务端的代码，最开始的时候直接暴力复制粘贴到远程服务器。这个过程需要：复制本地代码->打开远程桌面->粘贴源码，尤其复制python的时候还需要清理pyc文件。为了精简过程，使用Pycharm和Webstorm的Deployment工具，对每个前端和后端项目均做了设置，每次小改动后，只需右键并upload to xxx即可同步远程代码，十分方便。

展开全文 >>

pdfminer

遍历Pdf每一页

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
from pdfminer.converter import PDFPageAggregator
from pdfminer.pdfparser import PDFParser
from pdfminer.pdfdocument import PDFDocument
from pdfminer.pdfpage import PDFPage
from pdfminer.pdfpage import PDFTextExtractionNotAllowed
from pdfminer.pdfinterp import PDFResourceManager
from pdfminer.pdfinterp import PDFPageInterpreter
from pdfminer.layout import *

fp = open('test.pdf', 'rb')
parser = PDFParser(fp)
document = PDFDocument(parser, '')

if not document.is_extractable:
    raise PDFTextExtractionNotAllowed
rsrcmgr = PDFResourceManager(caching = False)
laparams = LAParams()
device = PDFPageAggregator(rsrcmgr, laparams=laparams)
interpreter = PDFPageInterpreter(rsrcmgr, device)
for page in PDFPage.create_pages(document):
    interpreter.process_page(page)
    layout = device.get_result()  
    for x in layout:  
        if(isinstance(x, LTTextBoxHorizontal)):  
            print(len(x.get_text()))

获取pdf目录

1
2
3
4
5
6
7
8
9
10
from pdfminer.pdfparser import PDFParser
from pdfminer.pdfdocument import PDFDocument

fp = open('test.pdf', 'rb')
parser = PDFParser(fp)
document = PDFDocument(parser, '')

outlines = document.get_outlines()
for (level,title,dest,a,se) in outlines:
        print(level, title)

展开全文 >>

xlsxwriter

hello

  • 将文本写入单元格
1
2
3
4
5
6
7
8
import xlsxwriter

workbook = xlsxwriter.Workbook('hello.xlsx')
worksheet = workbook.add_worksheet()

worksheet.write('A1', 'Hello world')

workbook.close()

simple xlsx

  • 生成简单的excel文件
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
import xlsxwriter

workbook = xlsxwriter.Workbook('Expenses01.xlsx')
worksheet = workbook.add_worksheet()

expenses = (
    ['Rent', 1000],
    ['Gas', 100],
    ['Food', 300],
    ['Gym', 50]
    )

row = 0
col = 0

for item, cost in expenses:
    worksheet.write(row, col, item)
    worksheet.write(row, col + 1, cost)
    row += 1

worksheet.write(row, 0, 'Total')
worksheet.write(row, 1, '=SUM(B1:B4)')

workbook.close()

formatting

  • 生成带格式的excel文件
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
import xlsxwriter

workbook = xlsxwriter.Workbook('Expenses02.xlsx')
worksheet = workbook.add_worksheet()

bold = workbook.add_format({'bold' : True})

money = workbook.add_format({'num_format': '$#,##0'})

worksheet.write('A1', 'Item', bold)
worksheet.write('B1', 'Cost', bold)

expenses = (
    ['Rent', 1000],
    ['Gas', 100],
    ['Food', 300],
    ['Gym', 50]
)

row = 1
col = 0

for item, cost in expenses:
    worksheet.write(row, col, item)
    worksheet.write(row, col + 1, cost, money)
    row += 1;

worksheet.write(row, 0, 'Total', bold)
worksheet.write(row, 1, '=SUM(B2:B5)', money)

workbook.close()

types of data

  • 其它数据类型
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
import xlsxwriter
from datetime import datetime

workbook = xlsxwriter.Workbook('Expenses03.xlsx')
worksheet = workbook.add_worksheet()

bold = workbook.add_format({'bold' : True})

money = workbook.add_format({'num_format': '$#,##0'})

date_format = workbook.add_format({'num_format': 'mmmm d yyyy'})

worksheet.set_column(1, 1, 15)

worksheet.write('A1', 'Item', bold)
worksheet.write('B1', 'Date', bold)
worksheet.write('C1', 'Cost', bold)

expenses = (
    ['Rent','2013-01-13', 1000],
    ['Gas','2013-01-13', 100],
    ['Food','2013-01-13', 300],
    ['Gym','2013-01-13', 50]
)

row = 1
col = 0

for item, date_str, cost in expenses:
    date = datetime.strptime(date_str, "%Y-%m-%d")
    worksheet.write(row, col, item)
    worksheet.write(row, col + 1, date, date_format)
    worksheet.write(row, col + 2, cost, money)
    row += 1;

worksheet.write(row, 0, 'Total', bold)
worksheet.write(row, 2, '=SUM(B2:B5)', money)

workbook.close()

展开全文 >>

tag:

    缺失模块。
    1、请确保node版本大于6.2
    2、在博客根目录（注意不是yilia根目录）执行以下命令：
    npm i hexo-generator-json-content --save

    3、在根目录_config.yml里添加配置： 

      jsonContent:
    meta: false
    pages: false
    posts:
      title: true
      date: true
      path: true
      text: false
      raw: false
      content: false
      slug: false
      updated: false
      comments: false
      link: false
      permalink: false
      excerpt: false
      categories: false
      tags: true

那年二十七