_ExResponse-ReadWorkbook

This data may be referenced in many pages. By changing the name of this page or its content, you will be affecting many pages throughout the wiki.

{
  "version": "2.0.0.2",
  "file": {
    "path": "/Workbooks/Workbook test.wbk",
    "description": ""
  },
  "pullType": "MANUALLY",
  "minKeepCount": 1000,
  "properties": {},
  "hadoopProperties": "",
  "sheets": [
    {
      "name": "UnionSheet9",
      "sheetId": "UnionSheet9",
      "sheetType": "das.internal.ExternalWorkbookSheetType",
      "keep": true,
      "referencedSheet": {
        "name": "UnionSheet9",
        "workbook": "/Workbooks/wb dupli union.wbk"
      },
      "columnStyles": []
    },
    {
      "name": "Sheet1",
      "sheetId": "Sheet1",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "remoteHost",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "=#UnionSheet9!remoteHost"
        },
        {
          "columnName": "logName",
          "columnId": "1",
          "columnIndex": 1,
          "formulaString": "=#UnionSheet9!logName"
        },
        {
          "columnName": "remoteUser",
          "columnId": "2",
          "columnIndex": 2,
          "formulaString": "=#UnionSheet9!remoteUser"
        },
        {
          "columnName": "timeEnglishFormat",
          "columnId": "3",
          "columnIndex": 3,
          "formulaString": "=#UnionSheet9!timeEnglishFormat"
        },
        {
          "columnName": "request",
          "columnId": "4",
          "columnIndex": 4,
          "formulaString": "=#UnionSheet9!request"
        },
        {
          "columnName": "status",
          "columnId": "5",
          "columnIndex": 5,
          "formulaString": "=#UnionSheet9!status"
        },
        {
          "columnName": "bytesSent",
          "columnId": "6",
          "columnIndex": 6,
          "formulaString": "=#UnionSheet9!bytesSent"
        }
      ],
      "columnStyles": [
        {
          "columnIndex": 0,
          "width": 100,
          "name": "remoteHost",
          "thousandSeparator": true
        },
        {
          "columnIndex": 1,
          "width": 100,
          "name": "logName",
          "thousandSeparator": true
        },
        {
          "columnIndex": 2,
          "width": 100,
          "name": "remoteUser",
          "thousandSeparator": true
        },
        {
          "columnIndex": 3,
          "width": 100,
          "name": "timeEnglishFormat",
          "thousandSeparator": true
        },
        {
          "columnIndex": 4,
          "width": 100,
          "name": "request",
          "thousandSeparator": true
        },
        {
          "columnIndex": 5,
          "width": 100,
          "name": "status",
          "thousandSeparator": true
        },
        {
          "columnIndex": 6,
          "width": 100,
          "name": "bytesSent",
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 7
    },
    {
      "name": "Sheet2",
      "sheetId": "Sheet2",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "A",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "=COPY(#Sheet1!remoteUser)"
        }
      ],
      "columnStyles": [],
      "nextColumnId": 1
    }
  ]
}