ioException POI changes, read excel file

[sLuintel]

Hello, i am kind of repeating myself... but hopefully someone help.

The issue is that I am receiving an error message as below:

IOException on file /glide/nodes/mhpdev001_16008/bin/../tmp/ids5ae7362a2b62650080d64c7605da1517.tmp, Invalid header signature; read 724303750490253372, expected -2226271756974174256

I also know that this issue is because the Excel file that is being imported was exported in a format other than a native Excel file (XML, HTML, etc.). I have try opening the Excel file (in Excel) and click File | Save As. Select the XLS file type. Try the import again using the "new" XLS file. and this works.

However, the problem is that this function is supposed to be automated function and we don't want somebody to manually get the export and save it as .xls and import it again. Is there a way where the POI will be able to read the file as .xls without having to manually save it and import it?

[Albert13]

Pradeep,

It should be doable.   What are you looking to do with the data once you've read it?

Albert

[pradeepgupta]

Hi Albert,

Thanks for your reply.

Could you please help me to achieve this.

Service-now is integrated with third party application, after reading the data, I need to send these data to third party using REST.

Actual process will be as follows:

Creating Service Request using Catalog with Attachment ---->>Reading data attached to Service Request (Using Script in Business rule or Script include) ---->>Calling REST to send these data to third party--->>Third party will receive data and send acknowledgement.

[Parnika Mishra]

Hi - Did anyone figure how to resolve this?