Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #97499

Re: change data in large excel file(more than 240 000 rows on sheet)

Path csiph.com!eternal-september.org!feeder.eternal-september.org!border1.nntp.ams1.giganews.com!nntp.giganews.com!newsfeed.xs4all.nl!newsfeed8.news.xs4all.nl!nzpost1.xs4all.net!not-for-mail
Return-Path <lac@openend.se>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.014
X-Spam-Evidence '*H*': 0.98; '*S*': 0.00; 'subject:file': 0.07; 'cc:addr:python-list': 0.09; 'received:openend.se': 0.09; 'received:theraft.openend.se': 0.09; 'cc:addr:lac': 0.16; 'cc:addr:openend.se': 0.16; 'from:addr:lac': 0.16; 'from:addr:openend.se': 0.16; 'from:name:laura creighton': 0.16; 'message-id:@fido.openend.se': 0.16; 'optimised': 0.16; 'received:fido': 0.16; 'received:fido.openend.se': 0.16; 'laura': 0.18; 'cc:addr:python.org': 0.20; 'cc:2**1': 0.22; 'received:se': 0.29; 'cc:no real name:2**1': 0.29; 'subject:change': 0.33; 'url:org': 0.36; 'subject:: ': 0.37; 'charset:us-ascii': 0.37; 'url:en': 0.39; 'header:Message-Id:1': 0.61; 'subject:more': 0.61; 'header:In-reply-to:1': 0.84; 'url:readthedocs': 0.84; 'url:latest': 0.91; 'subject:000': 0.95
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=openend.se; s=default; t=1444300062; bh=IMqBCP5KyNMiR5Uinn60OUMwwb8CGGCuSuOIBGgdR2o=; h=To:cc:From:Subject:In-reply-to:References:Date:From; b=0Cgv5x0wLSLcLIzA7Kiumo6RXRXlwo1iXqOal3sOxWMCvshqrwVRpEzSWLpHaJ33V pIJL3M4FCPEkKc1LxLbteN5JRhCN94/Fld6+PyEkwpEYlUvOjlGMsUkwr0KM5O/6B/ xCIihDJwnJrh6nVsHYOFFnclRsvk7u1KjKFNxl/w=
To gall.pavgal.gall@gmail.com
cc python-list@python.org, lac@openend.se
From Laura Creighton <lac@openend.se>
Subject Re: change data in large excel file(more than 240 000 rows on sheet)
In-reply-to <caed8133-f4cb-420b-b9fd-4512fbe11400@googlegroups.com>
References <9c23c9d1-4257-475b-a7f6-811e85fe83f3@googlegroups.com> <caed8133-f4cb-420b-b9fd-4512fbe11400@googlegroups.com>
Comments In-reply-to gall.pavgal.gall@gmail.com message dated "Thu, 08 Oct 2015 02:58:41 -0700."
MIME-Version 1.0
Content-Type text/plain; charset="us-ascii"
Content-ID <20035.1444300059.1@fido>
Date Thu, 08 Oct 2015 12:27:39 +0200
X-Greylist Sender IP whitelisted, not delayed by milter-greylist-4.3.9 (theraft.openend.se [82.96.5.2]); Thu, 08 Oct 2015 12:27:42 +0200 (CEST)
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.20+
Precedence list
List-Id General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list/>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups comp.lang.python
Message-ID <mailman.468.1444300069.28679.python-list@python.org> (permalink)
Lines 5
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1444300069 news.xs4all.nl 23768 [2001:888:2000:d::a6]:49186
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:97499

Show key headers only | View raw

You need to use the optimised reader.
https://openpyxl.readthedocs.org/en/latest/optimized.html

Laura

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

change data in large excel file(more than 240 000 rows on sheet) gall.pavgal.gall@gmail.com - 2015-10-07 07:13 -0700
  Re: change data in large excel file(more than 240 000 rows on sheet) Mark Lawrence <breamoreboy@yahoo.co.uk> - 2015-10-07 15:18 +0100
  Re: change data in large excel file(more than 240 000 rows on sheet) gall.pavgal.gall@gmail.com - 2015-10-08 02:58 -0700
    Re: change data in large excel file(more than 240 000 rows on sheet) Laura Creighton <lac@openend.se> - 2015-10-08 12:27 +0200
      Re: change data in large excel file(more than 240 000 rows on sheet) gall.pavgal.gall@gmail.com - 2015-10-09 01:21 -0700
        Re: change data in large excel file(more than 240 000 rows on sheet) Laura Creighton <lac@openend.se> - 2015-10-09 13:07 +0200
        Re: change data in large excel file(more than 240 000 rows on sheet) alister <alister.nospam.ware@ntlworld.com> - 2015-10-09 11:33 +0000
  Re: change data in large excel file(more than 240 000 rows on sheet) harirammanohar159@gmail.com - 2015-10-09 04:19 -0700

csiph-web