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 4054 posts 12927 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 4054 posts 12927 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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies