Register now or log in to join your professional community.
you can write the solution according to what language u prefer.
visual basic will be the easiest to use its code by creating a new spreadsheet then add with another code the records in it
That language must provide service and programming to connect with Excel and do the task. For example Microsoft provides ODBC, ADO and DAO its programming languages.
I can used English Language to create & store date in microsoft excel sheet
I AGREE WITH MR TA TANVEER ANSWER
THANKS FOR INVITATION
another way to do is store in MySQL and export to Excel when you want it.
it all depends on the language you are using; you will need the tool, used in that language, to interact with Excel.
the best thing to do is to search: "create and write to Excel using <language>
Simply you have to study the file manipulation techniques of your concerned language. It is available almost in all languages(Mostly in Server Side).
It is better to use Visual Basic.
To write a program that communicates with Excel directly, you have to use a language that supports such thing. Microsoft is good with making Excel, and all Office products for that matter, and its dll/com libraries available to most of its programming languages, such as C# and VB.Net C++. Therefore, with out having a third party software you can talk to Excel and launch any of its commends, including inserting data, from and within that language. For example:
this is how you can create a workbook in C#:
Excel.Workbook newWorkbook =this.Application.Workbooks.Add();
E,g in case of VBscript we can use Import.datatable command to store or retrieve data along with Get or set commands.
“If you store your data by using Access and analyze it by using Excel, you can gain the benefits of both programs.”
