| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> asp >> ASP cao zuo Excel ji shu zong jie

ASP cao zuo Excel ji shu zong jie

2008-08-27 06:58:26 编辑來源:互联网 评论
 
 
 
本文为【ASP操作Excel技术总结】的拼音翻译版
  mu lu
  yi 、 huan jing pei zhi
  er 、 ASP dui Excel de ji ben cao zuo
  san 、 ASP cao zuo Excel sheng cheng shu ju biao
  si 、 ASP cao zuo Excel sheng cheng Chart tu
  wu 、 fu wu qi duan Excel wen jian liu lan 、 xia zai 、 shan chu fang an
  liu 、 fu lu
  zheng wen
  yi 、 huan jing pei zhi
  fu wu qi duan de huan jing pei zhi cong shen kao zi liao shang kan , wei ruan xi lie de pei zhi ying gai dou xing , ji :
  1.Win9x+PWS+Office
  2.Win2000 Professional+PWS+Office
  3.Win2000 Server+IIS+Office
  mu qian bi zhe ce shi cheng gong de huan jing shi hou er zhe 。Office de ban ben mei you te shu yao qiu , kao lv dao ke hu ji pei zhi de bu que ding xing he xia jian rong te xing , jian yi fu wu qi duan Office ban ben bu yao tai gao , yi fang zhi ke hu ji xia zai hou wu fa zheng que xian shi 。
  fu wu qi duan huan jing pei zhi huan you liang ge ou ran de fa xian shi :
  1. bi zhe kai fa ji qi shang yuan lai zhuang you jin shan de WPS2002, jie guo Excel dui xiang chuang jian shi zhong chu xian wen ti , xie zai WPS2002 hou , cuo wu xiao shi 。
  2. bi zhe kai fa ASP dai ma xi huan yong FrontPage, jie guo fa xian ru guo FrontPage da kai ( fu wu qi duan ), dui xiang chuang jian chu xian bu wen ding xian xiang , shi er cheng gong shi er bu cheng gong 。 kuo zhan kao cha hou fa xian ,Office xi lie de ruan jian ru guo zai fu wu qi duan yun xing , ze Excel dui xiang de chuang jian hen nan cheng gong 。
  fu wu qi duan huan bi xu yao she zhi de yi dian shi COM zu jian de cao zuo quan xian 。 zai ming ling xing jian ru “DCOMCNFG”, ze jin ru COM zu jian pei zhi jie mian , xuan ze Microsoft Excel hou dian ji shu xing an niu , jiang san ge dan xuan xiang yi lv xuan ze zi ding yi , bian ji zhong jiang Everyone jia ru suo you quan xian 。 bao cun wan bi hou chong xin qi dong fu wu qi 。
  ke hu duan de huan jing pei zhi mei fa xian shen me te bie jiang jiu de di fang , zhi yao zhuang you Office he IE ji ke , ban ben tong yong de hao xiang dou ke yi 。
  er 、 ASP dui Excel de ji ben cao zuo
  1、 jian li Excel dui xiang
  set objExcelApp = CreateObject("Excel.Application")
  objExcelApp.DisplayAlerts = false bu xian shi jing gao
  objExcelApp.Application.Visible = false bu xian shi jie mian
  2、 xin jian Excel wen jian
  objExcelApp.WorkBooks.add
  set objExcelBook = objExcelApp.ActiveWorkBook
  set objExcelSheets = objExcelBook.Worksheets
  set objExcelSheet = objExcelBook.Sheets(1)
  3、 du qu yi you Excel wen jian
  strAddr = Server.MapPath(".")
  objExcelApp.WorkBooks.Open(strAddr & "\Templet\Table.xls")
  set objExcelBook = objExcelApp.ActiveWorkBook
  set objExcelSheets = objExcelBook.Worksheets
  set objExcelSheet = objExcelBook.Sheets(1)
  4、 ling cun Excel wen jian
  objExcelBook.SaveAs strAddr & "\Temp\Table.xls"
  5、 bao cun Excel wen jian
  objExcelBook.Save ( bi zhe ce shi shi bao cun cheng gong , ye mian bao cuo 。)
  6、 tui chu Excel cao zuo
  objExcelApp.Quit yi ding yao tui chu
  set objExcelApp = Nothing
  san 、 ASP cao zuo Excel sheng cheng shu ju biao
  1、 zai yi ge fan wei nei cha ru shu ju
  objExcelSheet.Range("B3:k3").Value = Array("67", "87", "5", "9", "7", "45", "45", "54", "54", "10")
  2、 zai yi ge dan yuan ge nei cha ru shu ju
  objExcelSheet.Cells(3,1).Value="Internet Explorer"
  3、 xuan zhong yi ge fan wei
  4、 dan yuan ge zuo bian hua cu xian tiao
  5、 dan yuan ge you bian hua cu xian tiao
  6、 dan yuan ge shang bian hua cu xian tiao
  7、 dan yuan ge xia bian hua cu xian tiao
  8、 dan yuan ge she ding bei jing se
  9、 he bing dan yuan ge
  10、 cha ru xing
  11、 cha ru lie
  si 、 ASP cao zuo Excel sheng cheng Chart tu
  1、 chuang jian Chart tu
  objExcelApp.Charts.Add
  2、 she ding Chart tu zhong lei
  objExcelApp.ActiveChart.ChartType = 97
  zhu : er wei zhe xian tu ,4; er wei bing tu ,5; er wei zhu xing tu ,51
  3、 she ding Chart tu biao ti
  objExcelApp.ActiveChart.HasTitle = True
  objExcelApp.ActiveChart.ChartTitle.Text = "A test Chart"
  4、 tong guo biao ge shu ju she ding tu xing
  objExcelApp.ActiveChart.SetSourceData objExcelSheet.Range("A1:k5"),1
  5、 zhi jie she ding tu xing shu ju ( tui jian )
  objExcelApp.ActiveChart.SeriesCollection.NewSeries
  objExcelApp.ActiveChart.SeriesCollection(1).Name = "=""333"""
  objExcelApp.ActiveChart.SeriesCollection(1).Values = "={1,4,5,6,2}"
  6、 bang ding Chart tu
  objExcelApp.ActiveChart.Location 1
  7、 xian shi shu ju biao
  objExcelApp.ActiveChart.HasDataTable = True
  8、 xian shi tu li
  objExcelApp.ActiveChart.DataTable.ShowLegendKey = True
  wu 、 fu wu qi duan Excel wen jian liu lan 、 xia zai 、 shan chu fang an
  liu lan de jie jue fang fa hen duo ,“Location.href=”,“Navigate”,“Response.Redirect” dou ke yi shi xian , jian yi yong ke hu duan de fang fa , yuan yin shi gei fu wu qi geng duo de shi jian sheng cheng Excel wen jian 。
  xia zai de shi xian yao ma fan yi xie 。 yong wang shang xian cheng de fu wu qi duan xia zai zu jian huo zi ji ding zhi kai fa yi ge zu jian shi bi jiao hao de fang an 。 ling wai yi zhong fang fa shi zai ke hu duan cao zuo Excel zu jian , you ke hu duan cao zuo fu wu qi duan Excel wen jian ling cun zhi ke hu duan 。 zhe zhong fang fa yao qiu ke hu duan kai fang bu an quan ActiveX kong jian de cao zuo quan xian , kao lv dao tong zhi mei ge ke hu jiang fu wu qi she zhi wei ke xin zhan dian de ma fan cheng du jian yi huan shi yong di yi ge fang fa bi jiao sheng shi 。
  shan chu fang an you san bu fen zu cheng :
  A: tong yi yong hu sheng cheng de Excel wen jian yong tong yi ge wen jian ming , wen jian ming ke yong yong hu ID hao huo SessionID hao deng ke que xin bu chong fu zi fu chuan zu cheng 。 zhe yang xin wen jian sheng cheng shi zi dong fu gai shang yi wen jian 。
  B: zai Global.asa wen jian zhong she zhi Session_onEnd shi jian ji fa shi , shan chu zhe ge yong hu de Excel zan cun wen jian 。
  C: zai Global.asa wen jian zhong she zhi Application_onStart shi jian ji fa shi , shan chu zan cun mu lu xia de suo you wen jian 。
  zhu : jian yi mu lu jie gou \Src dai ma mu lu \Templet mo ban mu lu \Temp zan cun mu lu
  liu 、 fu lu
  chu cuo shi Excel chu xian de si jin cheng chu xian shi yi jian hen tou teng de shi qing 。 zai mei ge wen jian qian jia shang “On Error Resume Next” jiang you zhu yu gai shan zhe zhong qing kuang , yin wei ta hui bu guan wen jian shi fou chan sheng cuo wu dou jian chi zhi xing dao “Application.Quit”, bao zheng mei ci cheng xu zhi xing wan bu liu xia si jin cheng 。【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
