ms¾ÍÊÇÏë×Ô¼º¸ãÌ×±ê×¼³öÀ´
È»ºóÇ¿ÆÈ´ó¼Ò¶¼À´½ÓÊÜËûµÄ±ê×¼
È»ºó¸ãµÃÈ˼Òû»î·
·´ÕýmsÓÐÇ®ÏëÔõô¸ã¾ÍÄÜÔõô¸ã


ÔÚ06-11-7£¬Nicholas Pan <xdada280在gmail.com> дµÀ£º
>
>
> > ÁíÍâ, ºÜ¶àÈ˶¼Ì¸µ½±ê×¼µÄÎÊÌâ, ±ê×¼, ÄѵÀ IE ûÓÐ×ñÑ­W3C ±ê×¼? Ö»ÓÐ FF ×ñÑ­?
> >
>
> ΢ÈíÒ»¹áϲ»¶Åª³ö×Ô¼ºµÄÒ»Ì×±ê×¼  ¶ø²»ÊÇ×ñÑ­±ðÈ˵ıê×¼£¬Àý×ÓÂú´ó½Ö¶¼ÊÇ£¬ÎҾͲ»¾ÙÁË
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20061108/0104de96/attachment.html 

头太晕 写道:
> 不用IE有两个原因,第一是针对IE的流氓软件太多了.第二是使用习惯问题,我就觉 
> 得用firefox习惯了,用IE有点不顺手...
> 仅仅代表我个人的看法...
> 
> 不过讨论这个东西实在有点跑题了...
> 我就是想用免费的东西,不想用收费的.万一windows真的没有盗版了.我肯定买不起 
> 正版的.当然,我的电脑上有正版本的XP,但是以后出了新版的,我也不能用,岂不是 
> 很郁闷?隔几年就出一个新版的WINDOWS,每次都要花钱买,不用新版的,又不能使用 
> 那些新特性..想想都觉得郁闷...
> 
> 虽然我现在还在用盗版的windows,但是不得不为将来考虑...中国的法律会越来越 
> 健全的,迟早有一天就不能用盗版了...
> 
> 2006/11/7, IQDoctor <huanghao.c在gmail.com huanghao.c在gmail.com>>:
> 
>     嘿嘿, FF 的显示效果我就不说了.. 兼容性. IE 能显示W3C标准的和非标准的,
>     估计这个 FF 无能为力吧.
> 
>     "网页只不过目前都是按非标准的IE来做才能显示出IE的"兼容性"来。"
>     这句话我非常的不同意.
>     自动纠正一些 HTML 的错误,并显示正确的结果,这是缺点么? 不是 IE 强迫大家去
>     写非标准的 HTML 的吧.
> 
>     至于 DOM, 其他我不知道, 但单从XMLDOM 来说,我认为 M$ 的W3C建议的DOM实现
>     是最方便的.以前用过很多 DOM 解释库, 但是自从用过 NET 的 DOM 库,我都
>     不想用
>     别的了. IE 支持的很多东西FF目前是无法做到的. M$ 早在 IE 4. X 时代就
>     内制支持了.
>     我不认为 M$ 的工程师比 FF 的工程师无能. 写不出一个这样的库来. 至少
>     DOM 的解释,
>     在 FF 还没出世的时候, M$ 已经做得很好了.
> 
>     JS 的实现, 我不知道也不好发表任何看法, 总之我到目前没有碰到过IE 的
>     JS 解释器 bug, 无论是 JAVASCRIPT 还是JS/JS.NET
> 
> 
>     fdcn 写道:
>>     呵呵，我偏要反驳你一下，"页面绘制,显示效果"和FF相比，我认为不相仲
>>     伯，但说到"兼容性"，我不认为是多大的优点，网页只不过目前都是按非标
>>     准的IE来做才能显示出IE的"兼容性"来。
>>
>>     建议你做一下网页的开发（DOM，js),你就会发现IE的实现有多差，到处都
>>     是bug,比如盒模型、CSS标准支持、DOM的支持等等，是所有现代浏览器中最
>>     差的一个。IE７也没有多大的改善。
>>
>>     On 11/7/06, *IQDoctor* <huanghao.c在gmail.com
>>     huanghao.c在gmail.com>> wrote:
>>
>>         IE 还是很好的, 单从页面绘制,显示效果,兼容性来看, 哪个浏览器比它好?
>>
>>         我只在 linux 下用 非 IE 浏览器. 除了安全性之外, firefox 等浏览器和
>>         IE 没什么可比性(我并不是说firefox这些东西就安全, 盛行之后他一
>>         样不安全)
>>
>>         嘿嘿~ 有意见千万不要反驳我喔..当我没说
>>
>>         Xupeng Yun 写道:
>>>         在06-11-7，*lu_zi_2000* < lu_zi_2000在163.com
>>>         lu_zi_2000在163.com>> 写道：
>>>
>>>             这个还好说吧，如果大家都不用ＩＥ了银行不得想个办法吗
>>>
>>>
>>>         我使用linux有五年了，做为日常和开发使用也足有两年，我可谓是
>>>         linux的坚决拥护者，但我仍然觉得让大家都不用IE是不现实的，sigh。
>>>
>>>         -- 
>>>         I like Python & Linux.
>>>         Blog: http://recordus.cublog.cn
>>>         ------------------------------------------------------------------------
>>>
>>>         _______________________________________________
>>>         python-chinese
>>>         Post: send python-chinese在lists.python.cn
>>>
>>>          python-chinese在lists.python.cn>
>>>         Subscribe: send subscribe to python-chinese-request在lists.python.cn python-chinese-request在lists.python.cn>
>>>         Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn python-chinese-request在lists.python.cn>
>>>         Detail Info: http://python.cn/mailman/listinfo/python-chinese
>>
>>
>>         _______________________________________________
>>         python-chinese
>>         Post: send python-chinese在lists.python.cn
>>         python-chinese在lists.python.cn>
>>         Subscribe: send subscribe to
>>         python-chinese-request在lists.python.cn
>>         python-chinese-request在lists.python.cn>
>>         Unsubscribe: send unsubscribe to  
>>         python-chinese-request在lists.python.cn
>>         python-chinese-request在lists.python.cn>
>>         Detail Info: http://python.cn/mailman/listinfo/python-chinese
>>
>>
>>     ------------------------------------------------------------------------
>>
>>     _______________________________________________
>>     python-chinese
>>     Post: send python-chinese在lists.python.cn
>>      python-chinese在lists.python.cn>
>>     Subscribe: send subscribe to python-chinese-request在lists.python.cn python-chinese-request在lists.python.cn>
>>     Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn python-chinese-request在lists.python.cn>
>>     Detail Info: http://python.cn/mailman/listinfo/python-chinese
> 
> 
>     _______________________________________________
>     python-chinese
>     Post: send python-chinese在lists.python.cn
>     python-chinese在lists.python.cn>
>     Subscribe: send subscribe to python-chinese-request在lists.python.cn
>     python-chinese-request在lists.python.cn>
>     Unsubscribe: send unsubscribe to  
>     python-chinese-request在lists.python.cn
>     python-chinese-request在lists.python.cn>
>     Detail Info: http://python.cn/mailman/listinfo/python-chinese
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
同意。其实很多都是使用习惯问题，即满足自己使用，又不受侵权的困扰，何乐而
不为。

