Hi,
I am using following code to generate dynamic excel. its work perfectly on local machine but not on server. I have googled a lot but i am not getting satisfactory answer. I am using
Windows server 2012 from www.ctrls.com
I am not getting where am i wrong ? plz help
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataSet ds = SqlHelper.ExecuteDataset(ConnPipe.GetConnection(), CommandType.StoredProcedure, "p_Quality_Design_Color_ForExcel", null);
if (ds.Tables.Count > 0)
{
createWorkBook(ds, "SaudaExcel_Format_NEW");
}
}
}
private void createWorkBook(DataSet ds, string nfileName)
{
bool vbool = true; string path = Server.MapPath("~/ExcelUpload/");
Excel.Application x ...
Go to the complete details ...