製品

Studio

Studio Web

StudioX

Automation Ops

Document Understanding

検索

サインイン

製品

Document Understanding

検索

Ubiquity - Convert Index to Excel Column Letter

はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す →

Ubiquity - Convert Index to Excel Column Letter

作成者: Ubiquity Technology

アクティビティ

5.8k

要約

This activity receives as input the column number index and converts it to column letter (uppercase).

概要

This component is based on the ASCII table, if the number received is 2 it will return B.

Use case:

Imagine this scenario: you have a large Excel file and you know that one of the fields that you need in your DataTable is in the index 208. You need to write in the Excel file with the activity WriteCell and you need the correct coordinate. You just need to include this activity, pass the index and you will get HA as your Excel coordinate to write in the correct cell.

As an option, you can use column number instead, just remember that the index is zero based.

機能

Easly convert Excel column number to Excel header letters.

その他の情報

依存関係

None

コード言語

C#, Visual Basic

ランタイム

Windows レガシ (.Net Framework 4.6.1)

公開者

Ubiquity Technology