Excel with multiple attributes in rows

Excel with multiple attributes in rows

  
Hi,

I have the following excel format (image included in post attachment). The problem is diferent attributes are in diferent rows and not in columns, how can i import this excel?

Thanks in advance for all your help.
Hello Alexandra,

Would this component be helpfull: Excel Binary reader/writer

If i'm correct you can say which cell/colum need to be readed.

Kind regards,
Evert
Evert van der zalm wrote:
Hello Alexandra,

Would this component be helpfull: Excel Binary reader/writer

If i'm correct you can say which cell/colum need to be readed.

Kind regards,
Evert
 
Hi,

Thank you for your help. I ended up solving the problem using the following library
http://closedxml.codeplex.com/, that seems more versatile to me.

Regards
Hello Alexandra,

Just looked at it for a moment, seems handy.

Is there a general approch that can be used (read: could it be made as an OS component?)?

Kind reagards,
Evert
Hi,

You need to create an extension in Integration Studio, include the closedxml library and expose the functions that are handy to you.

I hope i answered your question.

Regards