# How to read json data converted from xlsx format

**URL:** <https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445>\
**Category:** General\
**Created:** [4 June 2022 05:54 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445 "2022-06-04T05:54:51Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [4 June 2022 05:54 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/1 "2022-06-04T05:54:51Z")

</div>

I am new to node red, have converted xlsx file into json format. Now i want to read this json data row wise with certain conditions. Also date is coming as 44548, want to convert it in dd/mm/yyyy format.  
Please help

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [4 June 2022 11:17 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/2 "2022-06-04T11:17:43Z")

</div>

Hi, I'm afraid that you might not get many responses as you've added this to a three-year-old thread. Moving to a new thread for you - can you please update the title to reflect your question? Thanks.

---

<div class="post-metadata">

**Author:** ![fmarzocca](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/fmarzocca/32/35901_2.png) [@fmarzocca](https://discourse.nodered.org/u/fmarzocca)\
**Post date:** [4 June 2022 13:57 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/3 "2022-06-04T13:57:22Z")

</div>

This is not a specific NodeRed question. It relates to javascript or nodejs programming.  
In addition, an example of the JSON could always help.

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [4 June 2022 15:51 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/4 "2022-06-04T15:51:40Z")

</div>

Thanks, I am new to this so again thanks

---

<div class="post-metadata">

**Author:** ![Paul-Reed](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/paul-reed/32/66906_2.png) [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Post date:** [4 June 2022 16:49 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/5 "2022-06-04T16:49:37Z")

</div>

Could you use a debug node, copy the output, and paste it here, so we can see exactly what data you are trying to work with.  
Before pasting it, click on the `</>` icon in the forum post window, and paste your data where indicated.

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [5 June 2022 01:23 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/6 "2022-06-05T01:23:30Z")

</div>

![20220605_065711](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/9/e958be9e8cd738931e2e9bacfc3dc7123cadf0fd.jpeg)

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [6 June 2022 03:31 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/7 "2022-06-06T03:31:33Z")

</div>

Need date conversion help too

Date is 44548  
1/1/1970 or 1/1/1900 is the reference point

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [6 June 2022 03:33 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/8 "2022-06-06T03:33:09Z")

</div>

Yes, need help in javascript/ node red

---

<div class="post-metadata">

**Author:** ![struland](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/struland/32/58587_2.png) [@struland](https://discourse.nodered.org/u/struland)\
**Post date:** [6 June 2022 04:43 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/9 "2022-06-06T04:43:45Z")

</div>

Seems like someone has already done the javascipt.  
Check out the code on Github:  
[excel-date-to-js](https://github.com/oleg-koval/excel-date-to-js/blob/master/index.js)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [6 June 2022 08:18 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/10 "2022-06-06T08:18:59Z")

</div>

Yes, there are several edge-cases so best to use a well tried library.

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [16 June 2022 06:00 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/11 "2022-06-16T06:00:11Z")

</div>

Not able to solve the problem of reading the xlsx file in alsql node in node red

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [16 June 2022 06:02 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/12 "2022-06-16T06:02:20Z")

</div>

Thanks, right now stuck at " reading the xlsx file thru alasql node in node-red"

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [21 June 2022 13:35 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/13 "2022-06-21T13:35:34Z")

</div>

Thanks for helping

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [21 June 2022 13:37 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/14 "2022-06-21T13:37:51Z")

</div>

Not able to use PATINDEX fn  
Err: alasql.fn.PATINDEX is not a function

---

<div class="post-metadata">

**Author:** ![Rachna](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Rachna](https://discourse.nodered.org/u/Rachna)\
**Post date:** [21 June 2022 13:38 UTC](https://discourse.nodered.org/t/how-to-read-json-data-converted-from-xlsx-format/63445/15 "2022-06-21T13:38:10Z")

</div>

Thanks a lot