EXCEL VBA Script

  • Posted:
  • Proposals: 3
  • Remote
  • #693116
  • Completed
Paul S.Dave G.Hassan F. have already sent a proposal.
  • 0

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:

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.