I have a form that has to put data to excel. The excel file is being created but my problem is the data is failing to insert from oracle to excel. I am using forms 6i. My machine is running Windows 7 Enterprise and office 2010. I have tried it on one with Excel 2007 and it works fine.
I am using the DDE package e.g
DOC_ID := DDE.INITIATE('EXCEL', V_PATH||V_FILE);
R := 2;
DDE.POKE(DOC_ID, 'R1C1', 'X', DDE.CF_TEXT, 40000);
DDE.POKE(DOC_ID, 'R1C2', 'Item', DDE.CF_TEXT, 40000);
DDE.POKE(DOC_ID, 'R1C3', 'Description', DDE.CF_TEXT, 40000);
EXCEPTION WHEN OTHERS THEN
:USER_message := '20000 - Error Inserting Data From Oracle To Excel '||sqlerrm;
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!