Forum Discussion
tarunkamboj
Microsoft
MicrosoftWant to connect excel with odc.
Problem statement: User click on any report. We will capture excel and odc base64 string from report entity. We need to connect excel with odc and download it on user's system.
Tried and failed...
need to connect excel with odc
I am not sure what you mean odc?
Read Excel workbook on Server side can use NPOI or open XML sdk.
If read .xlsx with standard structure table e.g. headers in first line and detail data from second line,Ado is an alternative way.
I am not sure what you mean odc?
Read Excel workbook on Server side can use NPOI or open XML sdk.
If read .xlsx with standard structure table e.g. headers in first line and detail data from second line,Ado is an alternative way.
tarunkambojMicrosoft
MicrosoftThanks for your response.
ODC here is Office data connection.
We have excel which contains pivot table. These tables will be connected to PBI dataset using ODC connection.
Issue is: We are storing excel file as base64 in our table. We generate ODC file which know the info of dataset. We want to connect Excel to ODC at server side and send it to client side. So that excel with the connection got downloaded to the user's local machine. And when user open excel, data in the pivot table got populated using the connection.
We did POC of excel data got populated when we have the connection.
We need some way to connect excel to odc.