Excel文档的数据如何读取到Oracle数据库的问题

Excel文档的数据如何读取到Oracle数据库的问题

Excel文档的数据如何读取到Oracle数据库一直是值得深究的问题。
目前相信大部分程序员都是直接用工具将Excel的数据读取到Oracle数据库的。例如Toad，PL/SQL Developer的Excel数据导入功能。
也有一部分程序开发的是：先将Excel转换为一个逗号分隔符等的文本文件(CSV等)，然后写代码通过特定的符号(TAB符号或者逗号等)将数据拆分并且识别。
其实上面的读取Excel的办法都不是最好用的办法。举个例子，用Toad等工具来做，程序开发工程师来做是可以的，但是不可以将这个工作交给普通用户做(当用户想导入数据的时候)。如果用文本来做，先要做一个转换，对于用户来说无疑是多做了一个动作，操作不方便。

综上所述，其实最方便的还是：如何在Oracle数据库用PL/SQL直接读取Excel的内容，这才是最好的做法。
在PL/SQL直接解析并读取Excel，有一个蛮不错的办法，就是用Java的POI组件。确实是不错，但是要先导入POI的Java类，然后再在Oracle里面写一段Pkg的class类解析Excel。是可行的。我也研究过，发现有一些限制(可能是和POI的版本太低有关系)。
这里提出一个更加好的办法，就是用Oracle自带的utl_raw 包（二进制处理包）和dbms_xmldom包，将Excel文件对应的Blob大文本字段进行解析，最后再将解析出来的内容用管道表函数输出一个虚拟的表格。这样子就是很直观了，直接将一个Excel文档解析为一个表格！
可能大家比较关心解析的效率。所以针对效率方面，经过测试，还是非常不错的。下面有专门测试解析效率的主题。
另外一个比较关心的问题：Excel里面可以有很多公式列，那对于公式列读取出来的结果是什么？另外，一些特殊的格式栏位是否可以正确识别？经过测试，这些都可以得到正确的解析。例如公式列，解析的是公式计算的结果。

先简单测试一下实现的效果。
现在有这么一个Excel文档：XLS文件导入样本.xls，想将它导入到Oracle数据库中。

然后将它上传到服务器的某个文件夹。注意，这个文件路径(/data/uat/apps/apps_st/appl/attchment/12.0.0/BATCH_UPLOAD_TEMP/)必须是在all_directories有定义的。否则用PLSQL无法直接读取文件。值得一提的是，这个步骤并不是必须的，你也可以将Excel文件上传到Blob大字段中，然后再直接读取。常见的是FND_LOBS表的FILE_DATA字段。

最后一步，用下面的函数就可以直接读取出Excel文本的内容了(注意输入的参数)：
SELECT* FROM TABLE(XYG_PUB_DATA_UPLOAD_PKG.CONVER_EXCEL_TO_TAB(XYG_ALD_FILE_PKG.CONVERT_FILE_BLOB('XYG_BATFILE','XLS文件导入样本.xls'),'',1))

必须要说明的是，栏位BATCH_CODE=工作表的名称。
如果有多个工作表，那BATCH_CODE是不同的。

附上Blob字段的Excel的读取方法：
SELECT * FROM TABLE(XYG_PUB_DATA_UPLOAD_PKG.CONVER_EXCEL_TO_TAB((SELECT FILE_DATA FROM FND_LOBS WHERE FILE_ID = 81171130),NULL,1));

