Python论坛的帖子：

Python论坛 - 讨论区

标题：[python-chinese] 读excel的新问题：超过255行数据怎么办？

楼主 2007年11月05日星期一 14:11

??? ?? clfff.peter在gmail.com
星期一十一月 5 14:11:04 HKT 2007

²»ºÃÒâË¼£¬ÊÇrows²»ÊÇcolumns¡£
µ«ÊÇÕÒ·Ç¿ÕµÄ»°£¬»¹ÊÇÓÐÐ©ÎÊÌâ£¬ÒòÎªÓÐÊ±¿ÉÄÜÄÄÒ»ÐÐ¾ÍÊÇ¿ÕµÄ£¬µ«ÏÂÒ»ÐÐÓÖÓÐÊý¾Ý¡£ÄÇÔõÃ´°ì£¿
µ«ÊÇ£¬Èç¹ûÓÃrowsÖµ£¬Ò»°ã¶¼ÉÏ65536£¬´¦ÀíÆðÀ´Ð§ÂÊ»áºÜµÍ¡£


ÔÚ07-10-30£¬Wei Jiang <jiejisheng在gmail.com> Ð´µÀ£º
>
> ÕÒ×îºóÒ»¸ö·Ç¿Õ°É.
>
> On 10/30/07, cai whidbey <whidbeycai在gmail.com> wrote:
> >
> > ÁÐÊÇcol£¬ÐÐÊÇrow
> >
> > ÔÚ07-10-29£¬??? ?? <clfff.peter在gmail.com > Ð´µÀ£º
> > >
> > >  ¶ÁexcelÖÐÒ»¸ösheetÊ±£º
> > > xlApp = Dispatch("Excel.Application")
> > > xlApp.Visible = 0
> > > doc = self.xlApp.Workbooks.Open(xlsName)
> > > sheet = self.doc.Sheets(sheetName)
> > > col_num = len(self.sheet.Columns)
> > >
> > > ÎÒµÄÊý¾ÝÆäÊµÓÐ600¶àÐÐ£¬µ«ÉÏÃæcol_numÖ»ÄÜ´ïµ½255£¬ÎªÊ²Ã´£¿
> > > ÓÐÃ»ÓÐÊ²Ã´°ì·¨µÃµ½ÕæÕýµÄÊý¾Ýµ½µ×ÓÐ¶àÉÙ£¿
> > > Ð»Ð»¡£
> > >
> > > _______________________________________________
> > > 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
> > >
> >
> >
> > _______________________________________________
> > 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
> >
>
>
> _______________________________________________
> 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/20071105/1d2d0e21/attachment-0001.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

Jiang, Wei

0楼 2007年11月09日星期五 11:06

Wei Jiang jiejisheng在gmail.com
星期五十一月 9 11:06:53 HKT 2007

Èç¹ûÃ»ÓÐ¹æÂÉµÄ»°£¬ºÜÄÑÅÐ¶¨ÄÇÐÐÊÇ¸ö½áÎ²¡£
£¨¼ÙÉèÒ»¸ö±íÖ»ÓÐ×îºóÒ»ÐÐÓÐÊý¾ÝµÄ»°¡£¡£¡££©

    def getRange(self, sheet, row1, col1, row2, col2):
        "return a 2d array (i.e. tuple of tuples)"
        sht = self.xBook.Worksheets(sheet)
        return sht.Range(sht.Cells(row1, col1), sht.Cells(row2, col2)).Value


On Nov 5, 2007 2:11 PM, ??? ?? <clfff.peter在gmail.com> wrote:

