Selects all rows from the base file, and all rows from the join file if the join condition is met. Choose 2 files via dialog box. Prompted at the console to make 1 file a base file. Prompted to choose a column from each Excel file to use as the join condition.
The joined file, left_join.xlsx is placed in the working directory.
Yvonne Glanville, firstname.lastname@example.org
innerjoinXL for SQL type inner join,
fulljoinXL for SQL type full join,
rightjoinXL for SQL type right join,
minusXL for file1 minus file2
1 2 3 4
## Not run: leftjoinXL(); ## End(Not run)