Posts

Showing posts with the label How to import / export excel file using open xml

How to import / export excel file using open xml

Download " DocumentFormat.OpenXml.dll " from website and write following code protected void btnimport_Click( object sender, EventArgs e)     {         try         {             DataTable dt = new DataTable ();             if (fu_File.PostedFile != null )             {                 string strtimeStamp = string .Empty;                 strtimeStamp = System. DateTime .Now.Ticks.ToString();                 string fileName = Server.MapPath( "~/UploadFile/" ) + strtimeStamp + "_" + fu_...