Hi I created a xlsx file from flexcel on my xdata server in a tmemorystream. How do I save that stream on my webclient to a xlsx file.

My code on the xdata server: TDirectDownload = class FFilename: String; Data: String; ContentType: String; end; function TReportService.DirectDownload(const ReportId: Integer; const ParamValues: string): TDirectDownload; var lFileName, lFullPath: string; lFileStream: TFileStream…

These posts might help you [image] Download file using service xdata and webcore save how binary file TMS WEB Core Hello, I can't solve this, I have a rest api with xdata with which I am returning a file in service, my function that returns is type tstream, th…

It seems the download payload is encoded as a Base64 file. Why does the Content-Type header say it's a spreadsheet rather than something appropriate for a Base64 data file? It might make sense if you want the client side (a web browser) to open and display it somehow, but not if you just want to wor…

The reason that the underlying file type is provided is so that receiving applications know what has been encoded. In this instance I am just saving it, but that might not always be the case.

Hi Russel Thanks for your help so far, on the client side I get the below error once it execute the following command FileData := window.atob(AData); DOMException: Failed to execute 'atob' on 'Window': The string to be decoded is not correctly encoded

I retested this here but couldn't see an issue. I'd recommend to log AData in the console and verify if this is the correct expected base64 data and if not, check the code you use to get AData.

[image] Smit_Magriet: FileData := window.atob(AData); DOMException: Failed to execute 'atob' on 'Window': The string to be decoded is not correctly encoded I was wondering what the atob(...) function is.

[image] W3Schools.com W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

Thanks all, I did come write everything is working now, I appreciate all your help

How to save xlsx file from stream

WEB TMS WEB Core

brunofierens (Bruno Fierens) February 7, 2023, 1:55pm 2

These posts might help you

Topic		Replies	Views
Download file using service xdata and webcore save how binary file TMS WEB Core tmswebcore	11	1698	March 23, 2022
Web core Client - how to load Json from Xdata server direct into WebDBDataset/Grid TMS WEB Core	15	1922	September 20, 2022
Download a file from XData Service TMS WEB Core	6	1190	October 6, 2021
Upload File from WebCore to XData Service TMS WEB Core	7	1104	November 8, 2021
Web Core / XData Service Query Example v3 TMS WEB Core	5	2056	September 15, 2021

How to save xlsx file from stream

Related topics