| XML :: SAXDRIVER :: Excel. XML :: SAXDRIVER :: Excel ¸ðµâÀº Excel ÆÄÀÏÀ» XML·Î º¯È¯ÇϱâÀ§ÇÑ saxdriver°¡ ÀÖ½À´Ï´Ù. |
Áö±Ý ´Ù¿î·Îµå |
XML :: SAXDRIVER :: Excel. ¼øÀ§ ¹× ¿ä¾à
- ƯÇã:
- Perl Artistic License
- °Ô½ÃÀÚ À¥»çÀÌÆ®:
- http://search.cpan.org/~isterin/XML-SAXDriver-CSV-0.07/CSV.pm
XML :: SAXDRIVER :: Excel. ű×
XML :: SAXDRIVER :: Excel. ¼³¸í
XML :: SAXDRIVER :: Excel ¸ðµâÀº Excel ÆÄÀÏÀ» XML·Î º¯È¯ÇϱâÀ§ÇÑ saxdriver°¡ ÀÖ½À´Ï´Ù. XML :: SAXDRIVER :: Excel ¸ðµâÀº Excel ÆÄÀÏÀ» XML·Î º¯È¯ÇϱâÀ§ÇÑ saxdriver¸¦ Æ÷ÇÔÇÕ´Ï´Ù. Synopsis XML :: saxdriver :: Excel; MY $ Driver = XML :: SAXDRIVER :: Excel-> New (% attr); $ µå¶óÀ̹ö -> ±¸¹® ºÐ¾ß (% attr); XML :: SAXDRIVER :: ExcelÀº XML :: ExcelÀ» º¸¿Ï ÇÒ ¼ö ÀÖÁö¸¸ ¼º´É ¹× È¿À²¼ºÀ» Çâ»ó½ÃÅ°´Â SAX ÀÎÅÍÆäÀ̽º¸¦ Á¦°øÇÏ¿© ÆÄÀÏÀ» Ź¿ùÇÕ´Ï´Ù. ƯÁ¤ ¿ÀºêÁ§Æ® ¼Ó¼º ¹× Çڵ鷯´Â PARSE () ¸Þ¼µåÀÇ µ¿ÀÛÀ» Á¤ÀÇÇϵµ·Ï ¼³Á¤µË´Ï´Ù. ¼Ó¼ºÀ» Á¤ÀÇÇÏ´Â À§Ä¡´Â Áß¿äÇÏÁö ¾Ê½À´Ï´Ù. »õ () ¸Þ¼µå¿¡ Á¤ÀÇ µÈ °æ¿ì ¸ðµç parse () È£Ãâ¿¡ Àû¿ëµË´Ï´Ù. ±¸¹® ºÐ¼® ()¿¡ ´ëÇÑ È£ÃâÀ» ¹«½ÃÇÒ ¼ö ÀÖÀ¸¸ç ÇØ´ç ÇÔ¼ö È£Ãâ¿¡ ·ÎÄà ÀÜ·ù°¡ À¯ÁöµÇ¸ç ³ª¸ÓÁö object.xml :: saxdriver :: Excel µî·Ï Á¤º¸ ¼Ò½º - (String, ByteStream, SystemID) ¹®ÀÚ¿À» Àû¿ëÇÏÁö ¾Ê½À´Ï´Ù. ** ÇöÀç Áö¿øµÇÁö ¾ÊÀ½ ** ¸®ÅÍ·² Excel µ¥ÀÌÅÍ°¡ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ex (source => {string => $ foo}) bytestream - ** ÇöÀç Áö¿øµÇÁö ¾ÊÀ½ ** ÆÄÀÏ ÇÚµé ÂüÁ¶°¡ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. Àü. (source => {bytestream => * stdin}) systemId - Excel µ¥ÀÌÅÍ°¡ µé¾îÀÖ´Â ÆÄÀÏÀÇ °æ·Î¸¦ Æ÷ÇÔÇÕ´Ï´Ù. ex (source => {systemId => '../excel/foo.xls'}) Çڵ鷯 - XML Àμâ 󸮱â·Î »ç¿ëÇÒ ¿ÀºêÁ§Æ®¸¦ Æ÷ÇÔÇÕ´Ï´Ù. DTDHandler - XML DTD Çڵ鷯·Î »ç¿ëÇÒ °³Ã¼°¡ µé¾î ÀÖ½À´Ï´Ù. **** ÇöÀç DTD Áö¿øÀÌ ¾ø½À´Ï´Ù. **** subchar - ù ¹ø° Çà¿¡¼ »ý¼ºµÇÁö¸¸ µ¿Àû _col_headings¸¦ ¼³Á¤ÇÏ´Â XML ÅÂ±× À̸§¿¡¼ ºÒ¹ý ¹®ÀÚ¸¦ ´ëüÇÏ´Â µ¥ »ç¿ëÇÒ ¹®ÀÚ¸¦ ÁöÁ¤ÇÕ´Ï´Ù. COL_HEADINGS - XML ÅÂ±× À̸§¿¡ »ç¿ëÇÒ ¿ À̸§ÀÇ ¹è¿À» ÂüÁ¶ÇϽʽÿÀ. Dynamic_Col_Headings - XML ÅÂ±× À̸§À» Excel ÆÄÀÏÀÇ Ã¹ ¹ø° Çà¿¡¼ µ¿ÀûÀ¸·Î »ý¼ºµÇµµ·ÏÇÏ·Á¸é ¼³Á¤ÇؾßÇÕ´Ï´Ù. ** ù ¹ø° ÇàÀÇ ¿ ¼ö°¡ ¹®¼ÀÇ °¡Àå Å« Çà°ú µ¿ÀÏÇÑ Áö È®ÀÎÇϽʽÿÀ. À¯È¿ÇÑ Excel µ¥ÀÌÅ͸¦ Á¦ÃâÇÏ´Â °æ¿ì¿¡ ÀϹÝÀûÀ¸·Î °ÆÁ¤ÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù. °¢ ÇàÀº ºñ¾î ÀÖ´õ¶óµµ µ¿ÀÏÇÑ ¼öÀÇ ¿À» °¡Áú ¼ö ÀÖ½À´Ï´Ù. headings_handler - Dynamic_Col_Heading°ú ÇÔ²² Ç¥Á¦ Á¤±ÔÈ Ã³¸®±â¸¦ Á¦°øÇÏ¿© Ç¥Á¦¸¦ XML 1.0 »ç¾çÀ¸·Î ÁؼöÇؾßÇÕ´Ï´Ù. Á¦°øµÇÁö ¾ÊÀ¸¸é ASCII ¹®ÀÚ¿¡¼¸¸ ÀÛµ¿ÇÏ´Â ±âº»°ªÀÌ »ç¿ëµÇ¹Ç·Î ´Ù¸¥ ¹®ÀÚ ÁýÇÕÀº »ç¿ëÀÚ Á¤ÀÇ Ã³¸®±â¸¦ Á¦°øÇؾßÇÕ´Ï´Ù! Çڵ鷯 ÇÏÀ§´Â ù ¹ø° Àμö·Î Ç¥Á¦ ¹®ÀÚ¿À» Àü´ÞÇÕ´Ï´Ù. ¿ä±¸ »çÇ× : ¡¤ Perl.
XML :: SAXDRIVER :: Excel. °ü·Ã ¼ÒÇÁÆ®¿þ¾î