Microsoft Excel devices

You can define devices that allow you to print reports to an MS Excel spreadsheet.

Примечание

Printing reports to an MS Excel device is not supported in Worktop.

Defining a Microsoft Excel device

To create a Microsoft Excel device:

  1. Start the Данные устройства (ttaad3500m000) session.
  2. Add a device. The Данные устройства (ttaad3100s000) session starts.
  3. Complete these steps:
    1. Specify the name and description for the device.
    2. In the Тип устройства field, select Сервисы внешней отчетности.
    3. Leave the 4GL Program empty.
    4. In the Argument field, specify -excel, optionally followed by other parameters. For example:

      • -excel

        Print the data to an Excel file. The file is stored in a folder on your computer. This folder is specified in the Путь field. The filename has this format: [report name]_[company number]_[yyyymmdd-hhmmss].xlsx

        This is a sample filename: ttaad340001000_000_20130626-202842.xlsx

      • -excel -open

        Similar to -excel. The Excel file is automatically opened.

      • -excel -nodatetimestamp

        Similar to -excel. The Excel file has no date- and timestamp.

        The filename has this format: [report name]_[company number].xlsx

        This is a sample filename: ttaad340001000_000.xlsx

      • -excel -server

        Similar to -excel. The file is stored in a folder on the server. This folder is specified in the Путь field.

    5. In the Путь field, specify the folder where the Excel file will be stored.

      Примечание

      • If you use the -server option in the Argument field, specify a folder on the LN server. For example, /home/jdoe/tmp (Unix).
      • If you do not use the -server option in the Argument field, specify a folder on your computer. For example, c:\temp.
    6. Specify the remaining device properties and save the device. For details, see the online help of the Данные устройства (ttaad3100s000) session.
Printing reports to a Microsoft Excel device

To print a report to a Microsoft Excel device:

  1. Start the print session to which the report is linked.

  2. Print the report.

    Points of attention:

    • In the Device tab in the print session, select Advanced Device.
    • In the Printer tab in the Выбор устройства (ttstpsplopen ) session, select the Microsoft Excel device.

    A flat file with all input fields of the report is generated.