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”
Hi @Lori
Try this approach
Xaml for reference
AppendRangeWithGeneralFormat.xaml (4.8 KB)
@kumar.varun2 I tested and found your method ok, can you give the reason why I use excel scope failed ?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.