How to clear a TWebXLSX

WEB TMS WEB Core
1

I have a TWebXLSX on my form. I use it to save various data as XLSX and have the need to clear the content before reusing the TWebXLSX.

I looked for a method TWebXLSX.clear but failed.

How can I clear the content of a TWebXLSX?

tx Bernd

2

Hi,

It looks like the library itself doesn't come with a method to clear the contents.
Are you looking for something that removes all the sheets?
Or should it keep the sheets and remove the data only?

3

I want to "reset" the component. Clearing data, of course, but if I added sheets, they must be removed, too.

Workaround: Free/Create, I suppose?

4

That is one workaround, but you could also remove all sheets manually:

procedure TForm1.WebButton2Click(Sender: TObject);
var
  I: Integer;
begin
  for I := WebXLSX1.SheetNameCount - 1 downto 0 do
    WebXLSX1.RemoveSheet(WebXLSX1.SheetNames[I]);
end;

We can put this behind a RemoveAllSheets method for the next version.

5

This is good, but not exactly, what I wanted. I wanted a method to reset the component to the state it had after creation/being dripped on the form. So I suppose, one default sheet is created.

6

Do you encounter problems with adding an empty sheet? Normally this should produce the same output you are after:

procedure TForm1.WebButton1Click(Sender: TObject);
begin
  WebXLSX1.RemoveAllSheets;
  WebXLSX1.AddNewSheet;
end;
7

No problem at all. Just a matter of lazyness. :- )

I´d prefer:

procedure TForm1.WebButton1Click(Sender: TObject);
begin
  WebXLSX1.Clear;
end;

Which in turn may be implemented:

procedureTWebXLSX.Clear;
begin
  RemoveAllSheets;
  AddNewSheet;
end;
8

We'll look to add this for the next version.