Export to excel /xlsx file

[Ballita]

Hi, I need to export file in xlsx format. My code is bellow: string Path = strFullTo + "Balancing_" + String.Format("{0:MMddyy}", DateTime.Now) + ".xlsx"; StringWriter stringWriter = new StringWriter(); HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWriter); GridView DataGrd = new GridView(); System.IO.StreamWriter vw = new System.IO.StreamWriter(Path, true,System.Text.Encoding.Default); stringWriter.ToString().Normalize(); string style = @" .textmode { mso-number-format:\@; } "; vw.Write(style); vw.Write(stringWriter.ToString()); vw.Flush(); vw.Close(); But my problem is when I am trying to open the xlsx file it is saying "File format or extension is not valid". I need to keep the data in xlsx file. Please help.

Thanks & Regards Mishra

[ZurdoDev]

You need to export as .xls instead of .xlsx. .xlsx is more of an xml format but .xls can support html format, which is essentially what you are doing.

There are only 10 types of people in the world, those who understand binary and those who don't.