> ²»ºÃÒâË¼£¬ÊÇrows²»ÊÇcolumns¡£
> µ«ÊÇÕÒ·Ç¿ÕµÄ»°£¬»¹ÊÇÓÐÐ©ÎÊÌâ£¬ÒòÎªÓÐÊ±¿ÉÄÜÄÄÒ»ÐÐ¾ÍÊÇ¿ÕµÄ£¬µ«ÏÂÒ»ÐÐÓÖÓÐÊý¾Ý¡£ÄÇÔõÃ´°ì£¿
> µ«ÊÇ£¬Èç¹ûÓÃrowsÖµ£¬Ò»°ã¶¼ÉÏ65536£¬´¦ÀíÆðÀ´Ð§ÂÊ»áºÜµÍ¡£
>
>
> ÔÚ07-10-30£¬Wei Jiang <jiejisheng在gmail.com> Ð´µÀ£º
> >
> > ÕÒ×îºóÒ»¸ö·Ç¿Õ°É.
> >
> > On 10/30/07, cai whidbey <whidbeycai在gmail.com > wrote:
> > >
> > > ÁÐÊÇcol£¬ÐÐÊÇrow
> > >
> > > ÔÚ07-10-29£¬??? ?? <clfff.peter在gmail.com > Ð´µÀ£º
> > > >
> > > >  ¶ÁexcelÖÐÒ»¸ösheetÊ±£º
> > > > xlApp = Dispatch("Excel.Application")
> > > > xlApp.Visible = 0
> > > > doc = self.xlApp.Workbooks.Open(xlsName)
> > > > sheet = self.doc.Sheets(sheetName)
> > > > col_num = len(self.sheet.Columns)
> > > >
> > > > ÎÒµÄÊý¾ÝÆäÊµÓÐ600¶àÐÐ£¬µ«ÉÏÃæcol_numÖ»ÄÜ´ïµ½255£¬ÎªÊ²Ã´£¿
> > > > ÓÐÃ»ÓÐÊ²Ã´°ì·¨µÃµ½ÕæÕýµÄÊý¾Ýµ½µ×ÓÐ¶àÉÙ£¿
> > > > Ð»Ð»¡£
> > > >
> > > > _______________________________________________
> > > > 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
> > > >
> > >
> > >
> > > _______________________________________________
> > > 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
> > >
> >
> >
> > _______________________________________________
> > 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
> >
>
>
> _______________________________________________
> 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/20071109/ddaa2239/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

徐继哲

0楼 2007年11月09日星期五 11:27

clfff.peter clfff.peter在gmail.com
星期五十一月 9 11:27:46 HKT 2007

Õâ¸öÎÊÌâ»ù±¾ÉÏ½â¾öÁË£¬ÎÒ¼Ù¶¨×îºóÒ»ÐÐµÄÌõ¼þÊÇ£º
     ÆäºóÁ¬ÐøÊ®ÐÐÈ«ÊÇ¿ÕµÄ¡£
Í¨³££¬ÕâÖÖ¼Ù¶¨ÊÇ³ÉÁ¢µÄ£¬¶øÇÒÓÃ»§¿ÉÒÔÐÞ¸ÄÕâÖÖÏÞÖÆ¡£


