help export

[akp09]

Hi,

How would you export text file to Excel file in
Console Application?

 

[michaenh]

hi

well.. you have to first import the text file to your application then export it to excel file.

export - you could try OLE automation/COM programming
Remember excel have cells(rows and columns).

cheers,
mha

 

[TonHu]

a) Just open with Excel, and use the wizard to convert columns to fields etc.

b) Read the file, convert to columns in the way you need, write back as a .CSV file, with fields separated with commas, and fields that contain commas enclosed with quotes.
Depending on the windows settings for fieldseparator (comma?) the file will be read correctly.

HTH
TonHu