I have figured that out by checking one of your post.
current requirement is to pull all the output through powershell and generate an excel sheet and put those records in the same format without any manual intervention.
suppose we have 15-20 fields which we are pulling and sending it to excel even if I use autosize and other format table commands it gives me an output which needs to have manual intervention in excel to do 'text to column" since I use "out-file <excel_file.xls> location.
with the above approach if there are more records using "text to column" doesn't segregate the details properly
Hence please suggest if the records can be pushed into excel without any manual intervention in the same format as it shows in the pwershell console.
NOTE: If the records are less, then "text to columns" works fine but when we have more records and try to do it using "space" as seperator then it fails
I'm not sure what you mean by your latter statement: "is there a way to convert the CSV exactly same output into an excel." Excel should handle the CSV and import the columns/rows into cells as expected.
If this post resolved your issue, please help others by selecting ACCEPT AS SOLUTION or adding a KUDO.