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.
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 SpreadsheetNew Update:- Update EPPlus version 8.0.5Limitation:- 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.
BSD-3 license (https://opensource.org/licenses/BSD-3-Clause)
EPPlus for Commercial License, please refer to: EPPlus License Overview.