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
Server Action will be treated in a stateless fashion for ODC
Each action required Input Excel File (Binary ) and the output will be Excel File (Binary)
To minimize action calling, some of the server actions will have a list of parameters. For example "Range_Format" action can be used with a list of multiple cell range formats, in one action calling.
New Features:
- Excel Merge: Merge multiple excel component into single excel component
BSD-3 license (https://opensource.org/licenses/BSD-3-Clause)
EPPlus for Commercial License, please refer to: EPPlus License Overview