[said Internet use VBS]
I excel file is to use reporting tools download (shown below), to achieve resolution transcoding to formal excel, read with poi, but only can't read the text style, now convert ideas, directly in the Java code implementation background "save as" to formal excel, asked the great spirit guide!!!!!!

CodePudding user response:

Use reporting tools generate XML format excel the compiler open as shown in the above want to become a regular excel format

CodePudding user response:

 

<? The XML version="1.0"?> 
<? The oledata.mso - application progid="Excel Sheet"?> 
XMLNS: o="urn: schemas - Microsoft - com: office: office" 
XMLNS: x="urn: schemas - Microsoft - com: Microsoft office, excel" 
XMLNS: ss="urn: schemas - Microsoft - com: office: spreadsheet" 
XMLNS: HTML="http://www.w3.org/TR/REC-html40" & gt; 
 The 2009-12-18 T14:44:09 Z 
 12.00 & lt;/Version> 
 
 10005 & lt;/WindowHeight> 
 10005 & lt;/WindowWidth> 
 120 & lt;/WindowTopX> 
 135 & lt;/WindowTopY> 
 False 
 False 
 
<styles> 
<style ss: ID="Default" ss: Name="Normal" & gt; 
</style> 
<style ss: ID="s62" & gt; 
</style> 
<style ss: ID="s63" & gt; 
</style> 
 
X: FullRows="1" ss: StyleID="s62" ss: DefaultColumnWidth="54" & gt; 
 
  
  
  
  
 
 
   
   
   
   
 
 
 
 

CodePudding user response:

XML format excel file, similar to the above code

CodePudding user response:

Also don't know how to solve,

CodePudding user response:

Brother, this problem solved now, I have a large baidu, but still can't solve this problem,
Strives for the light,
Don't delete the administrator?

CodePudding user response:

references 9 f qq_39450243 response:

yes, the problem solved now, I baidu a lot, but still can't solve this problem,
Strives for the light,
Don't delete the administrator?

I also in studying this problem, brother you solved

CodePudding user response:

references to the tenth floor BlankING, reply:

Quote: references 9 f qq_39450243 response:

Brother, this problem solved now, I have a large baidu, but still can't solve this problem,
Strives for the light,
Don't delete the administrator?

I also in research this problem, the brother can you solve it

I solved at present, because he is a XML format to open,
My current plan is to use SAXReader read, then VisitorSupport to the node values I need,

CodePudding user response:

references 9 f qq_39450243 response:

yes, the problem solved now, I baidu a lot, but still can't solve this problem,
Strives for the light,
Don't delete the administrator?

The solution?