Problems of using Generate Data Table

[lj52man (James L Li)]

I has used Generate Data Table , I want to generate the table from string value, but the output excel format is not ok.

[sreekanth]

@lj52man,It is working fine for me.Check the add headers property in writerange and check

[MaurerDa]

I am getting headaches from this activity - but it is not us, it could be them.

Problem with Generate Data Table Activity

Hi, From my experience, the Generate Data Table is glitchy. You could try Chr(9) instead of vbTab. You could also try using a different delimitter in your text. It still might have problems though, cause I always have problems with it. As a workaround, you can use Write Text file with .XLS (tab-delimitted) or .CSV (comma-delimitted) extension. Then, Read CSV or Read Range to convert data to data table. Regards. C