asp讀取excel代碼(舉了四個(gè)excel不同實(shí)例應(yīng)用)

1、asp讀取excel代碼（舉了四個(gè) excel不同實(shí)例應(yīng)用）asp? a e ?excel ' ? ?(? u a ?excel2? i ?e a y o | o ?).txt37?3? e ?a?£?e - Y? ?，？. & 0 £ ?3?e ?e£?u ?' |? a - ?2? o u ?a a ?£ ?3? e ? e ? , £ ? i ? o u e ?e ?o D)o a ?£public property let createtype(byval val)if val <> 1 a

2、nd val <> 2 thencreatetype_ = 1 elsecreatetype_ = val end ifend propertypublic property let data(byval val)if not isarray(val) theninerr("± i e y?Ye 6 ?6 D?6 ')end ifexceldata = valend propertypublic property get savepath()savepath = savepath_end propertypublic property get usedt

3、ime()usedtime = usedtime_ end property publicpropertyletsheetname(byval val) if not isarray(val) then if val = "" theninerr("± i ?6 6 ?6 D?6end if titlefirstline = trueelse redim titlefirstline(ubound(val) dim ik_forik_ =0 to ubound(val)titlefirstline(ik_)=truenextend if sheetnam

4、e = valend propertypublicpropertyletsheettitle(byval val)if not isarray(val) then if val = "" thennerr(" ± i ± e i a6 6 ?6 D?6 ") end ifend if sheettitle_ = valend propertyrem ? i 2e e y?Yprivate sub checkdata()ifsavepath_ ="" thennerr("± £ '

5、; ?？2? u ?a?")ifnot isarray(sheetname_)thenifsheetname_ = "" theninerr(" ± i ?2?u ?a?")end ifif createtype_ = 2 thenif not isarray(exceldata)thenend ifinerr(nEyYO0Ee' ii6£-i»dOBI' O0Ee n)end ifexit sub end ifif isarray(sheetname_) then if not isarray (

6、sheettitle_) thenif sheettitle_ <> theninerr (n±i±eiaEedAODi6£-i6e±iAu2 »500 i")end ifend ifif not isarray (exceldata) then inerr(H±iEyYd0EeODi6n)if isarray(sheetname_) then if getarraydim(exceldata)<>1thennerr(" ± i e y?Y?6 ?6 D?6 £ ?e y

7、?Y?e ?' i ? o ? ?e o |?a o ?") elseif getarraydim(exceldata)<>2thennerr(" ± i e y?Y?e ?6 D?6 £ ?e y?Y?e ?' i ? o ? ?e o |?a?t") end if end sub rem e u 3e excel public function create() call checkdata() if not isnull(readpath_) thenexcelapp.workbooks.open(readpa

8、th_) elseexcelapp.workbooks.addend ifsetexcelbookexcelapp.activeworkbook setexcelsheetsexcelbook.worksheetsif createtype_ = 2 then dim ih_forih_ =0 toubound(exceldata) call setsheets(exceldata(ih_), ih_)nextexcelbook.saveas savepath_ usedtime_ formatnumber(timer usedtime_)*1000, 3) exit function end

9、 ifif isarray(sheetname_) thendim ikforubound(exceldata)iktocall createsheets(exceldata(ik_), ik_) next else call createsheets(exceldata, -1) end ifexcelbook.saveas savepath_usedtime_=formatnumber(timer-usedtime_)*1000, 3) end function private sub createsheets(byval data_, dataid_)dim spreadsheetdim

10、 tempsheettitledim temptitlefirstlineif dataid_<>-1 then ifdataid_>excelsheets.count - 1 thenexcelsheets.add()setspreadsheetexcelbook.sheets(l)elsesetspreadsheetexcelbook.sheets(dataid_ + 1)end ififisarray(sheettitle_)thentempsheettitle sheettitle_(dataid_)else tempsheettitle =""e

11、nd iftemptitlefirstline titlefirstline(dataid_) sheetname_(dataid_) elsesetspreadsheetexcelbook.sheets(l)sheetname_tempsheettitlesheettitle_temptitlefirstlinetitlefirstlineend ifdim line_ : line_ = 1dim rownum_ : rownum_ubound(data_, 1) + 1dim lastcols_if tempsheettit

