mary 0 Posted March 11, 2011 Hi ! Juste to ask if there is a way to read xls (excel) file without OLE (com object) ? my goal is to convert content to other file format ( csv, xml, etc...) exemple, i need to convert all .xls file in the directory to csv file format with pipe "|" as delimiter character Share this post Link to post Share on other sites
water 2,393 Posted March 11, 2011 (edited) Why do you want to avoid excel COM?You could use _ExcelReadSheetToArray and then write the Array to a file.Edit: If you don't have excel installed you could use one of the freeware excel converters like xls2csv Edited March 11, 2011 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites
mary 0 Posted March 11, 2011 Why do you want to avoid excel COM?because I have no excel installed.Edit: If you don't have excel installed you could use one of the freeware excel converters like xls2csvgood freeware but not flexible because it add a double comma ("") for each cell content Share this post Link to post Share on other sites
Juvigy 49 Posted March 11, 2011 You can manipulate the csv file and remove the double comma afterwords. Share this post Link to post Share on other sites
Zedna 280 Posted August 14, 2011 (edited) I know it's quite late but look hereAccessing and managing MS Excel sheets with Delphihttp://delphi.about.com/od/database/l/aa090903a.htm Edited August 14, 2011 by Zedna Resources UDF ResourcesEx UDF AutoIt Forum Search Share this post Link to post Share on other sites