麦田守望者 写道:
> 现在好像没有网上银行系统能够在非ie浏览器中运行。
>
>   
好像听说汇丰那些银行的网银就不用ActiveX

¿ÉÊÇ.ÎÒÃdz£ÓõŤÉÌÒøÐÐ,½¨ÉèÒøÐÐ,ÕÐÉÌÒøÐÐ,ÃñÉúÒøÐеȵÈ.¶¼ÊÇactivex

²»¹ý.ÖйúÒøÐкÃÏñ²»ÓÃactivex

2006/11/9, Nickcheng <nick.maillist在gmail.com>:
>
> ÂóÌïÊØÍûÕß Ð´µÀ:
> > ÏÖÔÚºÃÏñûÓÐÍøÉÏÒøÐÐϵͳÄܹ»ÔÚ·Çieä¯ÀÀÆ÷ÖÐÔËÐС£
> >
> >
> ºÃÏñÌý˵»ã·áÄÇЩÒøÐеÄÍøÒø¾Í²»ÓÃActiveX
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20061109/0d4c73db/attachment.htm 

On 11/9/06, Í·Ì«ÔÎ <super852在gmail.com> wrote:
>
> ¿ÉÊÇ.ÎÒÃdz£ÓõŤÉÌÒøÐÐ,½¨ÉèÒøÐÐ,ÕÐÉÌÒøÐÐ,ÃñÉúÒøÐеȵÈ.¶¼ÊÇactivex
>
> ²»¹ý.ÖйúÒøÐкÃÏñ²»ÓÃactivex
>
> 2006/11/9, Nickcheng <nick.maillist在gmail.com>:
> >
> > ÂóÌïÊØÍûÕß Ð´µÀ:
> > > ÏÖÔÚºÃÏñûÓÐÍøÉÏÒøÐÐϵͳÄܹ»ÔÚ·Çieä¯ÀÀÆ÷ÖÐÔËÐС£
> > >
> > >
> > ºÃÏñÌý˵»ã·áÄÇЩÒøÐеÄÍøÒø¾Í²»ÓÃActiveX
> >
>
Õâ¸öÌÖÂ۾͵½´ËλÖðÉ, ÅÜÌâÅÜÀÏÔ¶ÁË

