Am using talent DI to load data to SQL server. In my excel source there some hidden rows . These hidden rows not needed to import to my database. Is there any way to do it without setting a flag in source file.?
Don't think it is possible with standard tFileInputExcel component.
May be using Apache POI-HSSF / POI-XSSF library.
Hope this helps.
Thanks for the help.
I have one more question? Is this library can be included as component in talend process.