Write Data into Excel using GUICreate.

[iamtech]

I want to send/write data into excel book using Gui created.

 

My code :

expandcollapse popup

#include <ButtonConstants.au3>
#include <ComboConstants.au3>
#include <EditConstants.au3>
#include <GUIConstantsEx.au3>
#include <GuiStatusBar.au3>
#include <WindowsConstants.au3>
#include<File.au3>
#include <Date.au3>
#NoTrayIcon
#RequireAdmin
Local $iWidthCell = 100

$Form1 = GUICreate("form1", 550, 251, -1, -1)
GUICtrlCreateLabel("Username: ", 30, 55, $iWidthCell) ; first cell 70 width
$Input1 = GUICtrlCreateInput("", 100, 50, 400, 21)

GUICtrlCreateLabel("Area Code: ", 30, 85, $iWidthCell)
$Input2 = GUICtrlCreateInput("", 100, 80, 400, 21)

GUICtrlCreateLabel("Village: ", 30, 115, $iWidthCell)
$Input2 = GUICtrlCreateInput("", 100, 110, 400, 21)

GUICtrlCreateLabel("Today's Date: ", 30, 145, $iWidthCell)
$Input2 = GUICtrlCreateInput(_NowDate(), 100, 140, 400, 21)
GUICtrlSetState(-1, $GUI_DISABLE)

$Button1 = GUICtrlCreateButton("Save", 300, 188, 75, 25)
GUICtrlSetTip(-1, "Save...")
$Button2 = GUICtrlCreateButton("Exit", 400, 188, 75, 25)
GUICtrlSetTip(-1, "Exit...")
GUISetState()
While 1
    Switch GUIGetMsg()

Case $GUI_EVENT_CLOSE
     FileClose($open)
            Exit
        Case $Button1
            OK()
        Case $Button2
            Close()
    EndSwitch
WEnd

Func OK()

EndFunc
Func Close()
    Exit
EndFunc

I don't know about Excel automation.

Its Possible ?

 

[FrancescoDiMuro]

@iamtech
Take a look at Excel UDF in the Help file, especially at _Excel_RangeWrite()

[Nine]

yes totally possible look at Excel.au3 UDF in help file.

[iamtech]

Yes, But How can i use it with Gui ?

and what happen if data already exist in first/second/third row.

I want to send data only on empty row.

Edited March 18, 2019 by iamtech

[FrancescoDiMuro]

1 minute ago, iamtech said:

Yes, But How can i use it with Gui ?

GUICtrlRead() to read values from the GUI, _Excel_RangeWrite() to write to the Worksheet.

2 minutes ago, iamtech said:

and what happen if data already exist in first/second/third row.

I want to send data only on empty row.

This is a check that you have to do prior writing to the Sheet, but you can do everything with Excel UDF; just take a look at it and post the code related to Excel UDF if you have to ask something.

[Jos]

10 minutes ago, iamtech said:

Yes, But How can i use it with Gui ?

and what happen if data already exist in first/second/third row.

I want to send data only on empty row.

@iamtech or should I say @naru?   
Do you seriously think we will allow your begging for code approach when you use 2 different accounts?

You better read our forum rules now first and then PM me with which account you want to continue your life here.

Jos

[naru]

7 minutes ago, Jos said:

@iamtech or should I say @naru?   
Do you seriously think we will allow your begging for code approach when you use 2 different accounts?

You better read our forum rules now first and then PM me with which account you want to continue your life here.

Jos

Ohh ! i am Not @naru, Naru is my elder brother.

[Jos]

Just now, naru said:

Ohh ! i am Not @naru, Naru is my elder brother.

mmmm...   you know you are writing this with the Naru account, not iamtech ?

[naru]

Just now, Jos said:

mmmm...   you know you are writing this with the Naru account, not iamtech ?

Sorry, I handle his account

[iamtech]

1 minute ago, naru said:

Sorry, I handle his account

Yes, @naru is my brother and he was handle my account.

You can remove my account @Jos, But keep my brother's Account

[Jos]

After a little research I know I am being played so simply will ban your both account. Do not attempt to create a new one.

Jos