Use a variable for a parameter in _ExcelReadArray

[WilliamP]

I was hoping someone has figured this out.  I am using an Excel spreadsheet v 2012 to organize a list of email addresses for notification reciprients.  It is organized by location via column header. What I am trying to do is create a part of a script that can read from an ini file the column to start in and read those cells to an array that the script will use to address a SMTP email.   Here is what I have so far

#Include <file.au3>
#include <INetSmtpMailCom.au3>
#include <Array.au3>
#include <Excel.au3>
$inifile = FileOpen("C:gpalertgpsetup.ini", 0)
$L = FileReadLine($inifile, 7)
$oExcel = _ExcelBookOpen("c:gpalertGP Notification List.xlsx", 0)
$aArray = _ExcelReadArray($oExcel, 3, $L, 7, 1, 1) ;Direction is Vertical
$s_ToAddress = _ArrayToString($aArray, "; ", 1, 7)
  _ExcelBookClose($oExcel, 0, 0)

; msgbox below is just for testing

 MsgBox(0, "Test Excel",  $s_ToAddress)

Any help other method or work around would be most helpful.

Thanks
 

Edited July 20, 2013 by WilliamP

[WilliamP]

Ok this was an interesting fix.  Nothing wrong with my code,  just discovered that for some reason when I place a space before the line in my .ini file that $L is pulled from, it worked.  The function  _NetSmtpMailCom (wonderful function by the way, great praises to Jos who created it) for some reason didn't interpret the variable $L to be, in this case, 1 even though the MsgBox displayed it, until the space was added.  I am thinking something in the way   $L = FileReadLine($inifile, 7) parsed the data in the.ini file without the preceding space placed in the line.

I hope this helps someone that runs into a simular issue.

Happy scripting.

[BrewManNH]

Why aren't you using the INI functions to read and write to your INI file instead of fileread*?

[WilliamP]

Err INI functions????   I'll have to check into those.  I've been scripting for a while but lately I have been getting into projects that are getting increasingly complex.

Thanks for the help.