hello everyone ,
Is there any option to generate Excel sheet using record set obtained using the Select command ?. I tried to generate excel sheet using INTO OUTFILE command but I’m facing two issues,
1.The generated file doesn’t have any headings like NAME, DATE etc. Only data which is saved in db is getting written in that file.
2.I’m not able to provide custom location for generating report.
I’m using MySQL as back-end . please help me out .
You would only get a CSV file using INTO OUTFILE and not a real Excel file.
And don’t forget that this will save the file on the server, not on your computer if this is a desktop app.
You can generate XML Excel files quite easily with Xojo using a recordSet and some basic string commands.
Creating a real Excel file using the ExcelApplication Xojo class only works on Windows.
One more option i found is report in xojo . I’m able to print it as PDF. But its actually converting the report as a image and saving . I cannot select any text in that after saving .