求一个自动填选择题的程序

[luchenye1212]

EXCEL中
格式为EXCEL数据格试为

1 2 3 4 5 6
A C B C D E


网页上全为选择题
<td width="270" valign="bottom" class="DataB" align="center" VALIGN="top">
<font face="Arial, Helvetica, sans-serif" size="2">完全不正确
<input type="radio" name="p1" value="1">
<input type="radio" name="p1" value="2">
<input type="radio" name="p1" value="3">
<input type="radio" name="p1" value="4">
<input type="radio" name="p1" value="5">
非常正确
</font>
</TD>
</tr>

<tr>
<td class="DataA">
<font face="Arial, Helvetica, sans-serif" size="3">
 2. 不管人家怎么对待我，我对人都很友善．</font>
</td>
<td width="270" valign="bottom" class="DataA" align="center" VALIGN="top">
<font face="Arial, Helvetica, sans-serif" size="2">完全不正确
<input type="radio" name="p2" value="1">
<input type="radio" name="p2" value="2">
<input type="radio" name="p2" value="3">
<input type="radio" name="p2" value="4">
<input type="radio" name="p2" value="5">
非常正确
</font>
</TD>
</tr>

<tr>
<td class="DataB">
<font face="Arial, Helvetica, sans-serif" size="3">
 3. 我不是一个冒险的人．</font>
</td>
<td width="270" valign="bottom" class="DataB" align="center" VALIGN="top">
<font face="Arial, Helvetica, sans-serif" size="2">完全不正确
<input type="radio" name="p3" value="1">
<input type="radio" name="p3" value="2">
<input type="radio" name="p3" value="3">
<input type="radio" name="p3" value="4">
<input type="radio" name="p3" value="5">
非常正确
</font>
</TD>
</tr>

<tr>
<td class="DataA">
<font face="Arial, Helvetica, sans-serif" size="3">
 4. 我是一个害羞的人．</font>
</td>
<td width="270" valign="bottom" class="DataA" align="center" VALIGN="top">
<font face="Arial, Helvetica, sans-serif" size="2">完全不正确
<input type="radio" name="p4" value="1">
<input type="radio" name="p4" value="2">
<input type="radio" name="p4" value="3">
<input type="radio" name="p4" value="4">
<input type="radio" name="p4" value="5">
非常正确
</font>
</TD>
</tr>

<tr>
<td class="DataB">
<font face="Arial, Helvetica, sans-serif" size="3">
 5. 当压力很大的时候，我很难保持冷静．</font>
</td>
<td width="270" valign="bottom" class="DataB" align="center" VALIGN="top">
<font face="Arial, Helvetica, sans-serif" size="2">完全不正确
<input type="radio" name="p5" value="1">
<input type="radio" name="p5" value="2">
<input type="radio" name="p5" value="3">
<input type="radio" name="p5" value="4">
<input type="radio" name="p5" value="5">
非常正确
</font>
</TD>
</tr>

<tr>
<td class="DataA">
<font face="Arial, Helvetica, sans-serif" size="3">
 6. 我在集体工作中表现最好．</font>
</td>
<td width="270" valign="bottom" class="DataA" align="center" VALIGN="top">
<font face="Arial, Helvetica, sans-serif" size="2">完全不正确
<input type="radio" name="p6" value="1">
<input type="radio" name="p6" value="2">
<input type="radio" name="p6" value="3">
<input type="radio" name="p6" value="4">
<input type="radio" name="p6" value="5">
非常正确
</font>