ÔÚ07-11-9£¬Wei Jiang <jiejisheng在gmail.com> Ð´µÀ£º
>
> Èç¹ûÃ»ÓÐ¹æÂÉµÄ»°£¬ºÜÄÑÅÐ¶¨ÄÇÐÐÊÇ¸ö½áÎ²¡£
> £¨¼ÙÉèÒ»¸ö±íÖ»ÓÐ×îºóÒ»ÐÐÓÐÊý¾ÝµÄ»°¡£¡£¡££©
>
>     def getRange(self, sheet, row1, col1, row2, col2):
>         "return a 2d array (i.e. tuple of tuples)"
>         sht = self.xBook.Worksheets(sheet)
>         return sht.Range(sht.Cells(row1, col1), sht.Cells(row2,
> col2)).Value
>
>
> On Nov 5, 2007 2:11 PM, ??? ?? <clfff.peter在gmail.com> wrote:
>
> > ²»ºÃÒâË¼£¬ÊÇrows²»ÊÇcolumns¡£
> > µ«ÊÇÕÒ·Ç¿ÕµÄ»°£¬»¹ÊÇÓÐÐ©ÎÊÌâ£¬ÒòÎªÓÐÊ±¿ÉÄÜÄÄÒ»ÐÐ¾ÍÊÇ¿ÕµÄ£¬µ«ÏÂÒ»ÐÐÓÖÓÐÊý¾Ý¡£ÄÇÔõÃ´°ì£¿
> > µ«ÊÇ£¬Èç¹ûÓÃrowsÖµ£¬Ò»°ã¶¼ÉÏ65536£¬´¦ÀíÆðÀ´Ð§ÂÊ»áºÜµÍ¡£
> >
> >
> > ÔÚ07-10-30£¬Wei Jiang <jiejisheng在gmail.com> Ð´µÀ£º
> > >
> > > ÕÒ×îºóÒ»¸ö·Ç¿Õ°É.
> > >
> > > On 10/30/07, cai whidbey <whidbeycai在gmail.com > wrote:
> > > >
> > > > ÁÐÊÇcol£¬ÐÐÊÇrow
> > > >
> > > > ÔÚ07-10-29£¬??? ?? <clfff.peter在gmail.com > Ð´µÀ£º
> > > > >
> > > > >  ¶ÁexcelÖÐÒ»¸ösheetÊ±£º
> > > > > xlApp = Dispatch("Excel.Application")
> > > > > xlApp.Visible = 0
> > > > > doc = self.xlApp.Workbooks.Open(xlsName)
> > > > > sheet = self.doc.Sheets(sheetName)
> > > > > col_num = len(self.sheet.Columns)
> > > > >
> > > > > ÎÒµÄÊý¾ÝÆäÊµÓÐ600¶àÐÐ£¬µ«ÉÏÃæcol_numÖ»ÄÜ´ïµ½255£¬ÎªÊ²Ã´£¿
> > > > > ÓÐÃ»ÓÐÊ²Ã´°ì·¨µÃµ½ÕæÕýµÄÊý¾Ýµ½µ×ÓÐ¶àÉÙ£¿
> > > > > Ð»Ð»¡£
> > > > >
> > > > > _______________________________________________
> > > > > 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
> > > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > 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
> > > >
> > >
> > >
> > > _______________________________________________
> > > 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
> > >
> >
> >
> > _______________________________________________
> > 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
> >
>
>
> _______________________________________________
> 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/20071109/8ae844b9/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

徐继哲

0楼 2007年11月13日星期二 15:27

Liu Ian lpvips在gmail.com
星期二十一月 13 15:27:24 HKT 2007

×î¼òµ¥µÄ°ì·¨¾ÍÊÇ¼ÓÉÏÒ»¸ö±ß½ç·ûºÅ

