I would like to read excel files containing one sheet only. But columns headers may not be same apart from 2 columns Lat and Long. I am using VertexCreater to create point from Lat,long.
e.g. Excel1.xls contains A,B,C,Lat, Long
Excel2.xls contains C1,C2,C3,C4,Lat, Long,C5,C6
Excel3.xls contains Lat,Long,A1,B1,C1
How can I read excel file with dynamic scheam and retain all attributes for destination format.
Cheers.
Best answer by takashi
In my understanding, a writer with Dynamic Schema identifies a schema source by the feature type name. And, in the Excel format, worksheet names will be treated as feature type names. So I think the dynamic schema mechanism may be used if every worksheet name is unique. Otherwise, it may be hard.
Takashi
In my understanding, a writer with Dynamic Schema identifies a schema source by the feature type name. And, in the Excel format, worksheet names will be treated as feature type names. So I think the dynamic schema mechanism may be used if every worksheet name is unique. Otherwise, it may be hard.
Takashi
