Fetch connection details from excel file

[ManikandanRam]

I have an excel file, in that i have connected analysis services (OLAP cube) and prepared pivot table. I want to fetch those OLAP connection details from that excel file programmatically to re-create the OLAP pivot table with using third party components.

Is there any way to fetch connection details (like connection string and report details) from the excel file?

Continue reading...