XML and Excel

Advertisement

has anyone created any PLSQL using the XMLAGG and XMLELEMENT to create XML file output that can be read natively by MS Excel? I'd like to have/make something relatively simple that would have an API like this:
make_me_excel( p_query =>    'select a,b,c from my_table',
p_formats => 'a:text , b:date , c:number ',
p_path =>      '/tmp',
p_fname =>    'myfile.xls');Better yet, have oracle check the dictionary for the column types and auto format accordingly.
I could probably do everything myself except for getting it into the Excel XML format. Any suggestions?
Thanks,
Mike

Advertisement

what is the XML format the Excel expects?
if you post that, maybe we can see how to generate that from the given query.

November 30, -0001

XML and Excel

has anyone created any PLSQL using the XMLAGG and XMLELEMENT to create XML file output that can be read natively by MS Excel? I'd like to have/make something relatively simple that would have an API like this: make_me_excel( p_query =>    'select a,b

Mime-type tag in web.xml and attachment download

i have set a mime-type in web.xml as below: <mime-mapping>      <extension>xls</extension>      <mime-type>application/vnd.ms-excel</mime-type> </mime-mapping> And i have a simple jsp that only shows a table and i am ma

Please enable REST support in WEB-INF/conf/axis2.xml and WEB-INF/web.xml

Hi  All, we are not able to connect to Live office to our server . URL is  not authenticated in Excel and  if we place same url in browser ,we are getting below error message. "Please enable REST support in WEB-INF/conf/axis2.xml and WEB-INF/web.xml&

XML Publisher excel template

Hi , after installing the Patch Patch 12415414: 1OFF:11873050:12.1.3:12.1.3:FRM-41830, FRM-40212 SUBMITTING PROGRAM - PUBLISH FS i managed to add and excel template to XML Publisher , the template working fine in the Desktop template viewer but when

Could 'export button' show only pdf, and excel only?

Hai, I am using report viewer, it has export button in that header. Could 'export button' show only pdf, and excel only? So the report just only export pdf only or excel only. Technology: Asp.net Vs2010 SSRS2012 Windows 7I found the solution: http://

UTF-8, Unicode, XML and windows problems

Hi there, I'm developing an application which uses a lot of russian text. This russian text is stored in XML and can be sent to a server remotly I use the standard javax.xml libaries to parse the xml files and DBunits XMLWriter to write generate XML

Word, powerpoint and excel are not working with lion. Has anyone else had this problem

Word, Powerpoint and Excel have stopped working since downloading Lion. Has anyone else got this problem?Which version?  If it is 2004, then you are out of luck - Lion no longer supports apps written for PPC processors, only Intel.  There is no solut

How can i restrict the selecting file type to XML and TXT in file upload..

Hi, I am using Struts Upload Bean. I am also using html:file tag in the JSP. Now when i click on the browse button, A file dialogue window appears. The problem id the i want to show only text and xml files in the dialog box. Now the files of type com

SSRS/Powerview to compare SQL table and excel sheet

I have a SQL table and an excel sheet with some data... I want to be able to compare the two and find out which Excel rows are missing in the SQL table... Would it be easier to do this report in SSRS or would it be better to do it in Excel PowerView?

New to XML and Oracle

Just trying to clarify some issues as I try and learn about XML, and specifically how it integrates into the DB. 1 - Is there a way with Oracle tools for me to get an XSD of an existing 9i relational schema? We are not currently using the XML DB, but

How Do I read a String as an XML and reply?

Hello there to everyone reading my Post ! I am entering a total new subject in my learning about Java Programming, where I will need to interact with a server, I was wondering If somebody could help me with a Question I have; here it is: A server pro

NEW TO XML AND JAVA

hi, I'm new to xml, actually I'm taking a course in xml and I should choose a certain project related to xml. I want to ask about xml and java the things that I know about java is some classes ( I made a program of bouncing ball in java and changed s

Template builder for adobe pdf and excel

Hi All I couldnt find plugins and template builders for adobe pdf and excel. some pointers pls.. thanks cmRainer, I want to use this PDF Templates in EBS, is it possible?.. and also I have 10 sample output pdfs and one RDF for my AR Invoice Report. F

Xml and createEmptyMovieClip

I have created an julia.swf file with a connection to an xml file using the xml connector component. The file has a dropdown where you can choose the name of a movie and a dependant textbox that populates with the movie details when a movie has been

My microsoft word and excel programs won't work and files won't open.

After an automatic HP update, my Microsoft Word and Excel programs won't work and my files won't open.  What caused this and what can I do to fix the problem without losing my files?  I have files that are part of my work and I HAVE to have them ASAP

Data source for deposit advice xml and check writer xml

Could someone please tell me where I can find the data source for the Deposit Advice XML and Check Writer XML programs. Since these executables are now a spawned process (PYUGEN), I don't know how to get to the data source. I was able before to look

Essbase and Excel Add-in Migration from 6.5 to 11.1.2.1

Hi, Essbase and excel 6.5 Wanted to Upgrade to 11.1.2.1 since there only essbase we just need to install 11.12.1 essbase and copy the otl files and series of steps but how to upgrade the Excel addin 6.5 to 11.1.2.1If you are doing a clean upgrade the

How to set buildID.xml and custom.properties in SDK

Hello, I just completed a new build deployment of SAP ME5.2, because after I deployed the new version, I don't think I have set a correct version number.Can you someone give me a sample how to set the buildID.xml and custom.properties? I am a new on

[svn:bz-trunk] 21002: Clean up build. xml and remove unnecessary delete task in the jar target.

Revision: 21002 Revision: 21002 Author:   [email protected] Date:     2011-03-31 09:47:04 -0700 (Thu, 31 Mar 2011) Log Message: Clean up build.xml and remove unnecessary delete task in the jar target.  Checkin tests passed. Modified Paths:     blazed

OS X Lion crashes trying to print from Safari, Pages, Acrobat, Word and Excel

My OS X Lion crashes while trying to print in Safari, Pages '09 (4.1), Acrobat, Word and Excel. It works in Adobe CS5 Photoshop, Illustrator, InDesign, Numbers '09 (2.1), Apple Mail, and Preview. I'm printing to a Dell 3130 color laser printer.Here's