IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
22 Posts

Pinned topic how to read data from excel sheet (need to make it generic)

‏2013-04-21T09:56:40Z |

Hi  guys can anyone help me on how to read data from excel sheet. I went through the forum and followed the suggestions posted over there and I even succeeded in doing that. But ma problem is how to make a generic map which will read data from same kind of excel sheets i.e once i have created the type tree from a excel sheet and the map which uses that type tree it should read all similar excel sheets(with the same structure and different data of course).  I took the ODBC route to make the DSN and point to the .xls file. Then I used the DID to create the type tree and on the input card i used the database adapter as suggested. But this works only for one excel sheet. How to make it generic??? Please help