Excel view readable

[teslyak9437 (Sam)]

I have the following request for help with the following:

1. When reading data from excel cells, empty values are added to the variable, which later when inserted into the file are displayed
   
   

please tell me how to remove them before inserting them into excel

2. How can I make the excel view readable?
   Original.
   
   
   
   want it to be
   
   

[mkankatala (Mahesh Kankatala)]

Hi @teslyak9437

You can use the Autofit Range activiy to make it readable.

→ This is the Modern Excel activity you have to use inside the Use excel file activity.
→ Give the Select a source field like below,

Excel.Sheet("Sheet name")

→ Check the columns and rows option to autofit the both.

Check the below image for better understanding,

Hope it helps!!

[teslyak9437 (Sam)]

and what about first?

[mkankatala (Mahesh Kankatala)]

First question is not understandable. Could you be more specific… @teslyak9437