I am new to programming, please help.
Here is my situation:
I have an excel file, it contains data (over 1000 lines) and VBA code. I want to relocate this mini application into a web page, i.e. transfer my data from excel and create the same logic.
In my understanding, the following steps are necessary:
1. Transfer data from excel to .html (or .xml) in a way that necessary lines/cells can be manipulated (e.g. with ID generation for those lines/cells);
Now I am focused on step 1.
What is a good way to transfer?
Description of data: my contacts list: their details such as position, contact info etc. (one line per person). This includes birthday.
The logic necessary: return those people who have a birthday today.
Thank you in advance
Excel VBA has a capability to connect to a sheet as a database and use sql commands to query the data. I have used it a lot in some Excel VBA addins. You could pass an sql command.
I am doing something similar now. The user fills out a form on the web and the data is put into a database. Php starts an Office Word addin and it reads the database and creates a Word document based on a predefined template. The php program passes back the file location.
If you are using .net this appears to be a good article on how to access Excel data. I have never done this.
I still think you should look at using a database. You could use an Access db. Php connects to Access using ODBC. You can easily import your Excel data. Another option is Access can link to Excel spreadsheets. You could still enter your data in Excel but just use Access to get data from the web. In fact, thinking about it I recommend this approach. A lot less programming.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)