How to convert CSV file to XLS file using C# Programme

[liyakhat_shahid]

Hi frinds, My Question is simple. How to convert the CSV file to XLS file using the C# Programming langueage. Thanks, Liyakhat.

[Bijesh]

You can use the Excel Application object Microsoft.Office.Interop.Excel namespace...

[Jimmanuel]

try using Google[^] - the first result gives you a full code example of the answer to your problem

[martin_hughes]

Have a look at this article: http://www.codeproject.com/csharp/csharp_csv_fileparser.asp[^]

[Pete OHanlon]

Christian answered this question for you when you asked it yesterday and Jamie answered it the day before. Please don't repost questions. You need to understand that people here will normally give you the hints/areas that you need to look at in order to complete your task. They will not give you the complete application. You are expected to do some work on your own, and having been told to look at office Interop it is not unreasonable to think that you will have used <> to research the topic. If you have a problem with code then tell us what you have done, where the problems are and what they are. At that stage, we will be able to provide more help.

Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.

[liyakhat_shahid]

Hi Bijesh, First of all thanks, I got the code to Convert CSV file to XLS file using Excel Application object. My code: using System; using System.Collections.Generic; using System.Text; using System.Reflection; using Microsoft.Office.Interop.Excel; namespace File_Conversion { class Program { static void Main(string[] args) { ApplicationClass app = new ApplicationClass(); Workbook doc = app.Workbooks._Open( @"C:\GCProject\Input Example.csv", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, false, Missing.Value, Missing.Value, false); Console.WriteLine("Reading CSV File........"); doc.SaveAs( @"C:\GCProject\Output.xls", XlFileFormat.xlWorkbookNormal, Missing.Value, Missing.Value, Missing.Value, Missing.Value, XlSaveAsAccessMode.xlExclusive, Missing.Value, false, Missing.Value, Missing.Value, Missing.Value); doc.Saved = true; Console.WriteLine("Converted CSV to XLS file"); app.Quit(); Console.ReadLine();