mu lu yi 、 huan jing pei zhi er 、 ASP dui Excel de ji ben cao zuo san 、 ASP cao zuo Excel sheng cheng shu ju biao si 、 ASP cao zuo Excel sheng cheng Chart tu wu 、 fu wu qi duan Excel wen jian liu lan 、 xia zai 、 shan chu fang an liu 、 fu lu zheng wen yi 、 huan jing pei zhi fu wu qi duan de huan jing pei zhi cong shen kao zi liao shang kan , wei ruan xi lie de pei zhi ying gai dou xing , ji : 1.Win9x+PWS+Office 2.Win2000 Professional+PWS+Office 3.Win2000 Server+IIS+Office mu qian bi zhe ce shi cheng gong de huan jing shi hou er zhe 。Office de ban ben mei you te shu yao qiu , kao lv dao ke hu ji pei zhi de bu que ding xing he xia jian rong te xing , jian yi fu wu qi duan Office ban ben bu yao tai gao , yi fang zhi ke hu ji xia zai hou wu fa zheng que xian shi 。 fu wu qi duan huan jing pei zhi huan you liang ge ou ran de fa xian shi : 1. bi zhe kai fa ji qi shang yuan lai zhuang you jin shan de WPS2002, jie guo Excel dui xiang chuang jian shi zhong chu xian wen ti , xie zai WPS2002 hou , cuo wu xiao shi 。 2. bi zhe kai fa ASP dai ma xi huan yong FrontPage, jie guo fa xian ru guo FrontPage da kai ( fu wu qi duan ), dui xiang chuang jian chu xian bu wen ding xian xiang , shi er cheng gong shi er bu cheng gong 。 kuo zhan kao cha hou fa xian ,Office xi lie de ruan jian ru guo zai fu wu qi duan yun xing , ze Excel dui xiang de chuang jian hen nan cheng gong 。 fu wu qi duan huan bi xu yao she zhi de yi dian shi COM zu jian de cao zuo quan xian 。 zai ming ling xing jian ru “DCOMCNFG”, ze jin ru COM zu jian pei zhi jie mian , xuan ze Microsoft Excel hou dian ji shu xing an niu , jiang san ge dan xuan xiang yi lv xuan ze zi ding yi , bian ji zhong jiang Everyone jia ru suo you quan xian 。 bao cun wan bi hou chong xin qi dong fu wu qi 。 ke hu duan de huan jing pei zhi mei fa xian shen me te bie jiang jiu de di fang , zhi yao zhuang you Office he IE ji ke , ban ben tong yong de hao xiang dou ke yi 。 er 、 ASP dui Excel de ji ben cao zuo 1、 jian li Excel dui xiang set objExcelApp = CreateObject("Excel.Application") objExcelApp.DisplayAlerts = false bu xian shi jing gao objExcelApp.Application.Visible = false bu xian shi jie mian 2、 xin jian Excel wen jian objExcelApp.WorkBooks.add set objExcelBook = objExcelApp.ActiveWorkBook set objExcelSheets = objExcelBook.Worksheets set objExcelSheet = objExcelBook.Sheets(1) 3、 du qu yi you Excel wen jian strAddr = Server.MapPath(".") objExcelApp.WorkBooks.Open(strAddr & "\Templet\Table.xls") set objExcelBook = objExcelApp.ActiveWorkBook set objExcelSheets = objExcelBook.Worksheets set objExcelSheet = objExcelBook.Sheets(1) 4、 ling cun Excel wen jian objExcelBook.SaveAs strAddr & "\Temp\Table.xls" 5、 bao cun Excel wen jian objExcelBook.Save ( bi zhe ce shi shi bao cun cheng gong , ye mian bao cuo 。) 6、 tui chu Excel cao zuo objExcelApp.Quit yi ding yao tui chu set objExcelApp = Nothing san 、 ASP cao zuo Excel sheng cheng shu ju biao 1、 zai yi ge fan wei nei cha ru shu ju objExcelSheet.Range("B3:k3").Value = Array("67", "87", "5", "9", "7", "45", "45", "54", "54", "10") 2、 zai yi ge dan yuan ge nei cha ru shu ju objExcelSheet.Cells(3,1).Value="Internet Explorer" 3、 xuan zhong yi ge fan wei 4、 dan yuan ge zuo bian hua cu xian tiao 5、 dan yuan ge you bian hua cu xian tiao 6、 dan yuan ge shang bian hua cu xian tiao 7、 dan yuan ge xia bian hua cu xian tiao 8、 dan yuan ge she ding bei jing se 9、 he bing dan yuan ge 10、 cha ru xing 11、 cha ru lie si 、 ASP cao zuo Excel sheng cheng Chart tu 1、 chuang jian Chart tu objExcelApp.Charts.Add 2、 she ding Chart tu zhong lei objExcelApp.ActiveChart.ChartType = 97 zhu : er wei zhe xian tu ,4; er wei bing tu ,5; er wei zhu xing tu ,51 3、 she ding Chart tu biao ti objExcelApp.ActiveChart.HasTitle = True objExcelApp.ActiveChart.ChartTitle.Text = "A test Chart" 4、 tong guo biao ge shu ju she ding tu xing objExcelApp.ActiveChart.SetSourceData objExcelSheet.Range("A1:k5"),1 5、 zhi jie she ding tu xing shu ju ( tui jian ) objExcelApp.ActiveChart.SeriesCollection.NewSeries objExcelApp.ActiveChart.SeriesCollection(1).Name = "=""333""" objExcelApp.ActiveChart.SeriesCollection(1).Values = "={1,4,5,6,2}" 6、 bang ding Chart tu objExcelApp.ActiveChart.Location 1 7、 xian shi shu ju biao objExcelApp.ActiveChart.HasDataTable = True 8、 xian shi tu li objExcelApp.ActiveChart.DataTable.ShowLegendKey = True wu 、 fu wu qi duan Excel wen jian liu lan 、 xia zai 、 shan chu fang an liu lan de jie jue fang fa hen duo ,“Location.href=”,“Navigate”,“Response.Redirect” dou ke yi shi xian , jian yi yong ke hu duan de fang fa , yuan yin shi gei fu wu qi geng duo de shi jian sheng cheng Excel wen jian 。 xia zai de shi xian yao ma fan yi xie 。 yong wang shang xian cheng de fu wu qi duan xia zai zu jian huo zi ji ding zhi kai fa yi ge zu jian shi bi jiao hao de fang an 。 ling wai yi zhong fang fa shi zai ke hu duan cao zuo Excel zu jian , you ke hu duan cao zuo fu wu qi duan Excel wen jian ling cun zhi ke hu duan 。 zhe zhong fang fa yao qiu ke hu duan kai fang bu an quan ActiveX kong jian de cao zuo quan xian , kao lv dao tong zhi mei ge ke hu jiang fu wu qi she zhi wei ke xin zhan dian de ma fan cheng du jian yi huan shi yong di yi ge fang fa bi jiao sheng shi 。 shan chu fang an you san bu fen zu cheng : A: tong yi yong hu sheng cheng de Excel wen jian yong tong yi ge wen jian ming , wen jian ming ke yong yong hu ID hao huo SessionID hao deng ke que xin bu chong fu zi fu chuan zu cheng 。 zhe yang xin wen jian sheng cheng shi zi dong fu gai shang yi wen jian 。 B: zai Global.asa wen jian zhong she zhi Session_onEnd shi jian ji fa shi , shan chu zhe ge yong hu de Excel zan cun wen jian 。 C: zai Global.asa wen jian zhong she zhi Application_onStart shi jian ji fa shi , shan chu zan cun mu lu xia de suo you wen jian 。 zhu : jian yi mu lu jie gou \Src dai ma mu lu \Templet mo ban mu lu \Temp zan cun mu lu liu 、 fu lu chu cuo shi Excel chu xian de si jin cheng chu xian shi yi jian hen tou teng de shi qing 。 zai mei ge wen jian qian jia shang “On Error Resume Next” jiang you zhu yu gai shan zhe zhong qing kuang , yin wei ta hui bu guan wen jian shi fou chan sheng cuo wu dou jian chi zhi xing dao “Application.Quit”, bao zheng mei ci cheng xu zhi xing wan bu liu xia si jin cheng 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
清凉一夏_清纯美丽
纯白色小礼服
靓丽可人儿_嘉嘉
我的女神_靓丽女生
主题摄影
贵州,让我欢喜,让我神伤。
莫干山
天平秋色
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有