this.p={ m:2,
b:2,
loftPermalink:'',
id:'fks_080066092083081074081083085095085084082067087095082068085',
blogTitle:'Excel宏运行于所有sheet工作表(示例-字母大小写转换)',
blogAbstract:'本文链接:http://oicu.cc.blog.163.com/blog/static/123039471201021713632919/Excel不像Word有字母大小写转换的功能,那要怎样进行转换呢?
用Upper、Lower、Proper函数?显然那不是所要的功能。
其实很简单,替换即可,但是26次替换操作太麻烦,录制宏要方便一些,
而且以后还可以再次使用。',
blogTag:'',
blogUrl:'blog/static/123039471201021713632919',
isPublished:1,
istop:false,
type:0,
modifyTime:1316861584183,
publishTime:1268804192919,
permalink:'blog/static/123039471201021713632919',
commentCount:0,
mainCommentCount:0,
recommendCount:0,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
vote:{},
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
mcon:'',
srk:-100,
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'一河两寺三桥四川大学',
hmcon:'1',
selfRecomBlogCount:'0',
lofter_single:''
}
{list a as x}
{if !!x}
{if x.visitorName==visitor.userName}
{else}
{/if}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
{/if}
${fn(x.visitorNickname,8)|escape}
{/if}
{/list}
{if !!a}
${fn(a.nickname,8)|escape}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{/if}
{list a as x}
{if !!x}
推荐过这篇日志的人:
{list a as x}
{if !!x}
{if !!b&&b.length>0}
他们还推荐了:
{list b as y}
{if !!y}
{/if}
{list a as x}
{if !!x}
{list a as x}
{if !!x}
{list a as x}
{if !!x}
{list a as x}
{if x_index>4}{break}{/if}
{if !!x}
${fn1(x.title,60)|escape}${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{/if}
{/list}
{list a as x}
{if !!x}
{if !!(blogDetail.preBlogPermalink)}
网易新闻
${headlines.title|escape}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
被推荐日志
最新日志
该作者的其他文章
博主推荐
随机阅读
首页推荐
{list a as x}
{if !!x}
${x.nickName|escape} 投票给
{var first_option = true;}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if} “${b[voteToOption_index]}”
{/if}
{/list}
{if (x.role!="-1") },“我是${c[x.role]}” {/if}
${fn1(x.voteTime)}
{if x.userName==''}{/if}
{/if}
{/list}