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

Sachin Patil

Member
Joined
Sep 24, 2020
Messages
5
Programming Experience
3-5
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.

1606304517020.png
 
Back
Top Bottom