📄 documentedit.jsp
字号:
for (var mIndex=1;mIndex<=webform.WebOffice.ActiveDocument.ActiveSheet.Shapes.Count;mIndex++){
var mValidString=webform.WebOffice.ActiveDocument.ActiveSheet.Shapes.Item(mIndex).AlternativeText;
if ((mValidString!=null)&&(mValidString.length!=0)){
if ((mValidString.indexOf("DBSTEP_2004")!=-1) && (mValidString.indexOf(webform.WebOffice.RecordID)!=-1)){
SignatureString=SignatureString+"\r\n"+mValidString.substring(12,mValidString.length);
}
}
}
}
}
if (SignatureString){
alert("印章列表如下:"+SignatureString);
}else{
alert("没有找到任何有效印章");
}
}catch(e){}
}
//是否显示工具栏
function ToolBars(Visible){
try{
webform.WebOffice.ToolBars=Visible;
}catch(e){}
}
//是否显示菜单栏
function MenuBar(Visible){
try{
webform.WebOffice.MenuBar=Visible;
}catch(e){}
}
//是否显示某种工具栏
function ToolsVisible(ToolName,Visible){
try{
webform.WebOffice.ActiveDocument.CommandBars(ToolName).Visible = Visible;
}catch(e){}
}
//是否允许某工具栏上的某工具有效
function ToolsEnable(ToolName,ToolIndex,Enable){
var i;
try{
for (i=1;i<=webform.WebOffice.ActiveDocument.CommandBars(ToolName).Controls.Count;i++){
if (webform.WebOffice.ActiveDocument.CommandBars(ToolName).Controls(i).id==ToolIndex){
webform.WebOffice.ActiveDocument.CommandBars(ToolName).Controls(i).Enabled = Enable;
break;
}
}
}catch(e){}
}
//设置是否保护
function Protect(value){
try{
if (value){
if (webform.WebOffice.FileType==".doc"){
webform.WebOffice.ActiveDocument.Protect(2);
}else if(webform.WebOffice.FileType=='.xls'){
for (var mIndex=1;mIndex<=webform.WebOffice.ActiveDocument.Application.ActiveWorkbook.Sheets.Count;mIndex++){
var mSheet=webform.WebOffice.ActiveDocument.Application.ActiveWorkbook.Sheets(mIndex);
mSheet.Protect("", true, true, true);
}
}
}else{
if (webform.WebOffice.FileType==".doc"){
webform.WebOffice.ActiveDocument.UnProtect();
}else if(webform.WebOffice.FileType=='.xls'){
for (var mIndex=1;mIndex<=webform.WebOffice.ActiveDocument.Application.ActiveWorkbook.Sheets.Count;mIndex++){
var mSheet=webform.WebOffice.ActiveDocument.Application.ActiveWorkbook.Sheets(mIndex);
mSheet.UnProtect("");
}
}
}
}catch(e){}
}
//取得Word内容
function GetWordContent(){
try{
alert(webform.WebOffice.ActiveDocument.Content.Text);
}catch(e){}
}
//取得解说内容
function GetModel(){
try{
alert("请与管理员联系此功能!");
}catch(e){}
}
//插入Word内容
function SetWordContent(){
var mText=window.prompt("请输入内容:","测试内容");
if (mText==null){
return (false);
}
else
{
//下面为显示选中的文本
//alert(webform.WebOffice.ActiveDocument.Application.Selection.Range.Text);
//下面为在当前光标出插入文本
webform.WebOffice.ActiveDocument.Application.Selection.Range.InsertAfter (mText+"\n");
//下面为在第一段后插入文本
//webform.WebOffice.ActiveDocument.Application.ActiveDocument.Range(1).InsertAfter(mText);
}
}
function IText(){
var mText=window.prompt("请输入内容:","测试内容");
if (mText==null){
return (false);
}
else
{
//下面为显示选中的文本
//alert(webform.WebOffice.ActiveDocument.Application.Selection.Range.Text);
//下面为在当前光标出插入文本
webform.WebOffice.ActiveDocument.Range(0,0).insertAfter(mText+"\n");
//webform.WebOffice.ActiveDocument.Application.Selection.Range.InsertAfter (mText+"\n");
//下面为在第一段后插入文本
//webform.WebOffice.ActiveDocument.Application.ActiveDocument.Range(1).InsertAfter(mText);
}
}
//设置并取得Excel的内容
function GetExcelContent(){
webform.WebOffice.ActiveDocument.Application.Sheets(1).Select;
webform.WebOffice.ActiveDocument.Application.Range("C5").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "126";
webform.WebOffice.ActiveDocument.Application.Range("C6").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "446";
webform.WebOffice.ActiveDocument.Application.Range("C7").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "556";
webform.WebOffice.ActiveDocument.Application.Range("C5:C8").Select;
webform.WebOffice.ActiveDocument.Application.Range("C8").Activate;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "=SUM(R[-3]C:R[-1]C)";
webform.WebOffice.ActiveDocument.Application.Range("D8").Select;
alert(webform.WebOffice.ActiveDocument.Application.Range("C8").Text);
}
//设置Excel页,并演示锁定相应栏目
function SheetsLock(){
webform.WebOffice.ActiveDocument.Application.Sheets(1).Select;
webform.WebOffice.ActiveDocument.Application.Range("A1").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "产品";
webform.WebOffice.ActiveDocument.Application.Range("B1").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "价格";
webform.WebOffice.ActiveDocument.Application.Range("C1").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "详细说明";
webform.WebOffice.ActiveDocument.Application.Range("D1").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "库存";
webform.WebOffice.ActiveDocument.Application.Range("A2").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "书签";
webform.WebOffice.ActiveDocument.Application.Range("A3").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "毛笔";
webform.WebOffice.ActiveDocument.Application.Range("A4").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "钢笔";
webform.WebOffice.ActiveDocument.Application.Range("A5").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "尺子";
webform.WebOffice.ActiveDocument.Application.Range("B2").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "0.5";
webform.WebOffice.ActiveDocument.Application.Range("C2").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "樱花";
webform.WebOffice.ActiveDocument.Application.Range("D2").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "300";
webform.WebOffice.ActiveDocument.Application.Range("B3").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "2";
webform.WebOffice.ActiveDocument.Application.Range("C3").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "狼毫";
webform.WebOffice.ActiveDocument.Application.Range("D3").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "50";
webform.WebOffice.ActiveDocument.Application.Range("B4").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "3";
webform.WebOffice.ActiveDocument.Application.Range("C4").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "蓝色";
webform.WebOffice.ActiveDocument.Application.Range("D4").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "90";
webform.WebOffice.ActiveDocument.Application.Range("B5").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "1";
webform.WebOffice.ActiveDocument.Application.Range("C5").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "20cm";
webform.WebOffice.ActiveDocument.Application.Range("D5").Select;
webform.WebOffice.ActiveDocument.Application.ActiveCell.FormulaR1C1 = "40";
//保护工作表
webform.WebOffice.ActiveDocument.Application.Range("B2:D5").Select;
webform.WebOffice.ActiveDocument.Application.Selection.Locked = false;
webform.WebOffice.ActiveDocument.Application.Selection.FormulaHidden = false;
webform.WebOffice.ActiveDocument.Application.ActiveSheet.Protect(true,true,true);
alert("已经保护工作表,只有B2-D5单元格可以修改。");
}
//VBA套红操作
function InsertVBA(){
//画线
var object=webform.WebOffice.ActiveDocument;
var myl=object.Shapes.AddLine(100,60,305,60)
myl.Line.ForeColor=255;
myl.Line.Weight=2;
var myl1=object.Shapes.AddLine(326,60,520,60)
myl1.Line.ForeColor=255;
myl1.Line.Weight=2;
//object.Shapes.AddLine(200,200,450,200).Line.ForeColor=6;
var myRange=webform.WebOffice.ActiveDocument.Range(0,0);
myRange.Select();
var mtext="★";
webform.WebOffice.ActiveDocument.Application.Selection.Range.InsertAfter (mtext+"\n");
var myRange=webform.WebOffice.ActiveDocument.Paragraphs(1).Range;
myRange.ParagraphFormat.LineSpacingRule =1.5;
myRange.font.ColorIndex=6;
myRange.ParagraphFormat.Alignment=1;
myRange=webform.WebOffice.ActiveDocument.Range(0,0);
myRange.Select();
mtext="帝龙发[2003]154号";
webform.WebOffice.ActiveDocument.Application.Selection.Range.InsertAfter (mtext+"\n");
myRange=webform.WebOffice.ActiveDocument.Paragraphs(1).Range;
myRange.ParagraphFormat.LineSpacingRule =1.5;
myRange.ParagraphFormat.Alignment=1;
myRange.font.ColorIndex=1;
mtext="帝龙电子政务文件";
webform.WebOffice.ActiveDocument.Application.Selection.Range.InsertAfter (mtext+"\n");
myRange=webform.WebOffice.ActiveDocument.Paragraphs(1).Range;
myRange.ParagraphFormat.LineSpacingRule =1.5;
//myRange.Select();
myRange.Font.ColorIndex=6;
myRange.Font.Name="仿宋_GB2312";
myRange.font.Bold=true;
myRange.Font.Size=50;
myRange.ParagraphFormat.Alignment=1;
//myRange=myRange=webform.WebOffice.ActiveDocument.Paragraphs(1).Range;
webform.WebOffice.ActiveDocument.PageSetup.LeftMargin=70;
webform.WebOffice.ActiveDocument.PageSetup.RightMargin=70;
webform.WebOffice.ActiveDocument.PageSetup.TopMargin=70;
webform.WebOffice.ActiveDocument.PageSetup.BottomMargin=70;
}
//保存定稿文件
function UpdateFile(){
try{
webform.WebOffice.UpdateFile();
if (webform.WebOffice.Error!=""){
alert(webform.WebOffice.Status+webform.WebOffice.Error);
}
}catch(e){}
StatusMsg(webform.WebOffice.Status);
}
//从服务器上导入数据到文档中
function InportText(){
var mText;
webform.WebOffice.SendToServer("INPORTTEXT");
if (webform.WebOffice.Error==""){
mText=webform.WebOffice.GetMsgByName("CONTENT");
webform.WebOffice.ActiveDocument.Application.Selection.Range.InsertAfter(mText);
alert("导入文本成功");
}
StatusMsg(webform.WebOffice.Status);
}
//导出所有文档文本给服务器
function ExportText(){
var mText=webform.WebOffice.ActiveDocument.Content.Text;
webform.WebOffice.SetMsgByName("CONTENT",mText);
webform.WebOffice.SendToServer("EXPORTTEXT");
if (webform.WebOffice.Error==""){
alert("导出文本成功");
}
StatusMsg(webform.WebOffice.Status);
}
//根据标签名称查找标签
function FindBookmarks(mPosition)
{
var mBookObject,mBookName,mBookIdx;
if (webform.WebOffice.FileType==".doc"){
for (mBookIdx = 1; mBookIdx<=webform.WebOffice.ActiveDocument.Bookmarks.Count;mBookIdx++){
mBookName = webform.WebOffice.ActiveDocument.Bookmarks.Item(mBookIdx).Name;
if (mBookName==mPosition) {
mBookObject = webform.WebOffice.ActiveDocument.Bookmarks.Item(mBookIdx).Range;
break;
}
}
}
return (mBookObject);
}
//插入服务器图片
function InsertImage(vLabName,vImgName,vTrans,vZOrder)
{
//取得文件目录
var mFilePath=webform.WebOffice.MsgFilepath;
var mImgShape=null;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -