Import excel to forms [message #453205] |
Tue, 27 April 2010 20:25 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
Hi, could anyone let me know if there is a way to import excel to form in Oracle Apps Server running on UNIX using forms program unit?
I wanted to know where do we need to place the file on the server and how do we need to invoke the excel.
I would really appreciate your response.
--
Thanks
CB
|
|
|
|
Re: Import excel to forms [message #453362 is a reply to message #453240] |
Wed, 28 April 2010 06:38 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
I have seen it, I was able to create the same using windows server, but I was not sure about the unix server, I mean where do we need to place the file(which directory), also I wanted to know where or how do we need to call the excel?
|
|
|
|
|
|
|
|
|
|
Re: Forms [message #454252 is a reply to message #454084] |
Tue, 04 May 2010 11:21 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
David,
I was using DDE in windows, I was not sure how to map the path(Directory) using UNIX,please see the below sample code, I want to know how we can map this and where we can place our excel file, also how to establish a conversation with Excel
Sample code:
APPID := DDE.APP_BEGIN('D:Program FilesMicrosoft OfficeOffice10EXCEL.EXE',
DDE.APP_MODE_MINIMIZED);
I would really appreciate your help.
Thanks
[Updated on: Tue, 04 May 2010 11:25] Report message to a moderator
|
|
|
|
|
|
Re: Forms [message #454678 is a reply to message #454493] |
Thu, 06 May 2010 18:36 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
David,
My Oracle Apps server is on Unix, and I wanted to know how to use DDE.APP_BEGIN here
Initially I taught to write
AppID := DDE.App_Begin('C:\excel\excel.exe C:\emp.xls',DDE.APP_MODE_MINIMIZED);
But my doubt is that the server is on Unix and the I am not sure if this will work (C drive), also I wanted to know where do I need to place the excel file on the server, in order to get the file name and use the data.
Its really urgent rek for me, I would really appreciate if you can help me in this regard.
Thanks in advance.
[Updated on: Thu, 06 May 2010 18:40] Report message to a moderator
|
|
|
|
|
Re: Forms [message #456411 is a reply to message #454688] |
Mon, 17 May 2010 15:50 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
David,
My form doesn't load the data when I am trying to upload, it gets stuck when
MESSAGE ('Check1');
AppID := DDE.App_Begin('C:\excel\excel.exe C:\emp.xls',DDE.APP_MODE_MINIMIZED);
MESSAGE ('Check2');
this happens, I tried to keep the check messages, before and after this, I can see check1 when i run the form. I also tried using
AppID := dde.app_begin('rundll32.exe url.dll, FileProtocolHandler "file_name.ext"', dde.App_Mode_Normal);
could you please help me.
[Updated on: Mon, 17 May 2010 22:02] Report message to a moderator
|
|
|
|
Re: Forms [message #457756 is a reply to message #457076] |
Tue, 25 May 2010 20:19 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
AppID := DDE.App_Begin('C:\excel\excel.exe C:\emp.xls',DDE.APP_MODE_MINIMIZED);
This line is failing David, I think that my forms developer is calling the LINUX server and searching for the excel.exe there, rather then on the windows, so will that work if I can install open office on my Linux server?? or do you think I should further tweak my code??
I tried all the possible combinations on this, I would really appreciate if you could help me.
Thanks in advance.
|
|
|
Re: Forms [message #459723 is a reply to message #457756] |
Tue, 08 June 2010 01:57 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Have you solved your problem?
Are you just trying to open a spreadsheet so that someone can read it or are you trying to push or pull data between forms and excel?
Please search this forum for 'excel', there are very many threads on the subject.
David [EDITED by DJM: typos]
[Updated on: Wed, 07 July 2010 02:46] Report message to a moderator
|
|
|
Re: Forms [message #459818 is a reply to message #459723] |
Tue, 08 June 2010 07:21 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
David,
I was able to do the import on windows server for normal Oracle forms, where as it was not working for Oracle Apps which is on Linux server, I am still in research of how can the excel be invoked on the Linux server, I am trying to pull the data between forms and excel.
Thanks,
CB
|
|
|
|
|
Re: Forms [message #460479 is a reply to message #460371] |
Fri, 11 June 2010 07:21 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
I mean I wanted to know will AppID := DDE.App_Begin('C:\excel\excel.exe C:\emp.xls',DDE.APP_MODE_MINIMIZED); work on Linux? if we install Open Office.
|
|
|
|
|
|
Re: Forms [message #460786 is a reply to message #460781] |
Mon, 14 June 2010 15:56 |
coolbharat4u
Messages: 30 Registered: April 2010
|
Member |
|
|
Yes, I know that, I tried all the different combinations like just excel.exe, also some dll, giving ip etc, but I am not sure how to I need to do it on Linux. any help?
|
|
|
Re: Forms [message #460788 is a reply to message #460786] |
Mon, 14 June 2010 16:05 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Well how would you start it from the command line in linux - forgot about forms for a minute, you are calling like you would in windows.
|
|
|