Export to Excel
-
How can I export data from datagrid to Microsoft Excel without concerning about Excel's version???
Its very easy, you can write your data to a simple csv file with comma as delemter... for eg... if you have data as 1 abc abc1 2 def def1 then you can write this data as open "somefile.csv" for output as #1 dim i as integer for i = 0 to datagrid.count - 1 dim wline as string wline = datagrid1(0).text & "," datagrid(1).text & "," & datagrid(1).text & vbcrlf() output #1, wline next i close(1) This is just a concept not actual code the purpose is to explain u just to add datagrid text to csv file.. thinking u know how to get data from the gridtable.. This csv file can then be opened easily in excel.. Hope this helps u in writing ur code. Thanks!:) Manoj Madhavan