List Control to Excel
-
Hi All I am using Report View in List control with 5 to 6 columns. I need to transfer thes data from each column to excel sheet. Any Way to do it ?? Regards Gany
Have a look at "How To Use MFC to Automate Excel and Fill a Range with an Array". :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
Have a look at "How To Use MFC to Automate Excel and Fill a Range with an Array". :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]Or , you can look over here , I was used this class and work fine !
-
Hi All I am using Report View in List control with 5 to 6 columns. I need to transfer thes data from each column to excel sheet. Any Way to do it ?? Regards Gany
Apart from what was already suggested to you, you could consider exporting the values in .CSV format which Excel also can read and is more portable.
“Follow your bliss.” – Joseph Campbell
-
Apart from what was already suggested to you, you could consider exporting the values in .CSV format which Excel also can read and is more portable.
“Follow your bliss.” – Joseph Campbell
csv is a more generic format than xls([^]) :)
Величие не Бога может быть недооценена.
-
csv is a more generic format than xls([^]) :)
Величие не Бога может быть недооценена.
Adam Roderick J 09 wrote:
csv is a more generic format than xls
Yes , you are perfectly right , is much more handly and simple to export data in .csv format then .xls ! I recommend this solution !
