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>
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

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

Laura