Решено: Импортировать html таблицу в excel

Модератор: Модераторы разделов

Аватара пользователя
Mull
Сообщения: 35
ОС: Ubuntu

Решено: Импортировать html таблицу в excel

Сообщение Mull »

Spoiler
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=windows-1251">
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE>ОТЧЕТ</TITLE>
</HEAD>

<BODY>
<PRE> ОТЧЕТ
о суточных параметрах теплоснабжения
22/10/12г.-31/10/12г.
Абонент:xxxxxxxxxxxxxx Договор N:_________________
Адрес:xxxxxxxxxxxxx, 24 Тип расходомера:___________
Тепловычислитель ВКТ-7 сет.N 001 Пределы измерений:
Договорные расходы: G под max = 2.00 м3/ч G под min = 1.00 м3/ч
М сет.воды=______т.сут Мгвс=______ т.сут G обр max = 2.00 м3/ч G обр min = 1.00 м3/ч
Тхв= 0.00°C G3 max = 2.00 м3/ч G3 min = 1.00 м3/ч

Заводской номер 00107882 ВВОД 1 СХЕМА ПОДКЛЮЧЕНИЯ 3 БД 1 ФТ=0 Т3=1 КС=0xC8B6 ПО 2.7</PRE>
<TABLE cellSpacing=0 cellPadding=3 border=1>
<TR align=center valign=middle>
<TD rowspan = 2><B>
Дата
</B></TD>
<TD><B>
t1
</B></TD>
<TD><B>
t2
</B></TD>
<TD><B>
dt
</B></TD>
<TD><B>
V1
</B></TD>
<TD><B>
M1
</B></TD>
<TD><B>
V2
</B></TD>
<TD><B>
M2
</B></TD>
<TD><B>
V3
</B></TD>
<TD><B>
Mг
</B></TD>
<TD><B>
P1
</B></TD>
<TD><B>
P2
</B></TD>
<TD><B>
Qо
</B></TD>
<TD><B>
BНP
</B></TD>
<TD><B>
BOC
</B></TD>
<TD colspan = 12><B>
Н.С.
</B></TD>
</TR>
<TR align=center valign=middle>
<TD><B>
°C
</B></TD>
<TD><B>
°C
</B></TD>
<TD><B>
°C
</B></TD>
<TD><B>
м3
</B></TD>
<TD><B>
т
</B></TD>
<TD><B>
м3
</B></TD>
<TD><B>
т
</B></TD>
<TD><B>
м3
</B></TD>
<TD><B>
т
</B></TD>
<TD><B>
кг/см2
</B></TD>
<TD><B>
кг/см2
</B></TD>
<TD><B>
Гкал
</B></TD>
<TD><B>
ч
</B></TD>
<TD><B>
ч
</B></TD>
<TD><B>
t1
</B></TD>
<TD><B>
t2
</B></TD>
<TD><B>
dt
</B></TD>
<TD><B>
V1
</B></TD>
<TD><B>
M1
</B></TD>
<TD><B>
V2
</B></TD>
<TD><B>
M2
</B></TD>
<TD><B>
V3
</B></TD>
<TD><B>
Mг
</B></TD>
<TD><B>
P1
</B></TD>
<TD><B>
P2
</B></TD>
<TD><B>
Qо
</B></TD>
</TR>
<TR align=center valign=middle>
<TD>22/10/12</TD>
<TD>20,14</TD>
<TD>23,62</TD>
<TD>-3,48</TD>
<TD>0,00</TD>
<TD>0,00</TD>
<TD>0,00</TD>
<TD>0,00</TD>
<TD>0,00</TD>
<TD>0,00</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>0,000</TD>
<TD>11</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>*</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>23/10/12</TD>
<TD>64,98</TD>
<TD>49,88</TD>
<TD>15,10</TD>
<TD>20,82</TD>
<TD>20,44</TD>
<TD>21,53</TD>
<TD>21,30</TD>
<TD>0,00</TD>
<TD>-0,86</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>0,299</TD>
<TD>24</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>24/10/12</TD>
<TD>64,35</TD>
<TD>46,61</TD>
<TD>17,74</TD>
<TD>57,83</TD>
<TD>56,79</TD>
<TD>56,65</TD>
<TD>56,06</TD>
<TD>0,00</TD>
<TD>0,73</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>1,009</TD>
<TD>24</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>25/10/12</TD>
<TD>59,81</TD>
<TD>41,05</TD>
<TD>18,76</TD>
<TD>27,76</TD>
<TD>27,33</TD>
<TD>26,67</TD>
<TD>26,46</TD>
<TD>0,00</TD>
<TD>0,87</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>0,507</TD>
<TD>24</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>26/10/12</TD>
<TD>65,39</TD>
<TD>45,43</TD>
<TD>19,96</TD>
<TD>59,79</TD>
<TD>58,62</TD>
<TD>58,20</TD>
<TD>57,68</TD>
<TD>0,00</TD>
<TD>0,94</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>1,170</TD>
<TD>24</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>27/10/12</TD>
<TD>66,16</TD>
<TD>44,87</TD>
<TD>21,29</TD>
<TD>56,13</TD>
<TD>55,07</TD>
<TD>55,70</TD>
<TD>55,16</TD>
<TD>0,00</TD>
<TD>-0,09</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>1,169</TD>
<TD>24</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>28/10/12</TD>
<TD>64,93</TD>
<TD>43,48</TD>
<TD>21,45</TD>
<TD>55,88</TD>
<TD>54,86</TD>
<TD>55,18</TD>
<TD>54,68</TD>
<TD>0,00</TD>
<TD>0,18</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>1,175</TD>
<TD>25</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>29/10/12</TD>
<TD>64,63</TD>
<TD>43,52</TD>
<TD>21,11</TD>
<TD>34,58</TD>
<TD>33,96</TD>
<TD>33,99</TD>
<TD>33,68</TD>
<TD>0,00</TD>
<TD>0,28</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>0,716</TD>
<TD>24</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>30/10/12</TD>
<TD>66,57</TD>
<TD>40,92</TD>
<TD>25,65</TD>
<TD>20,88</TD>
<TD>20,47</TD>
<TD>20,57</TD>
<TD>20,44</TD>
<TD>0,00</TD>
<TD>0,03</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>0,530</TD>
<TD>24</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD>31/10/12</TD>
<TD>66,84</TD>
<TD>41,75</TD>
<TD>25,09</TD>
<TD>41,89</TD>
<TD>41,10</TD>
<TD>41,23</TD>
<TD>40,94</TD>
<TD>0,00</TD>
<TD>0,16</TD>
<TD>7,00</TD>
<TD>7,00</TD>
<TD>1,031</TD>
<TD>24</TD>
<TD>0</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
<TD>&nbsp;</TD>
</TR>
<TR align=center valign=middle>
<TD><B>Итого:</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>375,56</B></TD><TD><B>368,64</B></TD><TD><B>369,72</B></TD><TD><B>366,40</B></TD><TD><B>0,00</B></TD><TD><B>2,24</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>7,606</B></TD><TD><B>228</B></TD><TD><B>0</B></TD><TD colspan = 12><B>&nbsp;</B></TD>
</TR>
<TR align=center valign=middle>
<TD><B>
Средние:</B></TD><TD><B>60,38</B></TD><TD><B>42,11</B></TD><TD><B>18,26</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>7,00</B></TD><TD><B>7,00</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD><B>&nbsp;</B></TD><TD colspan = 12><B>&nbsp;</B></TD>
</TR>
</TABLE>

