Hi,
I am facing issues while exporting the results retrieved from the Database to an excel file.
I have 5 count query in order to count the records in 5 different tables.
I had connected to the DB and retrieved the column count and printed in the screen.
But wat I need to do is, I have to export the count results to an excel sheet which should be saved in my local system.
The format of the output should be:
Column1 Column2
AAAA 10
BBBB 12
CCCC 100
I searched in other threads and it was given as to export all these to a csv file first and then to excel file. I have also exported to csv file but the o/p is not formatted.
It is like AAAA 10 BBBB 12 CCCC 100
Please help!!!