Convert Excel To Json In Java Example

Hello Masnun , Your post is helpful. js file from here. csv file in another program. JSON’s purpose is structured data. Identifying header rows. xlsx) and convert it into JSON format and save it. Java Double To String Examples. In computing, JavaScript Object Notation or JSON is an open-standard file format that uses human-readable text to transmit data objects consisting of attribute-value pairs and array data types (or any other serializable value). 30 Comments → Quick JSON Parsing with C#. 1BestCsharp blog 6,397,300 views. Performing conversion from String to int is a common scenario when programming with Core Java. Customize online with advanced options, or download a command-line tool. Today's post is brought to you by Daniel Ferry. There are python packages available to work with Excel files that will run on any Python platform and that do not require either Windows or Excel to be used. Convert XML to JSON and force array. Hence knowing how to convert CSV to Excel is a useful skill. JSON samples. Microsoft Excel up until 2007 version used a proprietary binary file format called Excel Binary File Format (. CSV and TSV are always going to be smaller than JSON and I like that, so often times, I actually prefer to load a CSV file into the page and convert it into JSON with JavaScript. Created by developers for developers. After user browse for image when he click on upload image it sending request to web service. simple is lightweight JSON processing library which can be used to read JSON, write JSON file. In short a simple jQuery Ajax JSON example in Asp. It's very common nowadays to receive JSON String from a Java web service instead of XML, but unfortunately, JDK doesn't yet support conversion between JSON String to JSON object. Choose from the following 5 JSON conversions offered by this tool: CSV to JSON - array of JSON structures matching your CSV plus JSONLines (MongoDB) mode; CSV to Keyed JSON - Generate JSON with the specified key field as the key value to a structure of the remaining fields, also known as an hash table or associative array. Export just the PDF data you need. below is the working code. How to create Json Array using Object Model? This page shows how to create Json array using Object Model. In the languages JavaScript and Python, the JSON notation is built into the programming language; no additional software is needed at all. CSV files are especially useful when wanting to save a table worth of data in a simple to read format. Attributes may or may not be in quotes. The script is written in Python2. You can then use the ConvertFrom-Json cmdlet to convert a JSON-formatted string to a JSON object, which is easily managed in PowerShell. JSON stands for JavaScript Object Notation. That’s all it does. Convert Excel to JSON, mapping sheet columns to object keys. This returns a new List of strings. AngularJS Service returns an array of simple object literals to the controller. Unlike in the case of XML, choosing JSON. In this tutorial we will learn about How to Read JSON Response Body using Rest Assured? and How to Validate Content of a Response Body? Read JSON Response Body using Rest Assured. simple is lightweight JSON processing library which can be used to read JSON, write JSON file. Now let use see an example of JSON and how to create the same in java using java. In the first example, I start by getting today's date as a java. All you need is an Excel spreadsheet, an XML schema, and a rudimentary understanding of Excel, which you can learn in this Excel training course for beginners. In this tutorial,I will use Python scripts to download twitter data in JSON format from Twitter REST,Streaming and Search APIs. Summary: in this tutorial, we will show you how to work with PostgreSQL JSON data type. If you understand Objects and arrays then JSON is very simple. Example of query that opens content of JSON variable is shown in the following listing:. If you are looking for how to get JSON formatted result from jquery ajax call in asp. I seem to be missing that one, too. In the video I have shown you step by step, How you can code a simple java program that can convert JSON to XML. simple and have added the location of json-simple-1. Encode Image to Base64 String. Then convert the data to text that can be edited and analyzed in Microsoft Excel. How to parse nested JSON object in Java. You can then use the ConvertFrom-Json cmdlet to convert a JSON-formatted string to a JSON object, which is easily managed in PowerShell. Now java developers can read Excel spreadsheets, modify them with a convenient and simple API, and write the changes to any output stream (e. x to convert Java objects to / from a JSON. FreeMarker is a "template engine"; a generic tool to generate text output based on templates. NET, then by end of this post you will have the solution. dBase (dbf) read. This page contains examples on basic concepts of Java programming like: loops, functions, classes, etc. Many of my friends are using NoSQL databases just because of flexibility and schema-less design. This chapter describes how Oracle TopLink supports the ability to convert objects to and from JSON (JavaScript Object Notation). No ads, nonsense or garbage. Normally in Java we use frameworks that resolve dependencies at runtime, and this can often result in hard to track down errors on deployment. If you want to use Google services, you are limited to a certain number of requests but your usage is connected with your account. When you query data from the JSON column, the MySQL optimizer will look for compatible indexes on virtual columns that match JSON expressions. There are several libraries out there to help you import JSON to Excel. Java Project Tutorial - Make Login and Register Form Step by Step Using NetBeans And MySQL Database - Duration: 3:43:32. Is there an easy way to do this or do I need to install a. ContentsJson dependencyConvert Json to XMLConvert Json String to XML StringConvert Json File to XML fileFull ProgramConvert XML to JsonConvert XML String to Json StringConvert XML File to Json FileFull Program Json dependency For convert Json to/from …. The keys are strings and the values are the JSON types. The class can be used for reading a string of JSON data as well as writing JSON output from an AJAX file. Here I am going to discuss about converting multiple nested JSON which might or might not contain similar elements to CSV for usage with tools like excel or open office calc. This article also covers creating Excel from SOAP XML Web Service so read full article to learn about SOAP API Export. How to Create RESTful Java Client With Jersey Client – Example ; Build RESTful Service in Java using JAX-RS and Jersey (Celsius to Fahrenheit & Fahrenheit to Celsius) Escape Character Utility for URL and JSON data – Feel free to use in your Java Project. We'll discuss the most common JSON processing. Sheet convert dsheet to html excel data table xls python java. Just to demonstrate how JSON can be used along with JavaScript, here is an example: If you have gone though the above tutorial, you are familiar with the JSON structures. MapForce includes a. Convert object having date to/from JSON in java (Jackson ObjectMapper example) Java Scanner example - read & write contents to/ from file (example) Find or search node in a binary search tree (Java/ recursive /example) Convert Enum to / from Integer & String value in java (example). In computing, JavaScript Object Notation or JSON is an open-standard file format that uses human-readable text to transmit data objects consisting of attribute-value pairs and array data types (or any other serializable value). The data in cells can be formatted using predefined formats or user-defined formats. This tutorial shows you how to write and run a simple Hello World program in Java with Visual Studio Code. The purpose of this blog is to give a short overview over various options to work with Excel Files in SAP and provide links with examples for the described options. Just make a request using the simple URL Structure, and let our API do the rest. xlsx which contains id, name, phone,department,category,age fields and where department field refers to department. Gson is the main class used for converting JSON to/from java objects. Then, drag and drop to connect corresponding fields. Convert CSV to JSON. When we have a situation where strings contain multiple pieces of information (for example, when reading in data from a file on a line-by-line basis), then we will need to parse (i. You can either use a POJO with Jackson or the Java Collection classes to parse and convert your data. Whether you’re a developer building and testing applications, a startup founder creating new systems with the intention of scaling later, an enterprise looking to test things before moving to cloud, a student wanting to learn, or an academic developing curriculum in the cloud, Oracle Cloud Free Tier enables you to learn, explore, build and. JSON data looks much like a dictionary would in Python, with keys and values. How to parse nested JSON object in Java. In the video I have shown you step by step, How you can code a simple java program that can convert JSON to XML. Application convert data from CSV (Comma-separated values) file to JSON format. Nested JSON documents are also supported. John D K — Founder of softhints. pkl) You could also write to a SQLite database. The JSON filename extension is. Convert structured data to CSV text files. Writers like os. This is a JavaScript and html5 based excel formula beautifier. How to read Json data using JsonReader? How to read Json array data using JsonArray? How to create Json Object using Object Model? How to create Json Array using Object Model? How to create Json Object using Streaming Model API? How to create Json Array using Streaming Model API?. This filter is mostly useful for debugging. File; import org. Daniel is a Microsoft Excel MVP. The idea is to use the library to consume the JSON and convert it into a Map and then drill into that map with your Java code to create the desired output as a. Les fichiers convertis sont enregistrГ©s dans votre boГ®te Г lettres. How to get current thread in java? Daemon thread in java with example. Now compare both JSON string using comparison operator (==) to check both array objects are equal or not. Make Dynamic Tables in Seconds from Any JSON Data. Here I am going to discuss about converting multiple nested JSON which might or might not contain similar elements to CSV for usage with tools like excel or open office calc. At the opposite, it can be used to convert JSON string to Java objects. org has provided libraries to create/parse JSON data through Java code. Just paste your JSON in the form below, press Convert button, and you get CSV. Takes JSON data either through POST data or file upload. poi poi-ooxml 3. As you might have guessed, one of our favorite software for data cleaning, manipulation and analysis is Microsoft Excel. JAVA - JSON Serializing and De-serializing of polymorphic objects Posted by David Beer on Thursday, Jan 23rd, 2014 I was recently faced with a slightly different problem, of how to serialize and deserialize polymorphic objects using JSON, and as I've now successfully fixed the problem I wanted to share with you how I did it. Les fichiers convertis sont enregistrГ©s dans votre boГ®te Г lettres. Ndlovu In my article, Warehousing JSON Formatted Data in SQL Server 2016 , we had a look at available T-SQL options for converting JSON data into rows and columns for the purposes of populating a SQL Server based data warehouse. Here's an example. js-xlsx is a parser and writer for various spreadsheet formats. To convert your Excel data to HTML, perform the following steps. Each object can have different data such as text, number, boolean etc. Hi everybody, this is a simple snippet to help you convert you json file to a csv file using a Python script. Java JSON Parser Example. to the Outlook Address book or Access database, you can convert your Excel worksheet to CSV first and then import a. If the input JSON file has the hasZ or hasM property set to True, the output features will have z- and m-values. Is there a simple way to convert a simple excel sheet to a JSON file? For example the source sheet could look like: A B 1 firstName age 2 Alice 22 3 Bob 33 and the s. sleep() methods. you can use commons csv to convert into CSV format. The library parses JSON into a Python dictionary or list. ## JSON JSON( Java Script Object Notation) is a lightweight text based data-interchange format which is completely language independent. This is a simple example. It's very simple and easy way to transform and share XML to JSON data Best and Secure XML to JSON works well in Windows, Mac, Linux, Chrome, Firefox, Safari and Edge. This article series was rewritten in mid 2017 with up-to-date information and fresh examples. JSON Stand for JavaScript Object Notation. I am trying to convert excel data into JSON format. The scripts I will use in the examples are complete and can be run right away. CsvReader JavaDocs File Format. If today is the first day you get to know Apache POI and you haven’t written any code snippet to read/write Excel files yet, I recommend you to read the sections 1 and 2 in the tutorial How to Read Excel Files in Java using Apache POI to understand the fundamentals. See Parse mark up language (JSON, html, xml ) for the input part, and OpenRefine Tutorial for the output part. Data Converter : Convert Excel data into JSON & XML October 2, 2017 | Core Java Script , jSON , PHP , XML Mr. I am trying to convert a json file into an excel spreadsheet with each json attribute in it's own column. JSON (JavaScript Object Notation), specified by RFC 7159 (which obsoletes RFC 4627) and by ECMA-404, is a lightweight data interchange format inspired by JavaScript object literal syntax (although it is not a strict subset of JavaScript 1). JExcel provides integration of Microsoft Excel into Java Swing applications. In this article, we demonstrate how to create an Excel, PDF and CSV views using Spring Boot. What can you do with JSON TO JAVA CONVERTER ? This tool will help you to convert your JSON String/Data to JAVA Class Object ; To Save and Share this code, use Save and Share button. In this tutorial, we will show you how to use Gson to convert Java object to / from JSON. When using the double curly {{value}} notation the binding is automatically converted to JSON. We can use this module to load any JSON formatted data from a string or a file, as the following code example describes:. java Find file Copy path roadrunner three feature added 5b46dbe Jan 26, 2017. Comma Separated Values (CSV) and the Extensible Markup Language (XML) are the most widely used formats for data, and conversion between these two formats needs often to be accomplished. For example, a package of three simple classes that makes JSON available to Java is available for free from JSON. Based on the popular JSON Formatter and Validator, the JSONPath Tester allows users to choose between PHP implementations of JSONPath created by Stefan Gössner and Flow Communications' Stephen Frank. simple […] Vote Up 0 Vote Down Reply. Recommend using a library such as Jackson or Gson to help with this. This code is to convert your Gherkin feature file to JSON format based on JSON Formatter framework. In order to use POI we need to have the following dependencies added in your project. If you want to play with this example, here are the source files used on this page: The X12 EDI input file is 831. These libraries can be used in any Java/J2EE project including Servlet, Struts, JSF, JSP etc and JSON data can be created. Load base64, get JSON. I have a json response containing multiple objects and I need to determine the index of the object that I want. toString(int). sleep() methods. It does not rely on the JScript engine for parsing. The json library in python can parse JSON from strings or files. JSON can represent two structured types: objects and arrays. The marshal and Unmarshal method returned in Bytes format, but we can change these data to strings/JSON in Go. This tutorial, will explain you the ways to create more complex JSON structure. First, we will create a schema based on XML source data. In this example, we are first creating old Excel file format i. Convert CSV/Excel To JSON,XML,HTML,SQL,Flat File,KML, Use this site to convert Comma Separated Values (CSV) and Excel files into another format!. Normally, JSON object literal is not the same as JavaScript object literal. In this post, we will learn how to import JSON to Excel. Convert spreadsheet to html e2 80 93 collections sheet excel table json data. I want to read the excel files(. Preparation 1. We can convert a JSON object to an enum using the readValue() method of ObjectMapper class. simple example-read and write JSON GSON example-read and write JSON Jackson example - read and write JSON Jackson Streaming API - read and write JSON reading and writing JSON using json-simple. In depth demos and tutorials teaching you how to use GrapeCity Documents for Excel, Java Edition, a high-performance java spreadsheet component that gives developers a comprehensive API to quickly create, manipulate, convert, and share Microsoft Excel-compatible spreadsheets. Create an Excel and add some data We have created an excel file “Employee. Then import the resulting data as per the CSV instructions above. How to parse JSON with date field in Java - Jackson @JsonDeserialize Annotation Example I have read many articles on parsing JSON in Java and most of them give examples where properties are either String or int , there are very few examples, where you will see the JSON string contains a date field and that's one important thing to learn. Since I've looked far and wide for a good example of this to no avail, I have created my own using the JSONArray and JSONObject classes. js-xlsx is a parser and writer for various spreadsheet formats. Creating JSON data in Java JSON. In short, you can read and write MS Excel files using Java. You can use HttpURLConnection for sending get/post request in java. REST stands for Representational State Transfer. Step-16 Now converted JSON to Excel file will be available. Remember, you need to use the excel file provided along with utility otherwise you will get errors. In this tutorial, we will show you how to use Gson to convert Java object to / from JSON. java Find file Copy path roadrunner three feature added 5b46dbe Jan 26, 2017. Add the following highlighted dependencies to your pom. I thought they were relevant at first but they're not. simple jar in the project build path. Very often when you access JSON data with Excel it appears in 1 column. Place double underscore within the column header name to create nested data. JSON is a text-based, human-readable format for representing simple data structures and associative arrays (called objects). Performing conversion from String to int is a common scenario when programming with Core Java. In this tutorial, we are going to use a js-xlsx library to convert Excel to JSON. The columns in the table are dynamically created based on the columns. 26+ files of convert spreadsheet to html excel sheet sql data table json using jquery example xls how importexport spreadsheets javascript spreadjs et code file java. CSV and TSV are always going to be smaller than JSON and I like that, so often times, I actually prefer to load a CSV file into the page and convert it into JSON with JavaScript. Screencast #14: Post JSON to spring REST webservice. So let's create example to convert CSV data to JSON using JavaScript. PS: To get excel format you can just open file. The purpose is to spit out a JSON file that can be read by chart. This tutorial shows 2 ways for converting Java objects to JSON. This previous article showed how to parse CSV and output the data to JSON using Jackson. Select an excel file and convert it to Json data. In addition, we will introduce you to some of the most common PostgreSQL JSON operators and functions for handling JSON data. For example, our JavaScript spreadsheet makes use of the Excel2Json and Json2Excel libraries to provide end users with the ability to import and export Excel files. Please note that Convert to XML is only available in Stylus Studio® XML Enterprise Suite. I am sharing two examples here. loads(infile. The JSON-Java library is also known as org. It's no surprise then that a lot of our Big Data ETL tasks end up extracting JSON from some external system, aggregating and transforming it, and then…. com to convert the file to CSV. Converting JSON to/from Java Objects using JACKSON API Created on: June 27, 2015 | Last updated on: September 30, 2017 websystiqueadmin This post explains Jackson data-binding , which is a common approach when dealing with JSON using Jackson API in your Java projects. Remember, you need to use the excel file provided along with utility otherwise you will get errors. simple example-read and write JSON GSON example-read and write JSON Jackson example - read and write JSON Jackson Streaming API - read and write JSON reading and writing JSON using json-simple. We need to create an instance of the client-side ExcelIO component that we can use to actually open the file: var excelIO = new GC. And many of us are looking for solution to this problem. I am playing around with jsonflattener and attributeexposer however this has been quite difficult. This program uses a constant string literal and then converts that to a byte array. JSON data looks much like a dictionary would in Python, with keys and values. Download JAR file json-rpc-1. Often we are in a need to convert Excel data to XML file which can be used as a feed. For example, when I define a JSON property in my schema of type string, if I also attach the rule "format" : "uri" to that property (because my string is actually a URI) then my corresponding Java property will. This example shows how to convert XLSX/Excel file to CSV format using Apache POI. There are two simple ways you can read data from an external JSON file and convert the data to an Array. From our blog Sqlify's New Pay As You Go Pricing Convert between CSV, JSON and SQL files in PHP using the Sqlify API Convert and flatten JSON to CSV or SQL using JSON path expressions One-liner to migrate data from MongoDB to MySQL from your shell Uploading a big file to the Sqlify API in chunks. js file which we are going to refer in our HTML file. The client application uses the JAX-RS 2. HOwever, an exception is thrown when it passes this code that i'm using to deserialize. simple jar in the project build path. The purpose of this blog is to give a short overview over various options to work with Excel Files in SAP and provide links with examples for the described options. jQuery Plugin For Converting Table Into JSON Data - Table to JSON. Convert JSON to Java object. Java JsonParser is a pull parser and we read the next element with next() method that returns an Event object. How to generate a JSON Web Key (JWK) Here is an example how to import a key To generate an EC key pair with the standard Java facilities and convert it to JWK. @Matthias Yes, actually the problem with converting types is that the corresponding Java type is not always obvious. Support for JSON, Java. Multi-functional Table To CSV Converter With jQuery - TableCSVExport. If you like this tool, please share it with your friends!. Comma-separated values (CSV) files store tabular data - numbers and text - in plain-text form. In this tutorial, let us see how to convert MySQL database table data into XML and vice versa. Excel, PPT, HTML. How to parse nested JSON object in Java. Below I have shared examples to do this. There is no „best" way to work with Excel files - each option has its advantages and disadvantages and usage depends on several factors. Java Example – Convert Date to String In this Java Example we will see How to convert Date to String or how to convert java. Here in this post, I am sharing a simple example on how to read JSON data from a file and convert the. PS: To get excel format you can just open file. This example uses MOXy along with JAXB to unmarshal JSON to Java object. Get JSON from Excel using Python, xlrd Feb 5, 2013 | 12 Comments Powering interactive news applications off flat files rather than a call to a database server is an option worth considering. fromJson(jsonString, Player. Coding is Love is an award winning blog on programming & development with coding tutorials, best practices for developers and walk-through of latest technologies. Java Double To String Examples. It's no surprise then that a lot of our Big Data ETL tasks end up extracting JSON from some external system, aggregating and transforming it, and then…. Preparation 1. csv file is a formatted way ? After parse the json object , I write it to a text file using streamwriter. Java Csv project at SourceForge. Converting Objects from one form to another is a common request. How to parse JSON with date field in Java - Jackson @JsonDeserialize Annotation Example I have read many articles on parsing JSON in Java and most of them give examples where properties are either String or int , there are very few examples, where you will see the JSON string contains a date field and that's one important thing to learn. Re: Convert JSON to Excel using VBA I agree and have managed to get it working (by commenting out the lines as shown). xls” and saved in Desktop. Browse to your JSON file location, select it, and click Open. Basically, the json doc maybe is a json array, right? so it will be same. properties files and Windows. As Spark SQL supports JSON dataset, we create a DataFrame of employee. Produced JSON will be in full compliance with JSON specification (). Recommend using a library such as Jackson or Gson to help with this. Writers like os. 1) Copy/paste or upload your SQL export to convert it. Contact us if you have any questions. As its name suggests, JSON is derived from the JavaScript programming language, but it’s available for use by many languages including Python, Ruby, PHP, and Java. net package. It will help you design and run report te. (C#) HTTP POST JSON. You can then use the ConvertFrom-Json cmdlet to convert a JSON-formatted string to a JSON object, which is easily managed in PowerShell. Contribute to noahzark/Xlsx2Json development by creating an account on GitHub. For more information, see Using JSON with Google Data APIs. The first row of the CSV file must contain column headers. we can convert the excel data into a JSON. I am trying to convert a json file into an excel spreadsheet with each json attribute in it's own column. Can anyone help me out. 1) Copy/paste or upload your JSON to convert it. Complex (nested) JSON data source Like DataTables, Editor has the ability to work with virtually any JSON data source. Additionally, the platform undergoes constant upgrades so as to allow developers to continue delivering bespoke applications for their clients. How to Parse JSON to/from Java Object using Boon JSON Parser; How to Read and Write JSON using GSON; How to write JSON object to File in Java? How to read JSON file in Java – JSONObject and JSONArray; Jersey Jackson JSON Tutorial; Spring REST Hello World Example – JSON and XML responses; How to Convert Java Object to JSON using JAXB; JAX-RS. CSV files are especially useful when wanting to save a table worth of data in a simple to read format. All you need is an Excel spreadsheet, an XML schema, and a rudimentary understanding of Excel, which you can learn in this Excel training course for beginners. Customers often ask us about converting Tweet JSON into comma-separated values (CSV). How can i convert this into as normal date like (mm/dd/yyyy)? You better understand like this. CSVJSONConvertionExample. Let's get going. This is Recipe 12. 30 Comments → Quick JSON Parsing with C#. This previous article showed how to parse CSV and output the data to JSON using Jackson. 2) Choose your separator. JSON is highly recommended to transmit data between a server and web application. Java HTTP Request. To convert files automatically without using Excel, through a desktop icon, scheduled tasks or from command prompt, use FileSculptor. JSON samples. There are no ads, popups or nonsense, just an awesome base64 to JSON decoder. Writers like os. json implementation has already been included in Android SDK. An XML schema defines the data elements and structure of an XML document. stringify() section above, we would pass the string s to the function, and assign it to a new variable: var o = JSON. Your JSON input should contain an array of objects consistings of name/value pairs. I started using in Eclipse Luna and Enide Studio 2014. While programming we may come across a situation where we have to convert json to xml or vice versa. Apparently, if the base64 is smaller than 100kb, the image is parsed easily but if the image string is big, say, from an image around 1mb size, matlab takes forever to process it. CSVs are also easy files to create and read from – as they are basically text files with a. Working with JSON data in Java can be easy, but – like most anything in Java – there are a lot of options and libraries we can chose from. Both the first and second examples are equally valid ways of converting JSON to SQL. Your JSON input should contain an array of objects consistings of name/value pairs. How to convert Java Array/Collection to JSON array? Java 8 Object Oriented Programming Programming Google provides a library named org. The json library in python can parse JSON from strings or files. Dim FSO As New FileSystemObject Dim JsonTS As TextStream Set JsonTS = FSO. In this article, I show you how to how to use Jackson-databind API for binding Java Object to JSON and JSON data to Java Object. I am playing around with jsonflattener and attributeexposer however this has been quite difficult. load, overwrite it (with myfile. Convert tabular data within CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / Mediawiki / SQLite / SSV / TSV file (s) or named pipes to a SQLite database file. simple example-read and write JSON GSON example-read and write JSON Jackson example - read and write JSON Jackson Streaming API - read and write JSON reading and writing JSON using json-simple. Almost every programming framework that I can think of most of the programming frameworks support JSON-based data-interchange. JSON stands for JavaScript Object Notation. 4) Save your result for later or for sharing. 30 Comments → Quick JSON Parsing with C#. This article applies to the following connectors: Amazon S3, Azure Blob, Azure Data Lake Storage Gen1, Azure Data Lake Storage Gen2, Azure File Storage, File System, FTP, Google Cloud Storage, HDFS, HTTP, and SFTP. How to get current thread in java? Daemon thread in java with example. PROC JSON reads data from a SAS data set and writes it to an external file in JSON1 representation. VBA-JSON provides another method ConvertToJson which can be used to convert excel data into JSON.