Upload Excel using jxl

[former_member40425]

Hi All,

I am uploading an excel sheet using jxl jar file.

I am able to do it successfully. but I am facing one issue that suppose I have entered values in 4 rows in the excel sheet.

Now I enter value in any field(s) of 5th row but because of any reason I want to delete that entries of 5th row. If I right click on the 5th row and delete entire row then it works fine. and If I delete the entries using delete button or backspace button of keyboard and after that I save my excel sheet.

Now If I try to check the size of uploaded node it will 5. there will not be any entry corresponding to the 5th row of node but blank entries would be there. So it creates problem.

What is the solution for this problem... Any pointer would be appreciated..:)

Regards,

Rohit

[Former Member]

Hi,

Well, this is the way it is supposed to work. If you want to delete the entire row (content + row), you have to right click on a cell then choose delete and choose the "entire row" option.

Regards,

Pierre