REQUIREMENT:
Before using this component, Advanced Excel forge component need to be installed in the system and referenced it through manage dependency.
MAIN FEATURES:
This component includes following methods of Advanced Excel component demos created with simple flows:
1. Workbook_Create
2. Workbook_Open
3. Worksheet_Select
4. Chart_Create
5. Workbook_GetBinaryData
6. Workbook_Close
7. Cell_WriteRange
8. Column_Hide_Show
9. Column_Insert
10. Cell_Write
11. Worksheet_AutofitColumns
12. Worksheet_Rename
13. Cell_FormatRange
Added the demo regarding the below methods of Advanced Excel component:
Row_SetHeight
Row_insert
Row_delete
Column_setwidth
Cell_WriteImageByName/Cell_WriteImageByIndex
Cell_UnMerge
Cell_Merge
Cells_FindByValue
Cell_Read
Cell_SetFormulaByName/Cell_SetFormulaByIndex
Cell_CalculateByIndex/Cell_CalculateByName
Workbook_Calculate/Worksheet_Calculate
ContainInRange
ConditionalFormating_AddRule
ConditionalFormating_DeleteAllRules
ConditionalFormating_GetAllRules