Issue in comparing excel files after changing the format from .csv to .xlsx

[Anuja T]

HI!,
i am comparing two excelsheets,
1.one of which contains the data exported from
database and

2.one which i will download from application.

The excelsheet which i am going to get from application will be in .csv format.
and the data from the database will get exported in excel will be in .xlsx format.

now,i have to change the format of file which i am getting from application(.cs v to .xlsx) so tht i can compare both files.

1. I have tried to "save as" tht .csv file into .xlsx format and then comparing both.
but the code which i have written for comparing is not working.

Its giving error like size mismatched.( in script i have given condition like if row_count and col_count of both files does not matches then "size mismatched")

2. Rather than changing tht extension from .csv to .xlsx if i manualy copy tht .csv file data into new fresh excel and
then compare the file with file which has the exported database data.
my script works.

so can anybody suggest me why it is happening?

[Anuja T]

issue resolved.
there were multiple blank sheets present in that workbook which contains worksheet to be compared.that is why faced issue.
after deleting that blank sheets,my script working fine.