ÒªÌÖÂÛIE¼æÈÝÐÔ¿ÉÒÔ¿ªÐÂÌù

-- 
simple is good
http://brucewang.net
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20061109/2af89943/attachment.html 

程序源碼如下，主要作用從 SQL Server 數據庫中取出數據放入 Excel 中，然後由第三方客戶端讀取 Excel 工作表，我只知道第三方客戶端是用 Delphi 寫的。現在的問題就是生成的 Excel 文檔第三方客戶端不能讀取，如果重新給工作表命名，就可以讀取數據。看了下 pyExcelerator 的例子，都是這麽寫的，用 pyExcelerator 的例子生成的文件也不能讀取，必須給工作表重新命名，即使前後兩次名字一樣，只要重新命名就可以讀取，頭都大了，剛學 Python，看不到問題出在哪裏。誰有空，幫忙看下，謝謝！

# -*- coding: utf-8 -*-

import pymssql
import os
import sys
import decimal
from pyExcelerator import *
from time import *

filepath = os.path.dirname(sys.argv[0])

query = "exec GetSPCData"

while 1:         
    con = pymssql.connect(host = "xxxxx", user = "xxxx", password = "xxxx", database = "xxxx")    
    cur = con.cursor()   
    cur.__init__
    cur.execute(query)
    rr = []
    colcount = []

    sheets = parse_xls(filepath + '\\Template.xls')
    dicL = sheets[0][1]

    style0 = XFStyle()
    w = Workbook()
    ws0 = w.add_sheet('0')

    for i in dicL.keys():
        p = i[0]
        q = i[1]
        ws0.write(p, q, dicL[(p, q)], style0)
        
    if cur.rowcount > 1:
        while 1:
            for i in range(cur.rowcount):            
                rr = cur.fetchone()
                for col in rr:
                    colcount.append(col)
                for colct in range(25):
                    ws0.write(i + 1, colct, colcount[colct + 25 * i], style0)
            if 0 == cur.nextset():
                break

        Y = strftime('%Y')
        M = strftime('%m')
        D = strftime('%d')
        h = strftime('%H')
        m = strftime('%M')
        s = strftime('%S')
        XlsName = Y + M + D + h + m + s       
        w.save(filepath + '\\Data\\' + XlsName + '.xls')
        
        con.commit()

    cur.close()
    con.close()
    
    sleep(30 * 60)
    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20061109/fc658f95/attachment.htm 

òËÆÊÇÎļþÃû±àÂëµÄÎÊÌâ

