title: Input to Jmeter SOAP/XML-RPC Request via multiple sheets in Excel
body: <p><strong>My Problem:</strong> 
  I have all my test data inside an excel + multiple sheets. I am trying to read the excel data &amp; store it as a User Defined variable in Jmeter. I plan to use this:   </p>
  
  <ul>
  <li>As a variable in a Request XML I send via SOAP/XML-RPC Request</li>
  <li>As a assert variable of the Response XML that I receive.  </li>
  </ul>
  
  <p><strong>What have I done so far:</strong>
  I am using a similar example as in <a href="https://stackoverflow.com/questions/29047720/jmeter-upload-excel-hard-coded-values">Jmeter : upload excel, hard coded values</a> </p>
  
  <ul>
  <li>The first sheet has A1 and B1 cells of testfile.xlsx file as "foo" and "bar" </li>
  <li>I have downloaded tika-app-1.9.jar &amp; added in the /lib folder of Jmeter(v2.13)</li>
  <li><p>Added Beanshell PreProcessor &amp; in the Script section added: </p>
  
  <pre><code>import org.apache.jmeter.protocol.http.sampler.WebServiceSampler;
  import org.apache.poi.ss.usermodel.Cell;
  import org.apache.poi.xssf.usermodel.XSSFRow;
  import org.apache.poi.xssf.usermodel.XSSFSheet;
  import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  
  import java.io.File;
  import java.io.FileInputStream;
  
  FileInputStream excelFile = new FileInputStream(new File("/path/to/excel/testfile.xlsx"));
  XSSFWorkbook workbook = new XSSFWorkbook(excelFile);
  XSSFSheet sheet = workbook.getSheetAt(0);
  XSSFRow row = sheet.getRow(0);
  Cell a1 = row.getCell(0);
  String a1Value = a1.getStringCellValue();
  Cell a2 = row.getCell(1);
  String a2Value = a2.getStringCellValue();
  
  excelFile.close();
  
  sampler.addArgument("foo",a1Value);
  sampler.addArgument("bar",a2Value);
  </code></pre></li>
  </ul>
  
  <p>When I use the variable ${foo} in my SOAP/XML-RPC Request, the value does not get replaced with the value, but stays as ${foo}. </p>
  
  <p>Any idea on what might be the problem here? </p>