Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Conversion Problema - The maximum length of cell contents (text) is 32,767 characters

  1. #1
    Join Date
    Sep 2016
    Posts
    4

    Question Conversion Problema - The maximum length of cell contents (text) is 32,767 characters

    I'm trying to pass from a csv file to a XLSX (Excel 2007 and Above) but i get an error "Error writing field (15,3356) : java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters".

    I Know this is a Excel limitation.

    Any solution for this problem?

    Thanks

  2. #2

    Default

    Off-hand, I'd recommend just doing a "String Cut" to only keep the first 32k characters.

    Alternatively, you can split the field every 32k characters using a Regular Expression. Note that you'll need to know how many splits will occur, so that you don't lose any part of the data.

    Here's a sample that splits every 5 characters: https://pasteboard.co/Hc1A5Zu.png


  3. #3
    Join Date
    Sep 2016
    Posts
    4

    Default

    Thank You, I've used the String Cut

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.