Home > IT Answers > Microsoft Windows > Read/Write Excel spreadsheet in Forms6i but no excel
PaolaChile
35 pts.
 Read/Write Excel spreadsheet in Forms6i but no excel
Microsoft Excel, Oracle Forms 6i, Spreadsheets
Hi!

 I'd like to know if I there's a way to read/write a spreadsheet without to install Excel.

I'm working en Forms 6i and I'm performing a programmed task, so a file csv doesnt' work for me, the application must access and generate the Excel file automatically. 

Please, help me.

Regards, thanks in advance

Paola



Software/Hardware used:
Forms 6i
ASKED: May 12, 2010  11:35 PM
UPDATED: May 13, 2010  7:25 PM
RELATED QUESTIONS
Answer Wiki:
How to create Excel files from Forms has been asked several times here, but answers always included the use of the DDE package to communicate with Excel, and that means that Excel needs to be installed. You might need to use a third party tool.
Last Wiki Answer Submitted:  May 13, 2010  12:14 am  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for your answer! Other question, then.. Do I need to install complete Excel or only a library/component to work with ole2/dde?

Thanks again,
Paola

PaolaChile
 35 pts.
 

Ole2 is another option I forgot to mention.

I believe that you need a complete installation for both options (I’m sure about DDE, but not completely sure about OLE2, but I guess it is needed because the code actually creates an Excel application and opens it (although it could be invisible if needed)).

-Carlos

carlosdl
 63,580 pts.
 

Ok, thank you very much. Could you say me any third party tool to test? (i suppose these tools don’t need license)

Regards,

Paola

PaolaChile
 35 pts.
 

Hi Paola.

I don’t know any tool that I could recommend for this, but I just remembered about the Jakarta POI project.

Here are some examples.

Both links are in Spanish.

Hope this helps.

carlosdl
 63,580 pts.
 

Thanks a lot, Carlos.

Regards from Chile,
Paola

PaolaChile
 35 pts.