Ler arquivos de um diretório e escrever o nome em uma planilha Excel - Read files from a directory and write the name on an Excel spreadsheet

Help StudioX
,
1

Oi!
Pessoal, existe alguma forma em que eu consiga ler o nome dos arquivos de um diretório e ler isso no excel? A ideia é que a cada novo arquivo, o excel acrescente uma nova linha com o nome do arquivo.

Hi!
Guys, is there any way I can read the name of files in a directory and read this in excel? The idea is that with each new file, excel will add a new line with the file name.

2

@danielle.freitas …please check this post…

3

Thank you!
I did the steps in that post, but it is giving an error.

Obrigada!
Fiz os passos mencionados nesse post, mas está dando um erro.

image
image724×517 10.8 KB

Error:
Main.xaml: Compiler error(s) encountered processing expression “Directory.GetFiles(“C:\Users\FreitaD2\Documents\SAP\SAP GUI”)”.
‘Directory’ é ambíguo, importado dos namespaces ou tipos ‘Microsoft.Graph, System.IO’.
Main.xaml: Compiler error(s) encountered processing expression “Directory.GetFiles(“C:\Users\FreitaD2\Documents\SAP\SAP GUI”)”.
‘Directory’ é ambíguo, importado dos namespaces ou tipos ‘Microsoft.Graph, System.IO’.

image
image827×187 12.7 KB

4

@danielle.freitas - Share what you have typed in Directory.GetFiles…send the entire code…

5

image
image994×615 19.4 KB

image
image799×214 14.1 KB

6

@danielle.freitas - Please share the xaml.

7

Main.xaml (31.2 KB)

8

Problem solved!
I used only For Each and now it worked.
Thank you!

Problema resolvido!
Usei apenas o For Each e agora funcionou.
Obrigada!

image

9

@danielle.freitas - I was about to respond…I just fixed your xaml.

Good that you fixed…If its solves your query. Please mark my post solution , that will close this thread.

10

How can I declare this variable in this case?

Como eu posso declarar essa variável nesse caso?

image
image726×583 17.4 KB

11

@danielle.freitas - Inside Excel Application scope…you just have to give “File”…

which has the file name…you just printed the value in the message box right?

I dont know what is your requirement…I already gave you the xaml…not sure you downloaded or not?

Here you go: FileNames_ToExcel.zip (41.5 KB)

12

ok, it worked well!

ok, isso funcionou bem!

image

13

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