Forum Discussion
MicrosoftWant 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.
tarunkambojThanks 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.
- : We are storing excel file as base64 in our table.
?
base64 in our table. ?
workbook is a zip file in binary rather than base64 as far as I know.
And if you have download the Excel workbook from a web/Http server,you can run pivottable of Excel in local driver certainly.
So I really do not know what is your problem in detail.
If you want to generate analysis report on remote server rather than on client side,just using C# program which has no relation with ODC.
When want to connect remote sqlServer or MySQL directly,you can use ODBC driver instead to import data to Excel analysis.- tarunkamboj
peiyezhu Yes you are right.
excel is file type in table.
Issue is I have connection string for PowerBI dataset.
Is there a way, I can connect excel to this external connection string in c#.