3 replies to this topic

[Junee]

Been on a few coding forums and been let down, hoping this is what I'm looking for.

A real beginner, only know HTML & CSS but what to learn some new stuff.

Where's the best place for Newbie questions? Don't want to annoy anyone.

[Junee]

Quick question, I want to create a program which will allow me to enter stats and then save into a spreadsheet in a certain way. Also needs to be easily up-loadable to the web.

For a bit of background I'm running a sports site so want to be able to enter player stats into a program which will save them into a spreadsheet and then be able to total them up for season averages etc.

So my question is what sort of programming should I be looking at doing? C++ would be my first guess but just wondering if anyone can lead me in the right direction...

[Alexander]

Welcome to our forums, the "general programming" area is good for non-specific questions and we welcome any level of difficulty.

For spreadsheets, these may be specific to certain softwares or operating systems however the xls format is not too difficult, there should be a few C++ libraries kicking around to aid in creation of such a document.

With a rough search I have found this C++ library:
C++ Excel Library to read/write xls/xlsx files - LibXL

It's example:

#include "libxl.h"
using namespace libxl;


int main() 
{
    Book* book = xlCreateBook();
    if(book)
    {
        Sheet* sheet = book->addSheet(L"Sheet1");
        if(sheet)
        {
            sheet->writeStr(2, 1, L"Hello, World !");
            sheet->writeNum(3, 1, 1000);
        }
        book->save(L"example.xls");
        book->release();
    } 
    return 0;
}

There may be other languages of which have easier learning curves, however they may not have the libraries you are looking for. If you are using PHP or ASP for your website, you may wish to look for libraries of which work with them so you can automate/integrate this in to your website rather than having to manually do it offline.


Alexander.

[WingedPanther]

Welcome aboard! PHP and JavaScript would be good next steps in your learning.