while writing CSV (reading data from excel file)I'm checking (CSV file) if file exist or not in specified directory. If exist I'm trying to update existing CSV (with new rows from excel) file. If not existing I'm creating new CSV file(this part working fine).
I'm blocked while updating CSV with new rows, Please check my code and let me know the way to complete this.
First I'm creating 'temp' csv file and copying existing file data into temp file and adding new rows to temp file and rename temp file name with actual name.
Trying to delete existing csv file, but not working.
Can any one tell me what is issue with delete function.
If I use JExcelAPI for xlsx files getting error. Changed to apache poi XSSF, now I'm able to convert xlsx files into CSV format.
When I am trying to convert large (file size around 50,000 kb) file getting Exception in thread "main" java.lang.OutOfMemoryError: Java heap space. I have increased my heap size to 1024.