Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ò»¸ö¿ÉÒÔ´Ó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


Ïà¹ØÎĵµ£º

XMLÖк¬ÓÐhtml±êÇ©µÄÎÊÌâ

¿´½áÂÛÇëÖ±½Ó¿´ÏÂÃæ
½ñÌìдÉú³ÉxmlµÄphp¡£Ã»ÓÐÓÃʲôXMLDOMNodeÖ®ÀàµÄÀ´Éú³É£¬¶øÊÇÖ±½Óecho³öxmlµÄÄÚÈÝ¡£
xmlµÄÄÚÈÝÖÐÓÐÒ»²¿·ÖµÄÊý¾ÝÊÇ´ÓdbÖÐÑ­»·È¡³öµÄ£¬ÎÊÌâ¾Í³öÔÚÕâ¡£ÎÒ·¢ÏÖÈ«²¿È¡³öÊý¾Ýʱ£¬¶ÔÓÚÉú³ÉµÄxml£¬simplexml_load_string·µ»Øfalse£¬¼´±íÃ÷Éú³ÉµÄxmlÊÇ·Ç·¨µÄ¡£
debugһϣ¬·¢ÏÖÈ¡³öÊý¾Ý¼ÓÒÔÏÞÖÆ limit 8 һϠ......

ʹÓÃXMLµÄ³¡ºÏ

ÔںܶàÑÐÌÖ»áºÍÅàѵ°àÉÏÎÒÓöµ½¹ýÐí¶àÈË£¬ËûÃÇ»¹²»Ã÷°×ΪʲôҪʹÓÃXMLÒ²²»ÖªµÀÈçºÎÔÚËûÃǵÄÓ¦ÓÃÖÐʹÓÃXML¡£Ò»Ð©À´×ÔÖîÈçGartner¹«Ë¾µÄ±¨¸æ½¨Òé˵£¬ÉÌÒµ¹«Ë¾²»ÄÜÔÙ×ö¾ÖÍâÈËÁË£¬²»ÄܶÔXMLÖÃÖ®²»Àí¡£Èç¹ûÄ㻹²»Çå³þXMLµ½µ×ÓÐʲôºÃ´¦µÄ»°£¬Äã²¢²»ÊÇΨһµÄÈË¡£
ÎÒ¾ö¶¨°ÑÓëÈËÃǺÍýÌ幨ÓÚXML»°ÌâµÄ½»Ì¸ÕûÀí³ÉÎÄ£¬ÁгöXMLÔÚÓ¦ÓÃÖ ......

sqlserver FOR XML PATH Óï¾äµÄÓ¦ÓÃ

´úÂëÈçÏÂ:

DECLARE
@TempTable table(UserID int , UserName nvarchar(50));
insert into
@TempTable (UserID,UserName) values (1,'a')
insert into @TempTable
(UserID,UserName) values (2,'b')

select UserID,UserName
from @TempTable FOR XML PATH
ÔËÐÐÕâ¶Î½Å±¾£¬½«Éú³ÉÈçϽá¹û£º
¸´ÖÆ´úÂë ......

magento ¿ª·¢ ÁíÒ»ÖÖ·½Ê½ÓÃxmlÀ´²¼¾Ö

ÊÇ·ñÑá¾ëÁËÓÃxmlÎļþÀ´×öMagentoµÄÒ³Ãæ²¼¾Ö£¬ÊǵϰÀ´ÊÔÊÔÏÂÃæÕâÖÖ·½Ê½£¬°Ñ²¼¾Ö´úÂëдµ½controller ÀïÃæ
public function mycoolAction()
{
/* ... Some code ...*/
$update = $this->getLayout()->getUpdate();
/* ... Some code ...*/
$this->addActionLayoutHandles();
/* ... Some code ...*/
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