Excel Archives - Code for Devs

Group Concat in Excel-Concatenating Cell Values based on Grouping Rows

May 24, 2025May 24, 2025 codef4devs

In this article we would learn how to combine data from multiple rows into one single string in Excel There is no specific function in Excel to concatenate data from multiple rows into one field. […]

How to Set Excel Sheet Zoom Percentage using C#

November 8, 2024November 8, 2024 codef4devs

If you are automating excel using C# and Microsoft.Office.Interop and you need to set the zoom factor of excel sheet, first you need to activate that particular sheet then set the zoom percentage of ActiveWindow.Zoom […]