Re: XML and Office 2003
- From: "Robert Hicks" <sigzero@xxxxxxxxx>
- Date: 19 Oct 2005 10:00:55 -0700
yahalom wrote:
> Robert Hicks wrote:
> > Just thought I would share...
> >
> > I was looking high and low about ways to take data from a database and
> > create a valid Excel formatted document (that leaves out CSV). I found
> > out (and it might not be a revelation to you) that you can create a
> > valid XML document that Excel will load as a spreadsheet. Very
> > cool...if you ask me.
> >
> > I am going to work out doing the with Oratcl and TDom? Er, what is the
> > preferred XML package for Tcl?
> >
> > Robert
>
> we already made excel xml. look at http://mini.net/tcl/14468
I am trying it...looking at the Oratcl examples on the wiki I would
have thought this would have worked:
while {[orafetch $cur -datavariable row] == 0} {
excel::addRow $worksheet [lindex $row 0] [lindex $row 1]
puts $row
}
The puts statement gives me:
SHIP 01
SHIP 02
SHIP 03
SHIP 04
So I know the Oratcl part is working.
When I open the file up Excel tells me it is bad.
Robert
.
- References:
- XML and Office 2003
- From: Robert Hicks
- Re: XML and Office 2003
- From: yahalom
- XML and Office 2003
- Prev by Date: Re: Dr. Dobb's Tcl-URL! - weekly Tcl news and links (Oct 19)
- Next by Date: Re: Setting namespace variables
- Previous by thread: Re: XML and Office 2003
- Next by thread: Re: XML and Office 2003
- Index(es):
Relevant Pages
|
