Tag: Projects
All the articles with the tag "Projects".
-
OpenXML in Healthcare in PHP
Here's a cool present just before the weekend... 2 days ago, Wouter posted on his blog about an article he co-operated on for MSDN: OpenXML in Healthcare. Being both a Microsoft and PHP fan (yes, you can curse me, I don't care), I thought of porting (part of) the sample code from his article into PHP. Except for the document signing, as I did not have many time to write this sample code... The scenario for the article is quite simple: Contoso provides a central medical records database. Whenever a physician has to register a new patient, he downloads a Word 2007 document from the Contoso server, fills it out, and uploads it back. Contoso then strips out the necessary data and saves it back in their systems.
-
PackageExplorer, not only great for OpenXML...
-
PHPExcel 1.3.5 released
Just a quick note on the new PHPExcel 1.3.5 release. There are some cool new features included! One of the new features is rich text: one can now write coloured and styled text in a cell. Here's an example of how the feature demo result file looks: This is of course not all. Jakub had a couple of sleepless nights, but managed to port in the PEAR Spreadsheet classes. Meaningless? No! PHPExcel now supports Excel2007 and older versions, too. Want to write an Excel document for Excel200? No problem: [code:c#] $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);$objWriter->save('excel2000file.xls'); [/code] There's even a cooler part related to this, and that is .xlsx to .xls conversion! Here's how: [code:c#]
-
ASP.NET URL rewrites using .htaccess-like syntax
Having a PHP background, I've been using .htaccess mod_rewrite in Apache for ages. ASP.NET allows rewriting too, but using a different syntax than mod_rewrite. Using the attached library, you can now use mod_rewrite syntax to perform rewrites on your ASP.NET application. Here's how... First of all, you need to download the attached library. Reference it from your web project, and register it as a module in Web.config, preferrably as the first one: [code:xml] <httpModules> <add name="UrlRewriter" type="MaartenBalliauw.UrlRewriter.Rewriter"/> <!-- Other modules can be put here... --> </httpModules> [/code] Second, create a file UrlRewriter.xml in the root of your web project, and add rewrite conditions in there: [code:xml]
-
Commandline FTP folder download
A quick annoyed post... I just spent two hours searching the Internet for a means on how to recursively download a complete FTP folder, command-line, and in a simple way. Oh yeah, and preferably freeware. The solutions I found were not what I expected: a $50 software product providing a GUI (I said command-line! [:@]), a bloated scheduler thingy that does download in the background (I said simple! [8o|]), to batch-files relying on Windows built-in ftp.exe and a gigantic list of all files that need to be downloaded.
-
New PHPExcel release: 1.3.0
The new version of PHPExcel has just been released, bringing 1.3.0 to the public. New features include formula calculation, inserting and removing columns/rows, auto-sizing columns, freezing panes, ... One of the new features in PHPExcel is formula calculation. Just like Excel or any other spreadsheet application, PHPExcel now provides support for calculating certain cell values, using a formula. For example, the formula "=SUM(A1:A10)" evaluates to the sum of values in A1, A2, ..., A10. Have a look at this: if you write the following line of code in the invoice demo included with PHPExcel, it evaluates to the value "64": Another nice feature of PHPExcel's formula parser, is that it can automatically adjust a formula when inserting/removing rows/columns. Here's an example:
-
PHPExcel 1.0.0 final
I'm quite proud to announce the 1.0.0 version of PHPExcel, a set of classes that allows you to wirte Excel2007 files from PHP. Since my last post on this, a lot of things happened, feature-wise and project-wise. Feature-wise, conditional formatting was added, and a first attempt to a Excel2007 file reader has been created. Project-wise, Jakub Vrana signed up as a developer. He's currently working on an improved version of the Excel2007 Reader. We are still looking for extra developers: if you know PHP 5, object-oriented programming, have knowledge of/interest in OpenXML or the Open Document Format (as we plan to include that too), please apply.
-
PHP Excel classes on CodePlex
Just for the record: my PHP Excel classes have been released on CodePlex under a GPL license, and will be further released over there. The full URL: www.codeplex.com/PHPExcel.
-
Office 2007 SpreadsheetML classes in PHP
In my evening hours, I've been working on a set of PHP classes to create Offixe 2007 SpreasheetML documents (.xlsx files). I finished my first goals (some basic XLSX writing), and I want to share this set of classes to the community. Currently, the following features are supported: Each cell supports the following data formats: string, number, formula, boolean. Visual formatting is not implemented, but I'll get to that later. An example of what can be achieved, can be found in this example XLSX file. A download of my class set can be found here. Class documentation is included.Please note that I am releasing this under GPL license.
-
Simple SAX parser for PHP
Yesterday, I was working on PRAjax. The UpdatePanel did not work completely as I wanted it to work: in the background, the whole page was still fetched and updated. A cleaner way would be to just fetch updated content and not the whole page. In my search for a PHP HTML parsing class, I found a lot of libraries, but all with disadvantages: one was too big in file size, another only parsed XHTML, ... Luckily, I stumbled on SAX parser! So if you ever want to parse HTML and read out specific tags and attributes, try this one.