Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to open an excel file in oracle forms?

User_50L5NApr 11 2021 — edited Apr 11 2021

Hello everyone,
I'm trying to open a specific excel file in oracle forms by creating a button with a when pressed button trigger, so I learned about one of the method to do that by the following query:
DECLARE
AppID PLS_INTEGER;
BEGIN
AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE );
END;
but the problem is this query is opening a new empty excel sheet, so I tried to modify the query to open the specific excel file that I want and I came with this query:

DECLARE
AppID PLS_INTEGER;
BEGIN
AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE D:\Spools\data.xlsx',DDE.APP_MODE_MINIMIZED);
END;

but unfortunately I'm facing this message after pressing the button.

Any suggestion please ?
image.png

Comments

843798
Nearly all users' machines will have a JRE already installed. In fact, Microsoft is causing quite a stir by not including a JRE in Windows XP!
843798
That is a legitimate issue, and the answer is yes you have to force them to install the JRE one way or another. On the other hand, the reason your application is 100k is probably because the JRE is so large - I.E., the JRE wraps up all the code that you didn't have to write. Besides, nowadays 5MB is not that large.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 9 2021
Added on Apr 11 2021
3 comments
1,229 views