It works great with a TADVStringGrid, if that were what I wanted to use. I am trying to use a TAdvSpreadGrid.
Drop a SpreadGrid on a form and name it sGrid. Drop a stringGrid on a form and name it StringGrid. Create a simple CSV file with a header named "HeaderTest.csv". Paste the code below into the buttonclick event. Very straightforward example. Tell me how well it works.
sgrid.FixedRows := 1;
FileName := 'HeaderTest.csv';
sgrid.FilterEdit.Enabled := true;
sGrid.SaveFixedCells := true;
sGrid.LoadFromCSV(FileName);
sGrid.Options := sGrid.Options + [goColSizing, goColMoving];
sGrid.AutoSizeCells(true,4,8);
sGrid.Visible := True;
// StringGrid
StringGrid.FixedRows := 1;
StringGrid.FilterEdit.Enabled := true;
StringGrid.SaveFixedCells := true;
StringGrid.LoadFromCSV(FileName);
StringGrid.Options := sGrid.Options + [goColSizing, goColMoving];
StringGrid.AutoSizeCells(true,4,8);
StringGrid.Visible := True;