bb.txt

读excel文件生产文本文件导入用友生产凭证

#总计信息
#注意：本文件中的金额均以分为单位！
#币种|日期|总计标志|总金额|总笔数|
RMB|20040909|1|0||
#明细指令信息
#币种|日期|明细标志|顺序号|付款帐号开户行|付款帐号|付款帐号名称|收款帐号开户行|收款帐号省份|收款帐号地市|收款帐号地区码|收款帐号|收款帐号名称|金额|汇款用途|备注信息|
*
RMB|20040909|2|1    |少儿                                                        |0.3881066595514678            |702955                                                      |97397137.50                                                 |37800477.68500000000|
RMB|20040909|2|2    |文学                                                        |0.7421277072096514            |1049043                                                     |39340312.06                                                 |29195535.59000000000|
RMB|20040909|2|3    |社科                                                        |0.8304498393661033            |1491133                                                     |41504932.22                                                 |34467764.29500000000|
RMB|20040909|2|4    |文教                                                        |0.7763659967629693            |466172                                                      |26177989.56                                                 |20323700.95800000000|
RMB|20040909|2|5    |计算机                                                      |0.5449292995756018            |1227477                                                     |29452848.66                                                 |16049720.19080000000|
RMB|20040909|2|6    |外语                                                        |0.6228258272667955            |100263                                                      |3396528.20                                                  |2115445.486000000000|