Dear All,
We are facing below issue while importing excel file in our application.
Issue Description:
If user has imported the excel sheet with some empty rows between data rows in the excel sheet, infragistics shall not consider those empty rows. If any error in the data rows (after empty rows, i.e. without formatting) then system will display the error information of the row index wrongly.
So, kindly suggest us to how to overcome this issue
4403.Book1.xlsx
MvcApplication15_Sample.zip
FYR, We have attached the sample application.
Thanks in advance.
Hi,
Thank you for the uploaded sample ! I was able to run it on my side and the result that I get written on the page is
1 - 1 1 1 1 1 1 12 - 2 2 2 2 2 2 23 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 - 12 - 13 - 14 - 15 - 4 4 4 4 4 416 - 5 5 5 5 5 5
Which are exactly the values that the worksheet has. Please explain in more details what is the issue here, I am looking forward to hearing from you.
We are using the Infragistics ignite ui control ver 16.2. and issue has persists in it.
If user has imported the excel sheet with some empty rows between data rows in the excel sheet, infragistics shall not consider those empty rows (i.e. from Row no. #4 to Row no. #15 was not consider in 16.2)
Kindly check and suggest us.
I verified that I get the same results as cited above when running the samples against 16.2.20162.1035, so there is no difference in the behavior between the versions, but I need to figure out if this behavior is wrong or not. The output written on the page is:
which correctly represents the values from the Excel worksheet. Please let me know how the output that you expect differs, so that I am able to suggest accordingly.