Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

API or utility to generate PRN files?



> From: Robert La Ferla <robert at laferla.net>

> I need to generate a ".prn" printer file from a Excel spreadsheet (.xls) 
> via Java or PERL.  Is there an API or utility that I can use to do this 
> either under Linux or Windows?

Under Windows, you can use the Perl Win32::* modules to activate
Excel via the COM/OLE API; I expect you could use that to script Excel
Print functions.
 http://search.cpan.org/~nwclark/perl-5.8.7/win32/ext/Win32/Win32.pm
 http://search.cpan.org/search?m=all&q=win32
 http://search.cpan.org/~jdb/libwin32-0.26/OLE/lib/Win32/OLE.pm
OLE is sadly easier to program and explore via Perl than via VBA.


Under Linux, Perl has Excel modules which will allow reading files
"natively" without Windows.  
 http://search.cpan.org/search?query=Excel&mode=all
 http://search.cpan.org/search?query=spreadsheet&mode=all
but then you'll probably have to decide what to format in your print file
yourself.


-- 
/"\     Bill Ricker  N1VUX  wdr at world.std.com
\ /     http://world.std.com/~wdr/           
 X      Member of the ASCII Ribbon Campaign Against HTML Mail
/ \




BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org