procedure StringList2XLS(InSL: TStrings; OutXls: String);
var
XLSRW: TXLSReadWriteII5;
i: Integer;
DefFmt: TXLSDefaultFormat;
begin
XLSRW := TXLSReadWriteII5.Create(nil);
XLSRW.Filename := OutXls;
XLSRW.Clear;
XLSRW.Version := xvExcel97;
XLSRW.CmdFormat.BeginEdit(Nil);
XLSRW.CmdFormat.Font.Name := '微软雅黑';
XLSRW.CmdFormat.Font.Size := 9;
DefFmt := XLSRW.CmdFormat.AddAsDefault('F1');
XLSRW.DefaultFormat := DefFmt;
for i := 0 to InSL.Count - 1 do
begin
XLSRW.Sheets[0].AsString[0, i] := InSL.Names[i];
XLSRW.Sheets[0].AsFloat[1, i] := InSL.ValueFromIndex[i].ToDouble;
end;
XLSRW.Sheets[0].AutoWidthCol(0);
XLSRW.Sheets[0].AutoWidthCol(1);
XLSRW.Write;
FreeAndNil(XLSRW);
end;
Copyright © 2014 DelphiW.com 开发 源码 文档 技巧 All Rights Reserved
晋ICP备14006235号-8 晋公网安备 14108102000087号
执行时间: 0.30605888366699 seconds