How to read and write excel file in java

I want to read and write an Excel file from Java with 3 columns and N rows, printing one string in each cell. Can anyone give me simple code snippet for this? Do I need to use any external lib or …

Check if the file exists using VBA

Sub test()

thesentence = InputBox(“Type the filename with full extension”, “Raw Data File”)

Range(“A1”).Value = thesentence

If Dir(“thesentence”) <> “” Then
MsgBox “File exists.”

Remove #N/A in vlookup result

How do I modify this function so that the result will merely be a blank cell rather than having #N/A show up if B2 has nothing in that cell?

I think I might need something like an ISERROR check but I …