2006/11/9, Zuggie <magicccc at gmail.com>:
>
>  ³ÌÐòÔ´´aÈçÏ£¬Ö÷Òª×÷ÓÃÄ SQL Server ”µ“þŽìÖÐÈ¡³ö”µ“þ·ÅÈë Excel ÖУ¬È»ááÓɵÚÈý·½¿Í‘ô¶Ë×xÈ¡ Excel
> ¹¤×÷±í£¬ÎÒÖ»ÖªµÀµÚÈý·½¿Í‘ô¶ËÊÇÓà Delphi Œ‘µÄ¡£¬FÔڵƖî}¾ÍÊÇÉú³ÉµÄ Excel
> ÎęnµÚÈý·½¿Í‘ô¶Ë²»ÄÜ×xÈ¡£¬Èç¹ûÖØнo¹¤×÷±íÃüÃû£¬¾Í¿ÉÒÔ×xÈ¡”µ“þ¡£¿´ÁËÏ pyExcelerator µÄÀý×Ó£¬¶¼ÊÇß@÷጑µÄ£¬Óà pyExcelerator
> µÄÀý×ÓÉú³ÉµÄÎļþÒ²²»ÄÜ×xÈ¡£¬±Ø횽o¹¤×÷±íÖØÐÂÃüÃû£¬¼´Ê¹Ç°ááƒÉ´ÎÃû×ÖÒ»˜Ó£¬Ö»ÒªÖØÐÂÃüÃû¾Í¿ÉÒÔ×xÈ¡£¬î^¶¼´óÁË£¬„‚ŒW
> Python£¬¿´²»µ½†–î}³öÔÚÄÄÑY¡£ÕlÓпգ¬ŽÍæ¿´Ï£¬ÖxÖx£¡
>
> # -*- coding: utf-8 -*-
> import pymssql
> import os
> import sys
> import decimal
> from pyExcelerator import *
> from time import *
>
> filepath = os.path.dirname(sys.argv[0])
>
> query = "exec GetSPCData"
>
> while 1:
>     con = pymssql.connect(host = "xxxxx", user = "xxxx", password =
> "xxxx", database = "xxxx")
>     cur = con.cursor()
>     cur.__init__
>     cur.execute(query)
>     rr = []
>     colcount = []
>
>     sheets = parse_xls(filepath + '\\Template.xls')
>     dicL = sheets[0][1]
>
>     style0 = XFStyle()
>     w = Workbook()
>     ws0 = w.add_sheet('0')
>
>     for i in dicL.keys():
>         p = i[0]
>         q = i[1]
>         ws0.write(p, q, dicL[(p, q)], style0)
>
>     if cur.rowcount > 1:
>         while 1:
>             for i in range(cur.rowcount):
>                 rr = cur.fetchone()
>                 for col in rr:
>                     colcount.append(col)
>                 for colct in range(25):
>                     ws0.write(i + 1, colct, colcount[colct + 25 * i],
> style0)
>             if 0 == cur.nextset():
>                 break
>
>         Y = strftime('%Y')
>         M = strftime('%m')
>         D = strftime('%d')
>         h = strftime('%H')
>         m = strftime('%M')
>         s = strftime('%S')
>         XlsName = Y + M + D + h + m + s
>         w.save(filepath + '\\Data\\' + XlsName + '.xls')
>
>         con.commit()
>
>     cur.close()
>     con.close()
>
>     sleep(30 * 60)
>
>
> _______________________________________________
> python-chinese
> Post: send python-chinese at lists.python.cn
> Subscribe: send subscribe to python-chinese-request at lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request at lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>



-- 
devdoer
devdoer at gmail.com
http://project.mytianwang.cn/cgi-bin/blog
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20061109/e75971dc/attachment.htm 

ÊÔÊÔ½«
 XlsName = Y + M + D + h + m + s
        w.save(filepath + '\\Data\\' + XlsName + '.xls')
¸Ä³É
 XlsName=unicode(filepath+'\\Data\\'+Y+M+D+h+m+s,'utf-8').encode('gb18030')
w.save(XlsName)

