[Webtest] Reading an excel sheet

Sun, 15 Jun 2008 12:13:04 +0300

This is a multi-part message in MIME format.

--Boundary_(ID_17xoySTBTfOvD9ba22J1ww)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT

Hi,

I have an excel sheet with a lot of input cases I should check that are
rejected by a form..

I'd like to iterate over the rows in the file and repeat the test. Is it
possible to iterate over the rows somehow... Is there a way to read
files easily, at all?

I know that there are the excel steps, but aren't they a little
cumbersome for this job?

Thanks, Noam

--Boundary_(ID_17xoySTBTfOvD9ba22J1ww)
Content-type: text/html; charset=us-ascii
Content-transfer-encoding: 7BIT

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@page Section1
	{size:595.45pt 841.7pt;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I have an excel sheet with a lot of input cases I should
check that are rejected by a form..<o:p></o:p></span></font></p>

I&#8217;d like to iterate over the rows in the file and
repeat the test. Is it possible to iterate over the rows somehow&#8230; Is
there a way to read files easily, at all?<o:p></o:p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I know that there are the excel steps, but aren&#8217;t they
a little cumbersome for this job?<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks, Noam<o:p></o:p></span></font></p>

</div>

</body>

</html>

--Boundary_(ID_17xoySTBTfOvD9ba22J1ww)--