1,451
社区成员
发帖
与我相关
我的任务
分享
HTML code
<TABLE class=printtab width=600>
<TBODY>
<TR class=tablabel>
<TD class=printtd>单位公章</TD>
<TD class=printtd>打印时间:</TD>
<TD class=printtd>打印地点:</TD>
<TD class=printtd>打印人:</TD></TR></TBODY></TABLE>
<TABLE class=printtab width=600>
<TBODY>
<TR>
<TD>
<TABLE style="cellspacing: 0; cellpadding: 0" width="100%">
<TBODY>
<TR class=tablabel>
<TD class=printtd width=60>用户编号:</TD>
<TD class=printtd width=140>12345678</TD>
<TD class=printtd width=60>用户名称:</TD>
<TD class=printtd width=140>李强</TD>
<TD class=printtd width=60>房屋性质:</TD>
<TD class=printtd width=140>居民</TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE style="cellspacing: 0; cellpadding: 0" width="100%">
<TBODY>
<TR class=tablabel>
<TD class=printtd width=60>住址:</TD>
<TD class=printtd width=450>住址省略</TD>
<TD class=printtd width=60>进户时间:</TD>
<TD class=printtd width=60>199901</TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE style="cellspacing: 0; cellpadding: 0" width="100%">
<TBODY>
<TR class=tablabel>
<TD class=printtd width=60>公司:</TD>
<TD class=printtd width=140>第一分公司</TD>
<TD class=printtd width=60>收费员:</TD>
<TD class=printtd width=140>张三</TD>
<TD class=printtd width=60>面积:</TD>
<TD class=printtd width=140>75.58</TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE style="cellspacing: 0; cellpadding: 0" width="100%">
<TBODY>
<TR class=tablabel>
<TD class=printtd width=60>备注:</TD>
<TD class=printtd width=600>地址详情;</TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE style="cellspacing: 0; cellpadding: 0" width="100%">
<TBODY>
<TR class=tablabel>
<TD class=printtd>年度</TD>
<TD class=printtd>应收</TD>
<TD class=printtd>实收</TD>
<TD class=printtd>欠费</TD>
<TD class=printtd>滞纳金</TD>
<TD class=printtd>欠费合计</TD></TR>
<TR class=tablabel>
<TD class=printtd>2011</TD>
<TD class=printtd>3049.65</TD>
<TD class=printtd>0.0</TD>
<TD class=printtd>3049.65</TD>
<TD class=printtd>0.0</TD>
<TD class=printtd>3049.65</TD></TR>
<TR class=tablabel>
<TD class=Noprint>2010</TD>
<TD class=Noprint>3049.65</TD>
<TD class=Noprint>3049.65</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>0.0</TD></TR>
<TR class=tablabel>
<TD class=Noprint>2009</TD>
<TD class=Noprint>3049.65</TD>
<TD class=Noprint>609.93</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>0.0</TD></TR>
<TR class=tablabel>
<TD class=Noprint>2008</TD>
<TD class=Noprint>3049.65</TD>
<TD class=Noprint>609.93</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>0.0</TD></TR>
<TR class=tablabel>
<TD class=Noprint>2007</TD>
<TD class=Noprint>2611.29</TD>
<TD class=Noprint>2611.3</TD>
<TD class=Noprint>-0.01</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>-0.01</TD></TR>
<TR class=tablabel>
<TD class=Noprint>2006</TD>
<TD class=Noprint>2611.29</TD>
<TD class=Noprint>2611.3</TD>
<TD class=Noprint>-0.01</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>-0.01</TD></TR>
<TR class=tablabel>
<TD class=printtd>合计</TD>
<TD class=printtd> </TD>
<TD class=printtd>0.0</TD>
<TD class=printtd>3049.65</TD>
<TD class=printtd>0.0</TD>
<TD class=printtd>3049.65</TD></TR>
<TR class=tablabel>
<TD class=Noprint>合计[不打印]</TD>
<TD class=Noprint> </TD>
<TD class=Noprint>9492.11</TD>
<TD class=Noprint>3049.63</TD>
<TD class=Noprint>0.0</TD>
<TD class=Noprint>3049.63</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
s = 'HTML代码
s = Mid(s, InStr(1, s, "<TD class=printtd>年度</TD>"))
s = Left(s, InStr(1, s, "<TD class=printtd>合计</TD>") - 1)
s = Replace(s, "<TD class=printtd>", "")
s = Replace(s, "<TD class=Noprint>", "")
s = Replace(s, "</TR>", "")
s = Replace(s, vbCrLf, "")
'输出结果
s1 = Split(s, "<TR class=tablabel>") '每一行
For i = 0 To UBound(s1) - 1
s2 = Split(s1(i), "</TD>") '每一列
If i = 0 Then
Debug.Print "序号", s2(0), s2(3), s2(4)
ElseIf Val(s2(3)) > 0 Then
Debug.Print i, s2(0), s2(3), s2(4)
End If
Next i
序号 年度 欠费 滞纳金
1 2011 3049.65 0.0
s = 'HTML代码
s = Mid(s, InStr(1, s, "<TD class=printtd>年度</TD>"))
s = Left(s, InStr(1, s, "<TD class=printtd>合计</TD>") - 1)
s = Replace(s, "<TD class=printtd>", "")
s = Replace(s, "<TD class=Noprint>", "")
s = Replace(s, "</TR>", "")
s = Replace(s, vbCrLf, "")
'输出结果
s1 = Split(s, "<TR class=tablabel>") '每一行
For i = 0 To UBound(s1) - 1
s2 = Split(s1(i), "</TD>") '每一列
Debug.Print IIf(i = 0, "序号", i), s2(0), s2(3), s2(4)
Next i
结果:
序号 年度 欠费 滞纳金
1 2011 3049.65 0.0
2 2010 0.0 0.0
3 2009 0.0 0.0
4 2008 0.0 0.0
5 2007 -0.01 0.0
6 2006 -0.01 0.0