Create an account

Very important

  • To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
  • You will only see chat messages from people who are at or below your level.
  • More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
  • Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)

0Day Forums Coding JScript HTML with JScript to read/write XLS file

Thread Rating:
  • 225 Vote(s) - 3.62 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Options
HTML with JScript to read/write XLS file

Offline adelynnnfqsa


Valued member
***
Valued member
Posts: 0
Threads: 0
Joined: Nov 2021
Reputation: 0
Level: inf [Level]
Total Points: inf
Rank nan / 1
100% to upload Level
Rank
Activity inf / 1
99% to upload your Rank
Activity
Experience nan
100% to upload Experience
Experience

Points: 50
#1
07-24-2023, 04:29 AM
Very sorry if this is not in the right place etc. I have been researching this for a while but its raised more questions!

I have developed a spreadsheet which I use to set a teams duties for a shift. There are 5 teams, each with staff which can change day to day.

the spreadsheet works fine, but its too complicated for some users. I am therefore trying to develop a straightforward web based form.

All the data is on the spreadsheet, held on a network drive (essentially locally).

I need to be able to have several combo/select boxes which get their values from a range of cells from the XLS. Along with the ability to output the final selections to a XLS sheet.

Finally, it needs to be able to load the previous day values on load.

What is the best way of developing a web page for this? Is Jscript the best option? Can I access a local file with jScript?

Thanks in advance

Adrian
Reply

Offline antisilverite38410


Member
*
Member
Posts: 0
Threads: 0
Joined: Apr 2023
Reputation: 0
Level: inf [Level]
Total Points: inf
Rank nan / 1
100% to upload Level
Rank
Activity inf / 1
99% to upload your Rank
Activity
Experience nan
100% to upload Experience
Experience

Points: 50
#2
07-24-2023, 04:50 AM
The easiest option for you is to use [google web forms][1]. These allow creation of forms that will submit data to a google spreadsheet. Which is essentially an uploaded version of your local spreadsheet and can be downloaded to excel.

In case if you want more control and programming, pure javascript cant play with files, you need server side too. Javascript is not necessary unless you want to make your app do some visually fancy stuff. Since you mentioned php as a tag of this question, it seems you are a bit familiar with php. The task you have mentioned can be done using php programming as below:

- Read excel file using an excel plugin
- Parse relevant data using a text matching function, may require regular expressions knowledge.
- display the form by building up the html and putting in the variables using the data obtained above.
- Write a method to save the data submitted by the form to the same excel file using the excel plugin.

As its not convenient to play around with excel files. A better option would be to generate csv file or use a database using a database class . csv files can be parsed easily using text.

[1]: https://www.google.com/intx/en_sg/work/a...cts/forms/
Reply

« Next Oldest
Next Newest »


Forum Jump:


Users browsing this thread:
1 Guest(s)

©0Day  2016 - 2023 | All Rights Reserved.  Made with    for the community. Connected through