From user-return-25234-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Mon Apr 2 00:05:15 2012 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C5651987A for ; Mon, 2 Apr 2012 00:05:15 +0000 (UTC) Received: (qmail 36779 invoked by uid 500); 2 Apr 2012 00:05:13 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 36753 invoked by uid 500); 2 Apr 2012 00:05:13 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 36744 invoked by uid 99); 2 Apr 2012 00:05:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Apr 2012 00:05:13 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of potekhin@bnl.gov designates 130.199.3.132 as permitted sender) Received: from [130.199.3.132] (HELO smtpgw.bnl.gov) (130.199.3.132) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Apr 2012 00:05:06 +0000 X-BNL-policy-q: X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ArMGAI7seE+CxzYH/2dsb2JhbABEgw+1boEHggkBAQVJLxELBBQJFggHCQMCAQIBDyUREwYCAQGIBblRihaDYoMkBJtRhUOEfIMD X-IronPort-AV: E=Sophos;i="4.75,353,1330923600"; d="scan'208,217";a="178304173" Received: from rcf.rhic.bnl.gov ([130.199.54.7]) by smtpgw.sec.bnl.local with ESMTP/TLS/DHE-RSA-AES256-SHA; 01 Apr 2012 20:04:45 -0400 Received: from [192.168.0.196] (ool-44c3ab4d.dyn.optonline.net [68.195.171.77]) (authenticated bits=0) by rcf.rhic.bnl.gov (8.13.8/8.13.8) with ESMTP id q3204iXZ029875 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Sun, 1 Apr 2012 20:04:44 -0400 Message-ID: <4F78ED18.7070809@bnl.gov> Date: Sun, 01 Apr 2012 20:04:40 -0400 From: Maxim Potekhin User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:11.0) Gecko/20120327 Thunderbird/11.0.1 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: import References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------060204010905050105030609" X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --------------060204010905050105030609 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Since Python has a native csv module, it's trivial to achieve. I load lots of csv data into my database daily. Maxim On 3/27/2012 11:44 AM, R. Verlangen wrote: > You can write your own script to parse the excel file (export as csv) > and import it with batch inserts. > > Should be pretty easy if you have experience with those techniques. > > 2012/3/27 puneet loya > > > I want to import files from excel to cassandra? Is it possible?? > > Any tool that can help?? > > Whats the best way?? > > Plz reply :) > > > > > -- > With kind regards, > > Robin Verlangen > www.robinverlangen.nl > --------------060204010905050105030609 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Since Python has a native csv module, it's trivial to achieve.
I load lots of csv data into my database daily.

Maxim

On 3/27/2012 11:44 AM, R. Verlangen wrote:
You can write your own script to parse the excel file (export as csv) and import it with batch inserts.

Should be pretty easy if you have experience with those techniques.

2012/3/27 puneet loya <puneetloya@gmail.com>
I want to import files from excel to cassandra? Is it possible??

Any tool that can help??

Whats the best way??

Plz reply :)



--
With kind regards,

Robin Verlangen


--------------060204010905050105030609--