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
 

JohnH

C# Forum Moderator
Staff member
Joined
Apr 23, 2011
Messages
1,471
Location
Norway
Programming Experience
10+
Top Bottom