insert value and keep excel type

[xel_wise]

Hello

We have an excel file preformatted with certain types set in certain cells (ie. numeric, percentage, anything type really). We want to insert data in a particular cell (A1, B4, etc...)but respecting the excel type.

How would we do that?

Thanks

[Abel.He]

Hello,

Thanks for your inquiry.
To help us reproduce your issue and work out a solution for you, please offer the following message. Thanks for your assistance in advance.
1) Your full test code that can reproduce your issue,
2) Your excel file.
3) Application type, such as Console App, .NET Framework 4.8.
4) Your test environment, such as OS info (E.g. Windows 7, 64-bit) and region setting (E.g. China, Chinese).

Sincerely
Abel
E-iceblue support team

[xel_wise]

I got this working thanks

[Abel.He]

Hello,

Thanks for your feedback. Have you a nice day!

Sincerely
Abel
E-iceblue support team