Export a VirtualStringTree to excel, csv ?

Question

Is it possible to export a VirtualStringTree to Excel or CSV?

I am using Delphi 2007 and trying to save my VirtualStringTree data records as Excel or CSV format.

Answer 1

CSV Would be easier.

Your data is your own data, since the VirtualStringTree does not contain data, it is a virtual container. So, if your virtual string tree is a view of a TMyObjects list (container), it should be relatively trivial to output to CSV, and the content of the Virtual Tree would only really matter if your columns could be in a different order, or the set of columns that are visible are done.

I suggest you investigate the free JVCL JvCsvDataSet which is a really easy way to write CSV files.

If you really want XLS output, there are libraries for that.