Jinba FlowでExcelファイルの作成・読み取り・更新

- id: create_excel
  name: create_excel
  tool: EXCEL_CREATE
  input:
    - name: data
      value: [
        ["氏名", "役職", "給与"],
        ["田中太郎", "マネージャー", "50000"],
        ["佐藤花子", "開発者", "60000"]
      ]
    - name: sheetName
      value: "Members"
    - name: outputFilename
      value: "members.xlsx"
    - name: startCell
      value: "A1"

- id: get_excel_rows
  name: get_excel_rows
  tool: EXCEL_GET_ROWS
  input:
    - name: url
      value: "https://example.com/data.xlsx"
    - name: sheetName
      value: "Sheet1"
    # 任意: range を省略するとシート全体を読み取ります
    - name: range
      value: "A2:C10"

- id: get_specific_row
  name: get_specific_row
  tool: EXCEL_GET_ROW
  input:
    - name: url
      value: "https://example.com/data.xlsx"
    - name: sheetName
      value: "Sheet1"
    - name: range
      value: "A5:C5"

- id: get_cell_value
  name: get_cell_value
  tool: EXCEL_GET_CELL_WITH_COORDINATE
  input:
    - name: url
      value: "https://example.com/data.xlsx"
    - name: sheetName
      value: "Sheet1"
    - name: startCell
      value: "B5"
    - name: endCell
      value: "B5"

- id: get_images
  name: get_images
  tool: EXCEL_GET_IMAGES
  input:
    - name: url
      value: "https://example.com/data.xlsx"
    # sheetName を省略すると全シートから画像を抽出します
    - name: sheetName
      value: "Sheet1"

- id: update_excel_range
  name: update_excel_range
  tool: EXCEL_UPDATE
  input:
    - name: url
      value: "https://example.com/template.xlsx"
    - name: sheetName
      value: "Data"
    - name: startCell
      value: "A2"
    - name: endCell
      value: "C4"
    - name: data
      value: [
        ["田中太郎", "マネージャー", "50000"],
        ["佐藤花子", "開発者", "60000"],
        ["鈴木一郎", "デザイナー", "45000"]
      ]

- id: update_specific_cell
  name: update_specific_cell
  tool: EXCEL_UPDATE_BY_COORDINATE
  input:
    - name: url
      value: "https://example.com/report.xlsx"
    - name: sheetName
      value: "Summary"
    - name: updateData
      value: [
        {"coordinate": "E10", "content": "{{steps.calculate_total.result.sum}}"}
      ]

- id: read_source_data
  name: read_source_data
  tool: EXCEL_GET_ROWS
  input:
    - name: url
      value: "{{secrets.EXCEL_SOURCE_URL}}"
    - name: sheetName
      value: "RawData"
    - name: range
      value: "A2:C100"

- id: process_data
  name: process_data
  tool: PYTHON_SANDBOX_RUN
  needs: [read_source_data]
  input:
    - name: data_type
      value: OBJECT
    - name: code
      value: |
        import json
        
        # 前のステップからデータを取得（セル値の2次元配列）
        raw_data = json.loads(r'''{{steps.read_source_data.result}}''')
        
        # データを処理・変換
        processed_data = []
        for row in raw_data:
            if row[0] and row[1]:  # 名前と値が存在するかチェック
                processed_data.append([
                    str(row[0]).upper(),  # 名前を大文字に
                    float(row[1]) * 1.1,  # 値を10%増加
                    "処理済み"
                ])
        
        print(json.dumps({"processed_data": processed_data}))

- id: update_target_excel
  name: update_target_excel
  tool: EXCEL_UPDATE
  needs: [process_data]
  input:
    - name: url
      value: "{{secrets.EXCEL_TARGET_URL}}"
    - name: sheetName
      value: "ProcessedData"
    - name: startCell
      value: "A2"
    - name: data
      value: "{{steps.process_data.result.data.processed_data}}"