Excel Import with worksheets and ranges error

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
jdinero
Participant
Posts: 18
Joined: Wed Feb 08, 2012 12:24 pm
Location: NJ

Excel Import with worksheets and ranges error

Post by jdinero »

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
-Jennifer
Post Reply