The formatting of the document.

[qwertehok]

Hi
using 5.20.33

to create a blank form in Excel using this code

Code: Select all

  xls[0].Clear;
  xls[0].AsString[10,0]:='caption';
  xls[0].Cell[0,1].BorderTopStyle:=cbsThin;
  XLS.Filename := ExtractFilePath(Application.ExeName)+'out.xlsx';
  XLS.Write;

crashes error. tell me how?

[larsa]

Hello

Before you can format a cell, the cell must first have a value. At least: xls[0].AsBlank[0,1] := True;

[qwertehok]

thanks

say, please how to change the font of the whole document

Code: Select all

  xls[0].Range[0,0,31,55].FontName:='Roboto';
  xls.Sheets[0].Range[0,0,10,10].FontName:='Roboto';

  XLS[0].AsString[0,2] := 'test';
  XLS[0].Cell[0,2].FontName:='Ubuntu';

but 2013 office opens the document with the font Colibri

[qwertehok]

and the second question



red marked what I do so

Code: Select all

xls.Sheets[0].PrintSettings.ScalingFactor:=90;

orange marked what I do so

Code: Select all

XLS[0].PrintSettings.FitHeight:=1;
xls.Sheets[0].PrintSettings.FitWidth:=1;

but I can't switch to orange RadioButton
please tell me how to do it

[larsa]

Hello

If you want to set the default font, use: XLS.Font.FontName := 'Arial';

I couldn't find any problems regarding the other issue, but I'm not sure I got you right.

[qwertehok]

Code: Select all

XLS.Font.FontName := 'Arial';

delphi say me
[dcc32 Error] Unit1.pas(70): E2003 Undeclared identifier: 'FontName'

[qwertehok]

I couldn't find any problems regarding the other issue, but I'm not sure I got you right.

can I use "printscaling", but I did not get to choose another option scale