reybol7 Posted April 22, 2013 Share Posted April 22, 2013 Helo again, i trying to find a code in the forum that transfer my sql data to excel but i can't find one, i only find Exel to SQL. bacause i need my sqllite data to be in excel so that i can submit it to my fellow. Link to comment Share on other sites More sharing options...
Clark Posted April 22, 2013 Share Posted April 22, 2013 You can read the data from SQLLite into an internal array. Once you have it in an array, just write it out to Excel, using a function similar to this: func ExcelPrint($InArray) $sFilePath = @TempDir & "\Temp.xls" If Not _FileCreate($sFilePath) Then ;Create an .XLS file to attach to MsgBox(4096, "Error", " Error Creating File - " & @error) return 1 EndIf _ExcelBookOpen($sFilePath) $oExcel = _ExcelBookAttach("Temp.xls", "FileName") ;with $s_mode = "FileName" ==> Name of the open workbook _ExcelWriteSheetFromArray($oExcel, $inArray, 1, 1, 0, 0) EndFunc Link to comment Share on other sites More sharing options...
reybol7 Posted April 22, 2013 Author Share Posted April 22, 2013 @Clark Thank you very much it works owsome. Link to comment Share on other sites More sharing options...
water Posted April 22, 2013 Share Posted April 22, 2013 If the _ExcelWriteSheetFromArray function is too slow you can find some much faster versions on the forum or in my ExcelEX UDF. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
reybol7 Posted April 22, 2013 Author Share Posted April 22, 2013 (edited) Yup, it is slow, ok ill download and try yours, Thanks ohh, what function in your ExcellEX i should use in replacement with Clark function, and try to run the Excel_Export it has an error. C:Documents and SettingsBolima FamilyMy DocumentsDownloadsExcel Rewrite.au3(289,56) : ERROR: ObjGet() [built-in] called with wrong number of args. $oWorkbook = ObjGet("", $sCLSID_Workbook, $iCount + 1) Thanks in advance. Edited April 22, 2013 by reybol7 Link to comment Share on other sites More sharing options...
reybol7 Posted April 22, 2013 Author Share Posted April 22, 2013 (edited) Can you Help me where to find the function created by GreenChan that export SQL to EXCEL, its too complicated to me to understand.heres the linkhttp://www.autoitscript.com/forum/index.php?app=core&module=attach§ion=attach&attach_id=40099his SQL to Excel is very very fast. Edited April 22, 2013 by reybol7 Link to comment Share on other sites More sharing options...
water Posted April 22, 2013 Share Posted April 22, 2013 (edited) Yup, it is slow, ok ill download and try yours, Thanks ohh, what function in your ExcellEX i should use in replacement with Clark function, and try to run the Excel_Export it has an error. C:Documents and SettingsBolima FamilyMy DocumentsDownloadsExcel Rewrite.au3(289,56) : ERROR: ObjGet() [built-in] called with wrong number of args. $oWorkbook = ObjGet("", $sCLSID_Workbook, $iCount + 1) Sorry, my bad. I forgot to mention that you need the latest Beta version of Autoit to run this UDF. The replacement function is _Excel_RangeWrite. Edited April 22, 2013 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
reybol7 Posted April 22, 2013 Author Share Posted April 22, 2013 (edited) How can i get the latest Beta sir? my Autoit version is v3.3.8.1 Edited April 22, 2013 by reybol7 Link to comment Share on other sites More sharing options...
water Posted April 22, 2013 Share Posted April 22, 2013 Here you get the latest beta version. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now