Sorry, I missed the subject line.
We can fix that ;-)
Visual basic class to write to a text file, name this clXFile:
<code><![*CDATA*[
Private fno As Integer
Private eno As Long
Function xOpen(fs As String)
fno = FreeFile(0)
Open fs For Output As #fno
eno = Err.Number
xOpen = eno
End Function
Property Let xRec(val As String)
Print #fno, val
End Property
Property Get ErrorNo() As Long
ErrorNo = eno
End Property
Sub xClose()
Close fno
fno = 0
End Sub
]]></code>
Usage:
<code><![*CDATA*[
...
Dim er As Long
Dim ux As New clXFile
er = ux.xOpenOut(fname)
er = ux.xOpenOut(fname)
If (er = 0) Then
ux.xRec() = "<root>"
ux.xRec() = "<row>...</row>"
....
Call ux.xClose
End If
]]></code>
Bryce K. Nielsen wrote:
Not very OpenSource, like the OP requested ;-)
There are actually many tools that can do this, and even XSLT 2.0 can
read in a text document to transform into XML. I believe there are a
bunch of tutorials online explaining how to do this, though don't know
of any off hand that can. xmlLinguist (at
http://www.sysonyx.com/products/xmllinguist) is a tool I work with
that can translate a structured text document (i.e. a *.CSV) into XML
if you don't want to go through XSL. It can be a cost effective
solution at $80 for the designer, free for the runtime engine.
Designed more for EDI documents, it can do CSVs easily enough.
Bryce K. Nielsen
SysOnyx, Inc. (www.sysonyx.com)
Makers of xmlDig, the XML-SQL Extractor
http://www.sysonyx.com/products/xmldig
Visual Basic
Rashmi Rubdi wrote:
It's a bit tedious to create this file manually and
was looking to enter the data in an Excel spread sheet
and then use a converter to convert from Excel to XML.
Does any one know a good converter?
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--