How to better control Excel Reader for unwanted Warnings ?

Hi Michael,

An option in the FME Options exist to filter log messages and not show Warnings, but that will disable all warnings:

These settings for the Excel Reader can also help:

Reading blank cells as Null instead of missing can avoid some warnings.

Warnings are quite often the result of empty records at the end of the list that is read. Using the End Row setting the read can be stopped before hitting the empty rows.

Hope this helps.

Thanks for the hints.

The "Read blank cells as" option doesn't help. I tried both variants.

Start/End Row settings are no options, as the Excel contents may vary anytime.

So I consider this a weakness of the Excel format itself or the Excel reader.

Well, digging a bit more into this ...

it helped to delete all worksheets I don't use

Last resort: It may have to do with "splitting Feature tables ..." and the magic related to that turbo approach ...

Still: it is annoying !

@mhab Can you include a sample of your spreadsheet and the configuration of your excel reader. Then we can try and reproduce the problem here. We'd like to suppress these kind of spurious log messages if we can.

Hello Mark

The reason seems to be a SchemaMapper which uses one of the Excel worksheets.

I sent a sample workspace and data to support for further clarification.