Hello Everyone,
I want to write a program for reading an existing excel file, Report.xls. This file contains two columns, File_Name and Counter. I will get the value of the File_Name from some other program.
This code should read the excel file for the File_Name. It should check if the name which I got is already available in the excel sheet, if YES then the Counter value in the same row should get increased by one. If NO then it should add / append the File_Name in the excel sheet.
Can anyone help me for this? I know that I can use JavaExcelApi for this, but I don’t know how to use it.
Thanks in advance :grin:
I want to write a program for reading an existing excel file, Report.xls. This file contains two columns, File_Name and Counter. I will get the value of the File_Name from some other program.
This code should read the excel file for the File_Name. It should check if the name which I got is already available in the excel sheet, if YES then the Counter value in the same row should get increased by one. If NO then it should add / append the File_Name in the excel sheet.
Can anyone help me for this? I know that I can use JavaExcelApi for this, but I don’t know how to use it.
Thanks in advance :grin: