Category Archives: Excel

Microsoft Excel related

Excel Copy Column Value Based On Another Column Value Lookup

Problem: One Excel sheet named “Account Info” contains accountnumber and account name. The other sheet named “Order Info” contains order mapping between orderid and accountnumber. Now we need to add another column to the second sheet to show the matching … Continue reading

Posted in Excel | Tagged , , | Leave a comment

Excel Concatenate String With Cell Value

You can use the “&” operator for this purpose, see the attached screenshot.

Posted in Database, Excel, Tool and Debug | Tagged , | Leave a comment

Java Read Excel Files Using Apache POI

Apache POI is a Java library for processing Microsoft Office files. Here below are a few limited examples of its operation on Excel files(both in xls and xlsx format). Maven POM Add the following dependency into your project pom.xml file … Continue reading

Posted in Excel, Java | Tagged , , | Leave a comment

Excel Macro: Use VBA to Copy Column Data Into Rows

In this blog, I will demonstrate how to copy data from a complicated Excel spreedsheet and paste it into another worksheet with a VBA macro. Problem Scenario Very often, you have a complicated worksheet and you want to flat the … Continue reading

Posted in Excel, Programming, Tool and Debug, VB | Tagged , , | Leave a comment