We have found an issue when importing an excel sheet that has multiple tabs and the tabs have a 'space' in the name. We are using the parameter #shell# to enter the range to import, for example 'My Sheet'!A1:P10. If there is a space in the range name, like the one between My and Sheet above, you can VIEW the data, but you cannot run the job. If you change the worksheet name to not contain a space, it works perfectly for both VIEW and RUN
The error starts with:
EXCEL_DISEASE_STATE: Unrecognized argument: Sheet
then:
EXCEL_DISEASE_STATE: SAX parser exception thrown: The input ended before all started tags were ended. Last tag started was 'AreaExpression' (CC_PropertySet::fatalError, file CC_PropertySet.cpp, line 2,234)
EXCEL_DISEASE_STATE: Error occurred during initializeFromArgs().
Error occurred during initializeFromArgs().
main_program: Creation of a step finished with status = FAILED.
Any ideas or anyone run into this before?
THanks,
Jennifer
Excel Import with worksheets and ranges error
Moderators: chulett, rschirm, roy