| Author | 
		  Message
		 | 
		
		  | raindew | 
		  
		    
			  
				 Posted: Wed Oct 21, 2020 3:19 am    Post subject: Transform XML to EXCEL file | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 13 Oct 2010 Posts: 9
  
  | 
		  
		    
			  
				Hi All,
 
 
    Any suggestions/ code sample for transformation of xml file to excel format using java compute node. 
 
 
Please do suggest/comment if this has been previously done. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | gbaddeley | 
		  
		    
			  
				 Posted: Wed Oct 21, 2020 2:47 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 25 Mar 2003 Posts: 2538 Location: Melbourne, Australia 
  | 
		  
		    
			  
				I tried Google for "how to convert xml to excel in java" _________________ Glenn | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | raindew | 
		  
		    
			  
				 Posted: Wed Oct 21, 2020 6:16 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 13 Oct 2010 Posts: 9
  
  | 
		  
		    
			  
				| The java code copied and pasted just wouldn't work. Looks like the code is expecting keywords like MbElement etc., | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | raindew | 
		  
		    
			  
				 Posted: Wed Oct 21, 2020 7:20 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 13 Oct 2010 Posts: 9
  
  | 
		  
		    
			  
				Please suggest links /samples  that has code written in " Java Compute Node " not stand alone Java for the conversion of xml to excel.  
 
 
Based on google search it looks like this has never been done before. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | gbaddeley | 
		  
		    
			  
				 Posted: Sun Oct 25, 2020 3:55 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 25 Mar 2003 Posts: 2538 Location: Melbourne, Australia 
  | 
		  
		    
			  
				
   
	| raindew wrote: | 
   
  
	| The java code copied and pasted just wouldn't work. Looks like the code is expecting keywords like MbElement etc., | 
   
 
 
It's almost a given that a direct copy & paste would not work in the node. Invest some time investigating the issues. It could be relatively quick fix. You may need to use a particular XML structure & data layout. _________________ Glenn | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |