Sign in to follow this  
Followers 0
reybol7

How to Transfer SQLlite data to EXCEL?

9 posts in this topic

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.

Share this post


Link to post
Share on other sites



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

Share this post


Link to post
Share on other sites

@Clark :bye: Thank you very much it works owsome.

Share this post


Link to post
Share on other sites

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#5 ·  Posted (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 by reybol7

Share this post


Link to post
Share on other sites

#7 ·  Posted (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 by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#8 ·  Posted (edited)

How can i get the latest Beta sir? my Autoit version is v3.3.8.1

Edited by reybol7

Share this post


Link to post
Share on other sites
Here you get the latest beta version.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0