2006/11/9, Zuggie <magicccc at gmail.com>:
>
>  ³ÌÐòÔ´´aÈçÏ£¬Ö÷Òª×÷ÓÃÄ SQL Server ”µ“þŽìÖÐÈ¡³ö”µ“þ·ÅÈë Excel ÖУ¬È»ááÓɵÚÈý·½¿Í‘ô¶Ë×xÈ¡ Excel
> ¹¤×÷±í£¬ÎÒÖ»ÖªµÀµÚÈý·½¿Í‘ô¶ËÊÇÓà Delphi Œ‘µÄ¡£¬FÔڵƖî}¾ÍÊÇÉú³ÉµÄ Excel
> ÎęnµÚÈý·½¿Í‘ô¶Ë²»ÄÜ×xÈ¡£¬Èç¹ûÖØнo¹¤×÷±íÃüÃû£¬¾Í¿ÉÒÔ×xÈ¡”µ“þ¡£¿´ÁËÏ pyExcelerator µÄÀý×Ó£¬¶¼ÊÇß@÷጑µÄ£¬Óà pyExcelerator
> µÄÀý×ÓÉú³ÉµÄÎļþÒ²²»ÄÜ×xÈ¡£¬±Ø횽o¹¤×÷±íÖØÐÂÃüÃû£¬¼´Ê¹Ç°ááƒÉ´ÎÃû×ÖÒ»˜Ó£¬Ö»ÒªÖØÐÂÃüÃû¾Í¿ÉÒÔ×xÈ¡£¬î^¶¼´óÁË£¬„‚ŒW
> Python£¬¿´²»µ½†–î}³öÔÚÄÄÑY¡£ÕlÓпգ¬ŽÍæ¿´Ï£¬ÖxÖx£¡
>
> # -*- coding: utf-8 -*-
> import pymssql
> import os
> import sys
> import decimal
> from pyExcelerator import *
> from time import *
>
> filepath = os.path.dirname(sys.argv[0])
>
> query = "exec GetSPCData"
>
> while 1:
>     con = pymssql.connect(host = "xxxxx", user = "xxxx", password =
> "xxxx", database = "xxxx")
>     cur = con.cursor()
>     cur.__init__
>     cur.execute(query)
>     rr = []
>     colcount = []
>
>     sheets = parse_xls(filepath + '\\Template.xls')
>     dicL = sheets[0][1]
>
>     style0 = XFStyle()
>     w = Workbook()
>     ws0 = w.add_sheet('0')
>
>     for i in dicL.keys():
>         p = i[0]
>         q = i[1]
>         ws0.write(p, q, dicL[(p, q)], style0)
>
>     if cur.rowcount > 1:
>         while 1:
>             for i in range(cur.rowcount):
>                 rr = cur.fetchone()
>                 for col in rr:
>                     colcount.append(col)
>                 for colct in range(25):
>                     ws0.write(i + 1, colct, colcount[colct + 25 * i],
> style0)
>             if 0 == cur.nextset():
>                 break
>
>         Y = strftime('%Y')
>         M = strftime('%m')
>         D = strftime('%d')
>         h = strftime('%H')
>         m = strftime('%M')
>         s = strftime('%S')
>         XlsName = Y + M + D + h + m + s
>         w.save(filepath + '\\Data\\' + XlsName + '.xls')
>
>         con.commit()
>
>     cur.close()
>     con.close()
>
>     sleep(30 * 60)
>
>
> _______________________________________________
> python-chinese
> Post: send python-chinese at lists.python.cn
> Subscribe: send subscribe to python-chinese-request at lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request at lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>



-- 
devdoer
devdoer at gmail.com
http://project.mytianwang.cn/cgi-bin/blog
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20061109/d170395a/attachment.html 

这个列表真长，不留个名字对不起大家啊。哈

别把这里当论坛，以后灌水的也会被提醒-警告。

On 11/9/06, WhiteFox <wyh817在gmail.com> wrote:
>
> 这个列表真长，不留个名字对不起大家啊。哈
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese




-- 
Dreamingk (tc, 天成)
email:
    dreamingk在gmail.com
    tc在exoweb.net
website:
    http://www.exoweb.net
    http://python.cn
    http://django.cn
    http://zope.cn
Exoweb (北京轩辕互动科技有限公司)
  北京市朝阳区金台路甜水园东街2号
  甜水园商务中心A505  100026
