Print MS Excel Spreadsheet to Printer
Joyce Kind
Greenhorn
Posts: 8
posted 8 years ago
Hi all,
I am having a problem to print an Microsoft Excel spreadsheet to printer using Java. I searched POI, Jxcell ect. and could not find the solution. The Jave Print Service API seems no support too. Sorry if I am wrong.
Could anybody, who printed the spreadsheet to printer using Java before, please tell me which API you have used? I would like to study for it.
Thanks in advance,
Joyce
I am having a problem to print an Microsoft Excel spreadsheet to printer using Java. I searched POI, Jxcell ect. and could not find the solution. The Jave Print Service API seems no support too. Sorry if I am wrong.
Could anybody, who printed the spreadsheet to printer using Java before, please tell me which API you have used? I would like to study for it.
Thanks in advance,
Joyce
Ulf Dittmer
Rancher
Posts: 42970
73
posted 8 years ago
Welcome to JavaRanch.
You're right that none of the Excel APIs support printing, and I don't think any printer supports printing XLS files directly, so the Java printing APIs won't be of much help out of the box.
The two possible ways I see are either to use OpenOffice (by way of its Java API), or to implement printing yourself. For the latter you'd use POI or jExcelAPI to read the file, and then implement the Printable interface to do the actual imaging. The former is probably easier, but still has a fair learning curve.
You're right that none of the Excel APIs support printing, and I don't think any printer supports printing XLS files directly, so the Java printing APIs won't be of much help out of the box.
The two possible ways I see are either to use OpenOffice (by way of its Java API), or to implement printing yourself. For the latter you'd use POI or jExcelAPI to read the file, and then implement the Printable interface to do the actual imaging. The former is probably easier, but still has a fair learning curve.
| It is sorta covered in the JavaRanch Style Guide. |