Pramodh_Vijayan

Excel Functions

2 posts in this topic

#1 ·  Posted (edited)

I'm trying to copy the contents of a spreadsheet to a text file using _Excel_RangeRead function. I'm able to get the information successfully but when I try to access the individual elements of the array, I'm getting errors. Please find the part of the script with which I'm facing trouble below:

While 1
    $fr = _Excel_RangeRead($oWorkbook, $j, 1, $colnum - 1)
    $fr1 = _Excel_RangeRead($oWorkbook, $j + 1, 1, $colnum - 1)
    $line = ""
    ;If $fr[1] = "" Then Exit(0)


;    MsgBox(0, "", "'" & $fr[0] & "'")
    ;For $i In $fr
    $i = 1
    While $i < $colnum
        $line = $line & $fr[$i] & ","
        $i += 1

    WEnd
    If $line <> "" Then FileWriteLine($outop, $line)
    If ($fr[0] = "") Then
        If $fr1[0] = "" Then Exit (0)
    EndIf

    ;If $j = 1 then $j += 1
    $j = $j + 1
    $i = ""


WEnd

I'm getting an error "Subscript used on non-accessible variable." for the line    $line = $line & $fr[$i] & ","

Edited by Melba23
Added code tags and merged posts

Share this post


Link to post
Share on other sites



Can't you simply save the workbook as filetype txt?
As Excel only saves the active sheet to a file you simply would need to loop through the sheets and save each one to another file.


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