Return-Path: Delivered-To: apmail-jakarta-jmeter-user-archive@www.apache.org Received: (qmail 37911 invoked from network); 30 Sep 2003 10:20:38 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 30 Sep 2003 10:20:38 -0000 Received: (qmail 51068 invoked by uid 500); 30 Sep 2003 10:20:09 -0000 Delivered-To: apmail-jakarta-jmeter-user-archive@jakarta.apache.org Received: (qmail 51046 invoked by uid 500); 30 Sep 2003 10:20:08 -0000 Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "JMeter Users List" Reply-To: "JMeter Users List" Delivered-To: mailing list jmeter-user@jakarta.apache.org Received: (qmail 51032 invoked from network); 30 Sep 2003 10:20:08 -0000 Received: from unknown (HELO mgw01fi.tjgroup.com) (194.100.89.90) by daedalus.apache.org with SMTP; 30 Sep 2003 10:20:08 -0000 Subject: Re: Importing csv into MS-Excel To: "JMeter Users List" X-Mailer: Lotus Notes Release 5.0.5 September 22, 2000 Message-ID: From: Janne.Mattila@keypartners.fi Date: Tue, 30 Sep 2003 13:20:43 +0300 X-MIMETrack: Serialize by Router on MGW01FI/SRV/TJG(Release 5.0.11 |July 24, 2002) at 30.09.2003 13:20:22 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi, I believe you can import the data to Excel with basic file->open when y= ou have a delimiting character that Excel recognizes. Then again, you end = up with a big bunch of samples which can be painful to analyze with Excel.= I created a small Java program to do some csv analysis. You can also use = it to survive with a good performance with distributed JMeter tests, by running each computer independently and combining the separate csv file= s after tests. It's by no means fancy, but does the trick for me. I uploaded it at http://www.geocities.com/jmeter_analyze/ - - - Janne Mattila J=E4rjestelm=E4suunnittelija Key Partners Oy Polttimonkatu 4, 33210 Tampere Puh. + 358 20 551 6188 Gsm + 358 40 849 1074 Fax + 358 20 551 6200 www.keypartners.fi |---------+----------------------------> | | Jean-Sebastien | | | Morisset | | | | | | | | | 30.09.2003 00:20 | | | Please respond to| | | "JMeter Users | | | List" | | | | |---------+----------------------------> >--------------------------------------------------------------------= ----------------------------------------------------------| | = | | To: JMeter User = | | cc: (bcc: Janne Mattila/FI/TJG) = | | Subject: Importing csv into MS-Excel = | >--------------------------------------------------------------------= ----------------------------------------------------------| Hi, Is there somekind of MS-Excel template out there I could use to import = a CSV file and get some stats? I'd rather avoid re-inventing the wheel if= I can... :-) Thanks! js. -- Jean-Sebastien Morisset, Sr. UNIX Administrator Personal Home Page JS & Melanie's Homebrewery Underwater and Travel Photographs --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: jmeter-user-help@jakarta.apache.org = --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: jmeter-user-help@jakarta.apache.org