ÔÚ07-11-9£¬clfff. peter <clfff.peter在gmail.com> Ð´µÀ£º
>
> Õâ¸öÎÊÌâ»ù±¾ÉÏ½â¾öÁË£¬ÎÒ¼Ù¶¨×îºóÒ»ÐÐµÄÌõ¼þÊÇ£º
>      ÆäºóÁ¬ÐøÊ®ÐÐÈ«ÊÇ¿ÕµÄ¡£
> Í¨³££¬ÕâÖÖ¼Ù¶¨ÊÇ³ÉÁ¢µÄ£¬¶øÇÒÓÃ»§¿ÉÒÔÐÞ¸ÄÕâÖÖÏÞÖÆ¡£
>
>
> ÔÚ07-11-9£¬Wei Jiang <jiejisheng在gmail.com> Ð´µÀ£º
> >
> > Èç¹ûÃ»ÓÐ¹æÂÉµÄ»°£¬ºÜÄÑÅÐ¶¨ÄÇÐÐÊÇ¸ö½áÎ²¡£
> > £¨¼ÙÉèÒ»¸ö±íÖ»ÓÐ×îºóÒ»ÐÐÓÐÊý¾ÝµÄ»°¡£¡£¡££©
> >
> >     def getRange(self, sheet, row1, col1, row2, col2):
> >         "return a 2d array (i.e. tuple of tuples)"
> >         sht = self.xBook.Worksheets(sheet)
> >         return sht.Range(sht.Cells(row1, col1), sht.Cells(row2,
> > col2)).Value
> >
> >
> > On Nov 5, 2007 2:11 PM, ??? ?? <clfff.peter在gmail.com> wrote:
> >
> > > ²»ºÃÒâË¼£¬ÊÇrows²»ÊÇcolumns¡£
> > > µ«ÊÇÕÒ·Ç¿ÕµÄ»°£¬»¹ÊÇÓÐÐ©ÎÊÌâ£¬ÒòÎªÓÐÊ±¿ÉÄÜÄÄÒ»ÐÐ¾ÍÊÇ¿ÕµÄ£¬µ«ÏÂÒ»ÐÐÓÖÓÐÊý¾Ý¡£ÄÇÔõÃ´°ì£¿
> > > µ«ÊÇ£¬Èç¹ûÓÃrowsÖµ£¬Ò»°ã¶¼ÉÏ65536£¬´¦ÀíÆðÀ´Ð§ÂÊ»áºÜµÍ¡£
> > >
> > >
> > > ÔÚ07-10-30£¬Wei Jiang <jiejisheng在gmail.com > Ð´µÀ£º
> > > >
> > > > ÕÒ×îºóÒ»¸ö·Ç¿Õ°É.
> > > >
> > > > On 10/30/07, cai whidbey <whidbeycai在gmail.com > wrote:
> > > > >
> > > > > ÁÐÊÇcol£¬ÐÐÊÇrow
> > > > >
> > > > > ÔÚ07-10-29£¬??? ?? <clfff.peter在gmail.com > Ð´µÀ£º
> > > > > >
> > > > > >  ¶ÁexcelÖÐÒ»¸ösheetÊ±£º
> > > > > > xlApp = Dispatch("Excel.Application")
> > > > > > xlApp.Visible = 0
> > > > > > doc = self.xlApp.Workbooks.Open(xlsName)
> > > > > > sheet = self.doc.Sheets(sheetName)
> > > > > > col_num = len(self.sheet.Columns)
> > > > > >
> > > > > > ÎÒµÄÊý¾ÝÆäÊµÓÐ600¶àÐÐ£¬µ«ÉÏÃæcol_numÖ»ÄÜ´ïµ½255£¬ÎªÊ²Ã´£¿
> > > > > > ÓÐÃ»ÓÐÊ²Ã´°ì·¨µÃµ½ÕæÕýµÄÊý¾Ýµ½µ×ÓÐ¶àÉÙ£¿
> > > > > > Ð»Ð»¡£
> > > > > >
> > > > > > _______________________________________________
> > > > > > 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
> > > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > 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
> > > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > 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
> > > >
> > >
> > >
> > > _______________________________________________
> > > 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
> > >
> >
> >
> > _______________________________________________
> > 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
> >
>
>
> _______________________________________________
> 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/20071113/65873bc1/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

徐继哲

0楼 2007年11月14日星期三 18:57

clfff.peter clfff.peter在gmail.com
星期三十一月 14 18:57:51 HKT 2007

×ÜÖ®excel±¾ÉíÊÇÃ»ÓÐÕâÖÖ½Ó¿ÚµÄ£¬¶¼Òª×Ô¼ºÅÐ¶Ï¡£
Ó¦¸ÃËã¸öbug°É¡£hehe


