Lazarus 2.0.10 + Windows 11.
Would like to print the 'sWorksheetGrid'.
The content of the 'xlsx' file has several pages.
Can someone help me with the necessary code?
unit Unit1;
{$mode objfpc}{$H+}
interface
uses
Classes, SysUtils, Forms, Controls, Graphics, Dialogs, StdCtrls,
Printers, PrintersDlgs,
fpstypes, fpspreadsheetctrls,fpspreadsheetgrid, fpsopendocument,
fpsutils, fpspreadsheet, fpsallformats;
type
{ TForm1 }
TForm1 = class(TForm)
ButtonLOADXLSX: TButton;
Button2: TButton;
ButtonPrintGO: TButton;
PrintDialog1: TPrintDialog;
sWorksheetGrid1: TsWorksheetGrid;
procedure ButtonLOADXLSXClick(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure ButtonPrintGOClick(Sender: TObject);
private
var Nameworksheet : String;
public
end;
var
Form1: TForm1;
MyDir : String;
implementation
{$R *.lfm}
{ TForm1 }
procedure TForm1.Button2Click(Sender: TObject);
begin
Close;
end;
procedure TForm1.ButtonLOADXLSXClick(Sender: TObject);
begin
Nameworksheet:= '1.xlsx';
sWorksheetGrid1.LoadFromSpreadsheetFile(Nameworksheet);
end;
procedure TForm1.ButtonPrintGOClick(Sender: TObject);
begin
if PrintDialog1.Execute then
begin
// ????????
end;
end;
end.