Search DaniWeb - phpexcelreader

Re: importing data from Excel file (xls) 12 Years Ago by linuxaomi phpExcelReader.zip does the trick. I am using XAMPP under WINDOWS and LINUX as well. Good luck, linuxaomi Excel reading problem using PHP 14 Years Ago by balagod Hai, I want to read excel file and store the data into mysql. my excel file contains special symbols like ∫,Ω,√ ... (all physics formulas). I used phpexcelreader from pear.but this symbols are not reading correctly. it shows as rectangle box. please provide a solution for this to resolve. excel data into SQL with php-excelreader 14 Years Ago by lobstar … am using php-excelreader from: [url]http://sourceforge.net/projects/phpexcelreader/[/url] Here is what I have thus far: [code=php… Read spreadsheet (.xlm or .xls) into mysql database 14 Years Ago by futhonguy … using php. I did a search on google and found phpExcelReader. However i wasnt able to use that to do so… Compare and Update database from excel spreadsheet 14 Years Ago by futhonguy …. I did search on Google/Yahoo and found websites like PHPExcelReader or PHPExcel. My idea was to read from the spreadsheet… Fatal error: Class 'ZipArchive' not found 13 Years Ago by sam023 … want to read Excel-sheet.. for that i am using PHPExcelReader.. when i use it on localhost.. its work fine but… excel to mysql with special characters 11 Years Ago by vikaspa … code in http://phpexcel.codeplex.com/ http://sourceforge.net/projects/phpexcelreader/ MY issue is i cannot upload following (this is cut… Re: PHP class for manipulating xls ( MS Excel ) ? 16 Years Ago by iamthwee Try using [url]http://poi.apache.org/[/url] [url]http://sourceforge.net/projects/phpexcelreader/[/url] The best way would be to convert it to a csv file and then just parse through it. Re: need php script to upload excelsheet data into mysql 14 Years Ago by network18 … this excel sheet parsing Topic [url]http://sourceforge.net/projects/phpexcelreader/[/url] Re: How can i extract hyperlink URL from exel sheet 13 Years Ago by Martin B [URL="http://sourceforge.net/projects/phpexcelreader/files/Spreadsheet_Excel_Reader/"]PHP-ExcelReader[/URL] You would have got a faster response in a PHP forum. Re: import excel file into sql 11 Years Ago by jkon … that thing I am using Spreadsheet_Excel_Reader http://sourceforge.net/projects/phpexcelreader/files/Spreadsheet_Excel_Reader/2i/ The use is quite simple and I… Re: read an excel file 9 Years Ago by pixelsoul This might work for you http://phpexcelreader.sourceforge.net/ I've heard from someone else it works pretty good. You can also try this library http://phpexcel.codeplex.com/ to read and output to a CSV file and then parse that file. Re: Excel reading problem using PHP 14 Years Ago by chrishea I don`t know if this will work but you can give it a try [URL="http://code.google.com/p/php-excel-reader/"]http://code.google.com/p/php-excel-reader/[/URL] Re: Excel reading problem using PHP 14 Years Ago by balagod Hi, I tried with Entity symbols , it's working, for more details please refer this link. [url]http://tlt.its.psu.edu/suggestions/international/bylanguage/mathchart.html[/url] Re: excel data into SQL with php-excelreader 14 Years Ago by alex.tepes I gues you have to start indexing [B]$j[/B] from [B]0[/B] as the first column is 0, second 1, third 2, etc. or:[CODE] # if($j==1){ # $sku=trim($data->sheets[0]['cells'][$i][$j-1]); # } # if ($j==2){ # $desc=addslashes(trim($data->sheets[0]['cells'][$i][$j-1])); # } # if ($j==3){ # $list=addslashes(trim($data->sheets[0… Re: Read spreadsheet (.xlm or .xls) into mysql database 14 Years Ago by cwarn23 For making and reading excel files with php I have always used [URL="http://www.codeplex.com/PHPExcel"]PHPexcel[/URL] which is simple to use and effective. Enjoy. Re: Read spreadsheet (.xlm or .xls) into mysql database 14 Years Ago by futhonguy [QUOTE=cwarn23;1160316]For making and reading excel files with php I have always used [URL="http://www.codeplex.com/PHPExcel"]PHPexcel[/URL] which is simple to use and effective. Enjoy.[/QUOTE] Hi i tried using it, but it doesnt seem to work as one of the require_once cannot be found in the reader.php. ie: Warning: require_once(… Re: Fatal error: Class 'ZipArchive' not found 13 Years Ago by rajarajan2017 Try to Stop and restart the web server [URL="http://www.x-pose.org/blog/104"]http://www.x-pose.org/blog/104[/URL] Re: Fatal error: Class 'ZipArchive' not found 13 Years Ago by sam023 Yeah thats true.. but that can be possible in case of PHP 5.2 version not in PHP5.1 because it does not have zip support. Re: Fatal error: Class 'ZipArchive' not found 13 Years Ago by pssubash Hi, Just now i am facing the problem.On my understanding the followwing credentials needed on your server. [B]PHP Version : >5.2.0 Zip module:Enabled: Zlib Module :Enabled[/B] Re: excel data into SQL with php-excelreader 12 Years Ago by rrpandiarajan Deprecated: Assigning the return value of new by reference is deprecated in /.../Excel/Reader.php On line 261 What is this error .How to overcome this. Advance Thanks Re: excel data into SQL with php-excelreader 12 Years Ago by rrpandiarajan Take Out the "&" symbol for that line ......... and try it Re: excel to mysql with special characters 11 Years Ago by diafol ∴ is the html encoding for ∴ - I don't know if that helps? Re: excel to mysql with special characters 11 Years Ago by vikaspa Dear diafol Thanks. I have list of such encodes for different characters. I want to know whether i need to convert using encoding for special characters. is there a way to convert directly .... Re: excel to mysql with special characters 11 Years Ago by diafol I don't know, sorry. I went here: http://www.fileformat.info/info/unicode/char/2234/index.htm Re: excel to mysql with special characters 11 Years Ago by vikaspa Dear All Thanks I donot know how many such characters will be there also ther ei smass of data