Read/Write Excel spreadsheet in Forms6i but no excel

35 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • PaolaChile
    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
    35 pointsBadges:
    report
  • carlosdl
    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
    70,220 pointsBadges:
    report
  • PaolaChile
    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
    35 pointsBadges:
    report
  • carlosdl
    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.
    70,220 pointsBadges:
    report
  • PaolaChile
    Thanks a lot, Carlos. Regards from Chile, Paola
    35 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following