This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JSF and the fly likes How to embed file objects injava using POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JSF
Bookmark "How to embed file objects injava using POI" Watch "How to embed file objects injava using POI" New topic
Author

How to embed file objects injava using POI

Anju Kul
Greenhorn

Joined: May 31, 2011
Posts: 5
Please help me with code snippet for

How to embed file objects like .doc,.xls,.ppt and others into excel file using Apache POI.

The file objects are stored in database in BLOB and then to be retrived and embed as file objects in excel.

The functionality should be same like as we have in excel
insert-> object-> select a type
Please help its urgent
Anju Kul
Greenhorn

Joined: May 31, 2011
Posts: 5
Please reply its urgent
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41089
    
  43
I don't think POI can do that. I believe there's some rudimentary support for working with objects that are embedded already, but not for adding embedded objects.


Ping & DNS - my free Android networking tools app
Anju Kul
Greenhorn

Joined: May 31, 2011
Posts: 5
Thanks for reply

Canyou suggest any other way to embed objects in excel using java

May be some code snippet or some useful link I can refer to....
Anju Kul
Greenhorn

Joined: May 31, 2011
Posts: 5
Any idea on same... its urgent guys
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41089
    
  43
OpenOffice has a Java API, and can be run in server mode without showing a GUI; maybe that's powerful enough.

If it's "urgent" I advise to assume that it can't be done. If there is a solution, you won't get to it quickly.
Anju Kul
Greenhorn

Joined: May 31, 2011
Posts: 5
Hey thanks a lot
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to embed file objects injava using POI
 
Similar Threads
how to insert a file object in excel sheet using java
Restricting special characters while writing to excel
Export to excel in jsp
Excel Generation using POI
Excel Generation using POI