Post pobrano z: PHP Libraries For Working With Excel, Word And Powerpoint Files

Advertise here with BSA

As web designers/developers, MS Office files are pretty far from our daily lives. We usually don't need to create one and, if needed, there are web apps for that.

However, for web apps that host lots of information, enabling users to import/export the data is a huge time-saver and Excel (XLS, CVS) files are the most popular format for that job.

For standard content, we can always export it as a HTML file but, depending on the audience, providing Word files can be a better option.

If you are a PHP developer, working with MS Office files (Excel, Word and Powerpoint in our case) is so easy with the help of mature libraries out there.

Here are alternatives (both simple and complicated) where you may choose the one that fits the best to your project.

PHPExcel

A full-featured PHP library for handling and creating Excel files which can read from many different spreadsheet file formats like Excel (.xls), Excel 2007 (OfficeOpenXML -.xlsx), CSV, Libre/OpenOffice Calc .ods, PDF, HTML, etc.

It has support for setting any meta data of spreadsheets (author, title..), adding worksheets/rows/columns, merging cells, manipulating formulas, formatting and much more.

You may also want to read more about its features here.

SimpleExcel PHP

This PHP library is simple-yet-powerful and supports both writing + parsing files with Microsoft Excel XML/CSV format.

It accepts getting all the cells in a row or only a single cell (the same goes for the column).

PHP-Excel

A simple library for only generating Excel files.

It takes a 2-dimensional array and converts the data with a single function.

PHP Export Data

The library is based on the PHP-Excel mentioned above and can export data to Excel-friendly XML, CSV, or TSV.

There is support for streaming the data to a file or as a download.

Excel Writer (XML) for PHP

A set of PHP classes for dynamically generating Excel XML files.

Besides the initial Excel document, it can create sheets and style the output.

PHP Excel Reader

This PHP library is only for parsing and retrieving data from XLS files.

It allows targeting any specific cells, counting number of rows and format the output (alignment, colors, borders, etc.).

PHPWord

A powerful PHP library for creating Word files. Actually, .docx files (Office Open XML) which can be opened by many office programs.

Using the library, we can insert text, text breaks, page breaks, headers/footers, tables, list elements, hyperlinks and format all of them.

 

PHPPowerpoint

A PHP library that makes it possible to create a presentation, add slides to it (including test and images), format them and more.

The presentation can be exported as a PowerPoint 2007 (presentationML) or PHPPowerPoint Serialized Spreadsheet file.

Advertisements:
Infragistics jQuery controls deliver the magic of HTML5, w/o sacrificing resources, time, or money.
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Post pobrano z: Create QR Codes Online (Generators, JavaScript Plugins & Code Libraries)

Advertise here with BSA

QR Codes, a tracking code technology which was created in 1994 by Denso<Toyota to keep track of vehicles, is now a standard being used everywhere from websites to magazines, apps or stores.

In the web, considering the mobile devices are used as the barcode reader, QR Codes are usually used as an alternative way to show app download/purchase links, wi-fi passes, mobile version URLs of websites, etc.

I needed to create few of them in the past, used online QR Code generators and I was done in a few minutes.

Recently, a project required hundreds of them being generated automatically and I have played with many different JavaScript + server-side solutions. I have faced solutions that are -sometimes- not working correctly, not supporting too short or long texts or they were not simple enough. Here is the list of solid and good-quality QR Code generation resources that all work very straightforward:

P.S. I ended up using a JavaScript library which is so easy to implement, flexible in all levels, and, I knew that it would always be used by a modern browser. You can choose the solution that  fits the best to your case from the list below.

Online QR Code Generators

---

QRhacker

QRhacker is a beautifully implemented online QR code generator with many options for creating the QR code we want.

It allows many different input types (text, URL, phone number, VCard and Wi-Fi access) and offers customizations like the roundness of the blocks, their foreground/background colors, using images for them and more. Also, the code can be painted pixel-by-pixel.

Once the QR code is created, it can be downloaded either as an image or PDF.

Unitag

QR codes have a built-in error-correction mechanism and codes that are slightly morphed can still be recognized correctly.

Unitag makes use of this and allows users to transform QR codes by curving the blocks, adding extra shaped and more.

QrCodeGener

The website has a very clean interface and has a set of pre-defined QR code types.

QR codes can be downloaded in any size (including print quality ones) and an optional embed feature exists.

Beqrious Generator

This QR code generator accepts almost anything as the input (from text to images or Youtube videos to Facebook profiles).

There is an option to change the color of the QR blocks and the output can be saved in JPG, GIF, PNG + PDF format.

QR Stuff

QR Stuff differentiates itself from other QR generators with the ready-to-use templates for various services like the ability to create Skype call, FourSquare, Google Maps, etc. links.

QRcore

A simple QR code generation tool with no distractions. Just mention the text, choose the size and get it.

There is also an option to have an embed link.

goQR.me

goQR is a good solution for anyone looking to create QR code with no complicated stuff.

It has a plain interface and offers an embed feature which is handy.

lil'qr

lil'qr is a way simpler alternative compared to any others in the list as it only accepts text as the input and offers no customizations.

But, it has a unique feature: it auto-displays the QR code of the current URL by inserting a simple <img> tag to web pages.

 

QR Code JavaScript Plugins

---

JSQR

This is a standalone QR Codes JavaScript library that can generate the codes from vCards, vCalendar Events, geo coordinates and more.

There are methods for defining the error correction level, dimensions and colors.

jquery.qrcode

A jQuery plugin for creating QR codes on-the-fly, totally on the browser-side.

It is based on the QR Code Generator library mentioned below but wraps it as a plugin.

QR Code Generator

This is one of the most popular solutions around. It has versions in JavaScript, Java, PHP and AS3.

jQuery uQR plugin

uQR is a very flexible plugin that has settings for generating the QR Codes of e-mails, geolocations, addresses, phone numbers, etc.

QR Code Class

A JavaScript solution for making QR Codes using Google Charts API.

There are again options to define almost anything as the input.

Google Charts API

Although this is a hosted JavaScript library that creates QR Codes with requests to the Google servers, it is still a very good

 

QR Code Server-Side Libraries

---

PHP QR Code

An open source PHP library for generating QR Codes with PHP without any dependencies (except GD2).

PHP QR Code Class

This PHP class uses only the native methods, no modules required, and, it accepts text + images as the input.

QRForAll (PHP)

A simple and very easy-to-use class that is built with PHP5 and requires GD2.

PHP QR Code Generator Class

The PHP class creates QR codes in PNG and has options to allow many different inputs.

rqrcode-rails3 (Rails)

A Ruby gem for Rails to render QR Codes which support both SVG and PNG outputs.

It can also set a desired "error correction level".

rQRCode (Ruby)

rQRCode encodes QR Codes with Rails.

pyqrcode (Python)

A python extension for encoding and decoding QR Codes.

It has support for defining the dimensions and the QR Code type.

QrCode.Net (.NET)

An open source .Net library for encoding and decoding QR Codes.

It can render artistic QR Codes as well.

QRCode Library (.NET)

A .NET QR Code component to encode/decode these codes.

The generated codes can be saved in JPEG, GIF, PNG or Bitmap formats.

Advertisements:
Infragistics jQuery controls deliver the magic of HTML5, w/o sacrificing resources, time, or money.
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Post pobrano z: jqmPhp – HTML Code Generator For jQuery Mobile

Advertise here with BSA

jqmPhp is an open source project that aims to simplify using jQuery Mobile with PHP.

It is a pack of PHP classes that can generate the HTML outputs which jQuery Mobile is expecting within few lines.

The classes are on separate files (with names parallel to the JQM's features) so you can choose to only use the necessary ones.

It covers almost all the features of the framework, it is very well-documented and supported with examples.

Advertisements:
Infragistics jQuery controls deliver the magic of HTML5, w/o sacrificing resources, time, or money.
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
SSLmatic – Cheap SSL Certificates (from $19.99/year)