Sign in to follow this  
Followers 0
wutangah

Excel - How do I...

6 posts in this topic

Hello everyone!

How do I take values and load them into an array for data entry?

Share this post


Link to post
Share on other sites



Hello everyone!

How do I take values and load them into an array for data entry?

Welcome to AutoIt! :)

Download Locodarwin's ExcelCOM_UDF(), and start experimenting.

If you get stuck post a short 'reproducer' script to show the problem, and you'll get lots of help.

;)


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

Hello everyone!

How do I take values and load them into an array for data entry?

if you need data from txt file to excel then something like this

#Include <ExcelCOM_UDF.au3>
#include <File.au3>
$thenumber = "1"
$oExcel = _ExcelBookOpen(@ScriptDir&"\Excel.xls",1);<== show=1 hide=0
$search = "Excel.txt"
Dim $aRecords
If Not _FileReadToArray($search,$aRecords) Then
    Exit
EndIf
For $x = 1 to $aRecords[0]
_ExcelWriteCell($oExcel, $aRecords[$x], "a"&($thenumber))
$thenumber =$thenumber+1
Next

if you need data from excel to array try to read then try reading info from ExcelCOM_UDF on command _ExcelReadArray

your fast PsaltyDS

Edited by bogQ

TCP server and client - Learning about TCP servers and clients connection
Au3 oIrrlicht - Irrlicht project
Au3impact - Another 3D DLL game engine for autoit. (3impact 3Drad related)



460px-Thief-4-temp-banner.jpg
There are those that believe that the perfect heist lies in the preparation.
Some say that it’s all in the timing, seizing the right opportunity. Others even say it’s the ability to leave no trace behind, be a ghost.

 

Share this post


Link to post
Share on other sites

Thanks guys!

I'll start experimenting right away!

Share this post


Link to post
Share on other sites

your fast PsaltyDS

PsaltyDS is really just an answer-bot script written in AutoIt by SmOke_N... shh! Don't tell anybody...

:)


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

PsaltyDS is really just an answer-bot script written in AutoIt by SmOke_N... shh! Don't tell anybody...

:)

LOL! ;)

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