Question Read and Write range with existing data format in excel?

[Sachin Patil]

I am trying to read range from excel and writing or appending in another sheet using Microsoft.Office.Interop.Excel in c#. While writing or appending data existing data format is not copy like number, text, currency and date etc. If data type is currency then it convert into text or general category. Below I have attached example.

 

[JohnH]

Use the Copy method of Range and give destination Range. Range.Copy(Object) Method (Microsoft.Office.Interop.Excel)

sheet1.Range["A1:B3"].Copy(sheet2.Range["B4"]);