Lukket

ExcelJS: Parsing Worksheet row values for specific JSON

I have the following Excel Worksheet called `Calendar Config`:

[![excel screenshot][1]][1]

[1]: [login to view URL]

Desired JSON:

{

"name": "Standard",

"validFrom": "2021-01-01T00:00:00.000Z",

"validTo": "2021-12-31T00:00:00.000Z",

"useHolidays": true,

"workingDays": [

{

"dayIndex": 0,

"dayStart": "8:00",

"dayEnd": "20:00"

},

{

"dayIndex": 1,

"dayStart": "8:00",

"dayEnd": "20:00"

},

...

{

"dayIndex": 6,

"dayStart": "-",

"dayEnd": "-"

},

],

"uploadedBy": "foo"

}

My current implementation with TypeScript looks like this:

const workbook = new [login to view URL]();

await [login to view URL]([login to view URL]);

const worksheet = [login to view URL]('Calendar Config');

const sheet: any[] = [];

[login to view URL]((row) => {

[login to view URL]([login to view URL]);

});

I am having problems to parse `Rows` and `Values` and putting them into the correct order for the JSON object and would highly appreciate some help here! :-)

Evner: Excel, JavaScript, Typescript

Se mere: import data excel multiple excel files worksheet, passing row values gridview button, extract specific data from pdf to excel using vba, each row in a database table is called a ____, mysql sum row values, json api data into excel, how to sum row values in php, excel vba find first row with specific value, how to add values to json object in javascript, how to get values from json object in jsp, jquery to get table row values of selected checkboxes, excel find last row with specific value, sql sum row values, oracle sum row values, how to remove duplicates but keep rest of the row values in excel, how to display selected html table row values into input text using javascript ( with source code), how to display row values as columns in mysql, javascript sum table row values, jquery sum table row values, bash script to read values from json file

Om arbejdsgiveren:
( 0 bedømmelser ) Vienna, Austria

Projekt ID: #30470061

7 freelancere byder i gennemsnit €4/timen for dette job

(110 bedømmelser)
7.5
AccountantArman

"Sir, I am Excel Advance Level Expert. This is a basic work for me. I can complete this project with in your desired time with added Quality. ""I have completed similar projects with five stars from client"". About Flere

€2 EUR / time
(69 bedømmelser)
5.1
WebcoderSaurabh

Hi, I read the details about your project "ExcelJS: Parsing Worksheet row values for specific JSON".I can Design and Develop your Mobile app within the given time and develop it using the Technologies Mentioned. I Flere

€5 EUR / time
(7 bedømmelser)
4.1
nareshchahlia

I have 8 years of experience in data entry Specially in excel. My work is related to create excel sheet from multiple sheet to single sheet.

€5 EUR / time
(0 bedømmelser)
0.0
azleyanasywa

Hi, I am ready to start now. I read your project description and understand that you need. I will start work immediately once we discuss the work. Looking forward to hear from you. Thank you.

€4 EUR / time
(0 bedømmelser)
0.0
abhijeetvramgir

Hello, I have made the script using a excel sheet exactly like the sample excel sheet screenshot and output the JSON in the format you've specified. The script input is the following spreadsheet: [login to view URL] Flere

€3 EUR / time
(0 bedømmelser)
0.0
SohailAliMalik

Hello Sir/Ma'am, I can help in completing your task. I already have done something like this in Node.js Lets talk for more in DM.

€2 EUR / time
(0 bedømmelser)
0.0