Alpha Video Training
Results 1 to 5 of 5

Thread: Import excel then export to excel

  1. #1
    Member popellis's Avatar
    Real Name
    Mark Ellis
    Join Date
    Jan 2004
    Location
    Erie,PA
    Posts
    196

    Default Import excel then export to excel

    Is it possible to import an excel file, manipulate the data, then export back to excel?
    I know this sounds nuts but I'm just trying to figure if it is worth the effort.

  2. #2
    "Certified" Alphaholic
    Real Name
    Jeff Kletrovets
    Join Date
    Oct 2005
    Location
    Columbus, OH
    Posts
    1,135

    Default Re: Import excel then export to excel

    Mark

    I have not done it but I am quite sure that is easily doable.

    As another option, keep in mind with V9 you might be able to even make an Active Link to an Excel spreadsheet - you could then manipulate it directly from inside Alpha - no import / export. I know there is a predefined "connector" in V8 for connecting to Excel.

    Come to think of it - you could even make a passive link table in V8. Manipulate the data in your V8 passive link table and then easily send it back out. That would eliminate the import step since you would be using AlphaDAO to directly access the Excel Spreadsheet for the passive link table.

    Regards....

    Jeff

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Import excel then export to excel

    Quote Originally Posted by popellis View Post
    Is it possible to import an excel file, manipulate the data, then export back to excel?
    I know this sounds nuts but I'm just trying to figure if it is worth the effort.
    Yes. What portion of the process gives you trouble?

    It is also possible to use ole methods under xbasic control to open the excel file, manipulate the spreadsheet, and save it.

  4. #4
    Member popellis's Avatar
    Real Name
    Mark Ellis
    Join Date
    Jan 2004
    Location
    Erie,PA
    Posts
    196

    Default Re: Import excel then export to excel

    I have not tried this yet but I have someone who has to look up names on a 7 to 11 page spreadsheet, that he recieves by email each day. he then makes modifications to the data and then sends it back.
    Thought it might be easier to find the information if it was in a database, then convert it back to excel and send it back out to the originator. Like I said it may be more trouble than its worth at this point.

  5. #5
    "Certified" Alphaholic
    Real Name
    Jeff Kletrovets
    Join Date
    Oct 2005
    Location
    Columbus, OH
    Posts
    1,135

    Default Re: Import excel then export to excel

    Mark

    That would be quite simple to do with the passive link table strategy I outlined to read the spreadsheet in and use a genie to send it back out as Excel.


    Jeff

Similar Threads

  1. Export to Excel
    By Garry Flanigan in forum Archived Wishlist
    Replies: 1
    Last Post: 09-07-2007, 11:57 AM
  2. Export to Excel
    By gagsoft in forum Alpha Five Version 6
    Replies: 7
    Last Post: 04-01-2006, 06:28 PM
  3. Export to Excel XP
    By robert cook in forum Alpha Five Version 5
    Replies: 1
    Last Post: 11-12-2004, 12:09 PM
  4. Export to Excel
    By Mike Reed in forum Alpha Five Version 1
    Replies: 3
    Last Post: 07-14-2004, 01:27 PM
  5. Export to Excel
    By Craig Johnson in forum Alpha Five Version 5
    Replies: 2
    Last Post: 04-23-2003, 05:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •