WSheet Import SQL

This step allow us to get data with a SELECT query from an SQL server we already connected to through SQL Connection step. The data we get then can be placed into a target worksheet to editing and saving. The step has the following parameters:

  • Connection Djeeni name: This name identifies the connection name we wish to use to get data from.
  • SQL Query (SELECT): The SQL query we want to use to get data. The query must be a SELECT query.
  • Target top left cell: This parameter is only usable for target worksheets. We should use a target worksheet Djeeni name and the target cell we wish to copy the data from the query.
  • Options (Optional): No additional options available at the moment.