• 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