Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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 added by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date Posted: 2015/05/03
Ahmed Maher
by 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
by 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
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

I AGREE WITH MR TA TANVEER ANSWER 

  THANKS FOR INVITATION 

Ashraf Thaikkat
by 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
by 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
by 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).

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

It is better to use Visual Basic.

ayman hamdan
by 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
by 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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.