how to export to memorystream

[Packs]

how to export to memorystream .

[silvercoder70]

export what and from where...?

otherwise ...

there are WriteToStream() methods in fpspreadsheet.pas

[Packs]

I want to dataset to excel stream

[wp]

Sorry, I don't understand. Maybe you first write your question in your own language and then google-translate it to English.

[Packs]

Fpspeadsheet is exporting to excel file. I want it in stream format then I will convert to base64 and store in db

[wp]

Fpspeadsheet is exporting to excel file. I want it in stream format then I will convert to base64 and store in db

Code: Pascal  [Select][+][-]

1.   // Untested, maybe some typos here and there...
2. uses
3.   fpSpreadsheet, fpsTypes, xlsxOOML;
4. var
5.   stream: TMemoryStream;
6.   workbook: TsWorkbook;
7.   worksheet: TsWorksheet;
8. begin
9.   workbook := TsWorkbook.Create;
10.   try
11.     worksheet := workbook.AddWorksheet('Test');
12.     worksheet.WriteText(0, 0, 'abc');
13.     worksheet.WriteNumber(1, 0, 3.14);
14.     stream := TMemoryStream.Create;
15.     try
16.       workbook.WriteToStream(stream, sfOOXML);
17.       // --- do something with the stream...
18.     finally
19.       stream.Free;
20.     end;
21.   finally
22.     workbook.Free;
23.   end;
24. end;

[Packs]

Thank you 🙏. I will check

[Packs]

Thank you 🙏. It is working

[Packs]

Code: Pascal  [Select][+][-]

1.      
2. FPSExport.FileName:='xyz.xlsx';
3.       FPSExport.Dataset := vt_column;
4.       FPSExport.MultipleSheets:= false ;
5.       FPSExport.FormatSettings.HeaderRow:= true;
6.       FPSExport.Execute;
7.       FPSExport.WriteExportFile;
8.  

FPSExport to memorystream option not found in FPSExport  component.
how I can implement export to memory stream