<turbo-stream action="append" target="posts_list"><template>    <div class="postbit" id="174169" data-post-id="174169">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="david234" src="/assets/icons/user-9f439610.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  david234
                    <span class="op-star" title="Thread Starter">
                      <img alt="OP" class="op-star-icon" src="/assets/thread-icons/thread-icon-thread-starter-df91e872.png" />
                    </span>
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<p>I tried with Codepagex lib</p>
<pre data-code-wrap="elixir"><code class="lang-elixir">  def import_shipments(conn, %{"shipment_params" =&gt; %{"import_file" =&gt; params} }) do

    params.path
      |&gt; File.stream!(read_ahead: 100_000)
      |&gt; MyParser.parse_stream([skip_headers: true])
      |&gt; Stream.map(fn n -&gt;
          case n do
            [name, barcode] -&gt;
                IO.inspect Codepagex.to_string(name, :iso_8859_1)
                IO.inspect Codepagex.to_string(barcode, :iso_8859_1)
            _ -&gt; IO.inspect "empty"
          end
        end)
      |&gt; Stream.run


    render(conn, "index.html")
  end
</code></pre>
<p>But still the same error.</p>
<p><code>    ** (NimbleCSV.ParseError) unexpected escape character " in &lt;&lt;80, 75, 3, 4, 20, 0, 8, 8, 8, 0, 34, 35, 166, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26, 0, 0, 0, 120, 108, 47, 95, 114, 101, 108, 115, 47, 119, 111, 114, 107, 98, 111, 111, 107, 46, 120, 109, ...&gt;&gt;</code></p>
<p>I think in this line itself it is throwing error</p>
<p><strong>[name, barcode]</strong></p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="174169" data-batch-url="/posts/batch_likers">
                        0
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/excel-sheet-xslx-import-to-postgres-db-in-elixir-phoenix/31276/12">Post #11</a>
	                </div>
	            </div>
              <div id="likers-container-174169" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="174169"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-standard-post cat-standard-post" title="Post #11"></div>
  </section>
</div>
    <div class="postbit" id="174170" data-post-id="174170">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="NobbZ" src="https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/NobbZ/120/27235_2.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  NobbZ
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<aside class="quote no-group quote-modified" data-username="david234" data-post="12" data-topic="31276">
<div class="title">
<div class="quote-controls"></div>
<img alt="" width="24" height="24" src="https://forum.elixirforum.com/letter_avatar_proxy/v4/letter/d/838e76/48.png" class="avatar"> david234:</div>
<blockquote>
<p><code>&lt;&lt;80, 75, 3, 4, …&gt;&gt;</code></p>
</blockquote>
</aside>
<p>Is <code>&lt;&lt;0x50, 0x4b, 0x03, 0x04, …&gt;&gt;</code>, which again is the “<a href="https://en.m.wikipedia.org/wiki/List_of_file_signatures" rel="nofollow">magic number</a>” for ZIP archives, which again is the envelop format for excel spreadsheets.</p>
<p><code>nimble_csv</code> can’t work with those, as <code>nimble_csv</code> is a CSV parser, not an Excel Spreadsheet parser.</p>
<p>Please use a library suited to Excel Spreadsheets or open your data in Excel and export it as CSV.</p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="174170" data-batch-url="/posts/batch_likers">
                        4
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/excel-sheet-xslx-import-to-postgres-db-in-elixir-phoenix/31276/13">Post #12</a>
	                </div>
	            </div>
              <div id="likers-container-174170" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="174170"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-standard-post cat-standard-post" title="Post #12"></div>
  </section>
</div>
    <div class="postbit" id="198589" data-post-id="198589">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="aungmyooo2k17" src="https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/aungmyooo2k17/120/19723_2.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  aungmyooo2k17
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<p>Use this for excel</p>
<pre data-code-wrap="elixir"><code class="lang-elixir">https://github.com/TheFirstAvenger/elixir-xlsx_parser
</code></pre> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="198589" data-batch-url="/posts/batch_likers">
                        1
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/excel-sheet-xslx-import-to-postgres-db-in-elixir-phoenix/31276/14">Post #13</a>
	                </div>
	            </div>
              <div id="likers-container-198589" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="198589"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-last-post cat-last-post" title="Last post!"></div>
  </section>
</div>
</template></turbo-stream><turbo-stream action="replace" target="load-more-container"><template><div id="load-more-container" class="load-more-container">
    <span class="all-loaded">— All posts loaded —</span>
</div></template></turbo-stream>