CSPro Users Forum

Dear Gregory

i am converting excel file in PRN format but after a certain width in PRN format the line goes in the end of the RPN file. For reference i am forwarding excel and PRN file. Please see in the end of the PRN file.

a.

This is a limit with Excel. It maxes out at 240 characters: http://support.microsoft.com/kb/249885

Can you reduce the width of some of your columns?

Or, you could:

1) Save out half the columns to one file.
2) Save out the other half to another file.
3) Write a CSPro batch application that would read both files at the same time, concat the strings together, and write them to a third file.

In my free time I'm been working on an Import Data tool that can convert csv or Excel files directly to CSPro format. I don't know when I'll finish it, but it'll make a task like what you're trying to accomplish much easier.