• 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
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
Sheriffs:
  • Devaka Cooray
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Tim Holloway
  • Claude Moore
  • Stephan van Hulst
Bartenders:
  • Winston Gutkowski
  • Carey Brown
  • Frits Walraven

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

 
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: 724
5
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!