6/26/2021 0 Comments Delphi Read Excel File
Delphi is my art of programming.This blog contains technical solutions and tips for Delphi programming.I am just trying to share knowledges that I gained from others and which will help others.Delphi IOUtils. Accessing and changing Directories and Files in Delphi.
Create a new Diretory TDirectory.CreateDirectory(c:testfolder). Find create time, last opened time and last modified time TDirectory.GetCreationTime(c:testfolder); TDirectory.GetLastAccessTime(c:testfolder) TDirectory.GetLastWriteTime(c:testfolder). ShellExecute is Delphi Windows API function that is mostly used for launch external applications from our Delphi application. This function is linked to the ShellExecute Windows API function. Delphi Read Excel File Code Which IsThe function returns an integer that corresponds to an error code which is very useful when we need to show some status if the function worked or not. Can print documents from within my program, without explicitly starting the application that created the document, such as: print a Word-document without starting Word.Can open browser with a local HTML pageCan surf to a site i.e. URL link from a Delphi applicationCan send mails thorugh outlook Syntax of Windows API function HINSTANCE ShellExecute( Inopt HWND hwnd, Inopt LPCTSTR lpOperation. In this blog I will describe how to read and write data from and to an Excel file. Sometime in our application we use Excel for reporting purpose, for data import export purpose and for other works. So here I will explain how to access an Excel file and use for data read write. For this Excel 2003 or later should have installed in our system. You can get the unit in installed path C:Program Files (x86)EmbarcaderoRAD Studio10.0OCXServers Uses Excel2000; Before proceed I would mention an important word LCID which is required at most places. So what it LCID LCID In Microsoft Excel, the LCID indicates the currency symbol to be used when this is an xlListDataTypeCurrency type. Returns 0 (which is the Language Neutral LCID) when no locale is set for the data type of the column. Sometime we need some special directories path from Microsoft Windows system to store User data or to copy some files etc. By using Windows API function SHGetFolderPath Delphi provides SHGetFolderPath API function which helps us to get windows system folder paths. Delphi Read Excel File Patch Here AtFor more details about SHGetFolderPath please visit following link SHGetFolderPatch Here at following I have created a string function GetSpecialFolderPath using SHGetFOlderPath API function which will return all special Windows folder path as per CSIDLFolder value.
0 Comments
Leave a Reply. |