Zompy Posted March 24, 2009 Share Posted March 24, 2009 I need a kinda help with an excel script, i need the script the read the cells, and be able to retype them somehwere else Link to comment Share on other sites More sharing options...
DaRam Posted March 24, 2009 Share Posted March 24, 2009 Post what you have so far and if possible just the part that your are having issues with. You will get more pertinent responses this way. Link to comment Share on other sites More sharing options...
Zompy Posted March 24, 2009 Author Share Posted March 24, 2009 Well, i don't have a real something... I thoguth i might be using ;_ExcelReadCell but i have no idea of how to use it Only thing i ened is to know how to read a cell and how to enter it in something else (example notepad) Link to comment Share on other sites More sharing options...
PsaltyDS Posted March 24, 2009 Share Posted March 24, 2009 Well, i don't have a real something...I thoguth i might be using ;_ExcelReadCell but i have no idea of how to use it Only thing i ened is to know how to read a cell and how to enter it in something else (example notepad)Did you try the example script in the help file? Have you tried the tutorials in the help file and/or the larger AutoIt 1-2-3 tutorial? Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Zompy Posted March 24, 2009 Author Share Posted March 24, 2009 With Excel? Where? Link to comment Share on other sites More sharing options...
BlackScorpion Posted March 24, 2009 Share Posted March 24, 2009 Here's an Excel example that shows how to read and write to a spreadsheet using autoit and change the valueshttp://90kts.com/blog/2009/data-driven-autoit-scripts/ Link to comment Share on other sites More sharing options...
PsaltyDS Posted March 24, 2009 Share Posted March 24, 2009 With Excel? Where?In the help file, under the _Excel* functions in the index, or User Defined Function\Excel Management in the contents.You are using the help file, right? It's AutoIt3.chm in the AutoIt directory. Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Zompy Posted March 25, 2009 Author Share Posted March 25, 2009 Yes im using the helpfile, problem is, how can i copy the cells and for example retype them in notepad? Link to comment Share on other sites More sharing options...
Zompy Posted March 25, 2009 Author Share Posted March 25, 2009 Please help Link to comment Share on other sites More sharing options...
youknowwho4eva Posted March 25, 2009 Share Posted March 25, 2009 (edited) $oexcel = _ExcelBookOpen($sFilePath[, $fVisible = 1[, $fReadOnly = False[, $sPassword = ""[, $sWritePassword = ""]]]]) $text = _ExcelReadCell($oExcel, $sRangeOrRow[, $iColumn = 1]) $file = FileOpen ( "filename", mode ) FileWrite ( $file, $text ) I filled out the file write part for you. Look up the others to see what you need to replace in each Parameter. You may also note that to use _excel* functions you must have #Include <Excel.au3> at the top of your script. Write something up, try it, if it doesn't come back here, post what you have written, post what it is doing, post what it's not doing that you think it should, and post any errors Scite gives you. Edit: Just noticed the time lapse in your posts. It is proper AutoIt Forum Educate to not "bump" (post a post following a previous post of your own) in less than 24 hours. No one will write (well some may) a script for you with out some $. The forum is for learning, not I can't can you for me. We were all new once. We wouldn't know what we know if someone handed us the answer and didn't make us work. Not to be mean just a Friendly notice. Edited March 25, 2009 by youknowwho4eva Giggity Link to comment Share on other sites More sharing options...
Zompy Posted March 25, 2009 Author Share Posted March 25, 2009 $oexcel = _ExcelBookOpen($sFilePath[, $fVisible = 1[, $fReadOnly = False[, $sPassword = ""[, $sWritePassword = ""]]]]) $text = _ExcelReadCell($oExcel, $sRangeOrRow[, $iColumn = 1]) $file = FileOpen ( "filename", mode ) FileWrite ( $file, $text ) I filled out the file write part for you. Look up the others to see what you need to replace in each Parameter. You may also note that to use _excel* functions you must have #Include <Excel.au3> at the top of your script. Write something up, try it, if it doesn't come back here, post what you have written, post what it is doing, post what it's not doing that you think it should, and post any errors Scite gives you. Edit: Just noticed the time lapse in your posts. It is proper AutoIt Forum Educate to not "bump" (post a post following a previous post of your own) in less than 24 hours. No one will write (well some may) a script for you with out some $. The forum is for learning, not I can't can you for me. We were all new once. We wouldn't know what we know if someone handed us the answer and didn't make us work. Not to be mean just a Friendly notice. That my sir, is exalent! i've never thought of the thing you gave above, if it works, i love you! this is what i needed! Link to comment Share on other sites More sharing options...
youknowwho4eva Posted March 25, 2009 Share Posted March 25, 2009 If done properly, it will work. The scripts I have made for work deal a lot with Excel, and before thinking of alternate methods, most of my scripts read/wrote to ini files. So I am fairly experienced with these methods. Hopefully you read the help file carefully on both the File* and Excel* functions I noted. I did not put in there to close the files when you're done writing/reading. The help file will tell you how. And like I said play with it. If it doesn't work try again. If you just can't get it right, come back and we'll point you in the right direction. Giggity Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now