any update on this pls? This is blocking me.
Thanks,
On Tue, May 15, 2018 at 3:45 PM, Syed Mudassir Ahmed <
syed.mudas...@gaianconsultants.com> wrote:
> Yes, pls find the file attached here.
>
> Thanks,
>
>
> On Tue, May 15, 2018 at 3:43 PM, Tim Allison <talli...@apache.org> wrote:
>
>> Any chanc you can share the file?
>>
>> On Tue, May 15, 2018 at 3:19 AM Syed Mudassir Ahmed <
>> syed.mudas...@gaianconsultants.com> wrote:
>>
>> > Hi,
>> > I am trying to read data from a XLSX sheet via XSSFSheetXMLHandler.
>> The
>> > source code is below.
>> >
>> > public static void main(String str[]) throws Exception {
>> > String filePath
>> > = "/home/gaian/Desktop/salary.xlsx";
>> > File file = new File(filePath);
>> > InputStream inputStream = new FileInputStream(file);
>> > OPCPackage pkg = OPCPackage.open(inputStream);
>> >
>> > SheetContentsHandler sheetContentsHandler = new
>> > SheetContentsHandler() {
>> > @Override
>> > public void startRow(int rowIndex) {
>> > }
>> >
>> > @Override
>> > public void endRow(int i) {
>> > }
>> >
>> > @Override
>> > public void cell(String cell, String formattedValue,
>> > XSSFComment c) {
>> > System.out.println("cell encountered with addess:<" +
>> cell
>> > + "> and value:<" + formattedValue + ">");
>> > }
>> >
>> > @Override
>> > public void headerFooter(String text, boolean isHeader,
>> String
>> > tagName) {
>> > System.out.println("headerFooter()");
>> > }
>> > };
>> >
>> > ReadOnlySharedStringsTable strings = new
>> > ReadOnlySharedStringsTable(pkg);
>> > XSSFReader xssfReader = new XSSFReader(pkg);
>> > StylesTable styles = xssfReader.getStylesTable();
>> > XSSFReader.SheetIterator worksheets = (XSSFReader.SheetIterator)
>> > xssfReader.getSheetsData();
>> > InputStream stream = worksheets.next();
>> > SAXParserFactory saxFactory = SAXParserFactory.newInstance();
>> > XMLReader sheetParser = saxFactory.newSAXParser().getX
>> MLReader();
>> >
>> > ContentHandler handler
>> > = new XSSFSheetXMLHandler(styles, strings,
>> > sheetContentsHandler, false);
>> >
>> > sheetParser.setContentHandler(handler);
>> > sheetParser.parse(new InputSource(stream));
>> > }
>> >
>> > When I use the POI version 3.13, I am getting the following output:
>> >
>> > cell encountered with addess:<A1> and value:<Salary>
>> > cell encountered with addess:<A2> and value:<99.965432>
>> >
>> > The moment I switch to version 3.14 or higher, I am no longer getting
>> > any output.
>> >
>> > Can someone pls let me know if any more code changes needed if I
>> switch
>> > to 3.14 or higher? I even checked the test cases in Apache POI 3.17
>> > sources but was shocked not to find any there. Any example/references
>> that
>> > I can go through pls? This is blocker for one of my applications.
>> >
>> >
>> > Thanks,
>> >
>> >
>>
>
>
