If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Jan 2011
    Member #
    I created an Excel program that allows me to copy and paste a large amount of raw data into a worksheet, run a macro, have information added to blank columns based on information in columns with data, delete rows with certain data, etc. I am wondering whether I can create a website that I can paste large raw data downloads into and have it perform the same steps. Can you give me advice on where to begin? i.e. what type of program should I use to accomplish what I am trying to do, etc?


  3. #2
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Cottage Grove, Minnesota
    Member #
    726 times
    Can you define "large amounts"?
    I'm thinking of PHP ... but maybe might be a better match.
    Either way, the server-side script can use a CSV (.csv) comma-separated-variable
    file to get data and crunch it for you. I just don't know how big your files are.


  4. #3
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Not from USA
    Member #
    2784 times
    If it's an XLS file, ASP (or .NET) can read it as if the spreadsheet were a table. You just need a different (Excel-specific) connection string. I'd suggest .NET would be your better option, though, because I know that it can run programs and things like that (although I'm not sure if it can from an page.)

    That's going to be a tough one to solve, no matter how you cut it. You may end up having to recode the macro into your web page.
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
All times are GMT -6. The time now is 01:35 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: