Scraping data and writing in excel

Help
1

Im scraping data from a certain site. But when writing to excel the format for my scraped data is changed from numbers to general. How can it preserve the format

2

Hi @Tapiwa,
Have you tried to prepare “template” of excel spreadsheet with cells set to numbers and write data to that prepared file?

3

You could use a vba script to reformat the columns after writing. I’ve attached an example.

It requires using tha application scope and the invoke vba activity.

Test.zip (34.6 KB)