topic Re: validation on uploaded excel file in Application Development and Automation Discussions

validation on uploaded excel file

Former Member — Tue, 03 Jul 2007 18:11:39 GMT

hi all

i have uploaded the data from a spreadsheet into an internal table and now i would like to perform certain validations such as

1)there are no blank sapces in between the lines

2) the collums in the spreadsheet are in same order as internal table

3) colums are not hidden ,deleted or new colums have not been added

any pointers will be highly appreciated

navjot

amit_khare — Tue, 03 Jul 2007 18:14:37 GMT

1. Check the number of column read & individualy check foe space.

2. I dont think its possible.

3. Check for total columns uploaded, this will tell you the variation , if there from the original table.

Thse are possible if you are using ASLM_EXCEL_TO_INTERNAL_TABLE FM.

Regards,

Amit

Reward all helpful replies.