Excel_to_JSON_Convertor_ExternalLogic

Excel_to_JSON_Convertor_ExternalLogic (ODC)

Stable version 0.1.2 (Compatible with ODC)
Uploaded on 17 December 2024 by Cognizant Benelux
Excel_to_JSON_Convertor_ExternalLogic

Excel_to_JSON_Convertor_ExternalLogic (ODC)

Details
Detailed Description

This Lightweight library efficiently parses Excel binary files into JSON strings, offering significant performance improvement for reading Excel sheets in any format.


This external logic has following actions (as of now)::

1. GetJSONFormattedExcelData_Ext

Description :

Pass Excel as a binary format and return as JSON string

Return string format:

CellRowIndex (Integer)

CellColumnIndex(Integer)

CellValue(String)

CellAddress(String)


2. GetAllWorkSheetNames_Ext

Description :

Pass Excel as a binary format and return as all worksheet name as JSON string

Return string format:

ExcelSheetNames (String)

Limitations

Expected excel in binary format as input for actions

Release notes 

Updated extension and relevant libraries to .NET8 version