はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す →
作成者: Internal Labs
3
アクティビティ
4.8k
要約
要約
Pass the DataTable and Column Name or Column Index and get the Column Letter within an Excel Worksheet.
概要
概要
This activity receives a DataTable and either a Column Name or a Column Index, and then produces the Column Letter that is associated with that Column Name or Column Index (e.g. the first column returns A, while the 27th column returns AA).
The Column Lettter can then be used with other Excel activities to read/write data to the correct column. Other Spreadsheet applications that are similar to Excel may work as well (e.g. Google Sheets).
機能
機能
This component allows users to find column letter by column name or column index (e.g. A or AB or ZZZ) without using an Invoke Code Activity.
その他の情報
その他の情報
依存関係
n/a
コード言語
C#, Visual Basic
ランタイム
Windows (.NET 5.0 以上)