Tag Archives: openoffice

Alternative of PHP_Excel for Excel Reading and Writing

For Writing Excel

For Reading Excel

For Reading and Writing Excel

  • Ilia Alshanetsky’s Excel extension now on github (xls and xlsx, and requires business libXL segment)
  • spout OfficeOpenXML (xlsx) and CSV
  • The Open Office different option for COM (PUNO) (requires Open Office introduced on the server with Java support empowered)
  • PHP’s COM extension (requires a COM empowered spreadsheet program, for example, MS Excel or OpenOffice Calc running on the server)
  • SimpleExcel Claims to read and compose MS Excel XML/CSV/TSV/HTML/JSON/and so forth arranges

Another C++ Excel expansion for PHP, however you’ll have to manufacture it yourself, and the docs are really meager with regards to attempting to discover what usefulness (I can’t discover from the site what groups it bolsters, or whether it peruses or composes or both…. I’m speculating both) it offers is phpexcellib from SIMITGROUP.

All case to be quicker than PHPExcel from codeplex or from github, however (except for COM, PUNO Ilia’s wrapper around libXl and spout) they don’t offer both perusing and composing, or both xls and xlsx; might never again be upheld; and (while I haven’t tried Ilia’s expansion) just COM and PUNO offers the same level of control over the made exercise manual.

Source: http://stackoverflow.com/questions/3930975/alternative-for-php-excel

Pencil Project – An open-source GUI prototyping tool

Pencil Project, a free, open-source, cross-platform GUI prototyping tool, that people can easily install and use to create mock-ups in popular desktop platforms. Pencil is available as a standalone application and a Firefox extension. You can download it from here.

Pencil provides various built-in shapes collections by default, which includes flowchart elements, desktop/web UI elements, Android/iOS GUI shapes and general purpose shapes for drawing different types of user interface ranging from desktop to mobile platforms. There are also many other freely distributed collections on the internet provided by the community, which can easily installable to Pencil with simple drag-and-drop operation.

Pencil has pre-installed stencils for Android and iOS UI, which makes it even easier and faster to start prototyping apps with a simple installation. These stencils are included from version 2.0.2. Some of the stencil collections that you can try are collected in the download archive.

Drawing diagrams are as easy as UI design in pencil, because of its collection of flowchart shapes. Pencil also supports connectors used for “wire” shapes in the diagram.

Pencil provides a clipart browser tool integrated with OpenClipart.org to let users easily find cliparts and add them into the drawing by simply drag-and-drop. These cliparts are in vector format, which are easily scalable to appropriate sizes.

Pencil can export drawings into most of the popular formats including OpenOffice/LibreOffice, Image formats (JPG, GIF, PNG), text documents, Inkscape SVG, Adobe PDF and HTML page that can deliver to viewers.

For the web UI, Pencil provides links of an element to specific page in the same document. These links are converted to hyperlinks when the document is exported into HTML pages. This helps the user to understand the UI flow of an application mockups.

For more information about the pencil project, click here.
Firefox extension can be downloaded from here.