avatarSeniru Abeywickrama

Free AI web copilot to create summaries, insights and extended knowledge, download it at here

3414

Abstract

on>SELF TOKEN 發行募資計畫 — 第二輪 Self.Games</figcaption></figure><p id="4295">總之,電影裡所描述的 SELF TOKEN 發行募資真的<a href="https://www.self.games/">存在過</a>,SELF TOKEN 也真的有在區塊鏈上發行,甚至已經在 <a href="https://www.bitasset.com/reg?icode=kvnl">BitAsset (BA) 交易所</a>上面可以進行交易,而且是一個「<b>真的能夠用,有應用場景的虛擬貨</b>幣」。</p><p id="ac25" type="7">真的,真的,真的,是真的!</p><p id="e5eb" type="7">因為很重要,所以要講三次。</p><h2 id="52b4">SELF TOKEN 真的可以用來兌換/購買電影票</h2> <figure id="117b"> <div> <div> <img class="ratio" src="http://placehold.it/16x9"> <iframe class="" src="https://cdn.embedly.com/widgets/media.html?type=text%2Fhtml&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;schema=facebook&amp;url=https%3A//www.facebook.com/selfpick/posts/2330138883914152%3F__xts__%255B0%255D%3D68.ARD1CLg4SS9D9YOzQEoEb-bNgUzehFBCXx4ap72sfH93uIctXK8HrkioEATFNLrcp8dir5s-VUCff5SGkFzuqQ7f6rksyOSdm_Dw_Q7XYT4nWeDb4QspF9jmhEPTYrwHcaUQTeKr7EZVcfYB-i7Mr8mopIFzOjFJ0UfisK0D_LcWYebqieypGZLYYZGZvI8HZQkev_-CgEWpYTjFeZF1EA_5huVtatBAc4hmNpcNfNuDp4xsN2EtHvfLuVvnDlsrAp38W_ZHsLc32Eri7Mhng3HnZCjyfZM_5v4yU6hykgfzuWgwIapw8eAlk8v46MTd0pwaWZJGHTolEyH6rZEQxemy%26__tn__%3D-R&amp;image=" allowfullscreen="" frameborder="0" height="600" width="600"> </div> </div> </figure></iframe></div></div></figure><h2 id="9eb0">SELF TOKEN 真的可以到全系列 SELF Bar / SELF Oasis 消費</h2> <figure id="057f"> <div> <div> <img class="ratio" src="http://placehold.it/16x9"> <iframe class="" src="https://cdn.embedly.com/widgets/media.html?type=text%2Fhtml&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;schema=facebook&amp;url=https%3A//www.facebook.com/selftoken/posts/2427526713991471%3F__xts__%255B0%255D%3D68.ARDn2hkZ1xWxKZaepwAaF_4Sb7SWB2m3K0B7YccNYuE4Yw3fsAWkLa_5LhaSxHdf_CKX-doi-vBV__edmZLUVPgRU6khETX-HBuuhAY9Mf5jajNvdF5lmdk5yqZr3MJv0k_sGrRMsMHY-X6P_u-Gw3qLcOQ5eMUn42weoM49U6gsA1ga6Rh93psKpQkDmxYMog-WpZoGsLhlbx7bt6XE9GeJ_Cc4mUhU2ozdnFOnSTV_ISihA1l-RwGwgwQ9JQ0drSz-q2v4KcQ2B5bHWrqmhr6hFQYrRapX0C4o1mIj0feIBm5vFfoSXLU7MTjPX9B2-A5bL5K-Z80Mwo6YK_4MBn7VJwSWxc5dJaJmyXc-R25wmdWXZA05lGGCtg0dMGWHs_ARqhIqWT1A-wrLjzxkpu4KlqFxQB9gGcZwIjfLXfJp9jRlqnI%26__tn__%3D-R&amp;image=" allowfullscreen="" frameborder="0" height="600" width="600"> </div> </div> </figure></iframe></div></div></figure><p id="1e97">而且,聽說10月底還會開通更多場所用 SELF 兌換消費產品,<b>敬請期待!</b></p> <figure id="9e64"> <div> <div> <img class="ratio" src="http://placehold.it/16x9"> <iframe class="" src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F-ZL8LDXYiys%3Fstart%3D4%26feature%3Doembed%26start%3D4&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-ZL8LDXYiys&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F-ZL8LDXYiys%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" allowfullscreen="" frameborder="0" height="480" width="854"> </div> </div> </figure></iframe></div></div></figure><h2 id="ba5d">不斷更新:</h2><p id="31be"><b>2019.10.20 </b> 最新公告總算出來了!榮登全球最美書店的日本代官山知名書店「蔦屋書店」台灣店「蔦屋書店 TSUTAYA BOOKSTORE」及附設餐廳 WIRED TOKYO 加入 SELF TOKEN 支付實驗,限時推出支付活動及優惠!</p> <figure id="7cec"> <div> <div> <img class="ratio" src="http://placehold.it/16x9">

