Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Could not process xlsm document #225

Closed
blcham opened this issue Oct 19, 2023 · 3 comments
Closed

Could not process xlsm document #225

blcham opened this issue Oct 19, 2023 · 3 comments
Assignees

Comments

@blcham
Copy link
Contributor

blcham commented Oct 19, 2023

When I tried to process xlsm document I got the following error :
org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)
at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:133)
at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:106)

@blcham
Copy link
Contributor Author

blcham commented Oct 19, 2023

xlsm files is confidential thus try to find another one first please.

@rodionnv
Copy link
Contributor

Fixed in #222. Now the type of the excel file should be set explicitly:

* - "application/vnd.ms-excel" - EXCEL (XLS) file.
* - "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" - EXCEL (XLSX) file.
* - "application/vnd.ms-excel.sheet.macroEnabled.12" - EXCEL (XLSM) file.

@blcham
Copy link
Contributor Author

blcham commented Oct 22, 2023

@rodionnv, Good job!

Moreover, can we autodetect it somehow if the type is not provided? (we would not do it now but later as enhancement of the module)

@blcham blcham closed this as completed Nov 10, 2023
@github-project-automation github-project-automation bot moved this from Todo to Done in SPipes related projects Nov 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Development

No branches or pull requests

2 participants