Uploading json to excel and making columns read-only.

I have a JSON object, I need to upload it(or export) to excel and need to have some column read-only. Secondly I want to apply specific(defined) filter values to some cells and wont let the user to edit any cell value with diffrent data types.

I am able to export my JSON to excel using excelExportService.exportData(), but I am not getting how to use workbook and worksheets here to make column read-only and apply above mentioned constraints.

Hello RHimanshu,

Thank you for contacting Infragistics Community!

What I can suggest is using the Excel Library instead of the excelExportService in order to achieve the required behavior. I believe you will find Using Workbooks and Using Worksheets topics very helpful in order to understand how to use the workbooks and the worksheets.  

Please let me know if you need any further information.

Best Regards,
Martin Evtimov
Entry Level Software Developer
Infragistics, Inc.