Register

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 6 of 6
  1. #1
    Member
    Join Date
    Nov 2012
    Posts
    63
    Member #
    33941
    Liked
    2 times
    Hi everyone,

    I have created data entry tool in excel for our daily shift report details for the whole year. But the excel size seems to be so BIG and it becomes slow in calculations & saving.

    Is that possible to have HTML as front end data entry page & add the details to back-end Excel database by clicking a button in HTML?
    Host1Plus.com USA | UK | Germany | South Africa | Brazil | Netherlands | Lithuania | sales@host1plus.com
    Powerful VPS Hosting SSD caching | IPv4 & IPv6 | 2 free backups | DNS management | 500 Mbps uplink
    Cloud Servers - Powerful API KVM Virtualization, Windows and Linux | 1 Free Ipv4
    Reseller Hosting Unlimited domains, sub-domains, databases | Free dedicated IP

  2.  

  3. #2
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,483
    Member #
    425
    Liked
    2783 times
    You'll have to use a server-side programming language such as ASP, ASP.net or PHP (I believe PHP can do this) to interact with the Excel spreadsheet.

    However, I wouldn't recommend using Excel for database purposes. For one thing, it's not a database. For another thing, it's slow when it comes to data retrieval in this context. I usually will retrieve data from Excel and then import it into something like SQL Server or even Access (if the situation calls for it) and go from there.

    HTML by itself won't cut it, regardless of what you're trying to do. It's a markup language. That's it, that's all.
    Andrew Yurlov likes this.
    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)

  4. #3
    Senior Member Ronald Roe's Avatar
    Join Date
    Mar 2011
    Location
    Oklahoma City
    Posts
    3,141
    Member #
    27197
    Liked
    959 times
    GAME,
    Just because my brain is stuck trying to even fathom this, would a CSV file work better? XML?
    Ron Roe
    Web Developer
    "If every app were designed using the same design template, oh wait...Bootstrap."

  5. #4
    Senior Member Webzarus's Avatar
    Join Date
    May 2011
    Location
    South Carolina Coast
    Posts
    3,322
    Member #
    27709
    Liked
    770 times
    I'd go the MySQL DB route with that, actually have several clients ... And I use asp, if you set it up correctly, the information in the excel file can be imported directly into the MySQL DB.

    Then for reporting, with enough filtering, sorting and pagination ( to drill down to the data you're looking for ), you can export to excel easily ...

  6. #5
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,483
    Member #
    425
    Liked
    2783 times
    Quote Originally Posted by Ronald Roe, post: 246996
    GAME,
    Just because my brain is stuck trying to even fathom this, would a CSV file work better? XML?
    Not really. You'd have to have a writeable XML file to begin with and a way to write a specific node or series of them.

    CSV and Excel are pretty much the same thing when it comes to something like this.
    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)

  7. #6
    Member
    Join Date
    Nov 2012
    Posts
    63
    Member #
    33941
    Liked
    2 times
    Thanks for advice
    Host1Plus.com USA | UK | Germany | South Africa | Brazil | Netherlands | Lithuania | sales@host1plus.com
    Powerful VPS Hosting SSD caching | IPv4 & IPv6 | 2 free backups | DNS management | 500 Mbps uplink
    Cloud Servers - Powerful API KVM Virtualization, Windows and Linux | 1 Free Ipv4
    Reseller Hosting Unlimited domains, sub-domains, databases | Free dedicated IP


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
  •  

Search tags for this page

add data to the backend of a excel roe

,
create a html data entry page frontend database
,
excel frontend
,

front end for excel spreadsheet

,
frontend for excel
,

html backend excel

,
html front end for excel
,
html front end to a excel spreadsheet
,

html frontend for excel

,
use excel back end website
Click on a term to search for related topics.
All times are GMT -6. The time now is 05:45 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com