Python, I love this language.
-------------- 下一部分 --------------
一个HTML附件被移除...
URL: http://python.cn/pipermail/python-chinese/attachments/20061109/72b4be40/attachment.htm 

我的操作系統是繁體的，按照你給的方法轉換成 utf-8 或者 big5 、gb18030 都不可以。試了好久，終于暈了，不知道要怎麽改了。。
  ----- 原始邮件 ----- 
  发件人: bird devdoer 
  收件人: python-chinese at lists.python.cn 
  日期: 2006年11月9日 下午 12:11
  主题: [python-chinese]Re: [python-chinese] 幫忙找下問題！！


  试试将
   XlsName = Y + M + D + h + m + s       
          w.save(filepath + '\\Data\\' + XlsName + '.xls')
  改成
   XlsName=unicode(filepath+'\\Data\\'+Y+M+D+h+m+s,'utf-8').encode('gb18030')
  w.save(XlsName)


  2006/11/9, Zuggie <magicccc at gmail.com >: 
    程序源碼如下，主要作用從 SQL Server 數據庫中取出數據放入 Excel 中，然後由第三方客戶端讀取 Excel 工作表，我只知道第三方客戶端是用 Delphi 寫的。現在的問題就是生成的 Excel 文檔第三方客戶端不能讀取，如果重新給工作表命名，就可以讀取數據。看了下 pyExcelerator 的例子，都是這麽寫的，用 pyExcelerator 的例子生成的文件也不能讀取，必須給工作表重新命名，即使前後兩次名字一樣，只要重新命名就可以讀取，頭都大了，剛學 Python，看不到問題出在哪裏。誰有空，幫忙看下，謝謝！

    # -*- coding: utf-8 -*-

    import pymssql
    import os
    import sys
    import decimal
    from pyExcelerator import *
    from time import *

    filepath = os.path.dirname(sys.argv[0])

    query = "exec GetSPCData"

    while 1:         
        con = pymssql.connect(host = "xxxxx", user = "xxxx", password = "xxxx", database = "xxxx")    
        cur = con.cursor()   
        cur.__init__
        cur.execute(query)
        rr = []
        colcount = []

        sheets = parse_xls(filepath + '\\Template.xls')
        dicL = sheets[0][1]

        style0 = XFStyle()
        w = Workbook()
        ws0 = w.add_sheet('0')

        for i in dicL.keys():
            p = i[0]
            q = i[1]
            ws0.write(p, q, dicL[(p, q)], style0)
            
        if cur.rowcount > 1:
            while 1:
                for i in range(cur.rowcount):            
                    rr = cur.fetchone()
                    for col in rr:
                        colcount.append(col)
                    for colct in range(25):
                        ws0.write(i + 1, colct, colcount[colct + 25 * i], style0)
                if 0 == cur.nextset():
                    break

            Y = strftime('%Y')
            M = strftime('%m')
            D = strftime('%d')
            h = strftime('%H')
            m = strftime('%M')
            s = strftime('%S')
            XlsName = Y + M + D + h + m + s       
            w.save(filepath + '\\Data\\' + XlsName + '.xls')
            
            con.commit()

        cur.close()
        con.close()
        
        sleep(30 * 60)
        

    _______________________________________________
    python-chinese
    Post: send python-chinese at lists.python.cn 
    Subscribe: send subscribe to python-chinese-request at lists.python.cn
    Unsubscribe: send unsubscribe to   python-chinese-request at lists.python.cn
    Detail Info: http://python.cn/mailman/listinfo/python-chinese




  -- 
  devdoer
  devdoer at gmail.com
  http://project.mytianwang.cn/cgi-bin/blog 


------------------------------------------------------------------------------


  _______________________________________________
  python-chinese
  Post: send python-chinese at lists.python.cn
  Subscribe: send subscribe to python-chinese-request at lists.python.cn
  Unsubscribe: send unsubscribe to  python-chinese-request at lists.python.cn
  Detail Info: http://python.cn/mailman/listinfo/python-chinese
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20061109/923ce439/attachment-0001.html