Reading and Writing Excel Workbook
There are many use cases where reading and writing to Excel workbooks. For instance, users prepare data in an Excel file and your API read data from it for analysis. Alternatively, your API write data to a report template excel for generating report in Excel format.
AlchemyJ provides two extended functions for reading and writing to an Excel workbook.
ajReadWorkbook: Reading data from a range of cells in an Excel worksheet to the specified area in another Excel file.
ajWriteWorkbook: Exporting data from a range of cells in an Excel worksheet to another Excel file.
To find out more about the detailed usage of these two extended functions, please refer to the AlchemyJ Extended Functions section.