Files in Java

Question

Hi! I am working with files in Java and excel. I need to delete a given row or column. So that the formulas are not affected when they are erased, they must be automatically corrected. I really need your help!! Thank you

Answer 1

Hm, hard to tell without further information...
Do you use a framework for the excel handling stuff, like Apache POI?
If so, this will help you ;)
https://stackoverflow.com/questions/20955595/excel-formula-not-updating-on-row-delete-from-java-application-using-apache-poi

Answer 2

Hm maybe if you see my code you’ll have an idea of what I’m missing. I’ve work so hard on it but I don’t know how to erase the rows and columns and I really need a good grade

Answer 3

Im missing the option on the menu that deletes a row or a collum on the Excel document and the option that creates a new row or a collum on the Excel document. Im using a CSV reader in order to analize the file that the user gives me. Its also required that after doing a operation like this, the results of the document must ve printed through the console. I also have a method that prints the information of the document on the console