Forum > FPSpreadsheet
how to export to memorystream
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