Skip to main content
Question

Excel Reader - Incorrect String Length

lance
Contributor
Forum|alt.badge.img+5
  • lanceContributor
  • Contributor

I am using FME Form 2024.0 to read an excel file for processing.  The reader is not determining the correct max length of multiple text fields in the XLSX file.

I have set the max rows to scan to a value larger than the total row but short of manually setting these values I cannot get the reader to detect the correct field length.

The FME Help for the MS Excel Reader states to leave this setting blank to scan all rows but the transformer will not except a blank value.

I also tried to use the FeatureReader rather than a standard Excel Reader with the same results.  I want this to be dynamic as the data being read is variable.  Any suggestions or workarounds?

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme

2 replies

lambertus
Enthusiast
Forum|alt.badge.img+15
  • lambertusEnthusiast
  • Enthusiast
  • May 27, 2024

Hi @lance, does this reader issue influence the resulting data red from Excel into FME? 

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
justinweaver
Contributor
Forum|alt.badge.img+2
  • justinweaverContributor
  • Contributor
  • March 17, 2025

To follow up on the same issue. - Is there a way to manually override the TYPE settings in Bulk? ie from the EXCEL reader - id like to set 20 attributes to the same CHAR length , But at the moment i have to do it manually one by one. Anyone know of a way to do selected list at once? 

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme

Reply


Helpful Members This Week

Community Stats

31,340
Posts
118,849
Replies
38,929
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.