background preloader

PHPExcel - Home

PHPExcel - Home
Project providing a set of classes for the PHP programming language, which allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP.Checkout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more! Want to bookmark this page? Please use as the URL. Want to contribute? Please remember that we have been using github as our source repository for over two years now.... source code has not been maintained here on Codeplex in all that time.

Related:  ExcelWeb Development

Dynamic Data Source 1. Excel Pivot Table Introduction Getting Started with Pivot Tables Use a Dynamic Data Source 2. Create a Pivot Table in Excel 2007 3. Pivot Table Tutorial List Getting Started with Pivot Tables The first step in creating a Pivot Table is to organize your data in a list of rows and columns. File: SASS_REFERENCE — Sass Documentation Sass is an extension of CSS that adds power and elegance to the basic language. It allows you to use variables, nested rules, mixins, inline imports, and more, all with a fully CSS-compatible syntax. Sass helps keep large stylesheets well-organized, and get small stylesheets up and running quickly, particularly with the help of the Compass style library. PHPLinq - LINQ for PHP - Language Integrated Query Examples can be found in the test package in the latest release. A basic example Let's say we have an array of strings and want to select only the strings whose length is < 5.

AJAX Helper with jQuery (for CakePHP 2.x) Hi! On my site you can find AJAX Helper with jQuery for new version of CakePHP (2.x). All functions that were introduced in last version are supported and compatibile with CakePHP 2.0. Actual function list: link - Returns a link to a remote action that's called in the background using XMLHttpRequest when the link is clicked. The result of that request can then be inserted into a DOM object remoteFunction - This function creates the JavaScript needed to make a remote call.

Comprehensive Guide to VLOOKUP & Other Lookup Formulas Posted on March 30th, 2012 in Learn Excel - 25 comments This week many Excel bloggers are celebrating VLOOKUP week. So I wanted to chip in and give you a comprehensive guide to VLOOKUP & Other lookup formulas. Read on …, Getting Started with Zend Framework 2 — Zend Framework 2 2.0.7 documentation This tutorial is intended to give an introduction to using Zend Framework 2 by creating a simple database driven application using the Model-View-Controller paradigm. By the end you will have a working ZF2 application and you can then poke around the code to find out more about how it all works and fits together. Some assumptions This tutorial assumes that you are running PHP 5.3.3 with the Apache web server and MySQL, accessible via the PDO extension. Your Apache installation must have the mod_rewrite extension installed and configured.

30 Useful PHP Classes and Components « PHP Simplicity and extensibility are the main reasons why PHP became the favourite dynamic language of the Web. In the last decade, PHP has developed from a niche language for adding dynamic functionality to small websites to a powerful tool making strong inroads into large-scale Web systems. Below I present 30 useful PHP classes and components that you can use to test, develop, debug and deploy your PHP applications. Let me know if I missed anything or if you have something to add. Free Excel Templates and Spreadsheets Looking for free Microsoft Excel ® templates? This page lists all the popular spreadsheet templates and calculators created by, along with other places where you can find free Excel templates and spreadsheets. If you are looking for solutions for your business, see the Business Templates page.

The 30 CSS Selectors you Must Memorize So you learned the base id, class, and descendant selectors—and then called it a day? If so, you're missing out on an enormous level of flexibility. While many of the selectors mentioned in this article are part of the CSS3 spec, and are, consequently, only available in modern browsers, you owe it to yourself to commit these to memory. Framework: Documentation The YouTube Data API offers read and write access to YouTube's content. Users can perform unauthenticated requests to Google Data feeds to retrieve feeds of popular videos, comments, public information about YouTube user profiles, user playlists, favorites, subscriptions and so on. For more information on the YouTube Data API, please refer to the official » PHP Developer's Guide on

Discussing PHP Frameworks: What, When, Why and Which? Jul 26 2009 What is a PHP Framework? PHP is the world’s most popular scripting language for many different reasons – flexibility, ease-of-use, among others – but often times coding in PHP, or any language for that matter, can get rather monotonous and repetitive.

Advanced Excel Skills - What are they & How to become Advanced Excel user? Now a days, many jobs require advanced Excel skills. Naturally, you are interested to know what are these Advanced Excel Skills?Based on my experience of training more than 3,000 students in various online & physical training programs, the following 9 areas form the core of advanced Excel skills. Advanced Formulas Writing Efficient JavaScript: Chapter 7 - Even Faster Websites Today’s web applications are powered by a large amount of JavaScript code. Whereas early web sites used JavaScript to perform simple tasks, the language is now used to run the entire user interface in many places. The result can be thousands of lines of JavaScript code to execute every time a user interaction takes place.

How to Create Dynamic Excel Filter (Extract data as you Type) Data Filter is one of the most used excel functionality. In this blog post, I will show you how to create a Dynamic Excel Filter, such that it filters data as you type in a search box. Something as shown below: There is a dual functionality to this – you can select a country’s name from the drop down, or you can type in the search box and it will show you all the matching records (For example, when you type “I” it gives you all the country names with the alphabet I in it). Download Example File and Follow Along | Watch Video This Dynamic Excel filter can be created in 3 steps:

Related:  Programmation