IBM Sterling Ideas

Submit new product ideas for IBM Sterling solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed.

IBM is transforming its request for enhancement (RFE) process. The purpose of the transformation is to provide a more consistent experience for you to submit requests and to enable IBM product owners to respond to your requests more quickly. For more information click here.

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

Extract all Sheets(tabs) from Microsoft Excel into 1 csv file with sheet(tab) spacers

Is there a way in which I could read the whole workbook that would include
all the sheets (tabs) at once, instead of creating multiple cards or calls issuing
the PARSE(GET("EXCEL", "-W 'Tab 1' -T", ExcelIn)) changing the sheet name.

Is there a wild card that could be used for the "-W" parameter that would get both sheets(tabs)
as a 1 time "PARSE(GET(EXCEL)".
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jan 9 2018
  • Declined
What is your industry? Banking
What is the idea priority? Urgent
DeveloperWorks ID DW_ID109788
RTC ID RTC_ID549561
Link to original RFE http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=109788
  • Attach files
  • Admin
    Luke Raiano commented
    17 Oct, 2018 03:43pm

    The current architecture would not allow for this structure, and could potentially introduce performance issues