www.51sole.com/b2b/pd_458682507.htm
www.51sole.com/b2b/pd_458682799.htm
www.51sole.com/b2b/pd_458682865.htm
www.51sole.com/b2b/pd_458682922.htm
www.51sole.com/b2b/pd_458683224.htm
www.51sole.com/b2b/pd_458683285.htm
www.51sole.com/b2b/pd_458683349.htm
www.51sole.com/b2b/pd_458683584.htm
www.51sole.com/b2b/pd_458683642.htm
www.51sole.com/b2b/pd_458683723.htm
www.51sole.com/b2b/pd_458684003.htm
www.51sole.com/b2b/pd_458684177.htm
www.51sole.com/b2b/pd_458684242.htm
www.51sole.com/b2b/pd_458684354.htm
www.51sole.com/b2b/pd_458684474.htm
www.51sole.com/b2b/pd_458684646.htm
www.51sole.com/b2b/pd_458684713.htm
www.51sole.com/b2b/pd_458684770.htm
www.51sole.com/b2b/pd_458684827.htm
www.51sole.com/b2b/pd_458684940.htm
www.51sole.com/b2b/pd_458685161.htm
www.51sole.com/b2b/pd_458685216.htm
www.51sole.com/b2b/pd_458685283.htm
www.51sole.com/b2b/pd_458685391.htm
www.51sole.com/b2b/pd_458685445.htm
www.51sole.com/b2b/pd_458685508.htm
www.51sole.com/b2b/pd_458685637.htm
www.51sole.com/b2b/pd_458685699.htm
www.51sole.com/b2b/pd_458685883.htm
www.51sole.com/b2b/pd_458686080.htm
www.51sole.com/b2b/pd_458686327.htm
www.51sole.com/b2b/pd_458686526.htm
www.51sole.com/b2b/pd_458686590.htm
www.51sole.com/b2b/pd_458686721.htm
www.51sole.com/b2b/pd_458686787.htm
www.51sole.com/b2b/pd_458686854.htm
www.51sole.com/b2b/pd_458686982.htm
www.51sole.com/b2b/pd_458687107.htm
www.51sole.com/b2b/pd_458687289.htm
www.51sole.com/b2b/pd_458687354.htm
www.51sole.com/b2b/pd_458687619.htm
www.51sole.com/b2b/pd_458687700.htm
www.51sole.com/b2b/pd_458688024.htm
www.51sole.com/b2b/pd_458688276.htm
www.51sole.com/b2b/pd_458688335.htm
www.51sole.com/b2b/pd_458688450.htm
www.51sole.com/b2b/pd_458688643.htm
www.51sole.com/b2b/pd_458688791.htm
www.51sole.com/b2b/pd_458688863.htm
www.51sole.com/b2b/pd_458689017.htm
www.51sole.com/b2b/pd_458689169.htm
www.51sole.com/b2b/pd_458689502.htm
www.51sole.com/b2b/pd_458689567.htm
www.51sole.com/b2b/pd_458689630.htm
www.51sole.com/b2b/pd_458689770.htm
www.51sole.com/b2b/pd_458689837.htm
www.51sole.com/b2b/pd_458689903.htm
www.51sole.com/b2b/pd_458689961.htm
www.51sole.com/b2b/pd_458690090.htm
www.51sole.com/b2b/pd_458690222.htm
www.51sole.com/b2b/pd_458690296.htm
www.51sole.com/b2b/pd_458690477.htm
www.51sole.com/b2b/pd_458690538.htm
www.51sole.com/b2b/pd_458690599.htm
www.51sole.com/b2b/pd_458690661.htm
www.51sole.com/b2b/pd_458690724.htm
www.51sole.com/b2b/pd_458690794.htm
www.51sole.com/b2b/pd_458690866.htm
www.51sole.com/b2b/pd_458690930.htm
www.51sole.com/b2b/pd_458691005.htm
www.51sole.com/b2b/pd_458691128.htm
www.51sole.com/b2b/pd_458691265.htm
www.51sole.com/b2b/pd_458691334.htm
www.51sole.com/b2b/pd_458691454.htm
www.51sole.com/b2b/pd_458691512.htm
www.51sole.com/b2b/pd_458691570.htm
www.51sole.com/b2b/pd_458691679.htm
www.51sole.com/b2b/pd_458691800.htm
www.51sole.com/b2b/pd_458691964.htm
www.51sole.com/b2b/pd_458692019.htm
www.51sole.com/b2b/pd_458692248.htm
www.51sole.com/b2b/pd_458692301.htm
www.51sole.com/b2b/pd_458692574.htm
www.51sole.com/b2b/pd_458692941.htm
www.51sole.com/b2b/pd_458693063.htm
www.51sole.com/b2b/pd_458693160.htm
www.51sole.com/b2b/pd_458616543.htm
www.51sole.com/b2b/pd_458616645.htm
www.51sole.com/b2b/pd_458616676.htm
www.51sole.com/b2b/pd_458616840.htm
www.51sole.com/b2b/pd_458617054.htm
www.51sole.com/b2b/pd_458617160.htm
www.51sole.com/b2b/pd_458617244.htm
www.51sole.com/b2b/pd_458617341.htm
www.51sole.com/b2b/pd_458617436.htm
www.51sole.com/b2b/pd_458617512.htm
www.51sole.com/b2b/pd_458617560.htm
www.51sole.com/b2b/pd_458617605.htm
www.51sole.com/b2b/pd_458617664.htm
www.51sole.com/b2b/pd_458617735.htm
www.51sole.com/b2b/pd_458617834.htm
www.51sole.com/b2b/pd_458618015.htm
www.51sole.com/b2b/pd_458618312.htm
www.51sole.com/b2b/pd_458618422.htm
www.51sole.com/b2b/pd_458618513.htm
www.51sole.com/b2b/pd_458618702.htm
www.51sole.com/b2b/pd_458618795.htm
www.51sole.com/b2b/pd_458618907.htm
www.51sole.com/b2b/pd_458619179.htm
www.51sole.com/b2b/pd_458619419.htm
www.51sole.com/b2b/pd_458619510.htm
www.51sole.com/b2b/pd_458619639.htm
www.51sole.com/b2b/pd_458619955.htm
www.51sole.com/b2b/pd_458620060.htm
www.51sole.com/b2b/pd_458620180.htm
www.51sole.com/b2b/pd_458620303.htm
www.51sole.com/b2b/pd_458620655.htm
www.51sole.com/b2b/pd_458620773.htm
www.51sole.com/b2b/pd_458621227.htm
www.51sole.com/b2b/pd_458621596.htm
www.51sole.com/b2b/pd_458621821.htm
www.51sole.com/b2b/pd_458622057.htm
www.51sole.com/b2b/pd_458622330.htm
www.51sole.com/b2b/pd_458622471.htm
www.51sole.com/b2b/pd_458622610.htm
www.51sole.com/b2b/pd_458622754.htm
www.51sole.com/b2b/pd_458624076.htm
www.51sole.com/b2b/pd_458624460.htm
www.51sole.com/b2b/pd_458624595.htm
www.51sole.com/b2b/pd_458625372.htm
www.51sole.com/b2b/pd_458626029.htm
www.51sole.com/b2b/pd_458626418.htm
www.51sole.com/b2b/pd_458626683.htm
www.51sole.com/b2b/pd_458626945.htm
www.51sole.com/b2b/pd_458627199.htm
www.51sole.com/b2b/pd_458627439.htm
www.51sole.com/b2b/pd_458627579.htm
www.51sole.com/b2b/pd_458627751.htm
www.51sole.com/b2b/pd_458627918.htm
www.51sole.com/b2b/pd_458628227.htm
www.51sole.com/b2b/pd_458628380.htm
www.51sole.com/b2b/pd_458628660.htm
www.51sole.com/b2b/pd_458628782.htm
www.51sole.com/b2b/pd_458628920.htm
www.51sole.com/b2b/pd_458629063.htm
www.51sole.com/b2b/pd_458629310.htm
www.51sole.com/b2b/pd_458629447.htm
www.51sole.com/b2b/pd_458629721.htm
www.51sole.com/b2b/pd_458629855.htm
www.51sole.com/b2b/pd_458629993.htm
www.51sole.com/b2b/pd_458630127.htm
www.51sole.com/b2b/pd_458630258.htm
www.51sole.com/b2b/pd_458630541.htm
www.51sole.com/b2b/pd_458630666.htm
www.51sole.com/b2b/pd_458630952.htm
www.51sole.com/b2b/pd_458631123.htm
www.51sole.com/b2b/pd_458631421.htm
www.51sole.com/b2b/pd_458631567.htm
www.51sole.com/b2b/pd_458632276.htm
www.51sole.com/b2b/pd_458632569.htm
www.51sole.com/b2b/pd_458632889.htm
www.51sole.com/b2b/pd_458633175.htm
www.51sole.com/b2b/pd_458633501.htm
www.51sole.com/b2b/pd_458633996.htm
www.51sole.com/b2b/pd_458634306.htm
www.51sole.com/b2b/pd_458634476.htm
www.51sole.com/b2b/pd_458635768.htm
www.51sole.com/b2b/pd_458636220.htm
www.51sole.com/b2b/pd_458636639.htm
www.51sole.com/b2b/pd_458637050.htm
www.51sole.com/b2b/pd_458637746.htm
www.51sole.com/b2b/pd_458638170.htm
www.51sole.com/b2b/pd_458638595.htm
www.51sole.com/b2b/pd_458638967.htm
www.51sole.com/b2b/pd_458639345.htm
www.51sole.com/b2b/pd_458639487.htm
www.51sole.com/b2b/pd_458639620.htm
www.51sole.com/b2b/pd_458639753.htm
www.51sole.com/b2b/pd_458640015.htm
www.51sole.com/b2b/pd_458640168.htm
www.51sole.com/b2b/pd_458640312.htm
www.51sole.com/b2b/pd_458640604.htm
www.51sole.com/b2b/pd_458640896.htm
www.51sole.com/b2b/pd_458641345.htm
www.51sole.com/b2b/pd_458641503.htm
www.51sole.com/b2b/pd_458641661.htm
www.51sole.com/b2b/pd_458641825.htm
www.51sole.com/b2b/pd_458641962.htm
www.51sole.com/b2b/pd_458642130.htm
www.51sole.com/b2b/pd_458642290.htm
www.51sole.com/b2b/pd_458642444.htm
www.51sole.com/b2b/pd_458642750.htm
www.51sole.com/b2b/pd_458643054.htm
www.51sole.com/b2b/pd_458643387.htm
www.51sole.com/b2b/pd_458643540.htm
www.51sole.com/b2b/pd_458643683.htm
www.51sole.com/b2b/pd_458643854.htm
www.51sole.com/b2b/pd_458644015.htm
www.51sole.com/b2b/pd_458644735.htm
www.51sole.com/b2b/pd_458645019.htm
www.51sole.com/b2b/pd_458645300.htm
www.51sole.com/b2b/pd_458645683.htm
www.51sole.com/b2b/pd_458645965.htm
www.51sole.com/b2b/pd_458646888.htm
www.51sole.com/b2b/pd_458647042.htm
www.51sole.com/b2b/pd_458647184.htm
www.51sole.com/b2b/pd_458647771.htm
www.51sole.com/b2b/pd_458648190.htm
www.51sole.com/b2b/pd_458648610.htm
www.51sole.com/b2b/pd_458649284.htm
www.51sole.com/b2b/pd_458649691.htm
www.51sole.com/b2b/pd_458650087.htm
www.51sole.com/b2b/pd_458650943.htm
www.51sole.com/b2b/pd_458651197.htm
www.51sole.com/b2b/pd_458651324.htm
www.51sole.com/b2b/pd_458651431.htm
www.51sole.com/b2b/pd_458651683.htm
www.51sole.com/b2b/pd_458651812.htm
www.51sole.com/b2b/pd_458651916.htm
www.51sole.com/b2b/pd_458652161.htm
www.51sole.com/b2b/pd_458652542.htm
www.51sole.com/b2b/pd_458652650.htm
www.51sole.com/b2b/pd_458652794.htm
www.51sole.com/b2b/pd_458652937.htm
www.51sole.com/b2b/pd_458653419.htm
www.51sole.com/b2b/pd_458653539.htm
www.51sole.com/b2b/pd_458653678.htm
www.51sole.com/b2b/pd_458653908.htm
www.51sole.com/b2b/pd_458654045.htm
www.51sole.com/b2b/pd_458654180.htm
www.51sole.com/b2b/pd_458654287.htm
www.51sole.com/b2b/pd_458654895.htm
www.51sole.com/b2b/pd_458655126.htm
www.51sole.com/b2b/pd_458655343.htm
www.51sole.com/b2b/pd_458655469.htm
www.51sole.com/b2b/pd_458655685.htm
www.51sole.com/b2b/pd_458656194.htm
www.51sole.com/b2b/pd_458656406.htm
www.51sole.com/b2b/pd_458656855.htm
www.51sole.com/b2b/pd_458656957.htm
www.51sole.com/b2b/pd_458657063.htm
www.51sole.com/b2b/pd_458657157.htm
www.51sole.com/b2b/pd_458657251.htm
www.51sole.com/b2b/pd_458657370.htm
www.51sole.com/b2b/pd_458657565.htm
www.51sole.com/b2b/pd_458657653.htm
www.51sole.com/b2b/pd_458657872.htm
www.51sole.com/b2b/pd_458658181.htm
www.51sole.com/b2b/pd_458658513.htm
www.51sole.com/b2b/pd_458659008.htm
www.51sole.com/b2b/pd_458659411.htm
www.51sole.com/b2b/pd_458659596.htm
www.51sole.com/b2b/pd_458660219.htm
www.51sole.com/b2b/pd_458660399.htm
www.51sole.com/b2b/pd_458660494.htm
www.51sole.com/b2b/pd_458660678.htm
www.51sole.com/b2b/pd_458660780.htm
www.51sole.com/b2b/pd_458660945.htm
www.51sole.com/b2b/pd_458661381.htm
www.51sole.com/b2b/pd_458661466.htm
www.51sole.com/b2b/pd_458661624.htm
www.51sole.com/b2b/pd_458661789.htm
www.51sole.com/b2b/pd_458661880.htm
www.51sole.com/b2b/pd_458661967.htm
www.51sole.com/b2b/pd_458662061.htm
www.51sole.com/b2b/pd_458662208.htm
www.51sole.com/b2b/pd_458662300.htm
www.51sole.com/b2b/pd_458662386.htm
www.51sole.com/b2b/pd_458662440.htm
www.51sole.com/b2b/pd_458662528.htm
www.51sole.com/b2b/pd_458662604.htm
www.51sole.com/b2b/pd_458663063.htm
www.51sole.com/b2b/pd_458663154.htm
www.51sole.com/b2b/pd_458663405.htm
www.51sole.com/b2b/pd_458663481.htm
www.51sole.com/b2b/pd_458663632.htm
www.51sole.com/b2b/pd_458663931.htm
www.51sole.com/b2b/pd_458664015.htm
www.51sole.com/b2b/pd_458664395.htm
www.51sole.com/b2b/pd_458664467.htm
www.51sole.com/b2b/pd_458664749.htm
www.51sole.com/b2b/pd_458664818.htm
www.51sole.com/b2b/pd_458665085.htm
www.51sole.com/b2b/pd_458665230.htm
www.51sole.com/b2b/pd_458665296.htm
www.51sole.com/b2b/pd_458665360.htm
www.51sole.com/b2b/pd_458665482.htm
www.51sole.com/b2b/pd_458665538.htm
www.51sole.com/b2b/pd_458665681.htm
www.51sole.com/b2b/pd_458665870.htm
www.51sole.com/b2b/pd_458666065.htm
www.51sole.com/b2b/pd_458666205.htm
www.51sole.com/b2b/pd_458666775.htm
www.51sole.com/b2b/pd_458666839.htm
www.51sole.com/b2b/pd_458667041.htm
www.51sole.com/b2b/pd_458667172.htm
www.51sole.com/b2b/pd_458667251.htm
www.51sole.com/b2b/pd_458667384.htm
www.51sole.com/b2b/pd_458667595.htm
www.51sole.com/b2b/pd_458667744.htm
www.51sole.com/b2b/pd_458667817.htm
www.51sole.com/b2b/pd_458667957.htm
www.51sole.com/b2b/pd_458668103.htm
www.51sole.com/b2b/pd_458668244.htm
www.51sole.com/b2b/pd_458668398.htm
www.51sole.com/b2b/pd_458668466.htm
www.51sole.com/b2b/pd_458668692.htm
www.51sole.com/b2b/pd_458668773.htm
www.51sole.com/b2b/pd_458668841.htm
www.51sole.com/b2b/pd_458668920.htm
www.51sole.com/b2b/pd_458669063.htm
www.51sole.com/b2b/pd_458669146.htm
www.51sole.com/b2b/pd_458669211.htm
www.51sole.com/b2b/pd_458669506.htm
www.51sole.com/b2b/pd_458669591.htm
www.51sole.com/b2b/pd_458669844.htm
www.51sole.com/b2b/pd_458669917.htm
www.51sole.com/b2b/pd_458669991.htm
www.51sole.com/b2b/pd_458670389.htm
www.51sole.com/b2b/pd_458670477.htm
www.51sole.com/b2b/pd_458670624.htm
www.51sole.com/b2b/pd_458670702.htm
www.51sole.com/b2b/pd_458670983.htm
www.51sole.com/b2b/pd_458671112.htm
www.51sole.com/b2b/pd_458671246.htm
www.51sole.com/b2b/pd_458671430.htm
www.51sole.com/b2b/pd_458671562.htm
www.51sole.com/b2b/pd_458671671.htm
www.51sole.com/b2b/pd_458671800.htm
www.51sole.com/b2b/pd_458671979.htm
www.51sole.com/b2b/pd_458672036.htm
www.51sole.com/b2b/pd_458672161.htm
www.51sole.com/b2b/pd_458672543.htm
www.51sole.com/b2b/pd_458672628.htm
www.51sole.com/b2b/pd_458673021.htm
www.51sole.com/b2b/pd_458673096.htm
www.51sole.com/b2b/pd_458673162.htm
www.51sole.com/b2b/pd_458673230.htm
www.51sole.com/b2b/pd_458673437.htm
www.51sole.com/b2b/pd_458673579.htm
www.51sole.com/b2b/pd_458673663.htm
www.51sole.com/b2b/pd_458673993.htm
www.51sole.com/b2b/pd_458674138.htm
www.51sole.com/b2b/pd_458674300.htm
www.51sole.com/b2b/pd_458674359.htm
www.51sole.com/b2b/pd_458674497.htm
www.51sole.com/b2b/pd_458674632.htm
www.51sole.com/b2b/pd_458674867.htm
www.51sole.com/b2b/pd_458674938.htm
www.51sole.com/b2b/pd_458675011.htm
www.51sole.com/b2b/pd_458675067.htm
www.51sole.com/b2b/pd_458675135.htm
www.51sole.com/b2b/pd_458675196.htm
www.51sole.com/b2b/pd_458675268.htm
www.51sole.com/b2b/pd_458675335.htm
www.51sole.com/b2b/pd_458675636.htm
www.51sole.com/b2b/pd_458675716.htm
www.51sole.com/b2b/pd_458675796.htm
www.51sole.com/b2b/pd_458676238.htm
www.51sole.com/b2b/pd_458676308.htm
www.51sole.com/b2b/pd_458676429.htm
www.51sole.com/b2b/pd_458676518.htm
www.51sole.com/b2b/pd_458676825.htm
www.51sole.com/b2b/pd_458676976.htm
www.51sole.com/b2b/pd_458677218.htm
www.51sole.com/b2b/pd_458677374.htm
www.51sole.com/b2b/pd_458677587.htm
www.51sole.com/b2b/pd_458677750.htm
www.51sole.com/b2b/pd_458677970.htm
www.51sole.com/b2b/pd_458678045.htm
www.51sole.com/b2b/pd_458678112.htm
www.51sole.com/b2b/pd_458678329.htm
www.51sole.com/b2b/pd_458678652.htm
www.51sole.com/b2b/pd_458678722.htm
www.51sole.com/b2b/pd_458679059.htm
www.51sole.com/b2b/pd_458679390.htm
www.51sole.com/b2b/pd_458679602.htm
www.51sole.com/b2b/pd_458679666.htm
www.51sole.com/b2b/pd_458679799.htm
www.51sole.com/b2b/pd_458679868.htm
www.51sole.com/b2b/pd_458679947.htm
www.51sole.com/b2b/pd_458680007.htm
www.51sole.com/b2b/pd_458680132.htm
www.51sole.com/b2b/pd_458680276.htm
www.51sole.com/b2b/pd_458680399.htm
www.51sole.com/b2b/pd_458680471.htm
www.51sole.com/b2b/pd_458680652.htm
www.51sole.com/b2b/pd_458680907.htm
www.51sole.com/b2b/pd_458681223.htm
www.51sole.com/b2b/pd_458681274.htm
www.51sole.com/b2b/pd_458681351.htm
www.51sole.com/b2b/pd_458681413.htm
www.51sole.com/b2b/pd_458681525.htm
www.51sole.com/b2b/pd_458681581.htm
www.51sole.com/b2b/pd_458681691.htm
www.51sole.com/b2b/pd_458681750.htm
www.51sole.com/b2b/pd_458681869.htm
www.51sole.com/b2b/pd_458681923.htm
www.51sole.com/b2b/pd_458682008.htm
www.51sole.com/b2b/pd_458682120.htm
www.51sole.com/b2b/pd_458682180.htm
www.51sole.com/b2b/pd_458682384.htm
www.51sole.com/b2b/pd_458682432.htm
www.51sole.com/b2b/pd_458682517.htm
www.51sole.com/b2b/pd_458682585.htm
www.51sole.com/b2b/pd_458682773.htm
www.51sole.com/b2b/pd_458682937.htm
www.51sole.com/b2b/pd_458682999.htm
www.51sole.com/b2b/pd_458683213.htm
www.51sole.com/b2b/pd_458683313.htm
www.51sole.com/b2b/pd_458683372.htm
www.51sole.com/b2b/pd_458683424.htm
www.51sole.com/b2b/pd_458683744.htm
www.51sole.com/b2b/pd_458683885.htm
www.51sole.com/b2b/pd_458684091.htm
www.51sole.com/b2b/pd_458684313.htm
www.51sole.com/b2b/pd_458684458.htm
www.51sole.com/b2b/pd_458684552.htm
www.51sole.com/b2b/pd_458684611.htm
www.51sole.com/b2b/pd_458684658.htm
www.51sole.com/b2b/pd_458684712.htm
www.51sole.com/b2b/pd_458684818.htm
www.51sole.com/b2b/pd_458684860.htm
www.51sole.com/b2b/pd_458685008.htm
www.51sole.com/b2b/pd_458685054.htm
www.51sole.com/b2b/pd_458685150.htm
www.51sole.com/b2b/pd_458685248.htm
www.51sole.com/b2b/pd_458685420.htm
www.51sole.com/b2b/pd_458685675.htm
www.51sole.com/b2b/pd_458685724.htm
www.51sole.com/b2b/pd_458685939.htm
www.51sole.com/b2b/pd_458686012.htm
www.51sole.com/b2b/pd_458686102.htm
www.51sole.com/b2b/pd_458686174.htm
www.51sole.com/b2b/pd_458686279.htm
www.51sole.com/b2b/pd_458686320.htm
www.51sole.com/b2b/pd_458686382.htm
www.51sole.com/b2b/pd_458686440.htm
www.51sole.com/b2b/pd_458686555.htm
www.51sole.com/b2b/pd_458686680.htm
www.51sole.com/b2b/pd_458686737.htm
www.51sole.com/b2b/pd_458686888.htm
www.51sole.com/b2b/pd_458686995.htm
www.51sole.com/b2b/pd_458687055.htm
www.51sole.com/b2b/pd_458687157.htm
www.51sole.com/b2b/pd_458687309.htm
www.51sole.com/b2b/pd_458687421.htm
www.51sole.com/b2b/pd_458687656.htm
www.51sole.com/b2b/pd_458687778.htm
www.51sole.com/b2b/pd_458687833.htm
www.51sole.com/b2b/pd_458687894.htm
www.51sole.com/b2b/pd_458687953.htm
www.51sole.com/b2b/pd_458688227.htm
www.51sole.com/b2b/pd_458688379.htm
www.51sole.com/b2b/pd_458688687.htm
www.51sole.com/b2b/pd_458688808.htm
www.51sole.com/b2b/pd_458689084.htm
www.51sole.com/b2b/pd_458689150.htm
www.51sole.com/b2b/pd_458689260.htm
www.51sole.com/b2b/pd_458689317.htm
www.51sole.com/b2b/pd_458689383.htm
www.51sole.com/b2b/pd_458689441.htm
www.51sole.com/b2b/pd_458689503.htm
www.51sole.com/b2b/pd_458689717.htm
www.51sole.com/b2b/pd_458690031.htm
www.51sole.com/b2b/pd_458690082.htm
www.51sole.com/b2b/pd_458690188.htm
www.51sole.com/b2b/pd_458690253.htm
www.51sole.com/b2b/pd_458690419.htm
www.51sole.com/b2b/pd_458690519.htm
www.51sole.com/b2b/pd_458690751.htm
www.51sole.com/b2b/pd_458690811.htm
www.51sole.com/b2b/pd_458690872.htm
www.51sole.com/b2b/pd_458690922.htm
www.51sole.com/b2b/pd_458691047.htm
www.51sole.com/b2b/pd_458691107.htm
www.51sole.com/b2b/pd_458691217.htm
www.51sole.com/b2b/pd_458691270.htm
www.51sole.com/b2b/pd_458691321.htm
www.51sole.com/b2b/pd_458691483.htm
www.51sole.com/b2b/pd_458691530.htm
www.51sole.com/b2b/pd_458691619.htm
www.51sole.com/b2b/pd_458691668.htm
www.51sole.com/b2b/pd_458691725.htm
www.51sole.com/b2b/pd_458691867.htm
www.51sole.com/b2b/pd_458691961.htm
www.51sole.com/xinxi/458616452.htm
www.51sole.com/xinxi/458616497.htm
www.51sole.com/xinxi/458616532.htm
www.51sole.com/xinxi/458616602.htm
www.51sole.com/xinxi/458616640.htm
www.51sole.com/xinxi/458616705.htm
www.51sole.com/xinxi/458616748.htm
www.51sole.com/xinxi/458616798.htm
www.51sole.com/xinxi/458616851.htm
www.51sole.com/xinxi/458616973.htm
www.51sole.com/xinxi/458617018.htm
www.51sole.com/xinxi/458617096.htm
www.51sole.com/xinxi/458617178.htm
www.51sole.com/xinxi/458617264.htm