|
|
|
| Åñòü òàáëèöà ñ äàííûìè êàê ýòè âûâåòè ïåðåãðóçèòü â Microsoft Excel ÏËÈZZZZ HELP!!! | |
|
|
|
|
|
|
|
äëÿ: Alex_m
(27.12.2005 â 11:46)
| | à ïî-ðóññêè? | |
|
|
|
|
|
|
|
äëÿ: P@Sol
(27.12.2005 â 12:11)
| | $result = mssql_query ("exec Prosmotr ");
<?while ($row = mssql_fetch_assoc($result))
{?>
<tr>
<td><?=$row["x"];?></td>
<td><?=$row["PRVD"];?></td>
<td><?=$row["NAME_VD"];?></td>
</tr>
<?}?>
ïîëó÷èëè òàáëèöó !!!
òåïåðü íóæíà êíîïêà êîòîðàÿ ýòè äàííûå ïåðåêèäûâàëà áû â Microsoft Excel | |
|
|
|
|
|
|
|
äëÿ: Alex_m
(27.12.2005 â 12:15)
| | íà ïðÿìóþ ñêîðåå âñåãî íå ïîëó÷èòüñÿ, íî ìîæíî ñîçäàòü csv ôàéë, â êîòîðîì äàííûå ðàçäåëÿþòñÿ ñ ïîìîùüþ ";" (òî÷êè ñ çàïÿòîé), à ïîòîì îòêðûâàòü ýòîò ôàéë â Excel. Îí ñàì ðàñêèäàåò äàííûå ïî ÿ÷åéêàì äåëÿ èõ ïî ðàçäåëèòåëÿì (;)
ïî÷èòàéòå åùå èíôîðìàöèþ:
http://softtime.ru/forum/read.php?id_forum=1&id_theme=10731&page=1
http://softtime.ru/forum/read.php?id_forum=1&id_theme=5622&page=1
http://softtime.ru/forum/read.php?id_forum=1&id_theme=444&page=1 | |
|
|
|
|
|
|
|
äëÿ: P@Sol
(27.12.2005 â 12:20)
| | Íàøåë âîò òàêîå êðàñèâåííûé ñêðèïò)))
<?
$row = 1;
$handle = fopen ("test.csv","r");
while ($data = fgetcsv ($handle, 1000, ","))
{
$num = count ($data);
print "<p>.$num ïîëåé â ñòðîêå $row : <br>\n";
$row++;
for ($c=0; $c < $num; $c++)
{
print $data[$c] . "<br>\n";
}
}
fclose ($handle);
?>
Ïîëó÷àþ âîò òàêîå ((((
4 ïîëåé â ñòðîêå 1:
ÐÏࡱá>þÿ þÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ þÍÁ@á°Áâ\pmihal B°aÀ=œ¯¼=x ##0"@.";\-#
##0"@."9#
##
ÎÁÈÄÍÎ ÁËÈÍ (((
è íèêàêèõ äàííûõ â ôàéë íå ïîëó÷àþ (( | |
|
|
|
|
|
|
|
äëÿ: Alex_m
(27.12.2005 â 12:36)
| | åñëè ÿ íå îøèáàþñü âû îòêðûâàåòå ôàéë íà ÷òåíèå...ïðî çàïèñü òóò íå ñëîâà
Fopen
Äîáàâëåíî:
Ýòîò ñêðèïò èç csv äåëàåò òàáëèöó, à âàì íàîáîðîîò íàäî:) | |
|
|
|
|
|
|
|
äëÿ: P@Sol
(27.12.2005 â 12:44)
| | ÀÃÀ ))) 2-é äåíü ñèæó íè÷åãî íå ïîíèìàþ
óæ äóìàþ ïðîãó êîíñîëüíóþ íàïèñàòü íà DELPHI ÍÎ ÍÅ ÕÎ×ÅÒÑß ìóòèòü
Õî÷ó íà PHP è âñå!!! | |
|
|
|
|
|
|
|
äëÿ: Alex_m
(27.12.2005 â 12:48)
| | ïî÷èòàé òóò http://www.softtime.ru/bookphp/gl6_1.php. Âðîäå ïîíÿòíî âñå
<?
$filename = "name.csv";
$fp = fopen($filename,"a");
for ($k=0;$k<$_POST["total"];$k++)
{
$text = "NAME;"
.$_POST["i".$k].";"
.$_POST["name".$k].";"
.$_POST["god".$k].";"
.$_POST["type".$k].";"
.$_POST["voice".$k].";255;0;"
.$_POST["osn".$k].";"
.$_POST["cat".$k].";255;255;0\n";
fwrite($fp,$text);
}
fclose($fp);
|
âîò òàê çàïèñûâàþ ôàéëû ÿ | |
|
|
|
|
|
|
|
äëÿ: P@Sol
(27.12.2005 â 12:53)
| | Âîò ÿ Âàø êîä óïðîñòèë äî ........
$filename = "test.csv";
$fp = fopen($filename,"a");
for ($k=0;$k<10;$k++)
{
print $k;
$text = "NAME;";
fwrite($fp,$text);
}
fclose($fp);
|
è âñå ðàâíî íå ïèøåò (((( | |
|
|
|
|
|
|
|
äëÿ: Alex_m
(27.12.2005 â 13:10)
| |
<form method=post ...>
$result = mssql_query ("exec Prosmotr ");
<?while ($row = mssql_fetch_assoc($result))
{?>
<tr>
<td><?=$row["x"];?><input type=hidden name=row1 value=<?=$row["x"];?></td>
<td><?=$row2["x"];?><input type=hidden name=row2 value=<?=$row2["x"];?></td>
</tr>
<?}?>
</form>
|
<?
$filename = "test.csv";
$fp = fopen($filename,"a");
for ($k=0;$k<10;$k++)
{
print $k;
$text = $_POST["row1"].";".$_POST["row2"]."\n";
fwrite($fp,$text);
}
fclose($fp);
?>
|
| |
|
|
|
|
|
|
|
äëÿ: Alex_m
(27.12.2005 â 12:36)
| | À ôàéë òî÷íî ñîõðàíÿåòñÿ ïðè ïîìîùè "Ñîõðàíèòü êàê" â ôîðìàòå CSV? | |
|
|
|
|
|
|
|
äëÿ: cheops
(27.12.2005 â 13:35)
| | Òî÷íî íå ñîõðàíÿþ
Òîëüêî ÷òî ñîõðàíèë è âñå çàðàáîòàëî ))))
Ñïàñèáî çà ïîìîùü !!! | |
|
|
|
|
|
|
|
äëÿ: Alex_m
(27.12.2005 â 11:46)
| | ÷òî òî ÿ òàê è íå ïîíÿë, ÷òî òðåáóåòñÿ, òî ëè ñîçäàòü csv ôàéë, òî ëè ïðî÷èòàòü èç íåãî :/
[ïîïðàâëåíî ìîäåðàòîðîì] | |
|
|
|