1. Component introduction
Prerequisites: Start Excel or Get Opened Excel
This component automatically saves the content of an Excel file.
2. Inputs
For information about each input, see the help text in the component pane of the application flow editor.
3. Outputs
For information about each output, see the help text in the component pane of the application flow editor.
4. Component usage example
4.1. Component configuration example
For
Opened Excel Object, select v_excel_obj_1, which is the output from the prerequisite component (Start Excel or Get Opened Excel).For
Save Method, select "Save".Default values for advanced options
4.2. Example execution result
None
5. Example flow
Build the flow
Use the Get Opened Excel component to retrieve the file object of an opened Excel file.
Use the Get Active Sheet component to retrieve the object of the active sheet.
Use the Write Line to End of Excel component to write ["Xiong Er","18"] to the last row of the specified sheet.
Use the Save Excel component to save the content of the Excel file.
Use the Close Excel component to close the Excel file.
Execution result
The following figure shows the execution result. After the flow runs, it retrieves the opened Excel file, writes the specified values to the last row, and then saves and closes the file.
