I am trying to paste the DataTable values into Excel Macro file using Write Range Activity. but while pasting the data the values which starts with Zero Prefix removed zero.
Below is the screenshot for more reference.
Below is the Datatable Values which I need to paste in Excel file as it is without changing anyvalues.
But while paste it’s removed Zero from Prefix
I am doing this activity in Excel Application Scope. Can anyone please help to fix this.
@nilesh.mahajan
have a check if adding ’ (single apostrophe) before the 0 starting number could be an option. The ’ is forcing Excel to keep the starting zeros and keeps the value as text
Please try
Changing the excel cell format to Text as cell formatted as Number may auto-remove preceding zeros.
Use custom cell format to keep leading zeros.
Cell format is Text.
@nilesh.mahajan Is cell formatted as Text in both source and destination excel file?
or you can create a custom number format Create a custom number format
Please let me know if this helps 
My destination file is a Excel Macro file which I used to download from Office portal. So is there any activity through which I can change the Downloaded file’s cell format as Text before pasting data into that.
does this Component (Package) will support in my Production machine also? Or I need to install this packages on Production system’s Studio as well?
package needs to be available on each environment where the process is executed.
If Orchestratror is in use and the nuget feed to it is available for the execution machine, then upload the BalaReva component there (see section Libraries in Orchestratror)
Now I Observe that even if I change my Cell format as Text before pasting the DataTable values that cell format automatically change as General After pasting the values.
Before pasting values my cell format is
But After pasting DataTable values it change as General
Format as custom 000000000
Yes I tried this one, but while pasting Datatable value Cell Format again become as “Genaral” and paste the value without Zero Prefix.
Below is my Datable value.
and below is the paste value into Excel.
Below is my Main Input file from where I used to assign the values into DataTable.
Are you formatting the column on the sheet below directly with BalaReva Change Cell?:
just fyi as I have to log off
cells formatted in excel
Note for the text, i had to type the leading zeros after it was formatted.
set as custom here:
V_Roboto_V
prashant1603765
ashokkarale
mively
Anil_G
yedukondaluaregala
Latifa
sharazkm32
postwick
jast1631