7 posts in this topic
open excel and update pivot
hello guys, I'm doing one excel pivot connected to a mysql script to display it in a table array . I need you to open the excel file , the pivot is updated .
where do I fix it?
Save Opened Excel Files
I am needing to save an opened Excel file, but the issue that I am running into is that this instance of Excel won't have been opened via the Excel UDF. I am exporting data as part of a web scrapping process I'm working on, and the data is put into a Excel file from my browser. Is there a way to simply attach an open Excel file to an Excel object in AutoIT so that I can then use the Excel UDF to manipulate it?
Thanks in advance.
Paste from Clipboard into Excel - Harder than it looks?
I have used my script to paste a string ($TestCSVGenerator) onto the clipboard - it has text seperated by tabs and at certain intervals there are CRLF. I am certain that this is a valid string because after I run my script (and it fails to do what I need) I can then manually 'Paste' the string into Excel using CTRL v and Excel puts the text in rows separated by the tab position and starts a new row of cells after a CRLF. (I make sure that the clipboard was empty before running my program).
All I need is a command that pastes the string into a certain cell and in theory the above should happen but it doesn't!
First I tried the following:
_Excel_RangeWrite ($oWorkbook, 1, $TestCSVGenerator, "C18", False, True)
This pastes, but everything goes in one cell! I've tried all the combinations of True/false
Next I tried:
_Excel_RangeCopyPaste($oWorkbook.ActiveSheet, Default, "C18")
This pastes nothing at all (gives @error =4 ), if I define a range of cells Excel does highlight them.
Any ideas or alternative methods? I guess I could paste the text painfully cell by cell but Excel seems to understand what I have on the clipboard if I paste it manually - it's the automation that is flooring me!
Multiple login using details in excel file
i have a list of usernames and passwords in an excel file (row 1 : username1, password1, row 2 : username2, password2 ... likewise) the work (login, do some work, log out, login with second user, do same work, log out.. likewise) is same for each user. how do i create a script with that?
Excel Make Row Some Color
Hey there, I am trying to figure out how to fill an Excel row with a color, if some condition. For example:
$sColor = #FFF000 For $iCC = 1 To Ubound($aArray)-1 $sRange = "A:" & $iCC If _Excel_RangeReady($oWorkbook, $sRange) = "Some String" Then _Excel_FillInRowWithColor($iRowToFillIn, $sColor) Next
Anyone know how to do that? Thanks!