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
Have you tried to prepare “template” of excel spreadsheet with cells set to numbers and write data to that prepared file?
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.