Using .Net app to connect to sql and get the data using store proc, creating excel file in the app and opening the file. There are no problems with this process. It is just that when the excel file that is produced is small size, excel does not open the file. This is a known issue and the workaround is to create empty rows in excel so that it increases the file and opens the file without any issues.