08-20-2011, 08:45 PM
Hi Arul,
My requirement is like this.
Our App generates 3 reports HTML,Excel and PDF respectively.
I have to compare the three reports with master data.
So what i planned is keeping the excel report as it is, I will prepare one more excel sheet with a specific format which i need to test.
I have to copy the data from HTML and PDF to two excel sheet where i can compare the data using any excel macro or conditional formatting or something else,
The main challenge for me is to copy the required data from HTML or PDF into Excel where i can compare it.
Please help me in this regard.
My requirement is like this.
Our App generates 3 reports HTML,Excel and PDF respectively.
I have to compare the three reports with master data.
So what i planned is keeping the excel report as it is, I will prepare one more excel sheet with a specific format which i need to test.
I have to copy the data from HTML and PDF to two excel sheet where i can compare the data using any excel macro or conditional formatting or something else,
The main challenge for me is to copy the required data from HTML or PDF into Excel where i can compare it.
Please help me in this regard.