ermucis Posted May 17, 2004 Report Posted May 17, 2004 Vai ir iespeejams no excel failu savienot ar PHP. jaanjem veeraa fakts, ka Excel mainiisies katru meenesi.
ermucis Posted May 17, 2004 Author Report Posted May 17, 2004 Izveidot PHP lapu, kur dati tiek njmeti no Excel!
bubu Posted May 17, 2004 Report Posted May 17, 2004 ja datus izeksportee CSV formaataa, tad kaapeec gan ne? mieriigi panjem lasi pa rindinjai un taisi explode.
Roze Posted May 18, 2004 Report Posted May 18, 2004 Nu principaa var - tachu varbuut ir veerts padomaat par to kaa eertaak. 1. Ja stingri paliekam pie Excel: Tad variants ir izmantot ODBC - proti nepiecieshama windows darbstacija/serveris (var protams arii uz *ix sisteemaam tachu tad buus papildus jaaliek ODBC serveris un attieciigi draiveri). Ejam Control Panelii/ODBC vai arii XP/2000 zem Administrative Tools/Data sources(ODBC) njemam System DSN tad Add izveelamies Microsoft Excel Driver (*.xls) nosaucam muusu Sourci kaut kaa un noraadam uz .xls failu.. Tad ejam uz http://lv.php.net/manual/en/ref.uodbc.php http://lv.php.net/manual/en/function.odbc-connect.php un lasam kaa piesleegties un izpildiit SQL kverijus. Var gan meegjinaat taisiit arii taa sauktaas DSN-less konekcijas (ar Exceli nezinu bet ar Access .mdb straadaa normaali) http://php.weblogs.com/odbc http://php.weblogs.com/adodb 2. Veidojam pashi savu datubaazi (piem ieksh MySQLa) un ja vajag kaadam Exceli atskaiteem (parasti graamatvedeem utt) tad prieksh vinjaam to uzgjenereejam ar Spreadsheet_Excel_Writer http://pear.php.net/package/Spreadsheet_Excel_Writer straadaa vienkaarshi lieliski..
Recommended Posts