Forum > FPSpreadsheet

how to export to memorystream

<< < (2/2)

wp:

--- Quote from: Packs on November 03, 2024, 02:20:52 pm ---Fpspeadsheet is exporting to excel file. I want it in stream format then I will convert to base64 and store in db

--- End quote ---

--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---  // 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:
Thank you 🙏. I will check

Packs:
Thank you 🙏. It is working

Packs:


--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---      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 

Navigation

[0] Message Index

[*] Previous page

Go to full version