Axolot Data

qwertehok

Hello, tell me how to resize comments

my code

XLS[nlist].Comments.Add(col, row,'', TXlsLine(xlsFile[i]).Дата+' '+TXlsLine(xlsFile[i]).Поставщик+':'+TXlsLine(xlsFile[i]).Примечание+#13#10 );

qwertehok

before (original file) https://i.ibb.co/6ZcprFM/0.png after https://i.ibb.co/bz7DRLg/0.png my code (I read from the first sheet and write on the second) read xls.Filename:=edit1.Text; xls.Password:=Edit2.Text; xls.Read; for i := xls[0].FirstRow to xls[0].LastRow do begin if xls[0].AsString[0,i]= '' ...

qwertehok

but I can manually set print margins for sheet?

qwertehok

Could you tell me the settings are similar to "print on 1 sheet in height and width" in MSExcel

qwertehok

larsa wrote: 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

qwertehok

Code: Select all

XLS.Font.FontName := 'Arial';

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

qwertehok

and the second question http://savepic.org/6643005m.jpg red marked what I do so xls.Sheets[0].PrintSettings.ScalingFactor:=90; orange marked what I do so 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

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

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?

qwertehok

xmm
Reconnect modules in uses and and all is well

qwertehok

hi using 5.20.26a uses ... , XLSSheetData5, XLSReadWriteII5, XLSCmdFormat5, Xc12Utils5, Xc12Manager5, XLSComment5, XLSDrawing5, Xc12DataStyleSheet5 ... i:=1; while not FDQuery1.Eof do begin xls[0].AsInteger[i,0]:=FDQuery1.Fields[0].asInteger; xls[0].AsString[i,1]:=FDQuery1.Fields[1].AsString; xls[0]...

qwertehok

hi
show a small example of the author\version in xlsx files

qwertehok

Help please
If I use VCL components, then all is well
But as soon as I create firemonkey application compiler writes that he can not find clipbrd.dcu

tnx

Axolot Data

Search found 13 matches

resize comment

damage to the original color

Re: The scale for printing

The scale for printing

Re: The formatting of the document.

Re: The formatting of the document.

Re: The formatting of the document.

Re: The formatting of the document.

The formatting of the document.

Re: error

error

Re: Xls/Xlsx file author

Export to Excel in firemonkey (xe4)