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 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.
- Upgrade to .NET 10 and EPPlus 8.6
- Bug fixing for returning a corrupted Excel file
BSD-3 license (https://opensource.org/licenses/BSD-3-Clause)
EPPlus for Commercial License, please refer to: EPPlus License Overview.