I am giving a flow right here ,
1st step- i have a html table with data’s in rows and columns.
2nd step- Scrapping all those data using data scraping wizard and saving in a data table(say: dat1)
3rd step: My organisation badly needs that file in csv format ! so using write csv activity with the filepath like “c/user/table.csv” ,ok?
everything executed well
problem here is after opening a file in microsoft excel and if i change some data and try to saving the file total file is reformatted.
Analysed that and i found that , if i open that csv file “table.csv” and i am clicking save as in that file type it was showing unicode text(*.txt) .The file already is not in csv format i guess because of the extension we gave like “table.csv” in path right that’s why it looks like csv file in desktop because of icon image of csv. if i remove that “.csv” it was just saving only as “file”.
So tell me the solution and guide me to fix this issue. because every time i need to edit the data without reformatting.