EXCEL VBA Script
- or -
Post a project like this3317
£25(approx. $31)
- Posted:
- Proposals: 2
- Remote
- #693116
- Completed
Description
Experience Level: Intermediate
General information for the business: Data Processing
Description of requirements/functionality: Please attachments for detailed description and sample test file.
To read data from an Excel Spread sheet and write out JSON formatted data objects
NOTE: WE ARE NOT LOOKING FOR ANY OLD UTILITY DOWNLOADED FROM THE INTERNET. THE JSON FORMATTED DATA OBJECTS NEED TO BE CREATED TO A SPECIFIC SCHEMA.
GENERAL REQUIREMENT
Specifically, the script must:
1. loop through all the rows in a spread sheet. A sample spread sheet is attached
2. for each row a JSON data object must be created as specified below. See Excel Column to JSON Field Map
3. write the JSON data object to a file;
a. all data objects created must be written to a single text file
b. each object must start on a new line; See Example Output
c. data objects should not contain any new line characters; See Example Output
d. if a column has no data then a blank entry “” must be written
4. create an output file that is the name of the spreadsheet with a .json extension
Extra notes:
Description of requirements/functionality: Please attachments for detailed description and sample test file.
To read data from an Excel Spread sheet and write out JSON formatted data objects
NOTE: WE ARE NOT LOOKING FOR ANY OLD UTILITY DOWNLOADED FROM THE INTERNET. THE JSON FORMATTED DATA OBJECTS NEED TO BE CREATED TO A SPECIFIC SCHEMA.
GENERAL REQUIREMENT
Specifically, the script must:
1. loop through all the rows in a spread sheet. A sample spread sheet is attached
2. for each row a JSON data object must be created as specified below. See Excel Column to JSON Field Map
3. write the JSON data object to a file;
a. all data objects created must be written to a single text file
b. each object must start on a new line; See Example Output
c. data objects should not contain any new line characters; See Example Output
d. if a column has no data then a blank entry “” must be written
4. create an output file that is the name of the spreadsheet with a .json extension
Extra notes:
Dominic G.
98% (19)Projects Completed
20
Freelancers worked with
19
Projects awarded
54%
Last project
10 Mar 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies