½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
happycgi
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > PHP > PHP ¼Ò½ºÃ¢°í > Ŭ·¡½º ¹× ÇÔ¼ö > EXCEL > PHP-ExcelReader »ó¼¼Á¤º¸
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
asp
CSS
html
mysql
jquery
image
Mobile
API
slide
°Ô½ÃÆÇ
¸Þ´º
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
PHP-ExcelReader
¼Ò½ºÅë°èÁ¤º¸ ¿À·ù½Å°í ¹× ¹®ÀÇ
ÇØÇÇÆÀ
³×ƼÁð
Æ®À§ÅÍ·Î º¸³»±â ÆäÀ̽ººÏÀ¸·Î º¸³»±â
¼Ò½ººÐ·ù EXCEL
´Ù¿î·Îµå Ƚ¼ö 826 ȸ
°£´Ü¼³¸í php·Î ¿¢¼¿ÆÄÀÏÀ» ÀоÁÖ´Â lib ÀÔ´Ï´Ù.
Æò°¡Çϱâ ÈǸ¢ÇÔ ¸Å¿ìÁÁÀ½ ÁÁÀ½ ±¦ÂúÀ½ º¸Åë º°·Î
ȨÆäÀÌÁö¹Ù·Î°¡±â ¼Ò½º´Ù¿î·Îµå µ¥¸ð ¹Ì¸®º¸±â°¡ ¾ø½À´Ï´Ù ½ºÅ©·¦Çϱâ

³×ƼÁð ÀÇ°ß   ÀÌ¿ëÇϽŠÀÚ·áÀÇ Èı⸦ ÀÚÀ¯·Ó°Ô ÀÛ¼ºÇϼ¼¿ä. (»ó¾÷ÀûÀÎ ±¤°í ¹× µµ¹è¼º ±Û µîÀº »çÀüÅ뺸¾øÀÌ »èÁ¦µÉ ¼ö ÀÖ½À´Ï´Ù.)
³»¿ë ¾ÆÀ̵ð ÀÇ°ß³²±â±â
ÇØ´ç »çÀÌÆ®¸¦ µÚÁ®º¸´Ï ¾Æ·¡¿Í °°Àº ¹ö±× ¸®Æ÷ÆÃÀÌ Àֳ׿ä.
2¹ÙÀÌÆ®ÄÚµå ¹®ÀÚ¿­Àº ¾ÆÁ÷ Áö¿øÀ» ÇÏÁö ¾Ê´Â°Í °°½À´Ï´Ù.

Certain characters in text fields cause problems
If a text field contains certain characters, 'cells' returns
either a 1-character field or a 5-character field where
the first character is the first character of the Excel text
field and the remaining characters are 'alse'. For
example, if the Excel field started with 'The' then the
returned value would be 'Talse'.

I've identified the following characters as they've caused
me a problem. However, there may be others.
em dash —
en dash –
left single quote ¡®
right single quote ¡¯
left single angle quote ‹
right single angle quote ›

What I've had to do is to write an Excel macro that does
a search and replace for these characters before
uploading the spreadsheet to my web site.

I don't know enough about the logic of the class to even
guess where to look for a resolution of this problem.
2004-09-21 16:37:24
HappyCGI
Âù¼º 53
¹Ý´ë 45
±×·±µ¥ ÇѱÛÀÌ ±úÁö³×¿ä....
2004-09-21 16:35:57
idejin
Âù¼º 52
¹Ý´ë 54
1
À̸§
³»¿ë
:³×¸Â¾Æ¿ä: :È­³ª´Â±º¿ä: :Àá¿Í: :¿ì¿ïÇØ: :À̰ǾƳÄ: :¿ÕÇÏÇÏ: ¿Õ¿ôÀ½~ ³î·¥~
Æò°¡Çϱâ ÈǸ¢ÇÔ ¸Å¿ìÁÁÀ½ ÁÁÀ½ ±¦ÂúÀ½ º¸Åë º°·Î
µµ¹è¹æÁöÅ°
 94384847 º¸ÀÌ´Â µµ¹è¹æÁöÅ°¸¦ ÀÔ·ÂÇϼ¼¿ä.