<PRE>
</PRE>

<TABLE cellSpacing=0 cellPadding=3 border=1>
<TR align=center valign=middle>
<TD rowspan = 2><B>
Дата
</B></TD>
<TD><B>
V1
</B></TD>
<TD><B>
M1
</B></TD>
<TD><B>
V2
</B></TD>
<TD><B>
M2
</B></TD>
<TD><B>
V3
</B></TD>
<TD><B>
Mг
</B></TD>
<TD><B>
Qо
</B></TD>
<TD><B>
BНP
</B></TD>
<TD><B>
BOC
</B></TD>
</TR>
<TR align=center valign=middle>
<TD><B>
м3
</B></TD>
<TD><B>
т
</B></TD>
<TD><B>
м3
</B></TD>
<TD><B>
т
</B></TD>
<TD><B>
м3
</B></TD>
<TD><B>
т
</B></TD>
<TD><B>
Гкал
</B></TD>
<TD><B>
ч
</B></TD>
<TD><B>
ч
</B></TD>
</TR>

<TR align=center valign=middle>
<TH><B>21/10/1224:00</B></TH><TH><B>0,00</B></TH><TH><B>0,00</B></TH><TH><B>0,00</B></TH><TH><B>0,00</B></TH><TH><B>0,00</B></TH><TH><B>0,00</B></TH><TH><B>0,000</B></TH><TH><B>0</B></TH><TH><B>0</B></TH>
</TR>
<TR align=center valign=middle>
<TH><B>31/10/1224:00</B></TH><TH><B>375,56</B></TH><TH><B>368,64</B></TH><TH><B>369,72</B></TH><TH><B>366,40</B></TH><TH><B>0,00</B></TH><TH><B>2,24</B></TH><TH><B>7,606</B></TH><TH><B>228</B></TH><TH><B>0</B></TH>
</TR>
<TR align=center valign=middle>
<TH><B>Итого:</B></TH><TH><B>375,56</B></TH><TH><B>368,64</B></TH><TH><B>369,72</B></TH><TH><B>366,40</B></TH><TH><B>0,00</B></TH><TH><B>2,24</B></TH><TH><B>7,606</B></TH><TH><B>228</B></TH><TH><B>0</B></TH>
</TR>

</TABLE>
<PRE>
________________________________________________________________________________
_________________________

Период нормальной работы 228ч
Период отсутств.счета тепл.энергии 0ч
Время работы прибора после сброса 241ч

Представитель абонента Представитель теплоснабж.организации


</PRE>
</BODY>
</HTML>


Как сформировать похожий файл, для дальней обработки в excel?

Сам понял, пока описывал проблему. Просьба тему удалить =)
Спасибо сказали:
Вернуться к началу

Вернуться в «Программирование»