Excel file that has to be converted in to a Name/Value JSON format.

I have an Excel file that has to be converted in to a Name/Value JSON format. Each column has Name in the first row and the Value in the following rows. There are 9 columns and 250 rows. In the last column I have the output that I need in the JSON format. However; I also want the code or formula that you use to create the output. All work must be either totally in the Excel spreadsheet using VBA script or you can create it in C# or VB.Net. This is my output:

[{"name":"FirstName","value":"Andrea"},{"name":"Middlename","value":"M."},{"name":"LastName","value":"Abbott"},{"name":"emailaddress","value":"abbottan@[url removed, login to view]"},{"name":"eRACommons","value":"AMABBOTT"},{"name":"positionTitle","value":"Assistant Professor"},{"name":"MyNCBILink","value":""},{"name":" uniqueid","value":"900949149"},{"name":"ReferenceID","value":""}]

Taidot: tietojenkäsittely, Excel, VB.NET, Visual Basic, Visual Basic for Apps

Näytä lisää: csv to json c#, xlsx to json online, excel to json javascript, convert excel file to json online, excel to json python, convert excel to json in java, data file converter, csv to json converter download, how to get the client name of an web services in vb net, return record xml format sql server vb net, format phone number vb net, format date datagrid vb net, changing format excel file perl script, visual studio extract sheet name excel file, excel file changes format word

Tietoa työnantajasta:
( 111 arvostelua ) Charleston, United States

Projektin tunnus: #16301754

Myönnetty käyttäjälle:


Hi - This is pretty straight forward stuff. Given the assignment i can turn it around in couple of hours. Let me know. I have 2 decades work experience and am also a patent holder.

$22 USD 1 päivässä
(2 Arvostelua)

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


hi i am python expert and have rich experience in excel file processing i can do your task well by using python and i will work for you as long term thanks & regards

$25 USD 1 päivässä
(2 arvostelua)

I will give you a formula that will do what you need. This will be an efficient and easy way to do it again by yourself in the future. Please contact me if you need it and I can do it for you within minutes. Rega Lisää

$15 USD 1 päivässä
(4 arvostelua)

HI, I can create the JSON from excel file. We will use PHP for this. Let me know when we can discuss start working. Looking forward for your response. Thanks.

$35 USD 1 päivässä
(0 arvostelua)

Hi, I hope you are doing well ! We have 4.8+ Years of experience as a VBA Developer & Tester. We specialized in online directory scraping, email scraping, Data cleaning, data harvesting and web scraping service Lisää

$10 USD 0 päivässä
(0 arvostelua)
$25 USD 10 päivässä
(0 arvostelua)
$25 USD 1 päivässä
(0 arvostelua)
$25 USD 1 päivässä
(0 arvostelua)

I can complete your project on time and within your budget and I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.

$20 USD 1 päivässä
(0 arvostelua)