mysql - CodeIgniter PHPExcel export to excel for 16 digit varchar data type error -


i trying export table mysql excel in codeigniter using phpexcel. column varchar datatype [16 digits], result in excel become a,be+15. example 3374142005140004 in mysql, in excel export became 3,37414e+15 or 3374142005140000, lost last digit value 4. best file type export opendocumentspreadsheet (.ods) [tried manually xampp export file]. phpexcel doesn't have oocalc writer yet. , don't know how integrate phpmyadmin export in codeigniter app. so, if have solution problem, please please share solution. in advance help/suggestion.

if string value longer php integer, you'll need save string using setcellvalueexplicit() instead of setcellvalue()

phpexcel allow write openofficexml files using opendocument writer


-

Comments

Post a Comment

Popular posts from this blog

renaming files in a directory using python or R -

i went across similar questions of renaming files in directory using python. i have these files in directory want rename: -statistical_analysis_with_r -statistical_pattern_recognition_3rd_edition -statistical analysis r -statistical pattern recognition 3rd edition for wrote script in windows: def naming(so): import re w=re.split('[ _]+',so) r=[] in w: r.append(i.capitalize()) print(' '.join(r)) import os c in os.listdir(os.getcwd()): if c.endswith(".pdf"): os.rename(c,naming(c)) print(os.listdir(os.getcwd())) but getting error: statistical analysis r.pdf traceback (most recent call last): file "<ipython-input-79-d7f645d6d3e5>", line 4, in <module> os.rename(c,naming(c)) typeerror: rename: can't specify none path argument can what's going on? and doing same thing using r (www.r-project.org)? loads of in advance. your naming functio...
Read more

c# - ajax - How to receive data both html and json from server? -

i have referenced this topic , doesn't solve problem. i'm using mvc 5 c#. have used code receive data server data type json . $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "json", success: function (data) { if (data.result) { alert('successfull'); } else { alert(data.ex); } } }); and controller code: [httppost] public actionresult myaction() { try { return json(new { result = "true", ex = "" }); } catch (exception e) { return json(new { result = "false", ex = e.message }); } } i use way data type html: $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "html", success: function (data) { $(".mydiv").append(data); } }); and controller should be: [httppost] public actionresult myaction() { return partialview("_...
Read more