How to convert .CSV file to .XLS File in C# Programming?????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

My CSV file Contains Data like.
-----------------------------------

Ex: DriverID | CustomerID | Ship to ID | Load # | BOL Date/TimeStamp |
ProductN
520 | 2355 - | 1 | 61953 | ############
| 1 Eth 87

My XLS file Contains Data Like
------------------------------------------------------------------------------------
Ex: Field | Definition | Length | Starting Column | Ending Column
------------------------------------------------------------------------------------
delimiter
------------------------------------------------------------------------------------
TransType|Some Definition |1 | 1 | 1

-------------------------------------------------------------------------------------
delimiter ",
--------------------------------------------------------------------------------------
Termin ID | Some Difinition| 3 | 3 | 5

--------------------------------------------------------------------------------------
delimiter ",
--------------------------------------------------------------------------------------
Term SPLC | Some Difi | 7 | 6 | 12

---------------------------------------------------------------------------------------

I got the code converting CSV file to XLS file. But What I need is Converted
XLS file should look like above format in Excel sheet.


Hope I explained well.!

Thanks in advance.
Liyakhat.
Software Engineer.
Chennai, India.
 
If the delimiter is a Comma and it has a CSV extension, then just opening it
in Excel should do what you want.

Try opening it in Excel manually and see if it gives you the proper results.

If not, turn on the macro recorder and then do Data=>Text to Files, then
incorporate the recorded code/approach in your code.
 
Thanks for reply Tom,

Code I got from net to Convert the .CSV file to .XLS file(but the Problem is
converted .XLS file is not in specified format).


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();


}
}
}


Tom, I try to attach my .XLS format spec but I m new to this site. I don't
now how to attach. Can you give your mailid please.

Thanks and Regards,
Liyakhat.
 
Thanks for reply Tom,

Code I got from net to Convert the .CSV file to .XLS file(but the Problem is
converted .XLS file is not in specified format).

Full Source 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();


}
}
}

Tom, I try to attach my .XLS format spec but I m new to this site. I don't
now how to attach. Can you give your mailid please.

Thanks and Regards,
Liyakhat.
 
Try this .NET Excel converter :
http://www.aspose.com/.net/excel-component.aspx

I hope it will solve your problem because they provide code example
also for
converting csv files to excel and vice versa.
Click to expand...

Assumes running an automated instance of Excel AND you don't want an
extra dependancy on a 3rd party component...

To import FROM a CSV:
Put the CSV data into an ADODB recordset, then 'dump' it into a
worksheet like so...

wksTarget.Range("A1").CopyFromRecordset rsData

...where 'wksTarget' is a fully qualified object ref to the sheet
receiving rsData (the var containing the recordset).

To export TO a CSV:
Use Excel's SaveAs method like so...

wkbTarget.SaveAs Filename:=sFilename, FileFormat:=xlCSV

...where 'wkbTarget is a fully qualified object ref to the workbook, AND
sFilename is a string var containing the full path and filename.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top