Empty extension

Help Activities
, ,
1

hello i get this error
image

I want to fill the first column of the workbook from the data of Fname

Write Range Workbook: Empty extension is not supported.

Fname will be on Column “Name of file”

image
image1015×353 6.98 KB

2

Hi @shanti_18

Could you please share what the Filename variable holds.

3

Hi @shanti_18

You didn’t give the extension .xlsx

image
image693×268 23.6 KB

Plesae give this

Fname+".xlsx"

5

@shanti_18

I am asking about the value stored in Filename variable, not the datatype of the variable.

6

System.IO.Path.GetFileNameWithoutExtension(CurrentItem)

here it is

7

no error at all, but it doesnt write on excel

8

Hi @shanti_18

Fname = System.IO.Path.GetFileNameWithoutExtension(CurrentItem.tostring)

Fname+".xlsx"
9

@shanti_18

System.IO.Path.GetFileName(CurrentItem)

Try this instead of that one

1 Like
10

@shanti_18

You can simply give this


Path.GetFileName(currentItem.ToString)
11

I try this but it’s saving an excel file haha
what I wanted is to write a data on the column here (“Name Of file”)

image
image1015×353 6.98 KB

12

Hi @shanti_18

If you wanted to write a data in cell then please use the write cell activity.

Regards

13

I should not get the extension, that’s why i have WithoutExtension

I just need my workflow to write the value of

image
image716×178 3.43 KB

to this

image
image1015×353 6.98 KB

14

@shanti_18

Could you please elaborate the process with more details like what and how the input you are getting and what’s should be the output you want.

17

Hi @shanti_18 ,

Kindly refer this flow to write the data into particular column of excel

UipathTest.zip (8.3 KB)

This workflow will iterate through each row in the Excel sheet, display the “Name” column value in a message box, and update the “Status” column with the value “Done” for each row.

Hope it helps you

Thanks,
Vinit Mhatre

18

@shanti_18

Use add data row activity to add the current file details like file name, status, file path etc.
Then after the for each write the datatable to the excel

image
image801×434 18.2 KB

image

19

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