Xls to xls problem

Help Activities
, ,
1

Hello,

I want to import data from Excel.xls file into Excel.xlsx. When I manually “Save As”, the data is transferred successfully, but when I “Save As” to the robot via shortcuts, the dots and commas in the data get mixed up. How can the robot change the data even though it doesn’t touch any data (like copy, paste)? Can you help me please? (I put shortcuts workflows picture)

original xls
original xls1055×100 2.69 KB

by me
by me1036×97 2.95 KB

by robot
by robot1105×97 3.27 KB

image
image209×713 18 KB

2

Hi @heyium

While Reading the Excel file

In the properties → Enable the Preserve format

image
image826×257 12.5 KB

Regards
Gokul

3

HI @heyium

Enable modern in your activities panel
image

  • Excel process Scope
    • Use Excel
      • Save excel file as
        Follow the same as the image below and try once

image
image613×632 17.3 KB

Regards
Sudharsan

5

But I am not using range reading activity. I am opening the xls file from Excel Application Scope. Then I click the shortcuts File>Export>Change File Type>xlsx>Save As.Preformatted text

6

You can try the method i have shown here

7

thank you, i’m trying

8

Hi @heyium

  1. Use Read range activity and store the data in the DT.

  2. Use Write range activity and pass the DT

image
image848×397 16.7 KB

Regards
Gokul

9

In the same way, the dot was converted to a comma. :frowning: @Sudharsan_Ka

10

Try this way @heyium

12

Can you share the Image again it is not loaded @heyium

14

Close your excel file and run the process

15

Hi @heyium

Close all the excel files and run the process

Or

Use Kill Process activity

image
image835×228 12.1 KB

16

same error again :frowning: @Sudharsan_Ka @Gokul001

hata
hata792×365 13.3 KB

17

Hello @heyium

Initially you need to use Kill Process and close all the excel sessions.
Use Read Range activity and read the data from excel1.xls (DT1)
Use Write Range Activity and Write the data to Excel1.xlsx

Instead of using save as you can do as above.
Thanks

18

Share the screenshot of the Error @heyium

Check out the XAML file

XLStoXLSX.xaml (6.7 KB)

Note → Update the excel file path and sheet name in the activity

Regards
Gokul

19

doesnt work :frowning:

hata
hata1842×755 43.4 KB

20

hata
hata1801×409 23.5 KB

21

Share the sample excel file with us @heyium

22

Are you sure you are the only one using that file?

or it is somewhere in the sharedrive and the client will access it something like that?

23

In the excel scope you are reading the file and getting the output to datatable DT1

Then outside of Excel scope start a new Excel scope and open the excel.xlsx file and then use Write range activity.

Thanks