reading data form in excel using office API RRS feed

  • Question

  • Hi,

    I readt data using getDataAsysnc command and I would like to read the formatted data as it is on the spreadsheet. Formats like currency, date, etc. Currently this is how it read teh data:

        Office.select("bindings#myBinding").getDataAsync({ coercionType: "matrix" },function (asyncResult) {
            if (asyncResult.status === "failed") {


            } else {

                Data = asyncResult.value;


    However, it just reads numbers not the format. How can I do it to read the correct formats?

    Thursday, April 21, 2016 12:45 PM