Ping

发表于 更新于 分类于 本文字数： 116 阅读时长 ≈ 1 分钟

坑

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
// 这里定义的row的长度，超过这个长度导出异常
Workbook workbook = new SXSSFWorkbook(500);

import org.apache.poi.ss.usermodel.Sheet;
Sheet sheet = workbook.createSheet(sheetName);

// SXSSFWorkbook的SXSSFSheet没有实现合并单元格
// 此处为poi源码
@NotImplemented
@Override
public void shiftRows(int startRow, int endRow, int n)
{
    throw new RuntimeException("NotImplemented");
}

// 现改为
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.getSheetAt(0);

样式定义

1
2
3
4
5
6
7
8
9
10
11
12
// 边框
CellStyle defStyle = workbook.createCellStyle();
defStyle.setBorderTop(BorderStyle.THIN);
defStyle.setBorderLeft(BorderStyle.THIN);
defStyle.setBorderBottom(BorderStyle.THIN);
defStyle.setBorderRight(BorderStyle.THIN);
// 顶端对齐
CellStyle topStyle = workbook.createCellStyle();
// clone默认样式
topStyle.cloneStyleFrom(defStyle);
// 设置新的样式
topStyle.setVerticalAlignment(VerticalAlignment.TOP);

发表于 更新于 分类于 本文字数： 179 阅读时长 ≈ 1 分钟

hexo blog init

添加搜索组件

1
2
3
4
5
$ npm install hexo-cli -g
$ hexo init blog
$ cd blog
$ git clone https://github.com/theme-next/hexo-theme-next themes/next
$ npm install hexo-generator-searchdb --save

创建页面

1
2
3
4
5
$ hexo g -w
$ hexo server
$ hexo new page categories
$ hexo new page tags
$ hexo new page about

hexo配置

1
2
3
4
5
6
7
search:
  path: search.xml
  field: post
  format: html
  limit: 10000
# 图片资源
post_asset_folder: true

主题配置

1
2
3
4
5
6
7
8
9
10

local_search:
  enable: true
back2top:
  enable: true
  # Back to top in sidebar.
  sidebar: true
  # Scroll percent label in b2t button.
  scrollpercent: true
scheme: Gemini

图片资源

1
hexo new page
1
2
{% asset_img hexo.svg hexo %}
![hexo](hexo/hexo.jpg)

deploy

1
2
3
4
5
6
7
8
9
10
11
12
13
Example:
  deploy:
    type: sftp
    host: <host>
    port: [port] # Default is 21
    user: <user>
    pass: <pass> # leave blank for paswordless connections
    privateKey: [path/to/privateKey] # Optional
    passphrase: [passphrase] # Optional
    agent: [path/to/agent/socket] # Optional, defaults to $SSH_AUTH_SOCK
    remotePath: [remotePath] # Default is `/`
    forceUpload: [boolean] # default is false
    concurrency: [number] # Max number of SFTP tasks processed concurrently. Default to 100.