Login   Register  
PHP Classes
elePHPant
Icontem

Textarea 2 CSV: Convert a pasted Excel document to the CSV format

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2012-12-31 (1 year ago) RSS 2.0 feedNot enough user ratingsTotal: 538 All time: 5,075 This week: 1,470Up
Version License PHP version Categories  
textarea-2-csv 1.0GNU General Public Lice...5.0Text processing, Parsers
Description Author  

This class can Convert a pasted Excel document to the CSV format.

It can parse text of a Excel spreadsheet eventually pasted in a form textarea input and convert it in data in the CSV format.

The converted data may saved to a given file or displayed as the current script output.

The CSV field separator character is configurable.

Innovation Award  
PHP Programming Innovation award nominee
January 2013
Number 6
Some applications need that the users supply tabular data, eventually edited in a spreadsheet program like Excel.

The users could upload the spreadsheet file but it may be hard to process it, especially when it is necessary that the data of a specific range of cells.

This class provides an alternative approach for this problem that consists in letting the user copy data from the spreadsheet program and pasting it in a textarea form input.

Then the class is able to parse the input data and return it in a more convenient format for processing by the application.

Manuel Lemos
Picture of Gianluca Zanferrari
Name: Gianluca Zanferrari <contact>
Classes: 16 packages by
Country: The Netherlands The Netherlands
Age: 48
All time rank: 2749 in The Netherlands The Netherlands
Week rank: 65 Up3 in The Netherlands The Netherlands Up
Innovation award
Innovation award
Nominee: 4x

  Files folder image Files  
File Role Description
Plain text file class.textarea2csv.php Class class itself
Accessible without login Plain text file example.textarea2csv.php Example example of use

 Version Control Unique User Downloads Download Rankings  
 0%Total:538All time:5,075
 This week:0This week:1,470Up
 User Comments (1)  
 
sdsdsdsd sdsdsd sdsdsd
1 year ago (harry)
35%StarStar