Datatable value comes out Null

[JDoshi (Jeet Doshi)]

Hi @theryt ,

Try below link it has got the component used to convert DataTable to Json. Check if it can help you handle null values.

How to Convert Datatable into Json object

Hi @Ranjan, Here you go below Are some Operation being Performed:- Convert Text File To into Formatted Excel Data Column Read the the Formatted DataTable and Convert to JSON Attached the Sample Script:- JSON_TO_DataTable.zip (26.4 KB) Note:Require To Import NameSpaces 1.Microsoft.Office.Interop.Excel 2.Microsoft.Office.Tools.Excel Below are The Sample ScreenShots:- 1.Raw Data [image] 2. FormattedExcel [image] 3.Final JSON Result [image] [image] Regards Sanjay Shankhla