Same excel file uploaded validation

Aspose.Cells Product Family
1

Hi team,
We are using Aspose.cells for excel related opertaions.
Requirement : I am downloading programmatically generated Excel template from UI. While Uploading I want to check / validate whether same file has been uploaded .

Solutions tried so far:
1.For the same , in the last cell [A1048576] I put dummy value while generating the excel template ,same row made hidden. And compared same cell values during file upload…
It works fine but problem comes when I try to validate other functionalities during upload; it considers maxrow value as 1048576 (sheet.Cells.MaxDataRow) and returns error after long time…

Am I missing something in this approach?

Is there any perfect way to make carry out this validation in excel file. Please guide on the same…

Thanks,
Renuka

2

@RenukaH,

We are not sure what you really want to achieve but obviously if there is a value in A1048576 cell, Worksheet.Cells.MaxDataRow should return it 1048575, shouldn’t it return this value? As your issue is related to your own business logic (it does not concern with Aspose.Cells APIs), so you should devise and refine your approach by yourselves accordingly.