Options

          <iframe class="" src="https://cdn.embedly.com/widgets/media.html?type=text%2Fhtml&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;schema=facebook&amp;url=https%3A//www.facebook.com/selftoken/posts/2459430160801126&amp;image=" allowfullscreen="" frameborder="0" height="600" width="600">
          </div>
        </div>
    </figure></iframe></div></div></figure><p id="d9bd">還沒看過電影的朋友,敬請不吝閱讀寶夫人撰寫的安全無劇透觀影感想:</p><div id="b65d" class="link-block">
      <a href="https://medium.com/threefourwife/%E5%B0%91%E5%A9%A6%E5%87%BA%E4%BB%BB%E5%8B%99-%E7%AC%AC%E4%B8%80%E6%AC%A1%E7%9C%8B%E5%85%88%E7%94%9F%E6%93%94%E7%B6%B1%E6%BC%94%E5%87%BA-%E7%9A%84%E9%9B%BB%E5%BD%B1%E7%89%B9%E6%98%A0%E5%B0%B1%E4%B8%8A%E6%89%8B-f61d61e0bf5e">
        <div>
          <div>
            <h2>【少婦出任務】第一次看先生擔綱演出!? 的電影特映就上手</h2>
            <div><h3>常常戲稱我家先生是藝人,這次竟然真的接了通告去拍電影,少婦突然升格為徐嘉凱導演新作《聖人大盜》 中「音樂公司執行長」之妻,有幸陪先生參與特映會,以下是少婦心得分享 😇</h3></div>
            <div><p>medium.com</p></div>
          </div>
          <div>
            <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/1*wYDZws2ipgsp7I5mWpT1NA.png)"></div>
          </div>
        </div>
      </a>
    </div><p id="77ee">我的個人閃光😎心得請看此:</p>
    <figure id="55fc">
        <div>
          <div>
            <img class="ratio" src="http://placehold.it/16x9">
            <iframe class="" src="https://cdn.embedly.com/widgets/media.html?type=text%2Fhtml&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;schema=facebook&amp;url=https%3A//www.facebook.com/dAAAb/posts/10214830832267408&amp;image=" allowfullscreen="" frameborder="0" height="600" width="600">
          </div>
        </div>
    </figure></iframe></div></div></figure><p id="808f">Medium 的受眾真的相對冷靜,希望你</p><p id="3c6e" type="7">拍手 50!</p><p id="2ae1" type="7">追蹤我,謝謝!</p><h1 id="4d3c">如果大家喜歡,追蹤!多拍手!我會盡量多寫!</h1><p id="398d"><b>寶博士臉書: <a href="https://facebook.com/dAAAb">https://facebook.com/dAAAb</a>

