how to export to memorystream
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
Packs · 2024-11-03 11:56

how to export to memorystream .

----------------------------------------------------------------------
silvercoder70 · 2024-11-03 12:11

export what and from where...?

otherwise ...

there are WriteToStream() methods in fpspreadsheet.pas

----------------------------------------------------------------------
Packs · 2024-11-03 12:20

I want to dataset to excel stream

----------------------------------------------------------------------
wp · 2024-11-03 13:11

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

----------------------------------------------------------------------
Packs · 2024-11-03 13:20

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

----------------------------------------------------------------------
wp · 2024-11-03 13:28

Quote from: Packs on November 03, 2024, 02:20:52 pmFpspeadsheet is
exporting to excel file. I want it in stream format then I will
convert to base64 and store in db
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i   //
Untested, maybe some typos here and there...uses   fpSpreadsheet,
fpsTypes, xlsxOOML;var  stream: TMemoryStream;  workbook: TsWorkbook; 
worksheet: TsWorksheet;begin  workbook := TsWorkbook.Create;  try   
worksheet := workbook.AddWorksheet('Test');    worksheet.WriteText(0,
0, 'abc');    worksheet.WriteNumber(1, 0, 3.14);    stream :=
TMemoryStream.Create;    try      workbook.WriteToStream(stream,
sfOOXML);      // --- do something with the stream...    finally     
stream.Free;    end;  finally    workbook.Free;  end;end;

----------------------------------------------------------------------
Packs · 2024-11-03 18:19

Thank you 🙏. I will check

----------------------------------------------------------------------
Packs · 2024-11-04 09:54

Thank you 🙏. It is working

----------------------------------------------------------------------
Packs · 2024-11-04 18:30

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i      
FPSExport.FileName:='xyz.xlsx';      FPSExport.Dataset := vt_column; 
   FPSExport.MultipleSheets:= false ;     
FPSExport.FormatSettings.HeaderRow:= true;      FPSExport.Execute;   
 FPSExport.WriteExportFile; 
FPSExport to memorystream option not found in FPSExport  component.
how I can implement export to memory stream