CSV files (comma-separated values) are special types of files that you can create, read and edit in Excel. This format is textual and designed to provide tabular data. In CSV documents the data fields are separated by commas instead of columns (commas in English version or semicolons in Russian vers...
A developer has a huge choice of options when the task is to export to Excel from Delphi or Lazarus – it was partially described in the article “How to export a report to XLS Biff8 from Delphi” and there I also briefly explained why it is a bad choice. And what is a good choice, th...
Probably many have encountered the problem of using a CSV file as a DataSet in Delphi. Let's have a look at one of the solutions to this problem. We will connect the CSV file via TADOQuery and build a report from this data in FastReport VCL 6. Create a project and add the following components. ...
Quite often, you need to get a PDF document from a Pascal application - either Delphi or Lazarus. Usually it is recommended to use specialized solutions, PDF converters (such as itext, Synopse PDF Engine, PowerPDF, HotPDF, PDF Creator Pilot, PDFtoolkit VCL, Debenu Quick PDF Library etc.). In this ar...
Oh, it’s an eternal topic – creating an Excel spreadsheet from Delphi. Excel spreadsheets are one of the world’s standards today and for programs, even simple ones, it is frequently required to output the data as tables and transfer reports to the spreadsheet. One thing to notice i...
Today we will look at the way to get stock quotes using a GET request with HTTPS protocol and public tradingviewapi.docs.apiary.io APIAccording to the documentation https://tradingviewapi.docs.apiary.io/#reference/0/history/0?console=1 in order to get stock quotes you need to use the GET req...
Console utility FRConverter 1.0 (QuickReport 9, ReportBuilder 19 , Rave Reports to FastReport VCL 6)
Previously, there were several articles about converting QuickReport 6 and ReportBuilder 19 templates to *.fr3 format. But this is all inconvenient and requires additional effort to create a project and connect additional modules and creates difficulties when converting templates in bulk. We decid...
Today we will look at migration from QuickReport 6 to FastReport VCL 6. Let's do it with the updated Converter included in FastReport VCL 6.3, it allows you to convert your template, even without QuickReport 6 installed on your computer. Converter (ConverterQR2FR.pas) has the following list of c...
Today we will look at migration from ReportBuilder 19 to FastReport VCL 6. Let's do it with the updated Converter included in FastReport VCL 6.3, it allows you to convert your template, even without ReportBuilder 19 installed on your computer. Converter (ConverterQR2FR.pas) has the following li...