Hi, I have a requirement that extract data from a PDF and each word of the PDF insert into an Excel in each cell. Means For one word one cell in excel and for next word next cell accordingly.
Can anyone please suggest me on this ?
One way is split your string tab delimited(row paste) or Environment.Newline delimited (Column paste) and copy to clipboard.
Ctrl+V on excel
Or
Use the split data and and add it to data table
Hi @vvaidya,
Thank you for your replay.
Can you please elaborate with a small example?
Thanks,
Koushik
Example for pasting, this looks fun but slow process. You can use add data row instead using the existing logic.(You will get many samples if you search)
It pasts every letter cell by cell, if encounters space goes to next row (you can manipulate this)
pasteCells.xaml (11.3 KB)
Hi @vvaidya,
It is now pasting each letter in a cell, I want each word in a cell.
Anyway Thanks again for your help.
Thought you wanted letter, if word you can split your string by space
Split(Word," ") and do foreach
Now it’s working.
Thank you so much.