Pdf conversiion throwing error-XMLStreamException: Unexpected end of input block in start tag

Aspose.Cells Product Family
1

hi

i am saving excel file using UTF-8 encoding and file saved successfully and i am able to open the file after saving.

but if i try to create object to that file in another method its throwing following exception

method 1:
workbook.getSettings().setEncoding(Encoding.getUTF8());
workbook.save(excelFileName);

method 2:
Workbook workbook = new Workbook(excelFileName);

java.lang.IllegalStateException: XMLStreamException: Unexpected end of input block in start tag
at [row,col {unknown-source}]: [1,217]
at com.aspose.cells.b.a.h.k.a(Unknown Source)
at com.aspose.cells.b.a.h.k.f(Unknown Source)
at com.aspose.cells.b.a.h.k.j(Unknown Source)
at com.aspose.cells.zk.b(Unknown Source)
at com.aspose.cells.zk.a(Unknown Source)
at com.aspose.cells.zj.b(Unknown Source)
at com.aspose.cells.zu.y(Unknown Source)
at com.aspose.cells.zu.a(Unknown Source)
at com.aspose.cells.zt.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.open(Unknown Source)
at com.steelwedge.util.demo.generatePdfReport1(demo.java:88)
at com.steelwedge.util.demo.main(demo.java:514)
Caused by: com.ctc.wstx.exc.WstxEOFException: Unexpected end of input block in start tag
at [row,col {unknown-source}]: [1,217]
at com.ctc.wstx.sr.StreamScanner.throwUnexpectedEOB(StreamScanner.java:691)
at com.ctc.wstx.sr.StreamScanner.loadMoreFromCurrent(StreamScanner.java:1057)
at com.ctc.wstx.sr.StreamScanner.getNextCharFromCurrent(StreamScanner.java:802)
at com.ctc.wstx.sr.BasicStreamReader.handleNsAttrs(BasicStreamReader.java:3048)
at com.ctc.wstx.sr.BasicStreamReader.handleStartElem(BasicStreamReader.java:2926)
at com.ctc.wstx.sr.BasicStreamReader.handleRootElem(BasicStreamReader.java:2063)
at com.ctc.wstx.sr.BasicStreamReader.nextFromProlog(BasicStreamReader.java:2043)
at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1102)
… 13 more

please provide me the reply quickly.

thanks

2

Hi,


Thanks for the template file.

I can notice the exception while opening the template file:
“Unexpected end of input block in start tag”.

Sample code:
Workbook workbook = new Workbook(“Current_Plan_Report_WITHDATA.xlsx”);

I have logged a ticket with an id “CELLSJAVA-40517” for your issue. We will look into your issue to figure it out soon.

Thanks,
3

thanks amjad

please provide me the fix as soon as possible.


thanks

4

any update on this issue?

5

Hi,

Thanks for your posting and using Aspose.Cells for Java.

We are afraid, there is no update for you at this moment. We have logged your comments in our database. Once, there is some update for you, we will let you know asap.

6

Hi Shakeel

Thanks for the reply.

As this is high priority issue for us Can you please provide the ETA for this issue so that we can plan accordingly.



thanks

7

Hi,


Well, we are working over your issue at the moment. We hope, we can provide you the fix before the end of this week. Once the fix is ready with extended testing, we will provide you here immediately.

Thank you.
8

Hi Amjad

Do you have any update on this issue?


Thanks

9

Hi,

Thanks for your posting and using Aspose.Cells.

We are
afraid, there is no update for you at this moment. However, we have
logged your comment. Once, there is some update for you, we will let you
know asap.

10

Hi thanks for the reply.

ETA previously was before this week end. so is that still stands or any change in that ?



thanks

11

Hi,


Please try the new fix/version: Aspose.Cells for Java v7.4.3.5. We have fixed the issue.


Let us know your feedback.


Thank you.

12

Thanks amjad

i will test and let you know the status.


Thanks

13

Thanks amjad

i will test the issue and let you know the status

14

Hi,

Thanks for your posting and using Aspose.Cells for Java.

If you encounter any issue, please feel free to post on our forums, we will be glad to help you further.

15

The issues you have found earlier (filed as CELLSJAVA-40517) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
16

Hi

The issue with special charecters in excel is not resolved even with latest version.

My excel file has special charecters like spanish ,chenese etc.

step 1: i am trying to refresh the excel pivot tables and save the excel again.

Workbook workbook = new Workbook(excelFileName);
//Workbook workbook1 = new Workbook(excelFileName);
workbook.calculateFormula(true);
int sheetCount = workbook.getWorksheets().getCount();
System.out.println(“sheet count…” + sheetCount);
for (int i = 0; i < sheetCount; i++) {
Worksheet ws = workbook.getWorksheets().get(i);
System.out.println(“worksheet name :”+ws.getName());
for (int k = 0; k < ws.getPivotTables().getCount(); k++) {
System.out.println(“in start…” + k);
ws.getPivotTables().get(k).setRefreshDataOnOpeningFile(true);
ws.getPivotTables().get(k).setRefreshDataFlag(true);
if (excelFileName.contains(“Extract”)) {

} else {
ws.getPivotTables().get(k).refreshData();
}
try {
ws.getPivotTables().get(k).calculateData();
} catch (Exception el) {
el.printStackTrace();

}
ws.getPivotTables().get(k).setRefreshDataFlag(false);

}

}

workbook.getSettings().setEncoding(Encoding.getUTF8());
workbook.save(excelFileName);
}catch(Exception e){
e.printStackTrace();
}

step2: i am trying to convert the saved excel to pdf

after performing step 1 if i try to open excel its throwing exception saying that

excel has unreadable content.

any suggestions?


Thanks



17

Hi,

Thanks for your posting and using Aspose.Cells for Java.

We were able to observe this issue using your code and source file. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40540.

18

Hi

Any update on this issue?

This is high priority issue from our side, Can you please provide the ETA for this defect?


Thanks

19

Hi,

Thanks for your posting and using Aspose.Cells for Java.

We are afraid, there is no update for you at this moment. However, we have logged your comment against this issue. Please spare us some time. Once, we will have some update for you, we will let you know asap.

20

Hi

Thanks for the reply.
Any news on the above issue ?


Thanks