Script error : Unable to load headers from the XLSX data source
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 01:13 AM
Hi,
I need to load an excel file using a business rule, the file is attached to the data source. The headers start in row 3 (the first rows are for title and languages). 'Header row' field in Data source is 3.
When i test manually (Load all Records) it works but when i use the script i get this error :
Root cause of JavaScriptException: com.glide.db.impex.datasource.DataSourceException
: com.glide.db.impex.datasource.DataSourceException: Unable to load headers from the XLSX data source: com.glide.db.impex.ExcelLoader2.setImportDataSource(ExcelLoader2.java:94)
com.glide.db.impex.datasource.ExcelDataSource.getLoader(ExcelDataSource.java:71)
This is a part of my script :
Does anyone have an idea what the issue here ?
Thank you for your help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 03:45 AM
Have you double checked the Sheet Number and Header Row field values in your Data Source record?
What is the full text of the error message? Are there any additional errors in the system log during the import?
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/