2 posts in this topic
I'm trying to insert the following formula in cell A2 using my script:
=if(A1=""; "YES"; "NO")
To my understanding, the line of code should be similar to this:
_Excel_RangeWrite($MasterFile, Default, "=if(A1=""; "YES"; "NO")", "A2")
However, it does not work, probably due to the multiple quotation marks that confuse the script :C
How do I avoid this problem?
i have a question about Excel, i have to create several charts one below the other dynamically.
I have thought to use:
$oRangeLast = .UsedRange.SpecialCells($xlCellTypeLastCell) $iRowCount = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)).Rows.Count
And then to use it in this way:
$Graph_position = "=Test1!A"&$iRowCount+2&":K"&$iRowCount+24 But it doesn't work with charts.
Does anyone have a suggestion?
i have an empty csv file, i have a non formatted text file.
What do i want to do?
I want to automate the process "get external data" in Excel, i want to import the data from the text file and basically create a csv file with a specific character encoding.
Is it possible with AutoIT?
i have to store an entire row of a Excel workbook into an array. The row index is stored in a variable.
How can i do it?
Thanks in advance for your support.
i have to write a value into an excel column.
I know where it starts from, but i don't know what the end is, last non-empty cell.
How can i get the number of last non-empty cell?
Thanks in advance.