Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • René 327 posts 852 karma points
    Aug 12, 2014 @ 15:09
    René
    0

    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é 

     


    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Aug 13, 2014 @ 08:22
    Richard Soeteman
    0

    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

    Copy Link
  • René 327 posts 852 karma points
    Aug 13, 2014 @ 08:39
    René
    0

    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é 

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Aug 13, 2014 @ 08:43
    Richard Soeteman
    0

    Yes best to have raw data indeed. Glad it's solved!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft