Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hi
Umbraco version 7.1.4
I have saved my excel as .xlsx - and i have different heades
When i try to import from excel i get this error:
Error validating the Data source: Index was outside the bounds of the array.
Is there any good reason for this :-)
René
Hi René,
Could it be that some headers are empty? What also could be possible is that headers use formatting. Best to copy all data to a separate sheet without formatting and try again. The Excel component can't handle some formatting.
Hope this helps,
Richard
Hi Richard
I have maneged to get it to work, i had af field where i had a formula. When i remove this it works.
Can it be true i cant have any formel in tke excel sheet?
Yes best to have raw data indeed. Glad it's solved!
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
cmsImport - Error validating the Data source
Hi
Umbraco version 7.1.4
I have saved my excel as .xlsx - and i have different heades
When i try to import from excel i get this error:
Error validating the Data source: Index was outside the bounds of the array.
Is there any good reason for this :-)
René
Hi René,
Could it be that some headers are empty? What also could be possible is that headers use formatting. Best to copy all data to a separate sheet without formatting and try again. The Excel component can't handle some formatting.
Hope this helps,
Richard
Hi Richard
I have maneged to get it to work, i had af field where i had a formula. When i remove this it works.
Can it be true i cant have any formel in tke excel sheet?
René
Yes best to have raw data indeed. Glad it's solved!
is working on a reply...