Two Excel have same columns and cell format, while use append range, the second excel "invoice date" change from General to Date, how to solve this issue?

Help Studio
, ,
1

Two Excel have same columns and cell format, while use append range, the second excel “invoice date” change from General to Date, how to solve this issue?
I want to still keep General format.

B1_TestUse.xls (28 KB)
A1_TestUse.xls (28 KB)
append excel.xaml (7.7 KB)

Remark: I need to append “B1_TestUse.xls” into “A1_TestUse.xls”

image
image1072×512 81.2 KB

2

Hi @Lori

Try this approach

image

Xaml for reference

AppendRangeWithGeneralFormat.xaml (4.8 KB)

3

@kumar.varun2
I tested and found your method ok, can you give the reason why I use excel scope failed ?

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.