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.
Width of PRN file
-
khurshid.arshad
- Posts: 618
- Joined: July 9th, 2012, 11:32 am
- Location: Islamabad, Pakistan
Width of PRN file
You do not have the required permissions to view the files attached to this post.
-
Gregory Martin
- Posts: 1947
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Width of PRN file
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.
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.