Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 3963D200CA8 for ; Thu, 15 Jun 2017 14:04:32 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 37D07160BDF; Thu, 15 Jun 2017 12:04:32 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 56BED160BC4 for ; Thu, 15 Jun 2017 14:04:31 +0200 (CEST) Received: (qmail 47504 invoked by uid 500); 15 Jun 2017 12:04:30 -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 47493 invoked by uid 99); 15 Jun 2017 12:04:30 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Jun 2017 12:04:30 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id B33BCC090C for ; Thu, 15 Jun 2017 12:04:29 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.497 X-Spam-Level: X-Spam-Status: No, score=-1.497 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-2.796, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id AS4EgFTptsk3 for ; Thu, 15 Jun 2017 12:04:27 +0000 (UTC) Received: from mx0a-001b2d01.pphosted.com (mx0b-001b2d01.pphosted.com [148.163.158.5]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 4AAEF5FCDA for ; Thu, 15 Jun 2017 12:04:27 +0000 (UTC) Received: from pps.filterd (m0098416.ppops.net [127.0.0.1]) by mx0b-001b2d01.pphosted.com (8.16.0.20/8.16.0.20) with SMTP id v5FC4PNu100448 for ; Thu, 15 Jun 2017 08:04:27 -0400 Received: from e28smtp02.in.ibm.com (e28smtp02.in.ibm.com [125.16.236.2]) by mx0b-001b2d01.pphosted.com with ESMTP id 2b3ppjg3xx-1 (version=TLSv1.2 cipher=AES256-SHA bits=256 verify=NOT) for ; Thu, 15 Jun 2017 08:04:25 -0400 Received: from localhost by e28smtp02.in.ibm.com with IBM ESMTP SMTP Gateway: Authorized Use Only! Violators will be prosecuted for from ; Thu, 15 Jun 2017 17:33:52 +0530 Received: from d28relay10.in.ibm.com (9.184.220.161) by e28smtp02.in.ibm.com (192.168.1.132) with IBM ESMTP SMTP Gateway: Authorized Use Only! Violators will be prosecuted; Thu, 15 Jun 2017 17:33:51 +0530 Received: from d28av01.in.ibm.com (d28av01.in.ibm.com [9.184.220.63]) by d28relay10.in.ibm.com (8.14.9/8.14.9/NCO v10.0) with ESMTP id v5FC25Wj10223658 for ; Thu, 15 Jun 2017 17:32:05 +0530 Received: from d28av01.in.ibm.com (localhost [127.0.0.1]) by d28av01.in.ibm.com (8.14.4/8.14.4/NCO v10.0 AVout) with ESMTP id v5FC3owd012637 for ; Thu, 15 Jun 2017 17:33:50 +0530 Received: from d50lp03.ny.us.ibm.com (d50lp03.pok.ibm.com [146.89.104.211]) by d28av01.in.ibm.com (8.14.4/8.14.4/NCO v10.0 AVin) with ESMTP id v5FC3lDN012616 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-GCM-SHA384 bits=256 verify=FAIL) for ; Thu, 15 Jun 2017 17:33:49 +0530 Received: from localhost by d50lp03.ny.us.ibm.com with IBM ESMTP SMTP Gateway: Authorized Use Only! Violators will be prosecuted for from ; Thu, 15 Jun 2017 08:03:47 -0400 Received: from smtp.notes.na.collabserv.com (192.155.248.73) by d50lp03.ny.us.ibm.com (158.87.18.22) with IBM ESMTP SMTP Gateway: Authorized Use Only! Violators will be prosecuted; (version=TLSv1/SSLv3 cipher=AES128-GCM-SHA256 bits=128/128) Thu, 15 Jun 2017 08:03:46 -0400 Received: from localhost by smtp.notes.na.collabserv.com with smtp.notes.na.collabserv.com ESMTP for from ; Thu, 15 Jun 2017 12:03:44 -0000 Received: from us1a3-smtp03.a3.dal06.isc4sb.com (10.106.154.98) by smtp.notes.na.collabserv.com (10.106.227.90) with smtp.notes.na.collabserv.com ESMTP; Thu, 15 Jun 2017 12:03:44 -0000 Received: from us1a3-mail97.a3.dal06.isc4sb.com ([10.146.21.232]) by us1a3-smtp03.a3.dal06.isc4sb.com with ESMTP id 2017061512034401-414296 ; Thu, 15 Jun 2017 12:03:44 +0000 In-Reply-To: To: "POI Users List" Subject: excel processing differences From: "Sateesh K Kolusu" Date: Thu, 15 Jun 2017 17:33:43 +0530 References: <870BE918-23A3-4FCB-BB85-B228607ECA8E@gmail.com> MIME-Version: 1.0 X-KeepSent: D7C20A09:608C2A35-65258140:003E6C1E; type=4; name=$KeepSent X-Mailer: IBM Notes Release 9.0.1FP7 August 18, 2016 X-LLNOutbound: False X-Disclaimed: 34015 X-TNEFEvaluated: 1 Content-Type: multipart/alternative; boundary="=_alternative 00422A6065258140_=" x-cbid: 17061512-0004-0000-0000-00000596FCC6 X-IBM-SpamModules-Scores: BY=0.00027; FL=0; FP=0; FZ=0; HX=0; KW=0; PH=0; SC=0.423878; ST=0; TS=0; UL=0; ISC=; MB=0.022337 X-IBM-SpamModules-Versions: BY=3.00007236; HX=3.00000241; KW=3.00000007; PH=3.00000004; SC=3.00000212; SDB=6.00875113; UDB=6.00435677; IPR=6.00655202; BA=6.00005423; NDR=6.00000001; ZLA=6.00000005; ZF=6.00000009; ZB=6.00000000; ZP=6.00000000; ZH=6.00000000; ZU=6.00000002; MB=3.00015836; XFM=3.00000015; UTC=2017-06-15 12:03:44 X-IBM-AV-DETECTION: SAVI=unsuspicious REMOTE=unsuspicious XFE=unused X-IBM-AV-VERSION: SAVI=2017-06-15 09:24:02 - 6.00006893 x-cbparentid: 17061512-3108-0000-0000-000042DBDDB1 X-IBM-AV-DETECTION: SAVI=unused REMOTE=unused XFE=unused X-TM-AS-MML: disable X-IBM-AV-DETECTION: SAVI=unused REMOTE=unused XFE=unused Message-Id: X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2017-06-15_06:,, signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 spamscore=0 suspectscore=0 malwarescore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1703280000 definitions=main-1706150216 archived-at: Thu, 15 Jun 2017 12:04:32 -0000 --=_alternative 00422A6065258140_= Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="ISO-8859-1" Hello all - Good day. We have a password XLS sheet with macros and when we use MS=20 Office 2010 to save the file as "Excel97-2003" format, we are able to read = the file and process the file. If we use MS Office 2013 (and higher. I used 2016) and save the file as=20 "Excel97-2003" format, then we are not able to read the file. It gives=20 error=20 java.io.FileNotFoundException: no such entry: "EncryptionInfo", had:=20 [=01CompObj, =5FVBA=5FPROJECT=5FCUR, =05DocumentSummaryInformation,=20 =05SummaryInformation, Workbook] at=20 org.apache.poi.poifs.filesystem.DirectoryNode.getEntry(DirectoryNode.java:3= 99) at=20 org.apache.poi.poifs.filesystem.DirectoryNode.createDocumentInputStream(Dir= ectoryNode.java:188) at=20 org.apache.poi.poifs.crypt.EncryptionInfo.(EncryptionInfo.java:94) at=20 org.apache.poi.poifs.crypt.EncryptionInfo.(EncryptionInfo.java:76) at com.ibm.is.cc.unstructured.poi.SSFile.readFile(SSFile.java:169) at=20 com.ibm.is.cc.unstructured.api.ExcelFile.readFile(ExcelFile.java:143)=20 I am using POI 3.14 --- Thanks Sateesh=20 --=_alternative 00422A6065258140_=--