寶博朋友說: <a href="https://www.youtube.com/c/dAAAb">https://youtube.com/c/dAAAb</a> 寶博士 IG: <a href="https://instagr.am/dab.ko">https://instagr.am/dab.ko</a></b></p> <figure id="49d5"> <div> <div> <img class="ratio" src="http://placehold.it/16x9"> <iframe class="" src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fbutton.like.co%2Fin%2Fembed%2Fjuchunko%2Fbutton&amp;display_name=LikeCoin&amp;url=https%3A%2F%2Fbutton.like.co%2Fjuchunko&amp;image=https%3A%2F%2Fstorage.googleapis.com%2Flikecoin-foundation.appspot.com%2Flikecoin_store_user_juchunko_main%3FGoogleAccessId%3Dfirebase-adminsdk-eyzut%2540likecoin-foundation.iam.gserviceaccount.com%26Expires%3D2430432000%26Signature%3DQBI1ejD7c2jewxxNHebKq1e%252F%252FuC9UX0uzhcw9P7i8C1oOSpg2tBtIofyYRprVrnDwmJZI4PoCIFtLi4kbE4m89GheyOjFoVSMR22n%252FvKHtN8iz7zJ28E6lJ1YN4oLR5SSshctNxs1WVsRkMkhs2FGuPrSfuV72NoRw17TLvxh0chnM%252BTgfQpk5nlFuop5eE8paDTr9FiG4jFIiQ0NTNLIKHkuFf7PDvkGfS98WDCeX5ZbAGoytfC%252F6XHmfU1pbJn2kWLloLjJwZJgaz7aap7UoiOG%252FqyTbIQ%252BTBNJDVNdlkxKsqzcpFmCgzDsvJtkV0z8S3cAma3QsZmdthUdWG6aw%253D%253D&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=like" allowfullscreen="" frameborder="0" height="212" width="485"> </div> </div> </figure></iframe></div></div></figure></article></body>

Best way to read data in . XLSX file in NodeJS and convert to JSON format.

Through the internet, there are a lot of methods to read .xlsx files. But most, are work with local servers, and won’t work with online servers. Here is the best way that I’m dealing with. Here’s a brief explanation of what your code does:

  1. Convert Local .xlsx file to base64 format.
  2. Pass that base64 string to the backend.
  3. Decodes the Base64 string to a Buffer.
  4. Convert the Buffer to an XLSX workbook.
  5. Convert workbook to XLSX sheet.
  6. Sheet into a JSON object.
  1. Convert Local .xlsx file to base64 format.
// Check for the File API support.
if (window.File && window.FileReader && window.FileList && window.Blob) {
  document.getElementById('files').addEventListener('change', handleFileSelect, false);
} else {
  alert('The File APIs are not fully supported in this browser.');
}

function handleFileSelect(evt) {
  var f = evt.target.files[0]; // FileList object
  var reader = new FileReader();
  // Closure to capture the file information.
  reader.onload = (function(theFile) {
    return function(e) {
      var binaryData = e.target.result;
      //Converting Binary Data to base 64
      var base64String = window.btoa(binaryData);
      //showing file converted to base64
      document.getElementById('base64').value = base64String;
      alert('File converted to base64 successfuly!\nCheck in Textarea');
    };
  })(f);
  // Read in the image file as a data URL.
  reader.readAsBinaryString(f);
}

2. Parses the Base64 string from the JSON object.

Add the converted base64 string on here and pass it to the NodeJS backend.

3. Decodes the Base64 string to a Buffer.

This will return you the buffer format of this base64 object.

4. Convert the Buffer to an XLSX workbook.

Use that buffer object and convert it to XLSX workbook.

5. Convert workbook to XLSX sheet.

This extracting the name of the first sheet from an Excel workbook. Let me break it down:

  1. workbook: This variable presumably holds an instance of an Excel workbook. In the context of the previous examples, it would be created using the xlsx or exceljs library.
  2. workbook.SheetNames: This property provides an array of sheet names in the workbook.
  3. [0]: This index [0] is accessing the first element in the array, effectively retrieving the name of the first sheet.

6. Sheet into a JSON object.

“jsonData” will return the data that is read from raw by raw in a .xslx formatted file as a JSON object. Using that object you may have access to the data to store in DB.

Hope this will help you. As usual, please feel free to leave a comment with your thoughts! Until we meet again.

Recommended from ReadMedium