Shulou(Shulou.com)06/02 Report--

This article mainly introduces how to use Jscript to prepare EXCEL export, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Function exportexcel ()

{

Var iSubjectNum,iElementNum

Var sText

Var iX=1

Var iY=2

Var xlsub

/ / alert ('export')

IniExcel ()

XlApp.visible=false

If (fso.FileExists (sExcelPath) = = true) {

Xlsub=xlApp.Application.Workbooks.Open (sExcelPath)

/ / alert (xlsub)

/ / xlsub=xlApp.Application.Worksheets (ipage)

}

Else {

XlApp.Workbooks.Add ()

/ / xlsub=xlApp.Application.Worksheets (1)

/ / ipage=1

}

Var sheetcount=xlApp.Application.Worksheets.Count

Var addcount=ipage-sheetcount

If (addcountaccountroom0) {

For (var mechatronic xlApp.Application.Worksheets.Add ()

}

/ / do you want to know how to use the SHEET of your client?

Var bFlag=false

Var isheetpos=-1

For (var nasty 1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.