Jump to content

Recommended Posts

Posted

#include <File.au3>
#include <Excel.au3>
#include <Array.au3>


$ID = "charid"
$pw = "charpw"
$sFilePath1 = @ScriptDir & "\Kaydedilcek-excel-dosyasi.xls"
If FileExists($sFilePath1) = 0 Then
$oExcel = _ExcelBookNew(1)
_ExcelBookSaveAs($oExcel, @ScriptDir & "\Kaydedilcek-excel-dosyasi.xls", "xls")
Global $aLastRow = $oExcel.Cells.SpecialCells($xlCellTypeLastCell).Row
Else
$oExcel = $sFilePath1
$oExcel = _ExcelBookOpen($oExcel, 1)
Global $aLastRow = $oExcel.Cells.SpecialCells($xlCellTypeLastCell).Row
EndIf
_ExcelWriteCell($oExcel, $ID, $aLastRow + 1, 1)
_ExcelWriteCell($oExcel, $pw, $aLastRow + 2, 1)
_ExcelBookClose($oExcel, 1, 0)

Posted

C:\Users\Cihan\Desktop\SteamAccountCreator-master\excelsave.au3"(11,79) : error: _ExcelBookSaveAs(): undefined function.
_ExcelBookSaveAs($oExcel, @ScriptDir & "\Kaydedilcek-excel-dosyasi.xls", "xls")

 

  • Moderators
Posted

gunesonline,

Welcome to the AutoIt forum.

But please pay attention to where you post - the "Developer General Discussion" section where you started this thread is not for general support questions.  I have moved it for you, but would ask you to be more careful in future.

M23

 

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

  Reveal hidden contents

 

Posted

Which version of AutoIt do you run?

My UDFs and Tutorials:

  Reveal hidden contents

 

Posted

BTW: When posting code please use code tags (the "<>" icon in the editor). That makes the code much easier to read.

My UDFs and Tutorials:

  Reveal hidden contents

 

Posted (edited)
#include <File.au3>
#include <Excel.au3>
#include <Array.au3>
$ID = "charid"
$pw = "charpw"
$sFilePath1 = @ScriptDir & "\test.xls"
If FileExists($sFilePath1) = 0 Then
$oExcel = _ExcelBookNew(1)
_ExcelBookSaveAs($oExcel, @ScriptDir & "\test.xls", "xls")
Global $aLastRow = $oExcel.Cells.SpecialCells($xlCellTypeLastCell).Row
Else
$oExcel = $sFilePath1
$oExcel = _ExcelBookOpen($oExcel, 1)
Global $aLastRow = $oExcel.Cells.SpecialCells($xlCellTypeLastCell).Row
EndIf
_ExcelWriteCell($oExcel, $ID, $aLastRow + 1, 1) 
_ExcelWriteCell($oExcel, $pw, $aLastRow + 2, 1) 
_ExcelBookClose($oExcel, 1, 0)

 

test.au3

Edited by gunesonline
Posted
  On 5/22/2016 at 4:05 PM, gunesonline said:

I do not use the latest version

Expand  

And the EXACT version you use is???

My UDFs and Tutorials:

  Reveal hidden contents

 

  • Developers
Posted
  On 5/22/2016 at 4:11 PM, gunesonline said:

Please adaptable to new version

Expand  

First better prove this isn't a pilot error, which likely is the case here!

Jos

SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

  • Moderators
Posted

Jos,

We no longer use "pilot error" - the new term is "human factors". Or perhaps in this case we could compromise on "keyboard-chair interface".

M23

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

  Reveal hidden contents

 

Posted

What kind of game are you trying to play with us :huh:
Please answer our questions or you will have to find the solution to your problem yourself.

My UDFs and Tutorials:

  Reveal hidden contents

 

Posted
  On 5/22/2016 at 5:03 PM, water said:

What kind of game are you trying to play with us :huh:
Please answer our questions or you will have to find the solution to your problem yourself.

Expand  

 

 

I'm having problems while recording excel

  • Developers
Posted
  On 5/22/2016 at 6:16 PM, gunesonline said:

$word = InputBox("Steam Account Creator","Kullanıcı adınızın ve mailinizin başına gelecek olan kelimeyi giriniz. " & @crlf & "Örn: techfuat ->

Expand  

Unfortunately you appear to have missed the Forum rules on your way in. (there is also a link link in my signature) 
Please read them now particularly the bit about not discussing game automation - and then you will understand why you will get no help and this thread will now be locked. :naughty:

Jos

SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

  • Jos locked this topic
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...