a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

df6a0f32-cf32-47e3-a063-2d0b0fd1212d.jpg

Technical Account Manager

40896816-a878-4a22-b055-df975b08fc1a.nupkg

Pass the DataTable and Column Name and get the Column Letter within an Excel Worksheet

d78474ed-7239-4ae7-9cf0-2b66ffee451b.png

3217dfc4-f0ae-479a-b2a7-070779039abb.png

537d8480-39c2-4640-8994-56fc8141a29b.png

8fa46618-7f31-4b17-8145-5aff0411b740.png

008af18f-9409-4918-9fbe-96ab30d5b84c.zip

5cb6f91a-d3d7-4782-84db-97a46ab1e76a.nupkg

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).

Pass the DataTable and Column Name or Column Index and get the Column Letter within an Excel Worksheet.

c220478d-0435-48c9-bd58-9e59724629d6.png

c4c2c747-ead0-42f7-a2a1-186cb355efe6.png

Visual Basic

b134093d-e4ff-4b82-8ad9-5642e637ecb4.zip

Version	Release Date	Download Link
1.0.8	January 26, 2023
Added column letter input argument to lookup a column by column index (starting with index 1) Converted code to C# and added support for both .NET Framework 4.6.1 and .NET 6. This is a breaking change and will require activities to be replaced within workflows.
1.0.0	May 24, 2019

Get Column Letter