資源描述：
《js操作excel常用方法》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫(kù)。
1、Js操作Excel常用方法1.創(chuàng)建一個(gè)新Excel表格????varXLObj=newActiveXObject("Excel.Application");????varxlBook=XLObj.Workbooks.Add;?????????????????????????//新增工作簿????varExcelSheet=xlBook.Worksheets(1);???????????????????//創(chuàng)建工作表2.保存表格????ExcelSheet.SaveAs("C:\TEST.XLS");3.使?Excel?通過(guò)Application?對(duì)象可見(jiàn)????ExcelShe
2、et.Application.Visible=true;4.打印????xlBook.PrintOut;????或者:????ExcelSheet.PrintOut;5.關(guān)閉????xlBook.Close(savechanges=false);????或者:????ExcelSheet.Close(savechanges=false);6.結(jié)束進(jìn)程????ExcelSheet.Application.Quit();????或者:????XLObj.Quit();????XLObj=null;functionendXlsObj(){????????oXL.UserControl=
3、true;???????oXL=null;???????oWB=null;???????activeSheet=null;???????//結(jié)束excel進(jìn)程，退出完成????idTmr=window.setInterval("Cleanup();",1);}functionCleanup(){????window.clearInterval(idTmr);????CollectGarbage();}?7.頁(yè)面設(shè)置????ExcelSheet.ActiveSheet.PageSetup.Orientation=2;????ExcelSheet.ActiveSheet.PageSe
4、tup.LeftMargin=2/0.035;?????????//頁(yè)邊距左2厘米????ExcelSheet.ActiveSheet.PageSetup.RightMargin=3/0.035;??????//頁(yè)邊距右3厘米，????ExcelSheet.ActiveSheet.PageSetup.TopMargin=4/0.035;????????//頁(yè)邊距上4厘米，????ExcelSheet.ActiveSheet.PageSetup.BottomMargin=5/0.035;???//頁(yè)邊距下5厘米????ExcelSheet.ActiveSheet.PageSetup
5、.HeaderMargin=1/0.035;???//頁(yè)邊距頁(yè)眉1厘米????ExcelSheet.ActiveSheet.PageSetup.FooterMargin=2/0.035;????//頁(yè)邊距頁(yè)腳2厘米????ExcelSheet.ActiveSheet.PageSetup.CenterHeader="頁(yè)眉中部?jī)?nèi)容";????ExcelSheet.ActiveSheet.PageSetup.LeftHeader="頁(yè)眉左部?jī)?nèi)容";????ExcelSheet.ActiveSheet.PageSetup.RightHeader="頁(yè)眉右部?jī)?nèi)容";????ExcelShe
6、et.ActiveSheet.PageSetup.LeftFooter="頁(yè)腳左部?jī)?nèi)容";????ExcelSheet.ActiveSheet.PageSetup.RightFooter="頁(yè)腳右部?jī)?nèi)容";????????????ExcelSheet.ActiveSheet.PageSetup.CenterHeader="&"宋體,加粗"&18長(zhǎng)天公司"+date1+"至"+date2+"(施工圖)項(xiàng)目進(jìn)度檢查表";????ExcelSheet.ActiveSheet.PageSetup.RightHeader="&D";????ExcelSheet.ActiveSheet.
7、PageSetup.PrintGridlines=true;????ExcelSheet.ActiveSheet.PageSetup.PrintTitleRows="$1:$1";????ExcelSheet.ActiveSheet.PageSetup.Zoom=75;8.對(duì)單元格操作，帶*部分對(duì)于行，列，區(qū)域都有相應(yīng)屬性????ExcelSheet.ActiveSheet.Cells(row,col).Value="內(nèi)容";????????????????//設(shè)置單元格內(nèi)容??
