How to use Excel Library Component:

1. Add "Excel_Library" as a dependency to your project.

2. Choose Server Side Action based on what you need to call.

Example Use Case for Cell_Write Action:

1. To Write into Cell Value, you can use Cell_Write Server Action

2. cellWrites parameter (in the action) is the list of CellWrite Structure

3. To Understand the parameter structure, this is the explanation:

4. CellValue is the value that you want to write in the cell

5. Decide whether you want to put the starting table based on Cell (Row Index and ColIndex) or using CellName (ex: B1)

6. Sheet Name is Optional, if you leave it blank, it will be used on the first sheet

7. You need to specify CellFormat, otherwise it will be default Formatted as Text

8. Cell Format -> Cell Type, You can input the data type: Text, Number, Decimal, Date Time, Boolean, and Formula.

9. Cell Format -> Cell Type Format, You can input the format string. such as: "dd/mm/yyyy" for Date Format.6. Sheet Name is Optional, if you leave it blank, it will be used on the first sheet

10. Related to detail font style formatting, You can use Font Style Format Structure

Cell_Write required Input Excel Binary and produce Excel Binary

=======================================================

How to Write Data from Table to Excel

=======================================================

1. Prepare the Data structure

for the example:

2. Create a server action to create a new Excel file, fetch the data, transform it to the list of the structure and serialize it to JSON

Example JSON structure to load in the function Data_WriteJSON