Login to follow
Excel_Library

Excel_Library (ODC)

Stable version 1.1.4 (Compatible with ODC)
Uploaded on 15 Jun (3 weeks ago) by OutSystems Labs
Excel_Library

Excel_Library (ODC)

Details
Detailed Description

Excel Library External Code Integration.

Extends Low Code Capabilities to enable various actions for Workbook, Worksheet, Cell, and Data Formatting, without the use of a Microsoft Office Installation.


Actions List:

- Workbook Create, List of Worksheets and Document Properties

- Worksheet Add, AutoFilter, AutoFit, Calculate, Delete, Hide/Show, Protect and Rename

- Cell Write, Read, Merge/Unmerge, Copy, and Find By Value

- Column Add, Delete, Width, and Hide/Show

- Row Add, Delete, Height, and Hide/Show

- Image Insert

- Range Cell Formatting: Font, Border, and Value

- Table creation from Table DB / JSON Format

- Comments Add and Delete

- Dropdown Data Validation (Data_Validation_List)

- Integer Data Validation (Data_Validation_Integer)

- Decimal Data Validation (Data_Validation_Decimal)


Data Type Support: Text, Number, Decimal, Date-Time, Boolean, and Formula


Based on EPPlus Excel Library: https://github.com/EPPlusSoftware/EPPlus

Limitations

Server Action will be treated in a stateless fashion for ODC

Each action requires an Input Excel File (Binary ), and the output will be an Excel File (Binary)

To minimize action calling, some of the server actions will have a list of parameters. For example, the "Range_Format" action can be used with a list of multiple cell range formats, in one action call.


Release notes 

Breaking Changes:
- Workbook_GetWorksheet: Output Parameter Change.

New Function:
- Image_Get: Get Image from the Spreadsheet
- Image_GetAll_InCell: Get All Images (In Cell Only) from the Spreadsheet
- Image_GetAll_OverCell: Get All Images (Over Cell Only) from the Spreadsheet
- Range_FromAddress: Convert Given Address to the Cell Range format
- Worksheet_Copy: Copy Worksheet from another Excel File
- Worksheet_GetProperties: Get All Worksheets Properties in the Spreadsheet

New Update:
- Update EPPlus version 8.0.5

Limitation:
- The default image upload in the Excel spreadsheet is set to 'Over Cell'. To get an image 'In Cell', a separate function is needed starting from EPPlus 8 onward.
- If the value is 0, the integer variable will be blank or empty. For example, in the Function GetWorksheet Properties with Worksheet index 0 (the first index), the return value will be empty or the default value for Integer.

License