{"id":592,"date":"2015-12-18T13:18:55","date_gmt":"2015-12-18T12:18:55","guid":{"rendered":"http:\/\/dokumentacja.edokumenty.eu\/?page_id=592"},"modified":"2015-12-23T13:15:09","modified_gmt":"2015-12-23T12:15:09","slug":"exceleditor","status":"publish","type":"page","link":"http:\/\/developer.edokumenty.eu\/index.php\/dokumentacja-online-systemu-edokumenty\/przetwarzanie-danych\/pomocne-klasy\/exceleditor\/","title":{"rendered":"ExcelEditor"},"content":{"rendered":"<p><strong>Artyku\u0142 dotyczy klasy, kt\u00f3ra jeszcze nie zosta\u0142a zaimplementowana do systemu eDokumenty.<\/strong><\/p>\n<p>Klasa <strong>ExcelEditor<\/strong> pozwala na pobieranie danych w formie arkusza kalkulacyjnego .xlsx, a tak\u017ce na wczytanie takiego pliku na serwer i przetworzenie danych.<\/p>\n<p>W celu u\u017cycia klasy nale\u017cy j\u0105 do\u0142\u0105czy\u0107 do skryptu oraz stworzy\u0107 obiekt typu ExcelEditor:<\/p>\n<div class=\"code-highlight code-highlight-with-label\" data-label=\"PHP\"><span class=\"js-copy-to-clipboard copy-code\">copy<\/span>\n\t<pre><code class=\"language-php js-code\">\nrequire_once('.\/scripts\/ExcelEditor.inc');\r\n$excel = new ExcelEditor();\n<\/code><\/pre><\/div>\n<p>Klasa pozwala na dost\u0119p do obiektu <strong>objPHPExcel<\/strong>, do kt\u00f3rego dokumentacj\u0119 mo\u017cna znale\u017a\u0107 pod adresem <a href=\"http:\/\/phpexcel.codeplex.com\/wikipage?title=Documents&amp;referringTitle=Examples\">phpexcel<\/a><\/p>\n<div class=\"code-highlight code-highlight-with-label\" data-label=\"PHP\"><span class=\"js-copy-to-clipboard copy-code\">copy<\/span>\n\t<pre><code class=\"language-php js-code\">\n\/\/\u00a0Dost\u0119p\u00a0do\u00a0obiektu:\r\n$excel-&gt;objPHPExcel;\r\n\r\n\/\/\u00a0Pobranie\u00a0danych\u00a0z\u00a0kom\u00f3rki\u00a0B2\r\n\/\/\u00a0wiersze\u00a0podajemy\u00a0w\u00a0formie\u00a0cyfr\u00a0licz\u0105c\u00a0od\u00a00\r\n\/\/\u00a0kolumny\u00a0podajemy\u00a0w\u00a0formie\u00a0cyfr\u00a0licz\u0105c\u00a0od\u00a01\r\n$excel-&gt;objPHPExcel-&gt;getActiveSheet()-&gt;getCellByColumnAndRow(1,\u00a02)-&gt;getValue();\n<\/code><\/pre><\/div>\n<p>Klasa posiada nast\u0119puj\u0105ce metody:<\/p>\n<div class=\"code-highlight code-highlight-with-label\" data-label=\"PHP\"><span class=\"js-copy-to-clipboard copy-code\">copy<\/span>\n\t<pre><code class=\"language-php js-code\">\n\/**\r\n*\u00a0Ustawia\u00a0aktywny\u00a0arkusz\r\n*\u00a0@param\u00a0$val\u00a0\u00a0-\u00a0dla\u00a0warto\u015bci\u00a0numerycznej\u00a0ustawia\u00a0wg\u00a0indeksu,\r\n*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0a\u00a0dla\u00a0stringa\u00a0wg\u00a0nazwy\u00a0arkusza\r\n*\/\r\nsetActiveSheet($val)\r\n\r\n\r\n\/**\r\n*\u00a0Zapisuje\u00a0dane\u00a0do\u00a0aktywnego\u00a0arkusza\u00a0-\u00a0domy\u015blnie\u00a0na\u00a0podstawie\r\n*\u00a0@param\u00a0$data\u00a0-\u00a0tablela\u00a0dwuwymiarowa\r\n*\u00a0@param\u00a0array\u00a0$start\u00a0-\u00a0kom\u00f3rka,\u00a0od\u00a0kt\u00f3rej\u00a0zaczyna\u00a0uzupe\u0142nia\u0107\u00a0dane\u00a0-\u00a0domyslnie\u00a0['A',\u00a01]\r\n*\u00a0@return\u00a0bool\r\n*\/\r\npublic\u00a0function\u00a0setData($data,\u00a0$start\u00a0=\u00a0array('A',\u00a01))\r\n\r\n\/**\r\n\u00a0*\u00a0Wczytuje\u00a0dane\u00a0z\u00a0pliku\u00a0i\u00a0przypisuje\u00a0je\u00a0do\u00a0obiektu\u00a0objPHPExcel\u00a0\r\n\u00a0*\u00a0@param\u00a0$filename\r\n\u00a0*\/\r\npublic\u00a0function\u00a0loadFile($filename)\r\n\r\n\/**\r\n\u00a0*\u00a0Zwraca\u00a0wszystkie\u00a0dane\u00a0w\u00a0formie\u00a0arraya\r\n\u00a0*\u00a0@return\u00a0array\r\n\u00a0*\u00a0@throws\u00a0PHPExcel_Exception\r\n\u00a0*\/\r\npublic\u00a0function\u00a0getAllData()\r\n\r\n\/**\r\n\u00a0*\u00a0Uruchamia\u00a0po\u00a0stronie\u00a0klienta\u00a0skrypt\u00a0pobieraj\u0105cy\u00a0plik\r\n\u00a0*\u00a0@throws\u00a0PHPExcel_Writer_Exception\r\n\u00a0*\/\r\npublic\u00a0function\u00a0downloadFile()\n<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Artyku\u0142 dotyczy klasy, kt\u00f3ra jeszcze nie zosta\u0142a zaimplementowana do systemu eDokumenty. Klasa ExcelEditor pozwala na pobieranie danych w formie arkusza kalkulacyjnego .xlsx, a tak\u017ce na wczytanie takiego pliku na serwer i przetworzenie danych. W celu u\u017cycia klasy nale\u017cy j\u0105 do\u0142\u0105czy\u0107 do skryptu oraz stworzy\u0107 obiekt typu ExcelEditor: Klasa pozwala na dost\u0119p do obiektu objPHPExcel, do [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":512,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"tags":[79,80],"_links":{"self":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/592"}],"collection":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/comments?post=592"}],"version-history":[{"count":7,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/592\/revisions"}],"predecessor-version":[{"id":599,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/592\/revisions\/599"}],"up":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/512"}],"wp:attachment":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/media?parent=592"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/tags?post=592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}