If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Simulating a spreadsheet in PCL?
Hi folks,
Hoping someone out there will have some tips or tricks for me. Or can direct me in the right direction. I'd like to be able to read in a CSV file that my system creates into a PCL file and somehow simulate the cells that you would see in an Excel spreadsheet. In other words, I need the little cells/boxes around the numerical data or it will be just too hard to read. If I can get this data into some sort of PCL "grid", I can convert that to PDF and my users would be much happier with the PDF files vs. the CSV files they get now. Even though the current CSV opens into Excel with no problem. They much prefer the manual PDF files I was making daily. But this job now runs seven days a week and I can't always be sitting AT my desk to make the file manually at the same time every day of my life. So, I automated it but at the time, could only create a CSV for them. Can anyone direct me on how best to create "cells" or boxes in PCL around data like this? Thx in advance, JJ |
#2
|
|||
|
|||
Simulating a spreadsheet in PCL?
JJ wrote:
Hi folks, Hoping someone out there will have some tips or tricks for me. Or can direct me in the right direction. I'd like to be able to read in a CSV file that my system creates into a PCL file and somehow simulate the cells that you would see in an Excel spreadsheet. In other words, I need the little cells/boxes around the numerical data or it will be just too hard to read. If I can get this data into some sort of PCL "grid", I can convert that to PDF and my users would be much happier with the PDF files vs. the CSV files they get now. Even though the current CSV opens into Excel with no problem. They much prefer the manual PDF files I was making daily. But this job now runs seven days a week and I can't always be sitting AT my desk to make the file manually at the same time every day of my life. So, I automated it but at the time, could only create a CSV for them. Can anyone direct me on how best to create "cells" or boxes in PCL around data like this? Thx in advance, JJ It's not too difficult to generate your own pdf's from the raw numeric data. See the nice pdf introduction by Kas Thomas, http://www.mactech.com/articles/mact...tro/index.html -- *********** To reply by e-mail, make w single in address ************** |
#3
|
|||
|
|||
Simulating a spreadsheet in PCL?
Wow, very interesting. Thx! JJ
"Ian Gay" wrote in message ... JJ wrote: Hi folks, Hoping someone out there will have some tips or tricks for me. Or can direct me in the right direction. I'd like to be able to read in a CSV file that my system creates into a PCL file and somehow simulate the cells that you would see in an Excel spreadsheet. In other words, I need the little cells/boxes around the numerical data or it will be just too hard to read. If I can get this data into some sort of PCL "grid", I can convert that to PDF and my users would be much happier with the PDF files vs. the CSV files they get now. Even though the current CSV opens into Excel with no problem. They much prefer the manual PDF files I was making daily. But this job now runs seven days a week and I can't always be sitting AT my desk to make the file manually at the same time every day of my life. So, I automated it but at the time, could only create a CSV for them. Can anyone direct me on how best to create "cells" or boxes in PCL around data like this? Thx in advance, JJ It's not too difficult to generate your own pdf's from the raw numeric data. See the nice pdf introduction by Kas Thomas, http://www.mactech.com/articles/mact...tro/index.html -- *********** To reply by e-mail, make w single in address ************** |
#4
|
|||
|
|||
Simulating a spreadsheet in PCL?
In article ,
JJ wrote: Hi folks, Hoping someone out there will have some tips or tricks for me. Or can direct me in the right direction. I'd like to be able to read in a CSV file that my system creates into a PCL file and somehow simulate the cells that you would see in an Excel spreadsheet. In other words, I need the little cells/boxes around the numerical data or it will be just too hard to read. If I can get this data into some sort of PCL "grid", I can convert that to PDF and my users would be much happier with the PDF files vs. the CSV files they get now. Even though the current CSV opens into Excel with no problem. They much prefer the manual PDF files I was making daily. But this job now runs seven days a week and I can't always be sitting AT my desk to make the file manually at the same time every day of my life. So, I automated it but at the time, could only create a CSV for them. Can anyone direct me on how best to create "cells" or boxes in PCL around data like this? Thx in advance, JJ Don't know about PCL programming, but if you were doing it by hand (on Windows), you can automate it with "autoit3". I used it on a few projects, and it's not too hard to pick up and it's free: http://www.autoitscript.com/site/autoit/ (You could probably also script OpenOffice to open a csv and print it to a PDF from a shell script or batch file) -- ------ columbiaclosings.com What's not in Columbia anymore.. |
#5
|
|||
|
|||
Simulating a spreadsheet in PCL?
"Ted Nolan tednolan" wrote in message
... Don't know about PCL programming, but if you were doing it by hand (on Windows), you can automate it with "autoit3". I used it on a few projects, and it's not too hard to pick up and it's free: http://www.autoitscript.com/site/autoit/ (You could probably also script OpenOffice to open a csv and print it to a PDF from a shell script or batch file) Thanks for the info. I'm not able to install new s/w to this server. So, I need to do this w/ the tool we already have. We already convert 100's of PCL files to PDF daily so I can use that existing function. I was just hoping for some help with the PCL commands to maybe make a grid. Thanks again! JJ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Open source "Get Legal" your spreadsheet, database,etc programs | MikeA | Creative Sound Blaster Cards | 0 | May 5th 06 02:07 PM |
pcl 5e commands | Rebecca Riehm | Printers | 4 | January 29th 05 09:51 AM |
hp 1012 & PCL | James Toast | Printers | 0 | November 10th 04 02:06 PM |
PCL XL error | Mike Ralph | Printers | 0 | November 26th 03 08:25 PM |
Sending Infrared Signals (simulating remote controls) | Gaines | General Hardware | 0 | July 15th 03 05:19 AM |