Hi,

First of all Marry Christmas to all.

I am writing a file to excel. Its working fine but there i delimited that report manaully, selecting 1st column then data/text to columns and then delimeter "|".


Is there any way to delimite it from the code itself.???


Suggestions are welcomed
Thanks

Try saving the file with filetype CSV. Excel will open CSV on doublicking and import it automatically.

If the file is imported without detection of the rows, than you will need to change the default table delimeter in your language settings of windows.

We've setup an baan-excel-printer to print an customized report directly into excel using the delimeted format.

Thanks Andreas......its working.

Hi Andreas (or anyone else), sorry but could clarify what or where the "default table delimeter in your language settings of windows." is? Thank you

Under control panel, region and language on win 7. I believe - not sure about this since I tested this years ago - you can change the list separator. Then it might pull up | files just like a comma delimited file. I think the file was still .csv, but really can't remember. I think you could have one or other as the default.

I'm using a german Windows 7, so the menu-names may differ. Start the control panel and go to the date, language settings. There's a "additional settings"-button in the session where you can change your date-formats. There you'll find the delimiter setting in the numbers-tab.

Google found a detailed description: http://answers.microsoft.com/en-us/office/forum/officeversion_other-excel/how-do-i-change-the-system-separator-delimiter-to/9f8d5f2c-940f-4418-b952-bfeac867c03e

Kind regards
Andreas