How can I get Column ID(A,B,C) while importing Excel and is this possible I can apply filter on the column ID
*This post is locked for comments
hi,
Did the below solution help you?
Could you verify the solution?
Best Regards,
MMV
hi,
check fct. ReadSheet in table ExcelBuffer. with CellData.ColumnNumber you have the column ID as number. to filter by column id you could write your own version of ReadSheet or import the complete data into ExcelBuffer and filter the data afterwards.
Simple data import using excel buffer
What you actually doing? What tool you use?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156