ÔÚ07-11-13£¬Liu Ian <lpvips在gmail.com> Ð´µÀ£º
>
> ×î¼òµ¥µÄ°ì·¨¾ÍÊÇ¼ÓÉÏÒ»¸ö±ß½ç·ûºÅ
>
> ÔÚ07-11-9£¬clfff. peter <clfff.peter在gmail.com> Ð´µÀ£º
> >
> > Õâ¸öÎÊÌâ»ù±¾ÉÏ½â¾öÁË£¬ÎÒ¼Ù¶¨×îºóÒ»ÐÐµÄÌõ¼þÊÇ£º
> >      ÆäºóÁ¬ÐøÊ®ÐÐÈ«ÊÇ¿ÕµÄ¡£
> > Í¨³££¬ÕâÖÖ¼Ù¶¨ÊÇ³ÉÁ¢µÄ£¬¶øÇÒÓÃ»§¿ÉÒÔÐÞ¸ÄÕâÖÖÏÞÖÆ¡£
> >
> >
> > ÔÚ07-11-9£¬Wei Jiang <jiejisheng在gmail.com> Ð´µÀ£º
> > >
> > > Èç¹ûÃ»ÓÐ¹æÂÉµÄ»°£¬ºÜÄÑÅÐ¶¨ÄÇÐÐÊÇ¸ö½áÎ²¡£
> > > £¨¼ÙÉèÒ»¸ö±íÖ»ÓÐ×îºóÒ»ÐÐÓÐÊý¾ÝµÄ»°¡£¡£¡££©
> > >
> > >     def getRange(self, sheet, row1, col1, row2, col2):
> > >         "return a 2d array (i.e. tuple of tuples)"
> > >         sht = self.xBook.Worksheets(sheet)
> > >         return sht.Range(sht.Cells(row1, col1), sht.Cells(row2,
> > > col2)).Value
> > >
> > >
> > > On Nov 5, 2007 2:11 PM, ??? ?? <clfff.peter在gmail.com> wrote:
> > >
> > > > ²»ºÃÒâË¼£¬ÊÇrows²»ÊÇcolumns¡£
> > > > µ«ÊÇÕÒ·Ç¿ÕµÄ»°£¬»¹ÊÇÓÐÐ©ÎÊÌâ£¬ÒòÎªÓÐÊ±¿ÉÄÜÄÄÒ»ÐÐ¾ÍÊÇ¿ÕµÄ£¬µ«ÏÂÒ»ÐÐÓÖÓÐÊý¾Ý¡£ÄÇÔõÃ´°ì£¿
> > > > µ«ÊÇ£¬Èç¹ûÓÃrowsÖµ£¬Ò»°ã¶¼ÉÏ65536£¬´¦ÀíÆðÀ´Ð§ÂÊ»áºÜµÍ¡£
> > > >
> > > >
> > > > ÔÚ07-10-30£¬Wei Jiang <jiejisheng在gmail.com > Ð´µÀ£º
> > > > >
> > > > > ÕÒ×îºóÒ»¸ö·Ç¿Õ°É.
> > > > >
> > > > > On 10/30/07, cai whidbey <whidbeycai在gmail.com > wrote:
> > > > > >
> > > > > > ÁÐÊÇcol£¬ÐÐÊÇrow
> > > > > >
> > > > > > ÔÚ07-10-29£¬??? ?? <clfff.peter在gmail.com > Ð´µÀ£º
> > > > > > >
> > > > > > >  ¶ÁexcelÖÐÒ»¸ösheetÊ±£º
> > > > > > > xlApp = Dispatch("Excel.Application")
> > > > > > > xlApp.Visible = 0
> > > > > > > doc = self.xlApp.Workbooks.Open(xlsName)
> > > > > > > sheet = self.doc.Sheets(sheetName)
> > > > > > > col_num = len(self.sheet.Columns)
> > > > > > >
> > > > > > > ÎÒµÄÊý¾ÝÆäÊµÓÐ600¶àÐÐ£¬µ«ÉÏÃæcol_numÖ»ÄÜ´ïµ½255£¬ÎªÊ²Ã´£¿
> > > > > > > ÓÐÃ»ÓÐÊ²Ã´°ì·¨µÃµ½ÕæÕýµÄÊý¾Ýµ½µ×ÓÐ¶àÉÙ£¿
> > > > > > > Ð»Ð»¡£
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > 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
> > > > > > >
> > > > > >
> > > > > >
> > > > > > _______________________________________________
> > > > > > 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
> > > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > 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
> > > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > 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
> > > >
> > >
> > >
> > > _______________________________________________
> > > 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
> > >
> >
> >
> > _______________________________________________
> > 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
> >
>
>
> _______________________________________________
> 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/20071114/7183ff42/attachment.html

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

请登录后回复。还没有在Zeuux哲思注册吗？现在注册！