2nd Method for import / export excel file using open xml
Download "Excel.dll" and "ICSharpCode.SharpZipLib.dll" and paste in bin folder protected void btnImport_Click( object sender, EventArgs e) { string strtimeStamp = string .Empty; strtimeStamp = System. DateTime .Now.Ticks.ToString(); string fileName = Server.MapPath( "~/UploadFile/" ) + strtimeStamp + "_" + FileUpload1.FileName; FileUpload1.SaveAs(fileName); ProcessYINVCO(fileName, 1, true , 1); } protected void btnExport_Click( object sender, EventArgs e) { DataSet dsDown = new DataSet (); dsDown = obj.GetYINVCO(0); if (dsDown !...