# 使用单元格格式化事件
```python
import clr
clr.AddReference("System")
clr.AddReference("System.Core")
clr.AddReference("Kingdee.BOS")
clr.AddReference("Kingdee.BOS.Core")
clr.AddReference("Kingdee.BOS.Contracts")
from Kingdee.BOS.Util import *
from Kingdee.BOS.Core.Report.PlugIn.Args import *
from Kingdee.BOS.Core.Report.PlugIn import *
from System import *
from System.ComponentModel import *
from System.Linq import *
from Kingdee.BOS.Util.StringUtils import *
def FormatCellValue(e):
if e.Header.Key.Equals("FSTOCKPOSNUMBER", StringComparison.OrdinalIgnoreCase):#改成基础资料的标识
e.FormateValue = e.DataRow["F_StockNumber"].ToString()+"-" +GetFormatString(e.DataRow["FSTOCKPOSNUMBER"].ToString());
def GetFormatString(value):
str = "";
i=0;
if value == "":
return str;
if len(value.split(';')) > 0:
for CWBM_1 in value.strip(';').split(';'):
if len(CWBM_1.split(':')) > 0:
if i==0:
str = str + CWBM_1.split(':')[1] ;
i=i+1;
else:
str = str + CWBM_1.split(':')[1] + "-";
i=i+1;
return str.strip('-');
```
---
# 部署
# 最终效果
# 简单的python开发集合
### [记录一下python简单的插件开发- beforef7select&基础资料组织 列表只显示用户拥有的组织权限](https://wenku.my7c.com/article/432506265244103680?productLineId=1)
### [记录一下python简单的插件开发- 单元格格式化事件&物料收发汇总格式化仓位编码](https://wenku.my7c.com/article/432502474717361152?productLineId=1)
### [记录一下python简单的插件开发- 菜单按钮事件（表体菜单按钮事件）执行SQL语句](https://wenku.my7c.com/article/433286928398603520)
### [python插件 - 动态 简单账表 通过SQL存储过程输出列实现动态展示](https://wenku.my7c.com/article/433709738048508160?productLineId=1):triangular_flag_on_post:
### [Python插件 - 将生产订单二开字段携带至下级订单上](https://wenku.my7c.com/article/434474741080938240?productLineId=1) :new:
### [Python插件 - 单据转换插件-WebApi下推单据 自定义入参插件](https://wenku.my7c.com/article/445155491019305984?fromAction=POST_ARTICLE&productLineId=1) :pushpin:
### [简单Python插件 - 点击菜单弹窗动态表单录入数据返回父窗体](https://wenku.my7c.com/article/449987803519330560?productLineId=1) :pushpin:
### [Python插件 - 【服务插件】取文本字段值赋值基础资料字段](https://wenku.my7c.com/article/453951446166029312?productLineId=1)
### [Python插件 - 保存、审核、提交 发送请求传输至第三方系统](https://wenku.my7c.com/article/452432069977609216?productLineId=1)
