#6.批量创建工作簿
function 批量创建工作簿(){ for(var city of ["成都","上海","北京"]){ Workbooks.Add(); ActiveWorkbook.SaveAs("F:\\JavaScriptworkbook\\"+city); //增加工作表时,直接 //ActiveWorkbook.SaveAs=("F:/JavaScriptworkbook/") 路径也可以写成这种格式 ActiveWorkbook.Close(); } }
Powered by: 博客园 Copyright © 2024 蓝绝 Powered by .NET 9.0 on Kubernetes