POI实现txt文件转化EXCLE

Report Name: Outstanding Loan Position and Interest report
Period: From 21-Mar-2011 To 31-Mar-2011
Pair Name|ABC LTD   &   XYZ LTD
A/C No. of ABC LTD|123456CNY12345
A/C No. of XYZ LTD|23456CNY12345
Date|Fund from ABC to XYZ|Fund from XYZ to ABC|Cumulative Position|Credit Rate|Debit Rate|Interest Amount|Cumulative Interest for XYZ|Cumulative Interest for ABC
|||300,000.00||||333.00|0.00
21-Mar-2011|1,000,000.00|0.00|1,300,000.00|3.00000|2.00000|108.33|441.33|0.00
22-Mar-2011|2,500,000.00|0.00|3,800,000.00|3.00000|2.00000|316.67|758.00|0.00
23-Mar-2011|0.00|1,000,000.00|2,800,000.00|3.00000|2.00000|233.33|991.33|0.00
24-Mar-2011|0.00|0.00|2,800,000.00|3.00000|2.00000|233.33|1,224.66|0.00
25-Mar-2011|0.00|2,000,000.00|800,000.00|3.00000|2.00000|66.67|1,291.33|0.00
26-Mar-2011|0.00|0.00|800,000.00|3.00000|2.00000|66.67|1,358.00|0.00
27-Mar-2011|0.00|0.00|800,000.00|3.00000|2.00000|66.67|1,424.67|0.00
28-Mar-2011|0.00|0.00|800,000.00|3.00000|2.00000|66.67|1,491.34|0.00
29-Mar-2011|0.00|0.00|800,000.00|3.00000|2.00000|66.67|1,558.01|0.00
30-Mar-2011|0.00|0.00|800,000.00|3.00000|2.00000|66.67|1,624.68|0.00
31-Mar-2011|0.00|1,000,000.00|-200,000.00|3.00000|2.00000|-11.11|1,624.68|11.11
Outstanding EL to ABC|200,000.00
Interest Due to ABC:|1,624.68|Interest Due to XYZ:|11.11
This report is computer generated and requires no signature
This report is to be read in conjunction with your bank statement
######
Report Name: Outstanding Loan Position and Interest report
Period: From 21-Mar-2011 To 31-Mar-2011
Pair Name|ABC LTD   &   BCD LTD
A/C No. of ABC LTD|123456CNY12345
A/C No. of BCD LTD|23456CNY12345
Date|Fund from ABC to BCD|Fund from BCD to ABC|Cumulative Position|Credit Rate|Debit Rate|Interest Amount|Cumulative Interest for BCD|Cumulative Interest for ABC
|||300,000.00||||333.00|0.00