Please let me know if there is a way to access the Data from excel sheet in BPT.
How to map the BPT component's parameter to a column_name in an excel?
save the excel file as .csv
then Select the parameter there in parameter dialog click the import button when in you need to select the excel file.
Make sure the parameter name and excel column name are exactly the same . there you can map ... give it a try
Thanks for the reply...
Is there any other way to do this?
You need to more explicit in your request [img]/images/graemlins/smile.gif[/img]
Mageshc gave a valid answer that resolves your specific issue. Do you have further requirements that you have not specified?
While I have been working for Businesses that are Vendor partners with HP, IBM and Microsoft, my opinions and advice is my own.
The solutions provided are either sourced from my own scripting libraries or from a quick Google Search.