ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
تاريخ النشر: 2015/05/03
Ahmed Maher
من قبل 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
من قبل 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.

pilipina espina
من قبل pilipina espina

I can used English Language to create & store date in microsoft excel sheet

 

FITAH MOHAMED
من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

I AGREE WITH MR TA TANVEER ANSWER 

  THANKS FOR INVITATION 

Ashraf Thaikkat
من قبل 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
من قبل 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
من قبل 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).

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

It is better to use Visual Basic.

ayman hamdan
من قبل 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
من قبل 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.

fahad bin nasir
من قبل fahad bin nasir

 

“If you store your data by using Access and analyze it by using Excel, you can gain the benefits of both programs.”

المزيد من الأسئلة المماثلة