Python openpyxl 表示形式を設定する

```python
from openpyxl import Workbook
import datetime
```


```python
wb2 = Workbook()
```


```python
ws2 = wb2.active
```


```python #セルの表示形式の設定  #セルのnumber_formatプロパティに 、表示形式を表す文字列を設定する #例 ）ws['A1'].number_format = '#,##0'
```


```python
ws2['A1'] = 1234567
ws2['A1'].number_format = '#,##0'
ws2['A2'] = 0.123
ws2['A2'].number_format = '0.00%'
ws2['A3'] = datetime.datetime(2020,1,23,12,34,56)
ws2['A3'].number_format = u'yyyy年m月d日 hh時mm分ss秒'
wb2.save('numformat.xlsx')
```