Collection manipulation - Change Column DataType

[Ismael]

Hi all,

I am facing the following issue with BP 6.4.0.

1. When getting CSV file to collection I get some columns formatted as "Number".
2. I made the following simple custom code, to translate all the columns to String (Text).

---------

OutCol = inCol.Clone()

'convert all the columns type to String
For Each col As DataColumn In OutCol.Columns
  col.DataType = GetType(String)
Next

OutCol.Load(inCol.CreateDataReader)

---------

Now the issue comes that when using BP 5.0.12 it works perfectly and I get all the columns as "Text" (originally were "Number").
However with BP 6.4.0, I still get some columns as "Number". (couple of screenshots attached of BP 5 correct cast)

Any idea why and how to overcome this issue?

Thanks a lot for your help!

Cheers,
Ismael.

 

[Debduti M]

i have the same issue.. any fixes found?

 

[yogesh sopp]

You can keep column type as general as shown below image

And Use Get Worksheet As Collection (Fast) Action of MS Excel VBO



You will get all column type as text only.