php - Format text to fit in columns in Excel -


I have this block of text in an array: 

  "Stephen Olsson" Kangswa Žgen "Skolgaton" xxxx-xx-xx 0735xxxxxx, "PAR Davidson" "Skolgaton" "Mantovage" xxxx-xx-xx 0709xxxxxx,   
 I parsed this kind of a CSV -File content, for use in Excel later, however, I want to fit this text with excellence in different columns. So, when I open CSV-file in Excel, I A column should be named, except the address in the column etc. How can I achieve this? Should I use PHPExcel? Or can this be done with plain old PHP?  
 This is my PHP-code  
  $ gatunamn = $ _POST ['gata']; $ Ort = $ _POST ['Omrade']; $ Csv_data = array (); $ newSpider- & gt; ; Fetch page ($ gatunamn, $ ort, offset = 0); $ Obj = json_decode ($ newSpider-> html); echo "& lt; Div id = 'rightcontent' & gt; & Lt; The table id = 'one-column-emphasis' & gt; "; encoded ;  the address    input type = 'Checkbox' name = 'csv_all' id = 'csv_all' & gt; & lt; / th> gt; Ad & gt; Adress2 & lt; / th & gt; & lt; th & gt; Adress3 & lt; / Th >> gt; & lt; th & gt; Personnummer & lt; / th & gt; & lt; th & gt; Telefonnummer & lt; / th & gt; & lt; th & gt; Telefonnummer2 & lt; / th & gt; "; $ Antal_sidor = round ($ obj-> search-> gtc- gt; total hits / $ obj-> search-> wp- & gt; pages); Echo "& lt; td> & lt; / td & gt;"; Foreign exchange ($ obj-> search-> WP-> FEATURES $ FISH AS) // HOPAR UT 50ST (POSESIZE) {echo "<"> <;; Echo "& lt; td & gt; & lt; input type = 'checkbox' value = 'csv' class = 'csv' & gt; & lt; / td & gt;"; Echo "& lt; td & gt;" . $ Fish- & gt; Name "& lt; / td & gt;"; $ Csv_data [] = Utf8_decode ($ fish- & gt; name); Foreign exchange ($ fish-> addresses as $ advertisement) {echo "" . $ Advertising-> Label "" $ ad- & gt; Pincode "" $ ad- & gt; Area "& lt; / td & gt;"; $ Csv_data [] = utf8_decode ($ ad-> label. "". $ ad-> Pincode. "". $ ad- & gt; area); } If (empty ($ fish- & gt; date offbrand)) {$ convert_date = substr ($ fish-> dateoffbirth, 0, -3); // Geor om Datam franaden a timestamp echo " . Date ("Y-M-D", $ Convert_date) "& lt; / td & gt;"; $ Convert_data = Date ("Y-M-D", $ Convert_date); $ Csv_data [] $$ Convert_data; } If (empty! (Fish- & gt; phone number)) {foreach ($ fish-> as phone $ $ ph) {echo " . $ PH "& lt; / td & gt;"; $ Csv_data [] = $ Ph ""; }} Echo "& lt; / tr & gt;"; } Resonates "& lt; / table & gt;"; $ J = 0; ($ I = 1; $ i & lt; = $ antal_sidor; $ i ++) {echo " ";} if (isset ($ _ POST ['export'])) {$ fp = fopen (" eniroo.csv "," w "); Forward (explosion (", ", implode (" $ Ref ($ csv_data)) as $ rad] {fputcsv ($ fp, array (implode (',', str_getcsv ($ rad, "\ n"))));} echo "& lt; Div id = 'csv_info' & gt; "echo" & lt; A href = 'eniro.csv' & gt; Hmata CSV-file & lt; / A & gt; "; echo" & lt; / Div> ";}    
 
 
  // lines in the original array Rebuild $ myDataArray = array_chunk ($ MyDataArray, 5); // then write CSV $ FP = FOPN ('file.csv', 'w'); Forex Currency ($ myDataArray $ as Data Rau) {fputcsv ( $ fh, $ dataRow);} Fclose ($ fh)

Comments

Post a Comment

Popular posts from this blog

Java - Error: no suitable method found for add(int, java.lang.String) -

I'm in the middle of homework work and I'm stuck. At this point in my code, I think that I should have a GUI window that opens and allows me to type "inserted text number". Notice is not going anywhere but at this point, If I pass through the problem then it will be in a linked list. I am getting two of the same error for the lines. Add (index, element); And I can not seem to get past it, there is no suitable method for the error "add (int, java. string string)". Code is below, please advise. To clarify - this will not be a method error because it is a linked list. There should not be any way involved. import java.awt. *; Import java.awt.event. *; Import javax.swing. *; Import java.util. *; Import java.util.Scanner; Import java.util.LinkedList; Public class TopTenList JFrame {Private TopTenList tt; See the Private JTextArea list; Private JTextField cmdTextField; Private JTextField resultsTestfield; // This GUI window is the code for the public toptist...
Read more

java - JPA TypedQuery: Parameter value element did not match expected type -

I am using JPA 2.0 and getting the following code in the DAO layer: Public Zero Test () {string key = "status"; String [] Conditions = {"A", "B"}; & Lt; TestTable & gt; Results = Search (Keys, Conditions); } Public listing & lt; TestTable & gt; Search (string key, object value error) {string sql = "test ndf to testlet and jade nand." + Key + "in:" + key; TypedQuery & LT; TestTable & gt; Query = entityManager.createQuery (SQL, TestTable.class); Query.setParameter (key, Arrays.asList (valueArr)) / *** Error Line *** Return query.getResultList (); } In the above error line, it throws the following exception: java.lang.IllegalArgumentException: parameter value element [[Ljava.lang.String; @ cbe5bc] did not match the expected type [java.lang.String] Why is this expected type string while actually this string []? Please help! Note: This is derived from the normal routine and is a simplified code. I can no...
Read more

c++ - static template member variable has internal linkage but is not defined -

Yes, I know, there is a question with almost the same title, but it refers to a different situation. Error message) In my case, I have a .cpp file with a big named designation name (implementation details). There is a property class template with a static data member in that name space, which I need to access from outside the unknown namespace. I give it a little bit of meat: file.hpp namespace Bar {template & lt; Typename A & gt; Struct foo {static_assert (is_same & lt; a, float & gt; :: value} is_same & lt; a, double>: value, ""); Fixed zero set_static_var (a const & x); // ...}; } and file.cpp namespace {template & lt; Typename A & gt; Struct foo_traits {// supports the implementation of several static code bars: foo & lt; & Gt; Fixed A data; }; The template's & lt; & Gt; Float foo_traits & lt; Float & gt; :: datum; // No change if this is in the global namespace template & lt; & Gt; Doub...
Read more