cancel
Showing results for 
Search instead for 
Did you mean: 

configuration of text file to excel file

Former Member
0 Kudos

How to post data from text file to excel file.

this means sender side i have text file here fields are separated by commas, that data take and put in the MS-Excel sheet format, here the pages are like boxes, how to put data in that boxes.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You can use the option of Data >> Text to Columns and use the Delimited or fixed witdth option and if Comma is the Delimiter set that.

It converts automatically all the data seperated by commas to Columns.

Former Member
0 Kudos

Plz send me the sample code how to configure

Thanks and Regards

Ramesh

Answers (1)

Answers (1)

Former Member
0 Kudos

tx