Converting Table Object into csv format

[#1]

Hi,

I am trying to convert by my table object into csv format. I exported my table into csv format but when I open my csv file, the data is not being displayed in one line. Rather it looks like a table only even though the file is saved in .csv format. Dont know what's happening.

Please Help!

[settu_periasamy]

where did you check, in excel? May be check in notepad or other editor tool

[#3]

duh...my bad.....thanks for the solution

[HirisH_V7]

Hi,

Check this,

This may help you  Link,

makeuseof.com/tag/how-to-convert-delimited-text-files-into-excel-spreadsheets/

HTH,

Hirish

[nagireddy_qv]

Hi Akash,

You will have to write a macro to achieve this.

sub ExportToCSV

set tb = ActiveDocument.GetSheetObject("TB99")
tb.Export "Final.csv",",",0

end sub

Where 0 = ANSI, 1200 =  Unicode, 65001 = UTF-8.  You might need ServerSideExport or ServerSideExportEx on a server.

[settu_periasamy]

Can you close this thread, if you got the Answer..

[jagan]

Hi,

If you open CSV file in Excel it will display in tabular format, if you really want to see the raw data open the csv file in any Notepad software.

Hope this helps you.

Regards,

jagan.