¼±£¡asp ±£´æ³ÉexcelÎļþ

ÆäÖÐÓÐÒ»ÁÐÊÇÊý×Ö£¬ÒªÇóÔÚexcelÖÐÏÔʾΪ100.00£¨¼´ÒªÇóÒÔÎı¾·½Ê½£©

ÈçºÎͨ¹ý³ÌÐòÉèÖøÃÁеÄÊôÐÔ

---

¹Øעһϡ£Ç°¼¸ÌìÓöµ½Í¬ÑùÀàËƵÄÎÊÌ⣬ÈÔδ½â¾ö

---

³ÌÐòÅжϴ¿Êý×ÖÇ°Ãæ+'`'Ðв»£¿£¿

---

ÒýÓÃ

³ÌÐòÅжϴ¿Êý×ÖÇ°Ãæ+'`'Ðв»£¿£¿

ÎÒÊÔ¹ýÓ¦¸Ã²»ÐÐ

---

ÓÐÐËȤ¹ýÀ´°ï°ïæ

---

ÄãÊÔÊÔÕâÖÖ·½·¨ÄØ

ÒýÓÃ

VBScript code <%
    response.ContentType="application/vnd.ms-excel"
%>
×¢Ê͵ôÕâÐе÷ÊÔ£¬ÕýʽʹÓõÄʱºò£¬È¥µô×¢ÊÍ

VBScript code <%
    response.ContentType="application/vnd.ms-excel"
%> <!--#include file=../include/conn.asp--> <!--#include file=../Public/PrvClass.asp--> <%
    sql=trim(request("sql"))
    GroupDepth=trim(request("GroupDepth"))'×éµÈ¼¶    QueryField=trim(request("QueryField"))'ÏÔʾ×ֶεÄÓ¢ÎÄ    FieldTitle=trim(request("FieldTitle"))'ÏÔʾ×ֶεÄÖÐÎÄ    SumFieldsIndex=trim(request("SumFieldsIndex"))'ÏÔʾ×ֶεÄÖÐÎÄ
    arrayQueryField=split(QueryField,",")
    arrayFieldTitle=split(FieldTitle,",")
    arraySumFieldsIndex=split(SumFieldsIndex,",")dim arraySumFieldsValue()'С¼ÆÏîÄ¿Êý×éredim arraySumFieldsValue(