Jump to content

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here. X
X


Photo

Excel data Import


  • Please log in to reply
2 replies to this topic

#1 Gihan

Gihan

    Seeker

  • New Members
  • 1 posts

Posted 30 September 2008 - 04:34 PM

Hi there,

I am new to Autoit, does anyone have automated data import to an excel file from an external Ascii file or any other file, I tried using AU3record 3.1 / Script writer but it did not work. Any Help would be appreciated so far I can open an excel file but the data import part is not working?

So far I have the following code

+++++++++++++++++++++++++++++++
; Prompt the user to run the script - use a Yes/No prompt (4 - see help file)
$answer = MsgBox(4, "This Opens Excel (English Only)", "This script will Open Execl and then quit. Run?")


; Check the user's answer to the prompt (see the help file for MsgBox return values)
; If "No" was clicked (7) then exit the script
If $answer = 7 Then
MsgBox(0, "AutoIt", "OK. Bye!")
Exit
EndIf


; Run execl
Run("C:\Program Files\Microsoft Office\OFFICE11\EXCEL.exe")


; Wait for the MS Execl to become active - it is titled "Microsoft Excel - Book1" on English systems
WinWaitActive("Microsoft Excel - Book1")

AutoItSetOption("SendKeyDelay", 400)
WinWait("Data")
WinWait("Get External Data")
WinWait("Select Data Source","")
If Not WinActive("Select Data Source","") Then WinActivate("Select Data Source","")
WinWaitActive("Select Data Source","")
; Now quit by sending a "close" request to the calc
WinClose("Microsoft Excel - Book1")

WinWaitActive("Excel file", "Do you want to save")
Send("!n")
; Now wait for calc to close before continuing
WinWaitClose("Microsoft Excel - Book1")


; Finished!
+++++++++++++++++++++++++++++++







#2 Community On Patrol

Community On Patrol

    Forum Nark

  • Active Members
  • PipPipPipPipPip
  • 263 posts

Posted 30 September 2008 - 05:32 PM

Hi Gihan,

1st Welcome to the AutoIt Forums! :idiot:

Some of the following tips may not apply to you, but it may make your life a bit easier here on the forum in the future.
CODE
  • Did you know that we have an awesome search feature?
    You can find many answers to your current questions, just by typing in the right search patterns.
  • A suggestion is to use the Advanced Search mode:
  • Type your specific search term in quotes.
  • Click the forum you want to search in (the one most likely to have your information would generally be the Example Script forum and or the General Help and Support Forum).
  • Click on "Search titles only" radio button.
  • Click perform search.
The above will help you narrow down your searches and prevent you from unneccesarily posting a new thread.

[*]Also, you should try to read the Sticky posts that are at the top of each of the AutoIt Forums you enter such as:

[*]Keep in mind, the help file will be your best friend, however you may find some of the tutorials written by some of our elite forum members helpful.

[*]Forum Etiquette:
  • Making a new thread:
    • Use the Search feature first to see if your question has already been answered.
    • Look in the help file as well before even thinking of posting (When what you want could be obtained by simply reading the help file, you don't generally get a good response from your AutoIt community).
    • Titles are very important here. 1 word titles or titles like "help me", "write something for me", "I'm a noob" etc... aren't tolerated.
    • Make sure you are posting in the correct forum:
      • General Help and Support:
        • This forum is for AutoIt related support questions only. If you have a question related to another language, or nothing at all to do with AutoIt then you need to post in the chat forum, or in that languages perspective forum.
      • Example Script:
        • This forum is for AutoIt scripts/executables only.
        • Source code is preferred but not necessary, you do have the right to just post the binary of your project if you wish.
        • Please don't post questions in this forum unless it's directly related to a thread already existing.
    • Use common sense when creating a new thread.
      Ask yourself if the title is descriptive enough to even interest someone (preferably those that know what they are talking about) to even look at your thread, let alone reply in it.
    • Think about how it would show in the search feature if someone were to look for something just like you are looking for (think of the keywords you used yourself and obviously didn't find anything (because we know you used the search feature :) ) and use those types of keywords in your title as well).
  • Thread content:
    • Be descriptive with your query. (Make sure we actually know what you want to do).
    • Show you've made an effort in coding what you want (provide the reproducer code (generally no more than 50 lines as people lose interest in debugging someones script for free)).
    • Don't talk in ebonics. A lot of the forum members are adults, and a lot of them know how to help you, but talk like a child, you'll be treated as such.
    • Don't ask for help making keyloggers, spam (even if it's to do as a prank), or anything that can be thought of as malicious. You'll more than likely have the thread locked by a moderator, and take a bashing from your fellow AutoIt community.
    • When posting code, use code boxes. This can be accomplished by using [code ]<content here>[/code ] (No spaces between the brackets []).
      Using code boxes will keep the indentation and make it easier to read for others to help you.
  • Bumping your threads:
    • Use common courtesy here.
      Keep in mind every time you bump your thread to the top of the forum, you knock the other threads down a notch.
      Everyone posting for help has just as much right for their threads to get read as you do.

      Because of that, do not bump your post more than once in a 24 hour period.
      A Bump is simply posting in your thread with nothing that pertains to your query with the sole purpose of moving it up.
      Deleting previous bumps, and posting new ones is not tolerated, and the moderators can find those deletions, so do yourself a favor and don't cross that line >_< .
  • Rude or obnoxious content:
    This falls pretty much under the common sense thing. If you use it (common sense) before posting, you won't have issues.
    • Don't use foul language, remember, a lot of the community is at work when they read these threads.
    • Don't provoke or instigate an argument with someone.
  • Double Posting:
    • It's understood that sometimes there's a lag in the system, and sometimes people don't see their post go up right aways so they post again.
      If this happens to you, simply notify a moderator with the report feature in the post, and politely ask them to delete it.
    • If you're just creating another topic because your original topic is not being answered the way you want or at all, this is not tolerated. You could lose your posting privileges all together over it.
  • Non-English languages
    • If English is not your primary language, please make an attempt to interpret (yourself or online) and post that interpretation.
      We have wonderful users from around the world, so after you've done your post in English, back it up with your question also in your native tongue (You may find your answer much quicker using both).
[/list]
That's it for now, I hope you have a wonderful learning experience, and hope to see you contribute to the community as your knowledge grows.

#3 PsaltyDS

PsaltyDS

    Most Venerable Penguin

  • MVPs
  • 13,279 posts

Posted 30 September 2008 - 05:55 PM

Hi there,

I am new to Autoit, does anyone have automated data import to an excel file from an external Ascii file or any other file, I tried using AU3record 3.1 / Script writer but it did not work. Any Help would be appreciated so far I can open an excel file but the data import part is not working?


Look at the _Excel* functions in the current Beta version, or use ExcelCOM_UDF.au3 with the current Prod version. Functions like _ExcelWriteCell() and _ExcelWriteSheetFromArray() will make it easy.

:)
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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users