Reading unstructured data from Excel

shwetarathi

• April 24, 2014 00:00

• Answered

Follow

Hi,

I am trying to read 3 fields(Clover,2,"Central) Client, Build Version and Region from a Excel sheet into Clover. I need to read these dynamically as my input file changes every time.
Screen Shot 2014-04-24 at 11.27.42 AM.png
Is there an easy way to do this? I am thinking using parameters could be one option but not sure how to make it dynamic.
I have attached a screenshot of how my input looks.
I would appreciate your help.

Thanks a ton.

• Screen Shot 2014-04-24 at 11.27.42 AM.png

• 

  shwetarathi

  • April 24, 2014 20:20

  0

  Comment actions Permalink

  Hi,
  
  I am trying to read data(Client, Build Version and Region) values from an Excel file dynamically.
  
  I have tried to read it using XLS reader and it worked but I am pretty sure there is a better way to do it. Maybe using parameters?
  
  Do you think you could help me figure it out? I have attached a screenshot for your reference.
  
  Thanks for your time.
  
  -Regards
  
  Shweta

  • Screen Shot 2014-04-24 at 11.27.42 AM.png
• 

  imriskal

  • April 25, 2014 08:34

  0

  Comment actions Permalink

  Hi Shweta,
  
  What do you mean by "dynamically", please? Does the position of these fields change? How? Horizontally, vertically, among various sheets or among various files? Could you please describe your task in more details?
  
  Thanks,
• 

  shwetarathi

  • April 25, 2014 14:00

  0

  Comment actions Permalink

  Hello imriskal,
  
  By dynamically, I mean every time I change the input file. The position of these fields does not change. Its pretty much constant.
  Sorry for confusing you.
  
  Thanks.
• 

  imriskal

  • April 28, 2014 09:03

  0

  Comment actions Permalink

  Ok, great. If the position is constant, you can read the whole file, pick just the fields you need and store them in dictionary. At the end, join dictionary values into one record. Please see the example graph. The conditions in if clauses in the first Reformat are just for the purpose of the example, maybe you can find some more suitable ones.unstructured.zipRegards,

  • unstructured.zip

Please sign in to leave a comment.