Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

If I am developing a program by any language, how can I create and store data in Microsoft Excel sheet?

you can write the solution according to what language u prefer.

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/05/03
Ahmed Maher
par Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

visual basic will be the easiest to use its code by creating a new spreadsheet then add with another code the records in it 

Atif Tanveer
par Atif Tanveer , Decision Support Specialist , Hamilton Health Science

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

 

FITAH MOHAMED
par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

I AGREE WITH MR TA TANVEER ANSWER 

  THANKS FOR INVITATION 

Ashraf Thaikkat
par Ashraf Thaikkat , Machinery Maintenance Supervisor , Ministry of Education

another way to  do is store in MySQL and export to Excel when you want it.

Abdelmonaam Kallali
par Abdelmonaam Kallali , Data application developer , DragonWave

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>

Naveed Chheena
par Naveed Chheena , Prienciple Software Engineer , innokat

Simply you have to study the file manipulation techniques of your concerned language. It is available almost in all languages(Mostly in Server Side).

هاشم المشارقة
par هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

It is better to use Visual Basic.

ayman hamdan
par ayman hamdan , CEO/ CIO, Consultant , IT Consultants / USA

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();

 

Touseef Ahmad
par Touseef Ahmad , Mumbai as Information Technology Analyst , TATA Consultancy Services Ltd

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.”

More Questions Like This