12、le <> "" thenspreadsheet.columns(1).shrinktofio D?Gi ¥t=truee e ?, e ? ?X?- e e o | ± i ? 以 ¥ ?a ? i 2?±?£?lastcols_getcolname(ubound(data_, 2) + 1)with spreadsheet.cells(1,1).valuetempsheettitle;usijuu6!|e|e;uozuoq"c V 。乙£ 不乙乙q X 66 ? 5 J = X9pUU0|

13、00J0U9；Ur,(Q 9 CiC X d )666 X 71 0 乙乙。 sBjsiju"(J愚-s|oo;se|i.e.JsBuejjssqspesjds!mq;i/v pus6 5 X。？乙乙乙丁 _9 566 CCCJC CCC CXCCCCC 天石乙乙 W 3=X9pUU0|00；U0;|,16 I 6X6666 X 66,Z I6d.=9eu ;uoj-606X6666天寸乙乙Z 03=9ZIS；U0J-+GCCC I 6X6666 X E3S|EJ =例網(wǎng)UOJ6 66 16X666 X 引am; =pioqjuoj"6 I 6X6 6 P I + 190X

14、966 W V.end withline = 2 rownum_ = rownum_ + 1end ifdim irow_, icol_dim drow_, dcol_dimtemplastrange2)+1)&templastrange getcolname(ubound(data_, (rownum_)dim beginrow : beginrow = 1 if tempsheettitle <> "" then beginrow = beginrow + 1if temptitlefirstline = true then beginrow = b

15、eginrow + 1if beginrow=1 then withspreadsheet.range("a1:"& templastrange).borders.linestyle = 1.borderaround-4138 ' e e ? i a? o-4119,.numberformatlocal"" '? ± ? e ?.font.bold = false.font.italic = false.font.size = 10.shrinktofit=trueend withelsewithspreadsheet.

16、range("a1:"&templastrange).borders.linestyle = 1.borderaround-4119,-4138.shrinktofit=trueend with withspreadsheet.range("a"&beginrow&":"& templastrange).numberformatlocal"".font.bold = false.font.italic = false .font.size = 10 end with end ifif

17、 temptitlefirstline = truethenbeginrow = 1iftempsheettitle <> "then beginrow = beginrow + 1withspreadsheet.range("a"&beginrow&":"& getcolname(ubound(data_, 2)+1) & (beginrow) .numberformatlocal"" .font.bold = true .font.italic = false.font.siz

18、e = 12 .interior.colorindex37 .horizontalalignment3 '? o ?D.font.colorindex=2 end withend iffor irow_ = line_ to rownum_foricol_ =1 to(ubound(data_, 2) + 1) dcol_ = icol_ - 1 iftempsheettitle <> ""then drow_ = irow_ - 2 else drow_ = row_ - 1ifnotsnull(data_(drow_, dcol_) thenwith

19、spreadsheet.cells(irow_, icol_) .valuedata_(drow_, dcol_)end withend if next next set spreadsheet = nothing end subrem 2a e ?X e ?t e ? ? o ?- ° 2X°privatefunctionsobjinstalled(strclassstring) on error resume next isobjinstalled = false err = 0 dim xtestobj setxtestobjserver.createobject(s

20、trclassstring )if 0 = err then isobjinstalled =trueset xtestobj = nothing err = 0end functionrem 6 ? ?6 yX 6 ?6 yprivatefunctiongetarraydim(byval arr) getarraydim = null dim i_, temp if isarray(arr) then for i_ = 1 to 60 on error resume next temp = ubound(arr, i_) iferr.number <> 0 thengetarra

21、ydim= i_ - 1err.clear exit functionend ifnextgetarraydim = i_end ifend functionclass createexcelprivate createtype_ private savepath_ private readpath_private authorstr reme e ?X + ?private versionstr reme e ?° ?士?private systemstr reme e ? ti i 3?3?private sheetname_ rem e e ?± i ?private

22、 sheettitle_ reme e ?± e i aprivate exceldata reme e ?± i e y?Yprivate excelapp remexcel.applicationprivate excelbookprivate excelsheetsprivate usedtime_ reme16?ti?e±?public titlefirstline reme X DD6 ? - ?± e i aprivate sub class_initialize() server.scripttimeout = 99999usedtime_ = timer systemstr "lc00_createexcelserver" authorstr 'surnfu surnfu 31333716” versionstr "1.0"ifnotsobjinstalled("excel.application