Win a copy of Machine Learning with R: Expert techniques for predictive modeling this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

Unable to open Microsoft Excel file(using XML code in PLSQL Code)

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I have XML to create Microsoft Excel file(existing PLSQL code) using in EBS application.




Adding Debit2 to the existing one.. ran the EBS concurrent program and clicking on View Output and opening the Microsoft Excel file from Desktop.

Can you help me what is the issue?

Thank you

error.JPG
[Thumbnail for error.JPG]
 
Ranch Hand
Posts: 729
7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The error message suggests you to look up the log with its whereabout. Have you done that?
 
siva mist
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Error log is not created in D:\Files path.

Just adding another additional column to the query , don't know what was the issue.
 
siva mist
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oh i found the error log and but don't what was the issue...

XML ERROR in Table
REASON: Bad Value
FILE: C:\Users\USER~1\AppData\Local\Temp\XXC_210219.xml-1.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 12

Here is the data file...



I am not getting this error before ... after adding the Debit2 column to the existing one.

Can you please help me ?
 
siva mist
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I changed Index 12 to 14 and It was working (tested with adding only Debit2 column) and it was not working if i add Date on Bank ,Cebit2 columns

XML ERROR in Table
REASON: Bad Value
FILE: C:\Users\USER~1\AppData\Local\Temp\XXC_210219.xml-4.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 14

 
siva mist
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I should update the index(no of columns) to 17 and it us working fine.
 
Live ordinary life in an extraordinary way. Details embedded in this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!