excel实用技巧

生成多个随机ip

=ROUND(RAND()*255,0)&"."&ROUND(RAND()*255,0)&"."&ROUND(RAND()*255,0)&"."&ROUND(RAND()*255,0)
生成固定格式的请求get代码

传输文件linux

scp system_mange_service_x86_64  root@10.11.4.66:/adcloud/modules/system_manage_service/restapi

配置临时gopath

gopath=/virtual_workspace/adicpip_beian/dev/thirdparty
gopath=$gopath:/virtual_workspace/adicpip_beian/dev/adcloud/modules/icp_service
gopath=$gopath:/virtual_workspace/adicpip_beian/dev/adcloud/modules/system_manage_service
export GOPATH=$gopath

多个字段复读不一样

="string.get"&"("&""""&A1&""""&")"