How do I translate the data from a particular server to EXCEL Format and see the real-time updates appear in Excel?

Question

0.00/5 (No votes)

See more:

I am just new to the system.
Not that good in Excel as well, but I make use of it to calculate, and make a report using the summary.
In our stats, I need to have the final total, average, and also the specific details.

What I do, is I have to copy and paste the table from the server to excel, then perform the necessary calculations.

But the hard part is that when there are new encodings or updates in the server, I cannot see that in Excel and I have to copy and paste the whole thing again in Excel and then make necessary computations.

It takes so much of my time and effort.

Please HELP.

Thank you.

Posted 8-Nov-15 15:53pm

danilo servano jr

Add a Solution

Comments

PIEBALDconsult 8-Nov-15 21:58pm

What does that have to do with PHP?
Where is the data stored? You can probably have the Excel file connect to the data source and pull the data in. (Don't ask me how, I've never done it.)

My preference is just to produce XML or CSV (for anyone who wants to see data in Excel).

You might also want to consider using SSIS to produce an Excel report.

danilo servano jr 8-Nov-15 22:59pm

The server is maintained by other person. It's like a 3rd party contractor. I have to request from time to time if I want to see some updates. Since it's a raw file, I have to calculate the sub-totals and overall totals.
What I have is just a view of the data.
He is using PHP. I am not sure what that is. Hahaha...
What I can do is just copy the tables and all the figures in excel, then calculate for the total and the average.
That is why I just want to link the data to excel, and perform the calculations.
Hope that makes sense.

Patrice T 8-Nov-15 22:19pm

Why do you need Excel at all ? can't you do the calculus without Excel ?

danilo servano jr 8-Nov-15 23:00pm

I am not sure if you can see my comment below or should I reply to your comments personally. But in case, I am posting it here personally to reply to you.
Thanks by the way.

The server is maintained by other person. It's like a 3rd party contractor. I have to request from time to time if I want to see some updates. Since it's a raw file, I have to calculate the sub-totals and overall totals.
What I have is just a view of the data.
He is using PHP. I am not sure what that is. Hahaha...
What I can do is just copy the tables and all the figures in excel, then calculate for the total and the average.
That is why I just want to link the data to excel, and perform the calculations.
Hope that makes sense.

danilo servano jr 8-Nov-15 22:25pm

The server is maintained by other person. It's like a 3rd party contractor. I have to request from time to time if I want to see some updates. Since it's a raw file, I have to calculate the sub-totals and overall totals.
What I have is just a view of the data.
He is using PHP. I am not sure what that is. Hahaha...
What I can do is just copy the tables and all the figures in excel, then calculate for the total and the average.
That is why I just want to link the data to excel, and perform the calculations.
Hope that makes sense.

Richard MacCutchan 9-Nov-15 5:02am

There is no simple answer to this. Firstly, how is this data obtained from the server? Can you read it programmatically so you could automatically write it into Excel?

danilo servano jr 10-Nov-15 20:34pm

A friend suggested SQL Server to Excel since it's the most common suggestion in youtube.
He tried it but only the headings were copied to excel and not the contents.
How this data is obtained?
It's like a school. The teacher encodes the grades, then the registrar has this database to see all the encoded grades of all teachers. I think that's the best example I can give.

It's a web-based program that I can access anywhere because I have a log in. But only the raw grades I can see so I have to compute for the average and total.

No function for me to extract what I want so I have to copy to excel all the grades for me to get the average per teacher and overall average.

Hope that makes sense.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Accepted Answer · 2015-11-09T06:46:00

I'll make a leap and presume your data is in SQL Server:

Google Results:
https://www.google.com/search?q=run+sql+query+inside+excel&ie=utf-8&oe=utf-8[^]

I've done this. The only weakness is that the login credential are available within the spreadsheet as plain-text (if one has a hex-editor to get at it). Thus, it is recommend you obtain a read-only guest account if you go this route.

As was state above: you've not really given enough information for a definitive answer.