writeDataBySheetName
Write data to a specific sheet in an Excel file, overwriting existing content if the sheet is present. Requires file path, sheet name, and data array for accurate execution.
Instructions
Write data to a specific sheet in the Excel file (overwrites if sheet exists)
Input Schema
Name | Required | Description | Default |
---|---|---|---|
data | Yes | Array of objects to write to the sheet | |
fileAbsolutePath | Yes | The absolute path of the Excel file | |
sheetName | Yes | The name of the sheet to write |