ermucis Posted May 17, 2004 Report Share Posted May 17, 2004 Vai ir iespeejams no excel failu savienot ar PHP. jaanjem veeraa fakts, ka Excel mainiisies katru meenesi. Link to comment Share on other sites More sharing options...
bubu Posted May 17, 2004 Report Share Posted May 17, 2004 ko noziimee savienot? Link to comment Share on other sites More sharing options...
ermucis Posted May 17, 2004 Author Report Share Posted May 17, 2004 Izveidot PHP lapu, kur dati tiek njmeti no Excel! Link to comment Share on other sites More sharing options...
bubu Posted May 17, 2004 Report Share Posted May 17, 2004 ja datus izeksportee CSV formaataa, tad kaapeec gan ne? mieriigi panjem lasi pa rindinjai un taisi explode. Link to comment Share on other sites More sharing options...
Roze Posted May 18, 2004 Report Share 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.. Link to comment Share on other sites More sharing options...
Recommended Posts