Return-Path: X-Original-To: apmail-poi-user-archive@www.apache.org Delivered-To: apmail-poi-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 B142A186A1 for ; Fri, 30 Oct 2015 15:44:34 +0000 (UTC) Received: (qmail 10045 invoked by uid 500); 30 Oct 2015 15:44:34 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 10015 invoked by uid 500); 30 Oct 2015 15:44:34 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 10003 invoked by uid 99); 30 Oct 2015 15:44:34 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Oct 2015 15:44:34 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 36F3D1A25BC for ; Fri, 30 Oct 2015 15:44:33 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.898 X-Spam-Level: ** X-Spam-Status: No, score=2.898 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id cIz1tOY211BG for ; Fri, 30 Oct 2015 15:44:32 +0000 (UTC) Received: from mail-yk0-f175.google.com (mail-yk0-f175.google.com [209.85.160.175]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 7838243A03 for ; Fri, 30 Oct 2015 15:44:32 +0000 (UTC) Received: by ykek133 with SMTP id k133so80003038yke.2 for ; Fri, 30 Oct 2015 08:44:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=MZYBU7HhqlMpZKIPw1Et3kwnxF5MrCw9SR/ZwH4cIs4=; b=NCaiB2OPMmDEpxjNE3QgPN16qeqle6+ThHWdSsyATS8FAk7fO7QUoR+4YVDMOmcWgP 1gJIbA0CubsAsHblpc/KWn8VCMJp26XpOu1KMyf0iIffPT0xcpUhhLIYljwlKu9fzr96 b+HT4kHV8f/MTH4CJdjejwj+IBNZ5NRIINsv2q7xAhaAR2R+vcPMtu6DpUObJFK0hvcT mUQOf5M2Qq6Hs0tvM5UgQFYHeiYPlTLXb0KxGx7W6vKrLhf/Ql323vfG0+H13TJ1mPHq HOoaidJ5MisNOr3cqZFwPVkm0ezgW5vm3bZSl25wp2dj3hA3oIm6Cm8ErDjDlUUmEQzF svbA== MIME-Version: 1.0 X-Received: by 10.129.128.65 with SMTP id q62mr7444956ywf.210.1446219872167; Fri, 30 Oct 2015 08:44:32 -0700 (PDT) Received: by 10.13.204.88 with HTTP; Fri, 30 Oct 2015 08:44:31 -0700 (PDT) Received: by 10.13.204.88 with HTTP; Fri, 30 Oct 2015 08:44:31 -0700 (PDT) In-Reply-To: References: Date: Fri, 30 Oct 2015 08:44:31 -0700 Message-ID: Subject: Re: Query about HSSF From: "Javen O'Neal" To: POI Users List Content-Type: multipart/alternative; boundary=94eb2c030e18bf6c6b0523544dda --94eb2c030e18bf6c6b0523544dda Content-Type: text/plain; charset=UTF-8 If you know you're reading an Excel 2007 file, using the XSSFWorkbook constructor means having an XSSFWorkbook object, which has some additional features that aren't available in the Workbook interface. If you go the WorkbookFactory.create route, you can always cast to an XSSFWorkbook. Likewise, you could do the same with HSSFWorkbooks for Excel 2003 files. The Quick Guide does a pretty good job showing you how to use POI. https://poi.apache.org/spreadsheet/quick-guide.html On 29 Oct 2015 9:44 p.m., "Rohit Cha" wrote: > What is advantage of using HSSF for reading exel(2007) files over > WorkFactory.create() > --94eb2c030e18bf6c6b0523544dda--