spreadsheet reader - exclude 1 sheet

raphael

• January 29, 2015 00:00

• Answered

Follow

Hi,
I am using Spreadsheet reader component to read a dynamically created xls file.To read data from all the sheets we use ?* in the sheet attribute.Is there some way so that i can read all sheets except the 1st sheet.

• 

  admin

  • February 02, 2015 12:35

  0

  Comment actions Permalink

  Hi Raphael,
  
  Unfortunately you can't provide such mask for SpreadsheetReader. I see 2 options:
  
  

  
  
  • Using JobFlows repeatedly pass parameter into graph which reads exactly one sheet - given by parameter. Then aggregate read data.
  
  
  • If all sheets share metadata you can read data of all sheets. Add one extra field into metadata using Autofilling Functions, namely "sheet_name". Then filter output records on this field - so you get only interesting sheets.

  
  
  I hope this helps.

Please sign in to leave a comment.