Btukfyl

I'm using appium with eclipse. In my project I need to read config data of my account from Mongo DB and based on the value assigned to key I have to execute code. My config file is as below. When I read it from mongo I get data in the form of Document, but I am not getting any function to save document in excel.

Config in mongo:

  {

    "_id" : ObjectId("5b64017c6c9b9d1a9d08563a"),

    "configId" : "1503121975430462",

    "configType" : "Workshop",

    "customerSource" : {

        "enabled" : true,

        "options" : [ 

            "Walk-in", 

            "Newspaper Ad", 

            "Print Ad", 

            "TV Ad"

        ]

    },

    "vehicleType" : {

        "enabled" : true,

        "values" : [ 

            "cars", 

            "bikes"

        ]

    },

    "createdOn" : ISODate("2018-09-06T09:47:25.006Z"),

    "updatedOn" : ISODate("2018-11-27T15:55:22.724Z")

}

// function to get data from config.

`public Document GetConfig(String AccountId) throws Exception{

        String MongoColl = ExcelUtils.getCellData(7,4);

        String QueryKey = ExcelUtils.getCellData(7,5);

        //Get table/collection in variable

        MongoCollection<Document> collector = GetCollection(MongoColl);

        // Get documents by query

        BasicDBObject query = new BasicDBObject();

        query.put(QueryKey, WorkshopId);

        //Get value based on query

        MongoIterable<Document> cursor = collector.find(query);

        //Print first row of data returned

        System.out.println(cursor.first());

        return cursor.first();

    }`

// Output I get is like below

`Document{{_id=1514279651131149, configId=1503121975430462, configType=Workshop,  customerSource=Document{{enabled=true, options=[Walk-in, Newspaper Ad, Print Ad, TV Ad, Leaflet]}}, vehicleType=Document{{enabled=true, values=[cars]}}, createdOn=Tue Dec 26 14:44:11 IST 2017, updatedOn=Tue Nov 27 19:11:42 IST 2018}}`

// function to save data in excel is as below

    public static void setCellData(Document value, int RowNum, int ColNum) throws Exception {

         try {

            row = excelWSheet.getRow(RowNum);

            if (row == null) {

                row = excelWSheet.createRow(RowNum);

            }

            cell = row.getCell(ColNum);

            if (cell == null) {

                cell = row.createCell(ColNum);

                cell.setCellValue(value);

            } else {

                cell.setCellValue(value);

            }

            // Constant variables Test Data path and Test Data file name

            FileOutputStream fileOut = new FileOutputStream(Constant.Path_TestData + Constant.File_TestData);

            excelWBook.write(fileOut);

            fileOut.flush();

            fileOut.close();



        } catch (Exception e) {

            try {

                throw (e);

            } catch (IOException e1) {

                e1.printStackTrace();

            }

        }



    }

But this gives error:

"The method setCellValue(double) in the type Cell is not applicable for the arguments (Document)"

I want to save all the values from config to an excel file. Can anyone suggest how to save this output(document) in Key:value format in excel in different rows?