Ò»¸ö¿ÉÒÔ´ÓexcelÖжÁÈ¡Êý¾Ý²¢Éú³ÉxmlµÄvba³ÌÐò
NND EXCEL2007£¬ÈÃÀÏ×ÓÕÒÁË°ëÌì²Å°ÑbuttonÌí¼ÓÉÏÈ¥¡£
Sub °´Å¥1_Click()
Dim sFileName As String
Dim ws As Worksheet '´æ´¢Îļþ·¾¶ÃûºÍÎļþÃûµÄ¹¤×÷±í
Set ws = Worksheets("english") 'ÉèÖù¤×÷±í
sFileName = "d:\text.xml"
Set fso = CreateObject("Scripting.FileSystemObject")
Set orgFile = fso.OpenTextFile(sFileName, 2, True, -1)
'dim head and tail
Dim headline1, headline2, tailline, span_bef_english, span_aft_english, span_bef_foreign, span_aft_foreign
headline1 = "<?xml version=""1.0\"" encoding=""utf-8\""?>"
headline2 = "<systems>"
tailline = "</systems>"
'dim span before english
span_bef_english = "<setting id=""id_xx"">" & Chr$(13) & "<content_en>"
'dim span after english
span_aft_english = "</content_en>"
'dim span before foreign language
span_bef_foreign = "<content_fgn>"
'dim span after forergn language
span_aft_foreign = "</content_fgn>" & Chr$(13) & "</setting>"
'write_x
Ïà¹ØÎĵµ£º
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Iterator;
import java.util.List;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.input.SAXBuilder;
import org.jdom.xpath.XPath;
public class XMLReader {
priv ......
JAVATMÓëXML 2010-05-14
Ò»¡¢¸ÅÄî
l ÈκÎXMLÎĵµ¶ÔÈκÎÀàÐ͵ÄÓ¦ÓÃÒÔ¼°ÕýÈ·µÄ½âÎö¶¼±ØÐë¾ßÓÐÁ¼ºÃµÄ½á¹¹well-formed
l XMLÎĵµ¿ÉÒÔÊÇÓÐЧµØ£¨valid£©£¬µ«²¢·ÇÒ»¶¨ÒªÇóÓÐЧ¡£
l PI£¨processing instruction£©¸ñʽ£º<?target instructions?>¡£XMLÖеĴ¦ÀíÖ¸ÁîÖ»ÄÜÊǽâÎöÆ÷¿ÉÒÔʶ±ðµÄXML±ê×¼´¦ÀíÃüÁ ......
SQl XmlºÍC# XmlÊý¾ÝµÄÒ»µã²Ù×÷×ܽá
ÔÚ´ËÉêÃ÷XmlÊÇInfoSetÊý¾Ý²»ÊÇ×Ö·û´®£¬ËùÒÔÔÚ´ËÇ¿ÁÒ·´¶ÔÓÃstringÆ´½Óxml¡£Êý¾Ý¿â¿ÉÒÔ´æ·ÅxmlÀàÐÍÊý¾Ý£¬ÄÇô¸ÃÊý¾ÝµÄ¾ßÌå²Ù×÷ÓÖÈçºÎÁË¡£
1.Ê×ÏȽ¨Á¢Ò»Õź¬ÓÐxmlÊý¾ÝÀàÐ͵ıí
CREATE TABLE [dbo].[TestXml](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[Message] [xml] NULL ......
Loading XML data using ActionScript 3.0
By Blue_Chi | Flash CS3 | ActionScript 3.0 | Beginner
Using XML is one of the best ways for structuring external content in a logical format that is easy to understand, process, and update. This tutorial will teach you the basics on how to load and process X ......