Make csv to open in excel with colums open

[Chimaera]

Im creating a csv from some array data of uninstall keys like this (needs Beta)

$sString = _ArrayToString($aList, ",", Default, Default, @CRLF) ; Make into .csv format Beta needed

FileWrite(@ScriptDir & '\Uninstall Logs\' & @OSVersion & ' ' & @UserName & ' ' & @MDAY & ' ' & @MON & ' ' & @MIN & ' ' & @SEC & '.csv', $sString)
MsgBox(64,'Finished', 'CSV Created', 2)

When i open it in excel 2013 it has the cells collapsed is there a way to make the csv remember to have colums maxed to the text within them?

[jdelaney]

ActiveSheet.UsedRange.Columns.AutoFit

[Chimaera]

Cant find anything in either helpfile for that and from googling it appears to be an excel component?

I am only opening them with excel to read them not saving them with it

When i take the log (csv) they may not have excel installed.

I need it to be a csv component that is remembered when it is opened in excel

[water]

You can't do that with a CSV. A CSV only contains data, no formatting information.

[Bert]

You can't do that with a CSV. A CSV only contains data, no formatting information.

agreed. A CSV is really nothing more than a comma delimited file. Definition:

A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form.

 

[Chimaera]

Ok thats a bust then

I will have to look at writing something that sits in the log folder and i run it before i start work on the logs

Open the csv, save them as excel on a loop and set the parameter (ActiveSheet.UsedRange.Columns.AutoFit) then close them

That seems to be the only sensible way