推荐链接
Excel
//批量添加字段
="ALTER table 表名 add "&A1&""
//批量向表中添加数据
="INSERT INTO 表名 ([字段名称一], [字段名称二], [字段名称三]) VALUES ('', '"&B4&"' ,'');"
//切换一列的值
="array('"&B1&"','"&A1&"'),"
="{field:'"&A1&"', title: '"&B1&"', fixed: 'left', width: 100},"
//列前面补0 (有多少位就填多少个0)
=TEXT(A2,"00")
//横向生成公式(向右拖动鼠标进行填充A到XFD
=MID(CELL("address",A:A),2,FIND("$",CELL("address",A:A),2)-2)