Exporting data to excel from datagrid, Problem.
How are you all? Hope you all are fine.
I have successfully downloaded data from datagrid to an excel file. Now I am trying to upload that excel file into the web-server after that I was trying to access that excel file as database. OK!
But an error occurred. The error message was âExternal table is not in the expected format.â Then I have checked the downloaded excel fileâs format.
The downloaded excel fileâs type was âWeb pageâ. I also have checked its Response.ContentType, That was âtext/htmlâ.
But in my download code I have mentioned
Response.ContentType = "application/vnd.ms-excel";
Hope you all understand the problem.