How to Change the cell format into text format in .csv file

[Gopikrishna_S]

Suggest a method to do it.

[ushu (Usha kiranmai)]

@Gopikrishna_S Can you share sample csv. Also, is it Okay if this can be converted to excel or do you want to keep only CSV format

[Gopikrishna_S]

I need to print like this 10E001 in B1 cell but I am getting like this 100 in B1 cell so I changed E1 cell format into string then i entered this value have got what i want.

[jack.chan]

is this not working for CSV file?

In this String "AB0610E001" I am using "Str.Substring(Str.Length -6)" this expression to get the last 6 digits of the String like this "10E001" but meanwhile i am entering it into excel cell i am getting like number value "100"

this then when calling you need to add sheet name parameter and column letter e.g. {“Sheet1”,“C”} for column C and sheet1 [image] Function ChangeFormatToText(sheetName As String, colLetter As String) Dim ws As Worksheet Set ws = ActiveWorkbook.Sheets(sheetName) ws.Activate Rows(1).Insert Range(colLetter & "1").Value = "test" Dim columnNumber As Integer columnNumber = Range(colLetter & "1").Column Columns(columnNumber).Select Selection.Tex…

[Gopikrishna_S]

I am using the Invoke code inside the excel application scope but in write csv activity how to use invoke code activity

[ushu (Usha kiranmai)]

@Gopikrishna_S Check below workflow

Example.zip (3.0 KB)

Make sure pass sheet name and column name in the Invoke VBA acitivyt within code

Before running this workflow make sure you open excel and follow below steps

• Click on Options
  

• Click on Trust Center
  

• Click on Trust Center Settings
  

• Click on Macro Settings
  

• Make sure you enable Turst access to VBA Project Model
  

[jack.chan]

that only works for xlsx

[jack.chan]

i think if you dont convert to xlsx,
you can add vbTab after your number when you write cell

then it will be normal in the result csv

[Gopikrishna_S]

But i am not using write cell, i am using write range how to apply this method for write range

[jack.chan]

before you write range, call this sequence
Append Tab To Dt.xaml (7.7 KB)

pass in dt variable

[Rahul_Unnikrishnan]

Hello,

Did you tried Format Cell Activity? You can define a Range the format that you want to keep.

[Gopikrishna_S]

Super Its Working, Cold you please explain how its working what is the logic behind this.

[jack.chan]

this loops through each row for a column and add tab character to each cell
dt.AsEnumerable().ToList().ForEach(Sub(row) row(colName)= row(colName).ToString+vbTab)

i loop over each column to call the code above so that it will effectively add tab character to each cell

[ushu (Usha kiranmai)]

@Gopikrishna_S It did work for CSV as well . I have tested it. Anyways Thank you