title: Pentaho : How to split single Excel file to multiple excel sheet output
body: <p>I have a list of employee details. I want to split each employee detail in separate Excel sheet. I tried a lot but I get only separate Excel files alone, not all the sheets in a single file by using Pentaho kettle.</p>
  
  <p>Eg:</p>
  
  <pre><code>Raja    22 developer  25000
  ravi    23 tester      2000
  karthik 24 designer    4000 
  Mani    28 developer  45000
  </code></pre>
  
  <p>In that each employee details will need separate sheets in a single excel file. Already, I worked with "MS excel writer" but it did not work. </p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Thanks for your valuable reply,its really clear and more useful. :-) But i need one more detail from you,if i added age,skill ,salary columns into the get variables, after run the job ,i didn't get the values of these three fields only their column names shown in every sheet. I need to include their column values in each sheet</p>
  
  <p>example : sheet 1 : (raja)</p>
  
  <p>Name age skill salary Raja 22 developer 25000</p>
  
  <p>sheet 2 :(ravi) Name age skill salary ravi 23 tester 2000</p>
  
  <p>Like that i need to generate each sheets,I hope you get my point. Can you please help me how to i generate that.</p>